Hi
Is there an easy way of mass updating prices from new supplier pricelists?
With thousands of inventory items, manually updating prices monthly is a tedious and time-consuming process. Exporting pricing data and using the VLOOKUP function externally to update this is not an issue and goes quick – it’s getting this new data back in to NetSuite that seems to be challenging.
- On the Inventory Item’s Pricing-tab, I need to update only the Base Price. We make use a Quantity Pricing Schedule and multiple Price Levels, which should all update automatically from the new Base Price.
- On the Inventory Item’s Inventory-tab, I need to update only the Purchase Price as well as the Purchase Price under the Vendors-sub-tab.
It seems that a CSV import is the only solution, although I could not successfully import only the fields above, nor will it automatically update the quantity schedule and price level fields.
Any advice would be greatly appreciated!