[ChristinaW]

We are attempting to Remove the Location from all our Inventory through a CSV update on the Item records. The Location fields are all Drop Down boxes with “Warehouse” selected as the Preferred Location and the Classification Location. (We are using Multi-Location in NetSuite) We currently set up a Subsidiary in our Sandbox Account and through testing realized we cannot have the Location fields set (they must be blank) on the Item Records.

Is there a way we can update all the Inventory (in our LIVE Account) through a CSV Import?? I have tried leaving those fields blank and also used NULL in hopes it would clear those fields. So far no luck.

Anyone know the answer to this?? If we can’t update with a CSV then we are going to have to manually edit hundreds of item records.
This is a cached copy. Click here to see the original post.

[khultquist]

What about mass update? If that’s not possible, you should be able to modify the items using Inline Editing. Build a search for items with location not blank, and enable inline editing. As a rough estimate, if you figure it takes 5-10 seconds to change each item, you can change about 400+ items per hour. It s*cks to click a mouse that many times, but it’s time efficient.

[ChristinaW]

The Mass Update worked! Thank you so much!!

[Author]

Posts