Question:
SKU's were deleted a few months ago and we want to list the products again but are getting a 404 error upon creation. We tried pushing the SKU's but we still get an error. When we create the SKU's manually it does sync. Is there a rule that or a conflict with Shopify trying to "recreate" an SKU after it's been deleted in Shopify?
Answer:
When updating an item in Shopify, it requires an ID (called a Shopify product ID), which is similar to the NetSuite internal ID. This ID is auto-populated either when an item is created via the Integration App or a mass Item ID update flow is run.
This linking between Shopify and NetSuite is done via a custom record which is created for each Shopify's store information and contains IDs as shown below:
Once this record is created for any item, any future updates for product or inventory information is done using these IDs only. If the item is deleted on Shopify, this item ID map needs to be updated to reflect the same (ideally it should be deleted) to avoid those 404 errors, as that old ID is not present in Shopify.
We are not supporting deletes at this moment, however, the mass update flow can update the new IDs if an item has been deleted and re-created directly in Shopify. If the item had to be deleted from Shopify and needs to be created via the Integration App, you will have to delete this custom record (which will make the Integration App assume that it is a new item) for that store and run the item export flow.