Title: Variation import problem
Last modified: October 24, 2017

---

# Variation import problem

 *  Resolved [Davinder](https://wordpress.org/support/users/davinderschiedel/)
 * (@davinderschiedel)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/variation-import-problem/)
 * I’m trying to import variations to show up automatically. However, when I used
   the attached spreadsheet, it doesn’t show up the variations based on the attributes.
 * [https://1drv.ms/u/s!AmPU40NVDqQxx0IeXdA7U6xu0kNn](https://1drv.ms/u/s!AmPU40NVDqQxx0IeXdA7U6xu0kNn)
 * However, if I go into the product and manually create the variations, it’s fine
   and works. However, when I then export the working product and try and create
   a similar product, it doesn’t import the variations automatically.
 * Any help is appreciated.
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fvariation-import-problem%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [Stuart Duff – a11n](https://wordpress.org/support/users/stuartduff/)
 * (@stuartduff)
 * Automattic Happiness Engineer
 * [8 years, 7 months ago](https://wordpress.org/support/topic/variation-import-problem/#post-9616301)
 * Hey [@davinderschiedel](https://wordpress.org/support/users/davinderschiedel/),
 * It seems the One Drive link you supplied is broken.
 * As a test for you, however, I created a single product on an install of WooCommerce
   v3.1.2 that had several variations added and then exported that product using
   the default **WooCommere > Products > Export** functionality.
 * After export I changed the CSV column **Parent** to have the same ID as the product,
   I am importing, and the variations should be imported for and re-imported this
   and a new product with variations was created.
 * Screencast of import testing: [https://imgur.com/a/pbSdz](https://imgur.com/a/pbSdz)
 * I have also attached the CSV file which I used for testing the variable product
   import so you can see how this was formatted which you can find below.
 * [https://nofile.io/f/8Oxc5sR8qkd/test-variable-import.csv](https://nofile.io/f/8Oxc5sR8qkd/test-variable-import.csv)
 *  Thread Starter [Davinder](https://wordpress.org/support/users/davinderschiedel/)
 * (@davinderschiedel)
 * [8 years, 7 months ago](https://wordpress.org/support/topic/variation-import-problem/#post-9616333)
 * Cheers. I was doing quite a bit of testing and finally cracked it.
 * I didn’t have the following in my CSV
 * Meta: attribute_data:pa_colour
    1|1|1
 * It seems to have fixed it 🙂

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

The topic ‘Variation import problem’ 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

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

 * 2 replies
 * 2 participants
 * Last reply from: [Davinder](https://wordpress.org/support/users/davinderschiedel/)
 * Last activity: [8 years, 7 months ago](https://wordpress.org/support/topic/variation-import-problem/#post-9616333)
 * Status: resolved