Skip to main content

NetSuite Sales Price vs. Base Price

Comments

9 comments

  • Praveen Kumar Reddy Basani Product Manager
    Celigo University Level 2: Seasoned

    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
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    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
    Celigo University Level 4: Legendary
    Salesforce-NetSuite IA Certification
    Engaged

    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
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    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
    Celigo University Level 4: Legendary
    Salesforce-NetSuite IA Certification
    Engaged

    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
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

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

    0
  • Gabe Parr
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

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

    1
  • Paul Petersen
    Engaged
    Celigo University Level 4: Legendary

    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
    Awesome Follow-up
    Engaged
    Celigo University Level 1: Skilled

    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.