ANS-1471 · CSV IMPORT & DATA MIGRATION
How to Set NetSuite Item Bin Preferred (Per Location) to Not Preferred via CSV
Utilize a CSV import to efficiently update the 'Preferred (Per Location)' status for NetSuite item bins to 'Not Preferred'.
Short answer
To set the 'Preferred (Per Location)' status for a NetSuite item bin to 'Not Preferred' via CSV, perform an import. Populate the relevant field with 'empty' and ensure 'OVERWRITE MISSING FIELDS' and 'OVERWRITE SUBLISTS' are both set to true in the advanced options. This method effectively clears the preferred status.
Scenario
Organizations often need to adjust the 'Preferred (Per Location)' status for specific item bin numbers at various locations within NetSuite. This requirement typically arises when a bin is no longer considered preferred for an item, and its status needs to be updated to 'Not Preferred' to reflect current inventory practices. Manually updating numerous records can be time-consuming, necessitating an efficient bulk update method.
Solution
To set the 'Preferred (Per Location)' status for a specific Bin Number at a specific Location for a specific Item to 'Not Preferred' via CSV import, follow these steps:
Prepare your CSV file, ensuring the field corresponding to 'Preferred (Per Location)' is populated with the value 'empty'.
During the CSV import process, navigate to the Advanced Options.
Set 'OVERWRITE MISSING FIELDS' to true.
Set 'OVERWRITE SUBLISTS' to true.
This configuration ensures that the existing preferred status is overwritten and effectively cleared, setting the bin to 'Not Preferred'.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support