When you try to create an order, create fulfillment, or add inventory, if any of the required fields/data is missing, the following error message is displayed on the integration app dashboard:
Unable to sync the inventory for the item #<NetSuite internal ID>. One of the required fields are missing. To resolve the error, see Resolve your Shopify error with code "{"errors":"not found"}"
The error might be displayed because of the following reasons:
- On the inventory or fulfillment request, if location details are missing or incorrect
- On the inventory request, the inventory item ID is empty or incorrect
Missing location details
Before you run the respective order, inventory, or fulfillment flow, in the Integration App > Settings > General section, in the Map NetSuite locations with Shopify locations setting, you can map 1:1 locations between NetSuite warehouse locations and Shopify stores. When a NetSuite location has no mapped Shopify location and no default is set with the Use Custom Default Value option, the request is sent with an empty location ID, and this error is displayed.
Item inventory ID is empty
When you provide a 1:1 mapping between a NetSuite item and a Shopify product using the inventory item ID of the particular item, we sync the inventory item ID details to the Celigo Shopify Item ID Map record. When the request has an empty inventory item ID or invalid inventory item ID, the error mentioned above message is displayed.
To resolve this error, it is recommended to sync the item and variant details between the Shopify catalog and the NetSuite items list. Run the Shopify Product Id to NetSuite Item Mass Update flow to sync the variant ID, inventory item ID, and product ID.
Item ID is incorrect
To maintain accurate inventory and product data synchronization between Shopify and NetSuite, it's crucial to ensure that the Shopify product ID, Shopify variant ID, and Shopify inventory item ID in NetSuite all match with the corresponding records in Shopify. This alignment is essential for seamless operations and effective management of your online store's inventory and product information.
To do this, you can manually correct the data in NetSuite or manually run the Shopify product ID to NetSuite item (mass update) flow. However, if you run the Shopify product ID to NetSuite item (mass update) flow, it will process data for all items but it won't create duplicates.
Often, the item isn't missing a field. Instead, the Shopify IDs stored for the NetSuite item point to a product that was deleted or recreated in Shopify. For example, if a recreated product has the same SKU as the original, the Shopify product ID to NetSuite item (mass update) flow copies the original product's IDs. To fix this:
- In the Celigo Shopify Item ID Map list, update the item's product ID, variant ID, and inventory item ID. Make sure the old and new products in Shopify have different SKUs.
- Resend the item with the NetSuite inventory to Shopify inventory (add or update) flow. Don't retry the failed record. Retrying resends the old ID, so it fails again.
- If Always sync inventory levels for the entire catalog (Settings > Inventory) is on, the item is exported on the next flow run.
- If it's off, the flow exports an item only when its quantity available changes. Create an inventory adjustment of 1 for the item in NetSuite and run the flow. Then delete the adjustment and run the flow again.
If the product is discontinued, archive it in Shopify with no sales channel. Then go to Settings > Inventory and disable Sync inventory levels for both published and unpublished Shopify items.