SOP: Inventory and Assembly Item pricing

This is a step-by-step process of updating pricing within NetSuite, including examples, and the SuiteAnswer article from which I created my templates. Currently our only multi-currency subsidiary is Debco, but that will likely change in the future, so this would become applicable to any multi-currency subsidiary. This also allows multiple price levels to be updated in one file.

SuiteAnswer: https://suiteanswers.custhelp.com/app/answers/detail/a_id/26741/loc/en_US

Step 1 requires you to create a Quantity Pricing Schedule update based on the quantity breaks being updated if applicable. Thanks to Akhil's modification of the existing script, you can now update or create new quantity breaks and pricing schedules within the same file.

QPS Page: https://1157875.app.netsuite.com/app/accounting/otherlists/quantitypricingschedules.nl

See the SOP for QPS Updates: https://helpdesk.hpgbrands.com/a/solutions/articles/8000111734

Step 2 requires you to clear the QPS and any existing pricing on the items you plan to update. Saved CSV imports for Inventory Items and Assembly Items are 1526 and 1527 respectively. Ensure to check Overwrite Sublists when clearing pricing.

Step 3 requires setting the QPS for all products, using Saved CSV import 1519 for Inventory Items and 1528 for Assembly Items.

Step 4 is when you can now upload your pricing files, see examples attached to ensure your columns are in the correct order and sorted properly so you can upload all price levels at one time. You will have to do two separate uploads since you are required to hard code the Currency though. The Saved CSV imports for Inventory and Assembly Items are 1500 and 1530 respectively.