Can Excel data import simplify weekly inventory transfer in Shopify?

SotaClothing
Visitor
2 0 1

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?

Replies 3 (3)

productsync
Shopify Partner
740 38 159

Hi

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.

Regards

Tom

Anto_S
Shopify Partner
148 4 19

Hey @SotaClothing 

We have set up an instant inventory sync between two stores for multiple customers. Please see a demo video below 

https://www.loom.com/share/3b71538b95c944308b13634ccdd42219

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 anto@comstack.co

Thanks!

 

Automating Commerce at Comstack.co
Email: anto@comstack.co

natashadisante
Shopify Partner
126 0 14

Hi @SotaClothing 

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.