Currently we are doing a weekly inventory transfer from one Shopify store to another. Right now the process is very manual. Is there any way to import SKU and quantity information from Excel into Shopify so to not have to manually enter in each SKU and quantity that needs to be transferred?
You can generate an inventory csv and import it into your second store: https://help.shopify.com/en/manual/sell-in-person/shopify-pos/inventory-management/export-import-inv...
Another option would be to use an app to automate the weekly update of stock levels. You can do it through our Channelup app whereby you set a schedule can be daily, hourly, weekly and we import your inventory from one store and then export it into your second store.
We have set up an instant inventory sync between two stores for multiple customers. Please see a demo video below
The inventory instantly syncs between both stores in the event of inventory updates, orders or any other method used for inventory change.
Let me know if you have any questions on DM or email@example.com
Take a look at Mixtable's Google Sheets-like spreadsheet interface to manage your Shopify product inventory. Mixtable works like Google Sheets, and syncs data to and from Shopify out of the box. So you can set up two columns to track the inventory at each location, and very quickly move inventory from one location to the other by simply updating the relevant cells.