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?

Rookie Asked on November 4, 2022 in Best Practices.
Add Comment
2 Answer(s)
Best answer

In my experience, yes this is a scripted solution. You may be able to accomplish most of your asks with a series of complex workflows, but I believe that scripting would be an easier solution. Without discussing this with my development team, I think you are looking at item triggers to adjust to custom forms based on the source of the order and then creating  saved searches based on the item and custom forms or depending on your segmentation, you could also use that for reporting.  If you’d like to discuss this further, I’d be happy to take a closer look with you- feel free to PM me

Beginner Answered on November 4, 2022.

Thanks for the response! I would really appreciate the help! I tried the PM you but its not going through.

on November 5, 2022.

Let’s switch to email- my email address is ckiester@palladiumconsulting.net

on November 5, 2022.

Just sent you an email.

on November 5, 2022.
Add Comment

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.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor