I have built a data flow updating pricing in product variants in 2 Shopify stores using data from Dear Systems and it is incredibly slow. It is taking hours to update pricing on 64 variants and I plan on updating thousands across 5 channels I've been waiting for this to finish its run so I can report how long it is taking but it is seriously too long to wait.
I am not using any lookups or conditional split logic after the source module just an SQL query on Dear(source) retrieving products updated in the last 30 minutes directly connected to 2 targets (Shopify Stores) using a split module
I have all of my Shopify variants IDs stored in my Dear database (customs fields) so the flow doesn't require doing lookups in Shopify to get the IDs etc.
I understand the answer might be a limitation of the Shopify API but the reason for using Skyvia this way is Dear doesn't currently support bulk updating products in Shopify channels based on recently updated and requires re-listing all products in the system to the channel again as well as updating stock quantities, but even that takes a fraction of the time it takes to update just 64 variants at the moment in Skyvia.
If you could please point me in the right direction or have any suggestions for optimizing the data flow that would be great. Can Skyvia use the bulk update features of the GraphQL API? I also have the product ids available for each row is it possible to use this somehow to optimize?