Shopify Inventory Management Mapping in NetSuite

The Shopify connector includes an inventory_management field that specifies whether Shopify should track inventory for items on its platform. This setting corresponds to the Track Quantity box found in the Shopify user interface.

You can manipulate this checkbox through the inventory management mapping feature. Moreover, you can set up mapping logic to have this checkbox checked or unchecked for different products.

Creating Item Field Translation Mapping

To effectively manage inventory features, it's essential to establish an Item Field Translation mapping. Here’s how to do it:

1. Create a Custom Box: Start in NetSuite by creating a custom box that will return true or false values.
2. Define Your Mapping Logic: Decide how you want the mapping to behave. For instance, check if the box is marked for tracking inventory or if it is left unchecked to indicate no inventory tracking.
3. Access the Mapping Tool: Log in to app.farapp.com and navigate to product mappings under Shopify > Mappings > Products > Full Product. Here, locate the inventory_management mapping.
4. Select Mapping Type: In the Mapping Type column, select Item Field Translation.
5. Configure Your Mapping:
   • Input the appropriate field ID in the NetSuite Field section.
   • Establish the on/off logic; then provide the equivalent Boolean value (true or false) in the NetSuite Value column, with the corresponding action (whether to track inventory or not) set in the Shopify Value column.

Note: If you set inventory_tracking to false for certain items, ensure you are not passing an inventory_quantity value from NetSuite. This setting is typically reserved for non-inventory items.

6. Save Changes: After entering all relevant information, click on Save Changes to confirm your settings.

Handling Sync Errors

When syncing items, you might encounter errors indicating a failure to update inventory due to the lack of inventory tracking on some items. Specifically, if inventory_quantity is received with a value (even if it is 0), Shopify will not permit inventory tracking for those items. In such cases, contacting the NetSuite Connector Support team is advisable to establish a conditional mapping for inventory_quantity to address these scenarios effectively.

Key Takeaways:

• The inventory_management field in the Shopify connector is crucial for managing inventory tracking.
• You can create custom mappings for different items to decide whether inventory should be tracked.
• Understanding the logic for checking or unchecking the Track Quantity box is essential for proper inventory management across platforms.

Source: This article is based on Oracle's official NetSuite documentation.