That is simple, first export exports from WooCommerce and you will get the CSV file. There you should find columns related to this plugin, according to the location ID, you can modify the values for all of your products.
Follow these steps:
1) Create locations in WordPress, enable them
2) Select under the product, enter some stock values
3) Export from the WooCommerce products list page, including metadata
4) Find the relevant column and recreate columns for each store/location while completing your file for other products too.
If you need further help, you can use the urgent help option under the help tab on the settings page.
Hi Fahad,
Thanks for the guidance. I have a problem though in that when I’ve exported the products, I don’t see the field for locations, despite a location being set in the backend for one of the products. Its like the field isn’t being exported from the WooCommerce product export option, despite all the custom fields etc being marked to have the export.
Those fields are actually metadata, so please export the meta fields too.
I already have that option checked and its not pulling through. I’ve tried to reach you through Skype, with the wordpress mechanic account or the Google Meets link if you are free?
This was resolved by exporting the products as usual through woocommerce, meta etc included. My problem came from expecting the names of the stock locations, rather than their IDs in the export.
In my case, Meta: _stock_at_354 was the field name I was looking for. This ID lined up with the ID that appears when hovering over a stock location in Products > Stock locations and looking at the URL in wp-admin. So to get the stock locations set against each product, a Meta: _stock_at_354 or Meta: _stock_at_350, etc. would have to be set up in the columns and the number of stock at that location, put in as the number for that field.
After this, I was instructed to run a curl job from the WooCommerce > Stock Locations for WC > Crons which will keep the stock of the overall product, updated with the total stock of the locations. We’ve set that to run every 5 minutes.
Thank you, hopefully this support thread will help other users too.
