Articles in this section

Understand the Shopify Markets edition of the Shopify - NetSuite integration app

The Shopify Markets feature acts as a global e-commerce hub where you no longer need to manage multiple stores in different countries. It is a cross-border management tool that helps you identify, set up, launch, optimize, and manage your international markets - all from a single store. The feature makes it easier for merchants to sell and list products in local currencies with price adjustments and convert product prices to local currencies feasibility. 

The Shopify Markets functionality is available with a separate edition of the integration app. This separate edition of the integration app includes all the premium features of the Shopify - NetSuite integration app. This edition of the integration app would make it easier for merchants to record the amounts customers paid in their books, rather than prices stored in the back end of Shopify. 

The integration app includes all the premium edition features along with the following three new settings that support Shopify Markets:

Limitations: 
  • The order flow does not support setting different default tax codes based on country. However, you can hardcode the HST or PST tax values to zero and club them under GST for collective reporting.
  • The billing flow does not support setting different default tax codes based on the country. Consequently, the taxes GST, HST, and PST for the Canadian markets sync incorrectly, and partial taxes are shown under variance.

Track order duties in NetSuite

The NetSuite item to track Shopify order duties as a line item setting allows you to choose a NetSuite item to track duties as a separate line item on the NetSuite sales order.

Note: In NetSuite, be sure to create the item type as non-inventory, payment, or other charge.

To track Shopify order duties in NetSuite:

  • In the Shopify Markets edition of the Shopify-NetSuite integration app, go to Settings > Order > Order tab and select the NetSuite item to track duties as a separate line item.

Limitation: This edition doesn’t support syncing refund of duties to Shopify.

Sync records in local currency to NetSuite 

The Sync records in local currency setting allows you to sync the records (order, billing, and refund) in presentment currency or Shopify local currency so that you can manage your books according to your accounting needs. The local, or presentment, the currency is what the customer sees at the Shopify store. This currency is also used to pay at checkout. 

This setting impacts the following flows:

  • Shopify customer to NetSuite customer (add/update)
  • Shopify order to NetSuite cash sale (add)
  • Shopify order to NetSuite sales order (add)
  • Shopify order to NetSuite order (cash sale or sales order) 
  • Shopify transaction to NetSuite customer deposit (add)
  • Shopify order transaction to NetSuite custom transaction record (add)
  • Shopify refund to NetSuite refund (add)
  • NetSuite refund to Shopify refund (add)

To sync Shopify records in local currency:

  1. In the Settings > Order > Customer tab, check the Multi-currency customers enabled in NetSuite checkbox, in the integration app.
  2. In the Shopify Markets edition of the Shopify-NetSuite integration app, go to Settings > General section and check the Sync records in local currency checkbox.
    Image2.png
  3. Set the currency mapping in the Shopify customer to NetSuite customer (add or update) flow as Currency::Primary Currency (InternalId), as shown in the following screenshot.
    Image_8.png
  4. Set the currency mapping in the order flows. It is recommended to configure the mapping as Currency::Currency (InternalId), as shown in the following screenshot
    Image_4.png

    Once the above settings are configured, you can run all the flows to sync the Shopify records in local currency.

    Sync GST/VAT for the customer country to NetSuite

    The Sync GST/VAT for the customer country setting allows you to manage taxes, and determine whether they are included or excluded from the order total based on the customer’s country.

    To sync GST/VAT for the customer country to NetSuite:

    • In the Shopify Markets edition of the Shopify-NetSuite integration app, go to the Settings > Order > Tax tab and check the Sync GST/VAT for the customer country checkbox.
    Image_5.png

    In Shopify, there are two tax settings:

    • All prices include tax
    • Include or exclude tax based on your customer’s country

    The following scenarios are explained based on the tax setting selection in Shopify, to help you understand and decide when to check/uncheck the new setting in the integration app:

    • ​​Tax-inclusive or exclusive: In the Shopify account, if the "Include or exclude tax based on your customer's country" checkbox is checked, your store will have tax-inclusive and tax-exclusive orders based on customer country. Check the Sync GST/VAT for the customer country checkbox to sync the GST/VAT for the customer country, uncheck the Deduct GST/VAT from the order total and Add GST/VAT to refund total checkboxes as shown in the following screenshot.
    Image_6.png
    • Tax-inclusive: In the Shopify account, if the “All prices include tax” checkbox is checked, and your store will have tax-inclusive orders. Check the Deduct GST/VAT from the order total and Add GST/VAT to refund total checkboxes as shown in the following screenshot.

      Note: Checking the Sync GST/VAT for the customer country checkbox can sync the tax-inclusive orders. You can uncheck the Deduct GST/VAT from the order total and Add GST/VAT to refund total checkboxes.

    Image_last.png

    Limitations: In Shopify markets, if an order is imported with the following settings:

    • Add total tax against a single line item on the order is checked
    • Sync GST/VAT for customer country is checked
    • Add GST/VAT to refund total is unchecked

    Scenario 1: The integration app will not be able to add the shipping tax amount to the shipping total because the shipping tax is imported as a separate line item and the tax rate on the order is zero stored internally is zero.

    Scenario 2: In addition to the above scenario, if you have checked the Add GST/VAT to refund total and the Add GST/VAT to item price (in the product tab) checkboxes. The integration app will not be able to add the correct tax amount to the total shipping amount all the time as the tax on each item may vary.

    Sync price lists per market from NetSuite to Shopify

    The Sync price lists per market from NetSuite to Shopify setting allows you to sync price lists per market from NetSuite to Shopify.

    To navigate to the setting in the integration app, go to the Settings > Product tab, check the Sync price lists per market from NetSuite to Shopify box, and choose the Shopify market, NetSuite currency, and NetSuite price level fields. The compare-at-price field is optional. Once you make the selections, save the settings, and run the NetSuite item to Shopify product (add or update) and NetSuite matrix item to Shopify product (add or update) flows to sync price lists from NetSuite to Shopify. For more information about price lists per market in Shopify, see Shopify Markets pricing.

    Notes: 
    • This setting doesn’t support deleting a price list or a partial set of prices on a price list.
    • The primary market will not appear in the Markets dropdown. This means the default price synced will apply to the primary or default market.

    Important: When you create a new market in Shopify and click the Refresh button under the setting Sync price lists per market from NetSuite to Shopify, the new market will appear in the dropdown list. However, the existing or previously saved market settings will disappear from the UI. You will need to re-configure the values for these previously saved markets as well when configuring a new market.

    mceclip0.png

    Sync HS code and country of origin from NetSuite to Shopify 

    If you ship internationally, then each of your products must include an HS code. An HS code is an international trade code, usually six digits long, that’s used to describe what a product is. Adding HS codes to your products helps to avoid non-compliance penalties, border delays, seizure of the products, or denial of import. For more information, see Adding HS codes to your products.

    To sync the HS (Harmonized System) code and country of origin information, check the Sync HS code and country of origin from NetSuite to Shopify box in the Settings > Product tab.  

    For more information about HS codes and country of origin in Shopify, see Harmonized system in Shopify.

    Pre-requisites: 
    • Add the HS Code and Country HS code to the item record and the NetSuite saved search. To do this, you must manually create the custom fields for the item record in NetSuite and then add them to the NetSuite saved search (Celigo Shopify Item Export saved search).
      • In NetSuite, set the data types of the custom fields for the HS Code and Country HS Code to free-form text. If multiple Country HS Codes exist, the integration app uses array logic during the flow execution to sync all Country HS Codes with Shopify. 
      • In NetSuite, add the standard field Manufacturer Country for Country/Region of origin.
    • If multiple Country HS Codes exist for an item record, ensure their addition to the NetSuite saved search.
    • Ensure that the display name of the items in NetSuite matches the SKU in Shopify to successfully sync the HS codes.

    The following screenshots are from NetSuite, after entering the HS code, Country HS Code, and Country of Origin details. 

    HS (Harmonized System) code: In the Custom Label field, enter the HS code. Be sure that the custom label is case-sensitive.

    Country HS code: The Country HS code must have the naming convention as Suffix: ‘(Country HS code)’ for ‘country_harmonized_system_codes’. Be sure that the suffix is case-sensitive.

    Make sure that you use the below format to set the Country HS code using the NetSuite custom field:

    Country HS code format:
    {
    “harmonized_system_code”:“1234561111",
    “country_code”:“CA”
    }

    Once you save the setting, a new page processor Add/update HS code and country of origin to Shopify products is added to both the flows NetSuite item to Shopify product (add or update) and NetSuite matrix item to Shopify product (add or update).

    mceclip2.png

    After the flow is run successfully, you can see the HS code and Country HS code details in Shopify:

    1. From your Shopify admin, go to Products.
    2. Click the name of the product that you want to change.
    3. In the Shipping section, click Add customs information to see the HS code and Country HS code details.

    The following screenshot is from Shopify after syncing the HS Code and Country HS Code from NetSuite to Shopify.

    Added scopes to support syncing of price lists per market

    The scopes "read_markets" and "write_markets" are added to the Connections for accessing Shopify markets. These scopes are required for the integration app to fetch Shopify markets-related information. The write markets permission is needed for updating price lists.

    IMPORTANT: If you are an existing user who has already installed the integration app, you must re-authorize your connection to add these scopes to the Connections, or the connection will throw an error. 

    NOTE: These scopes are automatically selected for new installations of all editions of the integration app.

    FAQs

    Q: As a Shopify merchant, I want to map Shopify's 'Cost per item' field to NetSuite's 'averagecost' field to track the cost of goods sold. Is there a way to map this field without needing a custom flow? I manage 1000 to 1500 SKUs yearly, so manual updates via CSV would be inefficient.

    A: Yes, this functionality can be supported by Shopify markets Edition. You can map the 'Cost per item' field without needing a custom flow by following these steps:

    1. Navigate to Settings > Product tab, and select the checkbox for Sync HS code and country of origin from NetSuite to Shopify.
    2. Once you save the setting, a new page processor Add/update HS code and country of origin to Shopify products is added to both the flows NetSuite item to Shopify product (add or update) and NetSuite matrix item to Shopify product (add or update).
    3. In this new page processor, map the inventory_item.cost field to the appropriate NetSuite field, such as 'averagecost'. For testing purposes, the NetSuite side of the mapping can be hardcoded.

    4. Run the product flow, and it will successfully sync the cost per item to Shopify as expected.

    This approach eliminates the need for manual CSV uploads or a custom flow, making it more efficient for managing large volumes of SKUs.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.