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.1.*)
  •  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.

Screenshots

Reviews

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

  1. GB Tim

    Just wanted to say that I've tried one or two other import / export plugins for WC but Product Importer Deluxe is by far the best, particularly as it also comes with a license for Store Exporter Deluxe. I've found it very simple to use. It works with minimal configuration and it's saved me a huge amount of time. I must also add that Michael has been incredibly helpful too. Recommended.

  2. US Pborde

    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.

  3. DE Dietrich

    Product Importer Deluxe works excellent!

  4. GB Osman Ahmed

    Hi, thanks for this amazing plugin!

  5. IE Andrew

    Thanks Michael :)

  6. GB Matt

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

  7. GB Nikki

    Thank you Michael. :-)

  8. US Joshua Wilson

    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

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

  10. GB Paul Cutcliffe

    Excellent, thanks Michael - keep up the good work!

  11. ZA Kim

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

  12. US Russ

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

  13. US Robert

    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.

Comments

  1. Anthony Markus US Anthony Markus

    I think you added support for importing wholesale price. Can’t find on csv proper way to import mass wholesale prices. Please let me know what the heading for the csv should be.

    Thanks,
    Anthony

    • Michael Visser au Michael Visser

      Hi Anthony, I’ll update the CSV’s now with additional information and a better explanation of the differences in each.

      Sample CSV – 1.3

      • Anthony Markus US Anthony Markus

        Thanks

  2. Andreas Johansson SE Andreas Johansson

    Is it possible to import a product into multiple categories?

    • Michael Visser au Michael Visser

      Hi Andreas, sure does. Just use the Category separator character; defaults to ‘|’ (pipe).

      Apples|Bananas|Kiwi fruit|Melons

      Take a look at the sample CSV’s above for more information as well as how to use Category hierarchies within the Product Category field.

  3. Paul Cutcliffe GB Paul Cutcliffe

    Hi Michael

    I’m still unable to import using your plugin, or even look at the Products section of my dashboard, without getting a Server 500 error. I’ve just upgraded both WP-Ecommerce & your Deluxe Importer to the latest versions (3.8.8 & 3.1.1 respectively), but still no change.

    How can I delete all my products without accessing the products section of the dashboard? I’m sure this is the only way, although of course if I then still can’t import, then I’m in trouble! But currently all my products are so out of date anyway, that many of the orders I’m getting are for out of stock items anyway!

    Also, I have emailed you regarding switching to Woocommerce – could you please get back to me on that?

    Thanks,

    Paul Cutcliffe
    Eastbourne Websites

    • Michael Visser au Michael Visser

      Hi Paul, have replied to your e-mail. To delete your Products outside of WP Admin you will need to manually dump your Products via phpMyAdmin to free up enough memory, you can do this as below.

      1. Open phpMyAdmin
      2. Open wp_posts
      3. Search and limit the results to ‘post_type’ = ‘wpsc-product’
      4. Select all Products and delete

      Do note this will leave any post_meta and other links around, I recommend running a database clean up within WP Admin after this.

      http://wordpress.org/extend/plugins/wp-cleanup/

  4. Pedro Candeias PT Pedro Candeias

    Hi,

    I can’t find a way for it to support an encoding with latin characters.
    I always get something like this: DICIONÃ?Â?RIO DE MÃ?Å¡SICA – VOL.I it should be DICIONÁRIO DE MÚSICA – VOL.I

    Thanks

    • Michael Visser au Michael Visser

      Hi Pedro, thanks for attaching that. I’ll reproduce this and update you.

  5. Steve US Steve

    Anybody else getting this error that shows up on your product page?

    Warning: Invalid argument supplied for foreach() in /home/content/13/9131313/html/wp-content/plugins/jigoshop/classes/jigoshop_product.class.php on line 1004

    I can’t remove it by editing the product.

    • Steve US Steve

      Nobody else is having this issue????

      • TairaK CA TairaK

        I am having this problem too.

      • Michael Visser au Michael Visser

        Hi Steve, this is resolved in the 1.2.5 Plugin update hitting Jigoshop momentarily.

    • Michael Visser au Michael Visser

      Hi guys, can you confirm if you are importing Attributes as part of your bulk import. This will help me narrow down if this is responsible for the warning.

      • Tanner Campbell US Tanner Campbell

        Yes, I’m having this problem as well and all my products were part of a rather large bulk import.

      • TairaK CA TairaK

        It dosen’t seem to matter. One site I did not import any attributes. But then another site I started I used your sample data files and the same thing happened.

      • TairaK CA TairaK

        I think I found my issue: I can not set a CSV field to ‘Attributes’, it is simply not in the drop down list.

        I downloaded the ZIP file from Jigoshop again, and the date modified on all the files March 23. Isn’t there a newer version?

        • TairaK CA TairaK

          And would a newer version also fix my issue with all the Tags being created, but only one Tag is saved to the product (when it has multiple tags)?

      • TairaK CA TairaK

        Jigoshop emailed me the current version but it did not solve any of the issues..in fact now the image field does not update on merge either!
        1). Still same issue with Attribultes admin tab.
        2) The single product page does not display properly until I have manually edited and saved the product.
        3) Only the first tag is being set for a product.
        4) Image field does not import or update properly. (I have only tried external url) – this was working in previous version, but since update my test imports have no images.

        I am getting really frustrated and I’m weeks behind on a project. I really need a version that works properly.

        • Michael Visser au Michael Visser

          Hi TairaK, I’ve just responded to your Jigoshop support topic, you’ll be receiving a Plugin update that sorts the Attributes, Tags and image import issues shortly.

          • TairaK CA TairaK

            Alright, version 1.2.5 is getting closer….

            1) Tags: Figured out you can not have any spaces in between delimiters for multiple tags to be assigned to product. i.e. tag1| tag2| tag3 will only assign first tag while same values, with no spaces, works great. Maybe there should check for blank spaces or a trim function used somewhere. : )

            2) Re-uploading a product (merging) causes the Featured Image to be deleted from server – yep, the whole thing is wiped right off the server. This obviously is a big concern!!!

            3) Still no option in drop down to assign field to Attribute (although I do not need this, others might).

            These are my findings so far.

            Thanks for the support. I am beginning to have faith in this product again. I am so close to being able to bill for two projects once the image issue is addressed.

            Cheers,
            Taira

  6. Steve US Steve

    Does anyone know where to find this:
    All in One SEO Pack for Jigoshop
    Is it the All in One SEO Pack found in the wordpress plug-ins or is there a different one just for jigoshop?

    Thanks,
    Steve

  7. Lucas US Lucas

    Can I load a CSV with sku, name, category, price and qty and in doing so update the qty and or category of existing products? When I do such an upload, it appears to scan for name changes, but not category and qty. My primary issues is attempting to update 400 out of stock items at once. I was attempting to set Qty to 0, but the Qty is ignored in the upload.

    • Michael Visser au Michael Visser

      Hi Lucas, there’s a Plugin update going out today that fixes a bug in the merge of Stock Quantity. Currently a ‘0’ (zero) value is detected as false when merging and is skipped/ignored during merging, this is fixed going forward.

  8. Steve US Steve

    Ok, thanks for the tip where the docs are. Feel dumb for not seeing them, but I uploaded the plug-in and didn’t look inside. My bad.

    • Michael Visser au Michael Visser

      All good, I’ll make this clearer on the Plugin detail page. 😉

  9. jdwbrw US Jdwbrw

    Michael,

    Do you have any intention of supporting this premium plugin? There are no detailed instructions on how to use this. Your bullet items following the above statement that these are “clear step-by-step instructions” is laughable by any standard. For example, if I want to import images for my products then what should be placed in the image field of the CSV file? Up to now I have learned a few things about this utility through trial and error time that I don’t believe I should be forced to complete. Why would I get error messages about duplicate SKU’s in my import file when there are no duplicates and it is the first time I have tried to import the the records. I have successful imported other products with my SKU’s using the same format for the CSV file.

    I am highly disappointed in what I received in this premium this plugin. You should get with it or make this a free plugin.

    Anybody, what am I missing here?

    Thanks,
    John

    • Dani Cela CA Dani Cela

      look in the directory of the folder it has example files which worked perfect for me…

      • jdwbrw US Jdwbrw

        Hi Dani,

        Very helpful reply.

        Many Thanks,
        John

  10. Rachel NL Rachel

    Hi, I bought your product importer today. I had already uploaded all the images into the media library via the media uploader & I check in the content/uploads file that they were also there. However, when I do an import it does not connect the images to the products. The product shows as having no image. I’ve checked the image column on the csv & all the image codes match those in the media library.

    Do you have any idea why this might be or what I may be doing wrong?

    Thanks

    • Michael Visser au Michael Visser

      Hi Rachel, a Plugin update is going out today which improves the image import functionality. I have disabled the duplicate Image detection in this latest release as it has been causing the ‘unlinked Product image’ issue you’re likely experiencing. Please download the latest release and confirm if this is still occurring.

      Please note that Product Importer Deluxe will only detect Images that have been uploaded in the current month else if you have turned off Media indexing from Settings > Media, the duplicate image detection above scans your entire Media Library but needs a bit more love before it’s reintroduced.

      • Rachel IT Rachel

        Hi Michael,

        Thanks for your reply on that. I will download the latest version now & see how it goes. I just wanted to check on one thing first though as I think I failed to do something before; do I have to go into the csv file & change all the image names to the file they can be found in?

        e.g. image – 100, should be changed to 100/2012/04

        Is that correct? Or can I just change it at the column title?

        Thanks

        Rachel

        • Michael Visser au Michael Visser

          Hi Rachel, if your Image filename is ‘100.jpg’ (no directories) then that is what you put in the Image column for that Product. The importer uses the current month directory to scan for Product images so ensure your images are uploaded to /wp-content/uploads/2012/04/…

  11. Emanuel AU Emanuel

    Hi Michael,

    I have a question regarding exporting products – you supplied a sample csv and that was great to start with, but now I have edited a whole bunch of items on my website and I want to export the entire product items in the same structure as your sample file so that I can make some changes and import them back in…..

    How can I export the products ?

  12. Lucas BR Lucas

    No support, no funcionality, no explain, no nothing, just $50 for nothing, Smart Manager Pro do all this, have GUI, works better and give support to their clients, if you can’t do it alone Michael, dont do it, dont sell your plugin if you cant tell people how it works, you only answer questions of people asking if they should buy it. too expensive Mr. Michael.

    • Michael Visser au Michael Visser

      Hi Lucas, I’m packaging up a major Plugin update to work out the critical import issues affecting the WooCommerce release and will be sending this to the WooThemes team shortly.

      • John BR John

        When you think it will be available?

        • Michael Visser au Michael Visser

          Hi John, the 1.2.4 Plugin update was sent to WooThemes today for distribution so I hope any day now!

  13. Steve US Steve

    I did also notice that I get this error message:

    Warning: Invalid argument supplied for foreach() in /home/content/13/9131313/html/wp-content/plugins/jigoshop/admin/write-panels/product-data.php on line 544

  14. Steve US Steve

    Ok, one last problem. I can’t seem to get the featured image to work. I have the full url in the image field, but after uploading the featured image is not showing up. Any ideas???

    • Michael Visser au Michael Visser

      Hi Steve, I’ve improved support for importing Product images. Please download the new 1.2.4 Plugin update going out today.

      • Marc US Marc

        Where can I get the new version? I have purchased the older one and am experiencing the same issues as mentioned here.

        • Michael Visser au Michael Visser

          Hi Marc, please log into your account via Jigoshop’s website to download the latest release. 🙂

  15. alvin ID Alvin

    Hi, VisserLab…
    If I buy this, will this importer able to handle CSV file which exported with your Exporter plugins?

    🙂

    • Michael Visser au Michael Visser

      Hi Alvin, sure can. I’m tying the two Plugins closer together to make things easier for store owners to import/export/merge Product changes. 🙂

      • Alvin ID Alvin

        Many thanks for the answer, Visserlab.., but I just tested your Exporter module today… and I found that it hasn’t been updated.
        That exporter doesn’t work well with the latest version of WooCommerce.

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.

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, sample import files are available from the Product Importer Deluxe > Usage page.

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).

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.