Product Importer Deluxe is a user-friendly Product importer enabling store owners to bulk import Products, Variations, Categories, Tags, and other Product details into your WooCommerce store.

Upgrading immediately makes it possible to bulk import:

  • Products – Simple, External, Variable, Variations, Simple Subscriptions and more
  • Global and per-Product Attributes
  • Featured Image and Product Gallery images
  • Categories
  • Tags
  • Brands
  • File Downloads
  • Up-sell and Cross-sells
  • Custom Product meta

New Product details are being added with each major Plugin update and regular minor Plugin updates add new import fields ready to be included in imports.

Product Importer Deluxe can merge Product changes against existing Products with live and post-import reporting. Product details assigned to Products within the CSV file are all generated at import time making setting up your next store a simple one-step import process.

To make store migrations even easier we include free licenses of our popular export Plugin Store Exporter Deluxe so you can immediately export Products from existing WooCommerce store’s ensuring import compatibility.


Native imports

We natively import Product details from many popular WordPress and WooCommerce Plugins including:

  • WooCommerce Subscriptions
  • WooCommerce Multilingual (WPML)
  • WooCommerce Custom Fields
  • WooCommerce Ultimate Multi Currency Suite
  • Simple SEO Meta Tags
  • YITH Brands
  • Jigoshop SEO Deluxe
  • Ultimate SEO
  • Yoast’s WordPress SEO
  • Custom Fields
  • MP3 Player Plugin for WordPress
  • All in One SEO Pack
  • Advanced Google Product Feed
  • Related Products
  • Wholesale Pricing

Native support for additional Plugins are being added with each minor Plugin update and are available to import as soon as you update.


Screenshots


Compatibility

  •  WooCommerce (up to 3.0.*)
  •  Jigoshop (up to 1.17.*)
  •  WP e-Commerce 3.7 ready (up to 3.7.8.3)
  •  WP e-Commerce 3.8 ready (up to 3.11.*)

Updates

The latest release can be downloaded from your My Account page as well as opening Dashboard > Updates from the WordPress Administration of your store.

Comments

  1. Hi Michael!

    There is another problem.

    If I used Product Importer Deluxe in conjunction with Google Product Feed it generate a Fatal Error because code uses some function not present in the plugin (these functions are: jigo_pd_is_valid_gpf_availability, jigo_pd_is_valid_gpf_condition, jigo_pd_is_valid_gpf_gender, jigo_pd_is_valid_gpf_age_group). I solved temporary this problem by disabling these functions.

    Can you fix this?
    Thanks.

  2. Hi Michael!
    I buy your fantastic plugin!

    I try to import part of my product for test (I have more then 10.000 products).
    I have ONE ONLY PROBLEM: tax classes are not set!
    I have 4 tax clasess (NO IVA, IVA 4, IVA 10, IVA 21) and on CSV I set the relative class for each product, but when import the CSV every product has set STANDARD tax classes o_0

    Can you help me?
    Thanks.

    • I think I discovered the error.

      During the import for product tax class is writing a meta_key tax-class with the value entered in the CSV (in my case value inserted is iva-21), but should be inserted a meta_key TAX-CLASSES with a serialized array of value added in CSV (eg.: a:1:{i:0;s:6:”iva-21″;})

      Can you verify if it’s true?
      Thanks!

      • Hi Michael!

        I made several tests and finally I found and fixed this small bug!!!

        If we insert manually a new product and set for it a tax class in the database we find meta key tax_classes and not meta key tax_class.

        After checking several times the name of the meta key saved, I went looking for the function where the meta key was inserted / updated.
        So I modify file functions.php (in the folder /includes) at lines 926 and 1578, replacing:
        update_post_meta ($ product-> ID, 'tax_class', $ product-> tax_class)
        with:
        update_post_meta ($ product-> ID,' tax_classes', array (0 => $ product-> tax_class));

        I tried again to import the products and tax classes now are saved correctly!!!

        For all the rest your plugin works fine!
        Hope this is useful for updating your fantastic plugin!

        Ciao!

          • Hello Michael …
            I bought the plugin “CSV Importer Deluxe” seems to work fine, except tax classes.

            It’s the same problem described by David in this post …. but, still following his instructions, did not get any results ….

            how can I fix this? Thank you.

  3. I was looking for the detailed instructions on how to use the extension. I have to turn over control of the web site to the owner and teach her how to you the importer.

    thanks

  4. I am very interested in this plugin because in these days I’m doing the porting of my site to Jigoshop.

    So I would like to have some additional information about the plugin.
    Can I assign a tax classes to the product?
    Can I assign product visibility?
    Can I assign one or more attributes for the product?
    Can I assign a stock quantity for the product?

    Thanks!

    • Hi Davide, you can assign Tax Classes. You can assign Product visibility. You can assign multiple Attributes using the Category separator character (defaults to ‘|’, pipe). You can assign Stock Quantity, if you leave it empty it’s unlimited, if it’s set to ‘0’ it’s out of stock.

      I’ll put up a post now detailing the supported Product fields. Hope this helps! 🙂

  5. Oh, and is there any sight on when it will be possible to import variations as well? Much needed :)!

    thx,
    Harold

    • Agreed! ^ I’m still debating whether or not to use Magento or WP+Woo+this plugin. Time is running out, though. :/

  6. Recently I bought your plugin Product Importer Deluxe for WooCommerce, a pretty handy plugin!
    But I get dozens of error messages, obviously only when an image cannot be found:

    Warning: copy(610030.jpg) [function.copy
    ]: failed to open stream: No such file or directory in /home/tshirtt/public_html/wordpress/wp-content/plugins/woocommerce-product-importer-deluxe/includes/functions.php on line 1100 (
    (on the domain http://tshirttoppers.nl/wordpress)

    Is there not a way to skip the images that are still missing? Now I have to do the whole import all over again and again? (I don’t know which images are missing and how many of them…)

    thanx! Harold

    • Okay, okay, I found it: When you upload images in WordPress the spaces are converted to _ unscores and brackets are deleted. So the plugin is not able to find the image (2000_white_red-2lr1.jpg instead of 2000_white_red (2)lr.jpg), which gives the error.

      …why didn’t I think of that in the first place… 🙂

    • Okay, okay, I found it: When you upload images in WordPress the spaces are converted to _ unscores and brackets are deleted. So the plugin is not able to find the image (2000_white_red-2lr1.jpg instead of 2000_white_red (2)lr.jpg), which gives the error.

      …why didn’t I think of that in the first place…

  7. For such an expensive plugin, I really expected more. You guys need to add some kind of column mapping so we don’t have to re-match all the columns in each import.

    And I was only importing 486 products. I had to split the file in 8 parts so the importer would take it without giving me a 500 error.

    Can I get my money back?

    • Hi Carlos, column mapping is supported, simply use the sample CSV templates provided and the importer will link them up for you. I’ve raised an Idea to remember column mappings when the same CSV file is re-uploaded after import (e.g. merging updates).

  8. There seems to be a problem with attributes not updating when merging products:

    Whenever I try to update an existing product the new attributes aren’t added.
    For example, a product might have the attribute ‘Bat Size’ with size 1,2 and 3. I then want to merge the product with an updated version including adding sizes 4 and 5 to the current three. However, when merging (checking ‘I am merging Product changes’ on import) this doesn’t happen.

    The only way I can get round this at present is if I completely delete the original products and re-upload from scratch.

  9. Also waiting on this product. Any new update on time before its in the extensions shop?

  10. Hello,
    I ‘m very interested in the plugin, but i see no possibility for making subcategorys. And can I send only one picture per product?

    Thanks in advance,
    Ger

    • Hi Ger, you can create sub-categories by filling the Category column as below.

      Category A>Category B>Category C

      This will create the Categories lists above and set the ‘Category A’ as the parent Category and ‘Category B’ as its child Category with ‘Category C’ belonging to Category B.

  11. Does product importer only support csv files?
    I would also like to import amazon products.
    How to accomplish this ?

    • Hi Pao, the importer only supports CSV files. You can save any Excel or spreadsheet file. If your Amazon Products are exported in the above formats you can import them into WooCommerce. 🙂

  12. Hello Michael i was just wondering if this would help me to attach downloads to 1000+ products all at once in csv? I have put all my downloads in the downloadable folder. Please let me know before I make the purchase. Thanks

    • Hi Dom, simply fill the Filename column with the filename (relative filename only, e.g. file-a1.zip), since you’ve already uploaded your download files to /wp-content/uploads/wpsc/downloadables/… you’re now ready to import! 🙂

      • Thanks a lot for the reply! Do u by the chance have a coupon code for purchasing this plug-in? Discount? It seems a bit pricy…or is it maybe going to go on sale soon?
        Thanks

  13. Michael,

    Is the product importer able to handle a CSV file exported from ShopperPress?

    T

    • Hi Tom, without knowing the CSV field format that ShopperPress uses I can’t confirm, send me a copy of your CSV and I’ll confirm and update this comment. 🙂

        • Hi Tom, ShopperPress will work as the minimum required fieldsa re all in there. SKU, Product Name, Price and Category.

          Here are how the columns match up with my importer.

          post_title = Product Name
          post_excerpt = Product Description
          post_status = Product Status
          comment_status = Comment Status
          image = Image
          price = Price
          qty = Quantity
          SKU = SKU
          weight = Weight (you’ll need to add a Weight Unit column with the unit measurement; e.g. g, kg)
          category = Category

      • ok. awesome pcoudrt, everything i need. i am ready to purchase. i have a thousand pcoudrts i want to upload. they are in 26 categories.each pcoudrt (letter number) has a corresponding 426 640 image in a file on the server. ../image/letters/a/a1.jpg and so on I assume that the image column in the csv (sample) will be able to handle these requirements.please advise.any other feedback or comments that are public about your pcoudrt?

  14. Any idea when the variation support will be implemented into this plugin? I see a huge calling for it everywhere from the poll in your WP e-Commerce version of this plugin to the Woo Ideas site to forums across the web. That capability alone will be the factor whether or not I use WooCommerce or a different solution like Magento.

    Please let us know an ETA if possible!

  15. Is it possible to import into a custom taxonomy?
    I registered two new custom taxonomies in WPEC called Make and Year.

    Is it possible for me to import into these?

    • Hi silent_soft, custom taxonomies are not supported, I have added Plugin filter support so you can just clone the generate_categories() and process_categories() functions to suit your needs.

      If you could recommend a way to detect linked custom taxonomies within WP e-Commerce then I’d happily add support for automating the import of this.

      • Hi Mike,

        Now that you mention the auto-detect issue, it makes good sense why this isn’t built in. I AM using 2 custom taxonomies though. Would you consider telling me what code I need to edit/add to get Importer Deluxe to import to these for me?

        I am happy to attempt the hack myself and have been playing with it the last few days. Unfortunately, I am pretty stuck. I have have several thousand products and if I can’t get this to work I am really not sure what I will do. :-/

        Thanks in advance!

Add a comment

Before you comment - Do you have a support request? If so, this is not the right place to post it. Please submit support requests for Premium Plugins on the Support page and in the community Support Forums for free Plugins.

Reviews

Here's a showcase of Plugin testimonials received from the Comments section which make our day. :)

  1. US pborde says:

    Michael:
    Now that I have had the benefit of your great products and incredible support for 12 months, I want to tell you that I love your Plugins and your help has been tremendous. This is an absolutely essential Plugin for us.

  2. DE Dietrich says:

    Product Importer Deluxe works excellent!

  3. GB Osman Ahmed says:

    Hi, thanks for this amazing plugin!

  4. IE Andrew says:

    Thanks Michael :)

  5. US DSTP says:

    Hello,

    I've purchased this product and it's working fantastically, a little slow importing/merging change, however this isn't an issue.

    Please can you point me in the direction or provide information for adding additional import field, I've purchased a plugin called Product Price Info and would like to bulk import this information.

    Thanks in Advance.

  6. GB Matt says:

    Hi Michael, really happy with the plugin, features & support. Thanks, Matt.

  7. GB Nikki says:

    Thank you Michael. :-)

  8. US Joshua Wilson says:

    Hello, iv been first using your plug in since it was first developed. I have 22 woocommerce stores with over 10,000 products a store. So i have a lot of importing to do. Once woocommerce came out with their own i started using theirs but its been no where as good as yours. With their plug in i can only import upto 50 products at a time and i keep getting duplicates that drive me annoying. I have to convert 1' 9MB excel file into 1,000 excel files. With your plug in i just keep importing the same excel file and it keeps importing without any doubles. Your picture placing is easier and i like your excel format. Its so much better than Woo's and i have so much to import. Thank you for your work and keep it coming :)

  9. US Ryan says:

    Hi Michael, Many thanks for the plugin, it's a great timesaver. Thanks, Ryan

  10. GB Paul Cutcliffe says:

    Excellent, thanks Michael - keep up the good work!

  11. ZA kim says:

    Everything working GREAT :-)
    Thanks Michael - saving me time already!

  12. US Russ says:

    Thanks for the quick response. It's nice to see developers have this kind of interaction.

  13. US Robert says:

    Holly molly!!! That is the best $95.00 I ever spend. I am still experimenting with 6 items at a time, the product importer worked great LOVE IT.

Support

Product Importer Deluxe comes with a Quick Start document (readme.txt) to help with installing the Plugin, a detailed Usage document is also maintained online. Additional support can be found from the Contact page or methods below.

Documentation

Looking for support, a copy of the readme or usage instructions? Check out our Documentation for Product Importer Deluxe and learn how to take full advantage of the Plugin.

Urgent Support

If you find yourself needing immediate support for your purchase use the Premium Support page or Live Support button.

Product Importer Deluxe Forum

If you have any problems, questions or suggestions please join the members discussion on our Product Importer Deluxe forum.

Recent Topics (134)

Plugin Updates

The latest release can be downloaded from your My Account page as well as opening Dashboard > Updates from the WordPress Administration of your store.

Roadmap

Our Trello boards keep an up to date listing of supported Product import fields as well as upcoming features as indicated on our roadmap. As the end-user you’re driving this Plugin’s future. Here's how you can help.

View and vote for features on our Trello roadmap boards.

Once you've reviewed the list of supported Product fields you can see a explained explanation of each field on the Usage page in our Documentation section.

You can also suggest features here in the Comments section.

FAQ

Supported Product fields

Please see the Trello boards listed on the Roadmap tab of this page.

Am I entitled to future Plugin updates?

You sure are, you can always download the latest release of your purchased Plugin from My Account.

What are the required product fields within the CSV to be imported?

The minimum data requirements for importing new products are:

  • Product Name

The minimum data requirements for merging Product changes are:

  • SKU

We recommend providing as a minimum for an operating store the following Product fields:

  • SKU
  • Product Name
  • Category
  • Price
  • Quantity (for stock limited products)

What import methods are available?

  • Import new Products only
  • Import new Products and merge Product changes
  • Merge Product changes only

Do you have a sample master products CSV file for Product Importer Deluxe?

Sure do, included below are a few samples as well as blank templates to buil from.

Blank CSV template with column names

Sample CSV

  • Sample CSV (1.4 - Updated: 02/08/2012) - with Variations and Table Rate Prices
  • Sample CSV (1.3 - Updated: 26/04/2012) - with Wholesale Pricing, Related Products
  • Sample CSV (1.2) - with Custom Fields, All in One SEO Pack, Google Product Feed support
  • Sample CSV (1.1)
  • Sample CSV (1.0)

Can I link a Product to multiple Categories/Tags/Images, etc?

Sure can, just put a '|' (vertical pipe) character between each item, currently all of the above are supported. In a near future Plugin update multiple file downloads will also be included.

Can I declare sub-categories and establish parent-child relationships with the included Product Category Importer for WP e-Commerce?

Roger that, when declaring a child Category ensure you use place an '>' (arrow) character between the parent and child. With the release of 2.6.5 you can drill down up to 3 levels deep, for instance:

  • Clothes>Men>Casual within the Category column of your CSV file will link a Product to Clothes, Men (as a sub-Category of Clothes) and Casual (as before).