I’m looking to create a Flow automation for product inventory mutation based on when an item with the same SKU stocked at a different location is ordered/that quantity changes. I’m having a lot of trouble finding information on this.
Use: You have one set of inventory, but due to UI reasons, the products are separated in digital locations on the Admin for the online store and the POS. When an order is placed online or in-person, the inventory for both separate products that have the same SKU would be reflected as the same.
Sure. I want to update inventory for two products with the same SKU stocked at different locations.
An example would be: I have a candle product, with 10 in stock. But I have a ‘location’ setup in the Shopify admin for the online called “Main Store”, and a ‘location’ setup in the admin for POS/in-person called “POS Store”.
The price of the candle online is $15, but in-person it’s $10, so I create two separate products but their SKU’s are the same. I want the inventory for “Main Store” and “POS” to sync when either an online or POS order is placed without having to manually update the other product.
If an online order is placed, bringing the “Main Store” inventory to 9pc, I want to automatically sync the inventory in “POS” to be 9 also.
Does that make sense?
Syncing inventory like this is quite difficult. I might explore native options more first. This seems like maybe a markets use case, which would allow using single products an where you control the pricing for each market.
The problem with updating inventory when another inventory is updated is that you create an infinite loop where things are continually updating. In addition, you can’t tell from the inventory trigger which location inventory has changed. So you would need to store that info too.