Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Import Sales Order Items using Item InternalID
SHORT VERSION:
Can you import a sales order, using the Item's InternalID, instead of the "Item (Req)" field - which is susceptible to changes in category hierarchy or item name??
LONG VERSION:
We currently import sales orders into NetSuite from a 3rd party system using a CSV file to hold the data.
We use a hierarchical item list - ie items can be sub-items of other items. (The parent items are only dummy items which we refer to as categories).
E.g. item list looks like:
CLOTHES
- MALE
- - T-SHIRTS
- - - SKU123 Red T-Shirt
When we import sales orders using the import assistant - the "Sales Order Items" area shows the field "Item (Req)" - which we use to identify the item. In this case, the item we want to import looks like this: