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

Related content

  • WooCommerce: Import California Tax Rates (.csv)
    It took me ages to find a way to import ALL California tax rates into WooCommerce. I started by hand, and after a while I said to myself “California is crazy! I wouldn’t want to be an accountant there!”. As usual, I looked for existing free and premium plugins, but I decided to do it […]
  • WooCommerce: Allow CSV Product Export By Tag
    Ok, this is a little hacky and pretty manual, but it happened to me in the past that the inbuilt WooCommerce CSV product export was just not enough. In other words, the default product export that you can find by clicking the “Export” button on the “Products” WordPress Dashboard screen, gives you the option to […]
  • WooCommerce: How To Set Up Dropshipping
    Are you interested in dropshipping but don’t know what you need to get started?  Join me as I explain how to start dropshipping in WordPress with the right tools and no monthly payments. If you’ve considered using WooCommerce as your dropshipping platform there are many ways you can implement it – one on the solutions […]
  • WooCommerce: How To Migrate From Shopify
    WooCommerce and Shopify are two of the greatest and most popular eCommerce platforms that allow you to create your online store and generate significant income.  However, as businesses grow – the need for a customizable, flexible, and feature-packed eCommerce platform that offers better control arises. And this is why some entrepreneurs migrate their online store […]

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. Follow @rmelogli

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.

Leave a Reply

Your email address will not be published. Required fields are marked *