RE: Looking for some insight on this project I need to complete


My company has 2 different product families for the same product (1 product family = “new style SKU”, 1 product family = “old style SKU”). The Ecommerce team deployed the new style in our website, which is where customer will purchase the item. All orders from the website will be placed with the new style SKU, but the Operations team wants to make the shipping process clean and ship the old style instead of the new style when possible.

Orders sync from our Ecommerce website into our ERP (NetSuite, where we manage inventory). Orders will be synced to the WMS 1 hour after creation in NetSuite.

All systems have the orders split into 2 records:

  1. Sales Order Header (General information – Customer, channel, ship date, Total amount, total discount, total taxes etc)

  2. Sales Order Lines (Order items details – SKU, item name, quantity ordered, price, discount etc)


  1. Change must happen when old SKU (item) inventory qty is greater or equal to threshold (threshold= 3)

  2. Change must happen only for Online Orders. (we have orders being place in 3 different channels)

  3. Online

  4. Wholesale

  5. POS (Physical store)

  6. Report to identify orders that had the item change. (if applicable).

I need to deliver the following:

1 – Process Data Flow – steps for the proposed solution (Required)

2 – Objects created – if applicable

3 – Code/logic to make the change – if applicable

4 – Report Query (any language) – if applicable.

For anyone who has experience with netsuite, will coding or any query language be needed to complete this?

netsuite_newb18 Rookie Asked on November 4, 2022 in Best Practices.
Add Comment
2 Answers

SuiteScript is the way to go here on After Submit of the order. You can have it check each line for the rules you have and then do an item replacement. You can store the item to use on the Item record, so it knows which it can use to replace with (older style). Then create some custom fields on the item line to tag if it has been replaced so ease of reference and store the original part number there too for reference.

Rookie Answered on November 8, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.