WooCommerce: How to Export/Import Products

Maybe you don’t know that, but WooCommerce has an inbuilt functionality for importing and exporting products from CSV/XML files. Therefore, most of the times, you don’t need a premium import/export plugin.

Simply go to WordPress Dashboard > Products > All Products and click on Import (or Export) and follow the instructions. That’s it!

This is a new functionality introduced since WooCommerce 3.0 and it’s working like a charm.

For more advanced import/export, automatic updates from server and more complex functionalities, take a look at WP All Import + WooCommerce Add-On

Rodolfo Melogli

Business Bloomer Founder

Author, WooCommerce expert and WordCamp speaker, Rodolfo has worked as an independent WooCommerce freelancer since 2011. His goal is to help entrepreneurs and developers overcome their WooCommerce nightmares. Rodolfo loves travelling, chasing tennis & soccer balls and, of course, wood fired oven pizza.

22 thoughts on “WooCommerce: How to Export/Import Products

  1. We are having a nightmare over and over dealing with product imports/exports the only system that works with Product bundles correctly is the built in system (which is manual) Do you know of a way to call this system through code to automate some of the tasks. We have tried them all and have had custom code added to example webtoffee and still have issues. Please help!!!

    1. I’d need to research that, and see if the inbuilt import/export can be triggered by a cron job. If you’d like to get a quote, feel free to contact me here. Thanks a lot for your understanding!

  2. The plugin does not import images. I get error codes.
    Then your article goes into “PHP Snippets” without any context. What are the snippets for and where is the code? You were talking about a plugin which is installed normally, not with code.
    Just a very confusing article and the plugin does not import my images.

    1. Shelly, thanks so much for your comment! You’re right, the plugin hasn’t been updated in over 4 years 🙂 Just so you know, WooCommerce now allows you to export/import products out of the box: go to Products > Export or Products > Import. Let me know if that exports/imports images as well.

    2. Rodolfo, the core WooCommerce export/import products does import the product images correctly.

  3. Thanks!
    It still works, but without gallery images 🙂

    1. Thanks for your feedback Dawid!!!

  4. Good morning Rodolfo,
    I need your help. I’m using wp all import to import massive product in woo commerce.
    My need now is to import the product category image in order not to have import one each manually.
    Does exist a sort of plug in for solving my need?
    thanks for you attention
    Matteo

    1. Hey Matteo, thanks for your comment! If I were you I’d contact WP All Import support, as tat is the reason you’re paying for a premium plugin – I’d be surprised if you can’t achieve what you want with their help 🙂 Let me know how it goes!

  5. Hi Rodolfo Melogli,

    Nice plugin to Export all woocommerce product images. I have use this plugin and it’s export all product featured image form one store to another. But till i am face one issues. It’s can’t export product gallery images. So please help me how to export product gallery images also.

    I am waiting your replay.

    Thanks,
    Ketan.

    1. Hey Ketan thanks for your comment! This plugin hasn’t been updated in 2 years so I’m not sure it even works… but in regard to the product gallery I’m afraid you will need a premium export/import plugin. I use WP All Import with WooCommerce add-on which is quite expensive – not sure about the others to be honest 🙂

  6. Thanks for this article, exactly what i needed!

  7. Do you export as posts or products? I tried both and both failed. Thanks for the suggestion – hope I can get it to work.

    1. Yes, it seems that free plugin hasn’t been updated in 2 years. However you don;t export as posts or products, you have to go to Tools-> Export Featured images. Did you try that already?

  8. import failed

    1. RJ thanks for your feedback! What error did you get?

      1. I had the same problem. Once I tried to import it said “Import Failed”. This is what I see for all 696 of my product featured image names:

        Failed to import Media “download”
        Failed to import Media “canopla-microfone-digital-video-destaque”
        Failed to import Media “cloud-activator-cl1-cloudlifter-mic-2”
        Failed to import Media “canopla-microfone-1”
        Failed to import Media “avisos-luminosos-para-radios-tx”
        Failed to import Media “avisos-luminosos-led-amarelo-destaque”
        Failed to import Media “auralex-mudguard-mic-shild”
        Failed to import Media “BRAÇO ARTICULADO PARA MONITOR MIKA YELLOWTEC M”
        Failed to import Media “Suporte Para Microfone Mika Yellowtec”
        Failed to import Media “Mika Estudio de Luz”
        Failed to import Media “Filtro pop para Micronone qmic q25”
        Failed to import Media “Q-mic 27g filtro pop microfone”
        Failed to import Media “Q-Mic QM-30 Pop Filter”
        Failed to import Media “Q-MIC REFLEXION FILTER QM-101”

        1. Hey Felicia thanks for your feedback! If you followed my instructions then it could be that the plugin hasn’t been updated in 2 years. There are paid plugins that would do the transfer very easy, however your error could also be due to the Upload Limit in WordPress. Have you tried with other imports, do they fail as well?

  9. Thank you, this plugin is exactly what I needed.

Questions? Feedback? Support? Leave your Comment Now!
_____

If you are writing code, please wrap it between shortcodes: [php]code_here[/php]. Failure to complying with this (as well as going off topic, not writing in English, etc.) will result in comment deletion. You should expect a reply in about 2 weeks - this is a popular blog but I need to get paid work done first. Please consider joining BloomerArmada to get blog comment reply priority, ask me 1-to-1 WooCommerce questions and enjoy many more perks. Thank you :)

Your email address will not be published.