Shopify Inventory Management Mapping

The Shopify connector has a specific inventory_management field that tells Shopify whether it should be tracking inventory for items on its platform. The field references the Track Quantity box on the Shopify user interface.

You can check or clear this box through the inventory_management mapping. Also, you can also set up the mapping logic to have this box checked for some items and cleared for other items. To do this, create an Item Field Translation mapping by following these steps.

To create Item Field Translation mapping:

When syncing items, an error might be encountered indicating a failure to update inventory because the inventory item does not have inventory tracking enabled. This means inventory_quantity is being received with a value even if it is 0, and Shopify will not accept not tracking inventory for those items. In this case, you must contact the NetSuite Connector Support team to get help in setting up another conditional mapping for inventory_quantity, to handle such scenarios.

In NetSuite, create a custom box, because you will only need true or false values.
Determine the logic that you want to apply for the mapping. For example, if the box is checked, inventory is tracked, or if the box is cleared, inventory is not tracked.
Log in to app.farapp.com and go to product mappings, Shopify > Mappings > Products > Full Product. Locate the inventory_management mapping.
In the Mapping Type column, select Item Field Translation.
In the translation mapping popup page, do the following:
1. Enter the relevant field ID in NetSuite Field.
2. Set the on or off logic switch; then, enter the equivalent Boolean value, true or false, under the NetSuite Value column, and the corresponding action (to track inventory or not) under Shopify Value column.
  
  Note:
  Setting inventory_tracking to false only for some items will only work if you are not passing over an inventory_quantity value from NetSuite. Typically, this mapping should only apply to noninventory items.
3. Click Save Changes.

To create Item Field Translation mapping:

Related Topics