Understand the Shopify Markets edition of the Shopify - NetSuite integration app – Celigo Help Center

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:

NetSuite item to track Shopify order duties as a line item
Sync records in local currency
Sync GST/VAT for the customer country
Sync price lists per market from NetSuite to Shopify
Sync HS code and country of origin from NetSuite to Shopify
Added scopes to support syncing of price lists per market

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:

In the Settings > Order > Customer tab, check the Multi-currency customers enabled in NetSuite checkbox, in the integration app.
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.

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.

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

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.

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.

Tax-inclusive: In the Shopify account, if the “All prices include tax” checkbox is checked, 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.

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.

NOTE: This setting doesn’t support deleting a price list or a partial set of prices on a price list.

Sync HS code and country of origin from NetSuite to Shopify

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 add the custom field to the item record and then add this field to the NetSuite saved search.

HS code: In the Custom Label field, enter 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.

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).

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.