Title: CSV Import
Last modified: March 8, 2021

---

# CSV Import

 *  Resolved [ezoranne](https://wordpress.org/support/users/ezoranne/)
 * (@ezoranne)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/csv-import-53/)
 * Hello,
    I have an online store with woocommerce. I have a catalog of about a 
   hundred products. I have several problems in the last few days. Here’s the conexte:
   I had to change supplier, so my internal SKUs will evolve, the pictures of my
   products will change, the attributes too (I created the new ones for the mapping).
   I’d like to do a mass import with a CSV file. For that, I made an export of my
   catalog in order to have the right column headers, then I changed the infos of
   my products. – I wanted to do a test on a variable product (I only have variable
   products) before launching on the whole catalog. But when importing, which can
   be done with ID or SKU, I have the impression that the SKU has priority over 
   the ID, and my import fails. – I tested by removing the SKU column, the import
   removes all my variations.
 * My question is: how can I make a clean import that takes all my data from the
   CSV, including the modified SKU, and using the product ID and not the SKU as 
   a reference?
    And if possible, do an update import, AND the simultaneous creation
   of new variations on some products.
    -  This topic was modified 5 years, 3 months ago by [ezoranne](https://wordpress.org/support/users/ezoranne/).

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

 *  Plugin Support [EastOfWest a11n](https://wordpress.org/support/users/eastofwest/)
 * (@eastofwest)
 * [5 years, 3 months ago](https://wordpress.org/support/topic/csv-import-53/#post-14155948)
 * Hi there,
 * First, I would suggest setting up a staging site on which to test-run this, as
   it often takes several tries to get right within a particular setup, and it’s
   best to do it away from your live site while you get the hang of it.
 * It’s important to properly link your parent VARIABLE-type product to its child
   VARIATION-type sub-products. Have a look at this forum post from before that 
   deals with a similar situation:
    [https://wordpress.org/support/topic/change-existing-sku-product-in-csv-bulk/#post-13681170](https://wordpress.org/support/topic/change-existing-sku-product-in-csv-bulk/#post-13681170)
 *  [MayKato](https://wordpress.org/support/users/maykato/)
 * (@maykato)
 * [5 years, 2 months ago](https://wordpress.org/support/topic/csv-import-53/#post-14191525)
 * Hi [@ezoranne](https://wordpress.org/support/users/ezoranne/)
 * We’ve not heard back from you in a while, so I’m marking this thread as resolved.
   If you have further questions, please feel free to open a new topic.

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

The topic ‘CSV Import’ 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/)
 * [sku](https://wordpress.org/support/topic-tag/sku/)

 * 2 replies
 * 3 participants
 * Last reply from: [MayKato](https://wordpress.org/support/users/maykato/)
 * Last activity: [5 years, 2 months ago](https://wordpress.org/support/topic/csv-import-53/#post-14191525)
 * Status: resolved