Shopify product cost sync questions
Hi, I have a custom action which pulls product costs from a separate system, compares them with the Shopify product cost data in gadget (in shopifyInventoryItem), and then runs through updating any that have changed in Shopify directly by running a graphql inventoryItemUpdate mutation on each. This action runs daily at 6am.
Questions:
1) My gadget db currently has 2 cost fields in the shopifyInventoryItem table; "cost", and "unitCost". The latter containing an object with "amount" and "currencyCode". I am on API "2025-10" which has been upgraded before, so I am assuming "cost" is just a legacy field?
2) I have a product at the moment which contains a price which is out of sync with what is shown in Shopify, I believe it was updated this morning via my task, but the updated cost is not yet reflected in the Gadget DB. Does a graphql inventoryItemUpdate mutation not trigger a webhook that would update the relevant data in the gadget DB? If it does not, is there some sort of overnight sync that eventually catches this? And if there is, can I tell when that catchup sync runs?
3) If there are a lot of costs that change in one day, I am looking to shift to using a bulkOperationRunMutation instead to update the costs in Shopify, would this trigger any webhooks to sync the data back to Gadget?
If the way I am updating the Shopify data is not triggering a sync back, I may well just update the data directly in the Gadget DB at the same time.
Questions:
1) My gadget db currently has 2 cost fields in the shopifyInventoryItem table; "cost", and "unitCost". The latter containing an object with "amount" and "currencyCode". I am on API "2025-10" which has been upgraded before, so I am assuming "cost" is just a legacy field?
2) I have a product at the moment which contains a price which is out of sync with what is shown in Shopify, I believe it was updated this morning via my task, but the updated cost is not yet reflected in the Gadget DB. Does a graphql inventoryItemUpdate mutation not trigger a webhook that would update the relevant data in the gadget DB? If it does not, is there some sort of overnight sync that eventually catches this? And if there is, can I tell when that catchup sync runs?
3) If there are a lot of costs that change in one day, I am looking to shift to using a bulkOperationRunMutation instead to update the costs in Shopify, would this trigger any webhooks to sync the data back to Gadget?
If the way I am updating the Shopify data is not triggering a sync back, I may well just update the data directly in the Gadget DB at the same time.
