Update variable products quantity using CSV
-
I need to edit the stock quantity of product variations using a CSV file.
The problem is due to the fact that I need to do it using as reference the parent SKU.
When I import a CSV file using as fields “type, parent, stock, attribute name, attribute value“, nothing change in the stock quantity of the prduct variation.
I tried using all the available fields in the csv files and the only solution that I found is to use the ID value of the variation.
I’m able to import new products with variations without problem, I’m in trouble only when I want to update the quantities.
-
Hey @damatt !
It sounds like you may be using a plugin or extension to import/export your product variations. If you are using our extensions ⇢ Product CSV Import Suite then you are welcome to reach out to use for support by using the ticket form found in your account page.
If that is the case then you should be able to use the “Merge Product Variations” option to import a CSV to update the stock. Be aware that you need to use at the very least the Parent Post ID or SKU along with either the Variation SKU or ID to properly update the correct variation. Here is an example of how I did it:
If you are using a different plugin then you will need to reach out to that plugin developer for better assistance.
I hope this helps!
@arcangelini
I’m not using any plugin or extension to import/export products. I just use the import option in the product list page. The csv is produced by an excel file that i use to manage my warehouseHey again @damatt !
Thanks for clarifying.
In that case you will want to make sure all your variations have a unique SKU. Then you can create a CSV with SKU and Stock for the columns. As long as the SKU matches the variation and you select the option for “Update existing products” you should have no problem managing the stock for your variations.
Take a look at this example:
If you are having any troubles with this share a screenshot of the import page where you are setting the columns along with the CSV you are using.
Thanks!
The topic ‘Update variable products quantity using CSV’ is closed to new replies.
