Troubleshooting Shopify Product Sync Errors in NetSuite

TL;DR Opening

When syncing products between Shopify and NetSuite, you may encounter errors such as variant ID mismatches and location deactivation. Understanding the reasons for these errors and how to resolve them is crucial for seamless inventory management.

What Causes the 'Variants Have Not Been Changed' Error?

The error stating "Variants have not been changed. The following IDs do not exist or do not belong to the product: <ID>" arises when Shopify identifies a variant under a different parent item than expected. NetSuite Connector attempts to associate the variant with a designated parent in NetSuite but cannot match the SKU correctly because it already exists under another SKU in Shopify.

How to Resolve the Error

To fix this issue:

• Delete the existing item from Shopify - This prevents conflict during synchronization.
• Adjust the item in NetSuite - Ensure it matches the variant item in Shopify to allow for successful posting.

What Does 'Exceeded Maximum Number of Variants' Mean?

This error indicates that a parent item exceeds the Shopify limit of 100 variants. When you try to add too many variants, it results in this sync failure.

Resolving the Maximum Variants Error

To resolve this issue:

• Reduce the number of subitems in NetSuite - Ensure there are 100 or fewer variants associated with the parent item.
• Refer to the article on Removing a Subitem From Your Item Matrix for guidance on managing your item matrix in NetSuite.

Handling Location Deactivation Errors

If a Shopify location used for syncing inventory becomes deactivated, you will receive the error message: Posting errors: [u'Location is deactivated']. Resolving this depends on whether the deactivation was intentional.

Solutions Based on Deactivation Status

• Intentional Deactivation: Update the mapping for the inventory_quantity field to remove the deactivated location by following the guidelines in Mapping Shopify Multilocation Inventory in NetSuite Connector.
• Not Intentional: Reactivate the location in Shopify, as NetSuite Connector cannot change the status of Shopify locations.

Troubleshooting Unsupported Carriers Tracking Error

When you use a carrier not recognized by Shopify, tracking fulfillment can fail, leading to errors in the synchronization process.

Steps to Create Custom Mapping

To address unsupported carrier errors:

1. Log in to app.farapp.com.
2. Select the Shopify connector and the relevant account.
3. Navigate to Mappings > Fulfillments.
4. Click Add Mapping.
5. In the Shopify Field dropdown, select Carrier.
6. Add the mapping and close the window.
7. In the NetSuite Fixed / Field Value column, enter the custom field name used for tracking the carrier.
8. Click Save.

Conclusion

Understanding these common errors and their resolutions can lead to a more seamless integration between Shopify and NetSuite, ensuring efficient inventory management and tracking.

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

Key Takeaways

• Resolve variant ID mismatches by managing item parentage in Shopify and NetSuite.
• Adhere to Shopify's limit of 100 variants per parent item to avoid sync errors.
• Handle deactivated locations appropriately based on their deactivation status.
• Create custom mappings for unsupported carrier errors to ensure smooth fulfillment tracking.