Hi there,
I’ve exported a csv with Name, SKU and Stock columns. When a product is Out of Stock it’s market with value 0, when it’s in stock its market with value 1, when it’s on backorder it’s market on back order.
There are a few different columns that control stock, since there’s a switch between in-stock/out-of-stock/on-backorder configuration to one with actual stock numbers. That is set by Enable stock management at product level
setting:
https://d.pr/i/HgWXBM
The data formatting across stock_status
, backorders
and manage_stock / stock_quantity
fields changes depending on your configuration and your import has to match that exact formatting.
The quickest way to look up the kind of formatting you need is to create a couple of products with different settings, export, open the .csv file and check the values in these fields.
So if I export products file with Name, SKU and stock columns and change the “Stock” value to 1 for each product, then reupload the products csv to woocommerce checking that option you’ve provided, all of the product Stock values should be updated to 1 (which means all products will be displayed as in stock) and no other changes will be made to my products (i’ll keep names desc etc), correct?
You can specify which particular fields you’d like to export, but since stock is controlled by a few different columns and those might be used differently depending on your configuration – I’d suggest exporting all stock-related columns.
Also, is it possible to make a selection of which products i’d like to export by selecting their checkboxes?
You can select which product types or categories you want to export but you may need an additional plugin if you’d like to select individual products.
I hope this helps!