Variable products show out of stock

Hi there,

Thank you for reaching out!

I understand that you’ve imported quite a few products to your new WordPress/WooCommerce store but all the variable products are out of stock.

It sounds like stock numbers were not imported correctly for variable products.

I’d suggest exporting your products to a .csv file using the default importer/exporter, opening the file in Excel or Google Sheets, making sure the stock is specified correctly for each variation and re-importing.

You could also compare the exported .csv file with the file you used during the migration, although that still needs to be done manually.

The only other way to fix stock numbers when those were not imported correctly is to adjust stock numbers via bulk product editing.

I hope this helps!

Hello,

Thank you for your reply.

I thought bulk editing would be the only available option too.

My old website did not have any stock management functionallity turned on. Why did this happen then?

Thank you.

Hi @kyledab0y7,

It could have been some misconfiguration within the CSV file during importation from the PrestaShop install to WoooCommerce as both would have different inventory systems and CSV columns.

You could also instead of bulk editing export the products, change the stock status with the exported CSV and reimport those again. When re-importing you’ll want to enable this setting in WooCommerce Product Importer so existing products are updated with the stock setting changes.

Image Link: https://cloudup.com/cxDjDcLkvFi

• This reply was modified 4 years, 9 months ago by Stuart Duff - a11n.

Hi @stuartduff

So let me know if I get this right.

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.

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?

Also, is it possible to make a selection of which products i’d like to export by selecting their checkboxes?

Thanks.

• This reply was modified 4 years, 9 months ago by kyledab0y7.

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!