Hi everyone, I’m trying to update and clean up a large volume (40.000) of Item Bin Numbers via CSV import in NetSuite and running into an issue with multiple bins across multiple locations. Context: * Record Type: Inventory Item * Feature: Multi-Location Inventory + Bins enabled * Goal: Disassociate bins from the item sublist (remove Item Bin Number assignments), not delete the bins themselves. My goal is to Note: All bins being removed have zero inventory What I’m doing: * CSV Import with:* Data Handling: Update * Overwrite Sublists: TRUE * File structure: Internal ID | Location | Bin Number | Preferred 10112 | Sunshine Warehouse | 123_SUN | T 10112 | Campbellfield Warehouse | 123_CAM | T Expected result: * Both bins remain (one per location) * Any other existing bins are removed Actual result: * Only the LAST line in the CSV is retained after import * All previous bin lines are effectively overwritten What I’ve already tried: * Removing extra columns (Name, Description) * Using correct sublist mapping (Item Bin Numbers) * Testing with the same location (still fails) * Adding External ID for grouping * Attempting Line ID workaround Question: Is this a limitation of CSV import with bin sublists and multiple locations? Or is there a specific way to structure the import so NetSuite correctly processes multiple bin lines? Any guidance or confirmation would be greatly appreciated. Thanks!

Hi @Alejandro G, I think you need to set up your template along the lines of the sample below. Internal ID Item - Bin Numbers 1 : Location Item - Bin Numbers 1 : Bin Number Item - Bin Numbers 1 : Preferred (per Location) Item - Bin Numbers 2 : Location Item - Bin Numbers 2 : Bin Number Item - Bin Numbers 2 : Preferred (per Location) 101160 Sunshine Warehouse 123_SUN T Campbellfield Warehouse 465_CAM F If you have more than 2 bins for an item, include additional [Item - Bin Numbers # : ] groups in the template. Hope this helps, John

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Child Item

Ask A Guru

Child Item

CSV Import with Overwrite Sublists only keeps last bin line (multi-location item)

Alejandro G

Hi everyone,

I’m trying to update and clean up a large volume (40.000) of Item Bin Numbers via CSV import in NetSuite and running into an issue with multiple bins across multiple locations.

Context:

Record Type: Inventory Item
Feature: Multi-Location Inventory + Bins enabled
Goal: Disassociate bins from the item sublist (remove Item Bin Number assignments), not delete the bins themselves.

My goal is to

Note: All bins being removed have zero inventory

What I’m doing:

CSV Import with:
- Data Handling: Update
- Overwrite Sublists: TRUE
File structure:

Expected result:

Both bins remain (one per location)
Any other existing bins are removed

Actual result:

Only the LAST line in the CSV is retained after import
All previous bin lines are effectively overwritten

What I’ve already tried:

Removing extra columns (Name, Description)
Using correct sublist mapping (Item Bin Numbers)
Testing with the same location (still fails)
Adding External ID for grouping
Attempting Line ID workaround

Question:
Is this a limitation of CSV import with bin sublists and multiple locations?
Or is there a specific way to structure the import so NetSuite correctly processes multiple bin lines?

Any guidance or confirmation would be greatly appreciated.

Thanks!

Find more posts tagged with

Component react.asset.answerThread had an error.

You are not allowed to view comments.

Child Item

Upcoming Events

SuiteWorld | October 25–28, 2026 | Las Vegas
Big ideas. No travel required. SuiteWorld On Air brings the best of SuiteWorld directly to you. Stream keynotes live, access exclusive virtual content, and connect with the NetSuite community from wherever you are. Explore what's next for NetSuite, see AI innovation in action, and discover practical insights designed to…
Learning Lab | DC
Drive better outcomes with AI built into NetSuite Next Capital Hilton,1001 16th St NW, Washington, DC 20036 Join NetSuite experts for a free half-day event where you'll get a tour of NetSuite Next, explore AI-powered capabilities built into the platform, and learn practical ways to optimize NetSuite for your business. At…
Inside the Suite | DC
Take NetSuite Next for a hands-on test drive Capital Hilton, 1001 16th St NW, Washington, DC 20036 What to expect: Inside the Suite is designed for companies exploring modern ERP solutions. This event gives you the opportunity to experience NetSuite Next - the next evolution of NetSuite that brings AI directly into how…
What's Next for Product Companies with NetSuite
WEBINAR What's Next for Product Companies with NetSuite See how NetSuite Next uses AI to improve accuracy and protect margins Ask. Understand. Act. Use Ask Oracle to search, navigate, analyze business data, surface insights, get guidance, and take action using natural language—all through a single conversational…

More events