Title: Update variable products quantity using CSV
Last modified: April 22, 2020

---

# Update variable products quantity using CSV

 *  Resolved [damatt](https://wordpress.org/support/users/damatt/)
 * (@damatt)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/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.

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [arcangelini](https://wordpress.org/support/users/arcangelini/)
 * (@arcangelini)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/update-variable-products-quantity-using-csv/#post-12750981)
 * Hey [@damatt](https://wordpress.org/support/users/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](https://woocommerce.com/products/product-csv-import-suite/?aff=10486&cid=1131038)
   then you are welcome to reach out to use for support by using the ticket form
   found in [your account page](https://woocommerce.com/my-account/create-a-ticket/).
 * 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:
 * [⌊Screenshot⌉⌊Screenshot⌉[
 * 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!
 *  Thread Starter [damatt](https://wordpress.org/support/users/damatt/)
 * (@damatt)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/update-variable-products-quantity-using-csv/#post-12751407)
 * [@arcangelini](https://wordpress.org/support/users/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 warehouse
    -  This reply was modified 6 years, 1 month ago by [damatt](https://wordpress.org/support/users/damatt/).
    -  This reply was modified 6 years, 1 month ago by [damatt](https://wordpress.org/support/users/damatt/).
 *  [arcangelini](https://wordpress.org/support/users/arcangelini/)
 * (@arcangelini)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/update-variable-products-quantity-using-csv/#post-12751708)
 * Hey again [@damatt](https://wordpress.org/support/users/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:
 * [⌊Screenshot⌉⌊Screenshot⌉[
    [⌊Screenshot⌉](https://d.pr/i/1h7eqI)
 * 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!
 *  Thread Starter [damatt](https://wordpress.org/support/users/damatt/)
 * (@damatt)
 * [6 years, 1 month ago](https://wordpress.org/support/topic/update-variable-products-quantity-using-csv/#post-12754027)
 * [@arcangelini](https://wordpress.org/support/users/arcangelini/)
    Thanks a lot,
   in this way I’ve solved my problem

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Update variable products quantity using CSV’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [variations](https://wordpress.org/support/topic-tag/variations/)

 * 4 replies
 * 2 participants
 * Last reply from: [damatt](https://wordpress.org/support/users/damatt/)
 * Last activity: [6 years, 1 month ago](https://wordpress.org/support/topic/update-variable-products-quantity-using-csv/#post-12754027)
 * Status: resolved