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:

• NetSuite item to track Shopify order duties as a line item
• Sync records in local currency
• Sync GST/VAT for the customer country

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.

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.

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

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 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 on 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 and 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.