NetSuite Sales Price vs. Base Price

Gabe Parr

• March 22, 2021 17:55

I would like to map pricing to show items that are on sale in Shopify from NetSuite Price change. Is this possible?

0

• 

  Praveen Kumar Reddy Basani Senior Product Manager

  • March 24, 2021 08:19

  

  

  

  Hi Gabe,

  This can be handled via a simple mapping of the pricing flow (see how the product is shown in Shopify below). Shopify has only two fields for pricing and you need to map

  Sale Price from NetSuite to Price (price) field in Shopify
  Base Price from NetSuite to Compare at Price (compare_at_price) field in Shopify.

  

  0
• 

  Gabe Parr

  • March 24, 2021 15:41

  

  

  

  I understand I can map the price fields to different locations, however before implementing that change - I need to understand the behavior (or if a script is needed) when items may not be on sale. Whereas the "Base Price" is fundamentally always populated the "Sale Price" is only populated when items go on sale and then how that needs to be implemented in the Saved Searches in NetSuite.

  0
• 

  Hairball.io

  • March 24, 2021 15:47

  

  

  

  We use this formula when customers require the Sale Price vs Compare at Price. Change the IDs of Price Level as per your NS account.

  Price: CASE WHEN {pricelevel6} is null THEN {pricelevel7} ELSE {pricelevel6} END

  Compare at price: CASE WHEN {pricelevel6} >= 1 THEN {pricelevel7} ELSE null END

  0
• 

  Gabe Parr

  • March 24, 2021 15:52

  

  

  

  Thanks for that.

  I am guessing that the Saved Search on "Price" and "Compare at Price" will have to be changed from a static lookup to Formula in the "Results" based on values I am trying to get?

  Then assure that the correct mapping is set up in the Flow in Celigo?

  0
• 

  Hairball.io

  • March 24, 2021 15:56

  

  

  

  The Saved Search Price: Unit Price changes to Type is Formula: Currency.

  Then you add a new row of Formula Currency for Compare at Pice, and in the label add Compare At Price (Variant), got to the mapping, refresh and map the new row.

  1
• 

  Gabe Parr

  • March 24, 2021 15:58

  

  

  

  Awesome, thank you for your help. I am going to go test it out and see. 

  0
• 

  Gabe Parr

  • March 24, 2021 17:32

  

  

  

  That works great!!!! Thank you again!!!

  1
• 

  Paul Petersen

  • December 01, 2021 20:22

  

  

  Gabe Parr
  Gabe - I'm trying to do the same thing but uncertain how the mapping and saved search needs to be modified. Can you connect with me on this?

   

  0
• 

  Gabe Parr

  • December 01, 2021 22:41

  

  

  

  Sure you can give me a ring here at the shop if you like and I should be able to walk you through it. +1 (541) 598-7322

  0

Please sign in to leave a comment.