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

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

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

    • 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/

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

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

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

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

      • 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?

        • 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)?

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

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

          • 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

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

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

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

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

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

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

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

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

      • 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

        • 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/…

  10. 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 ?

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

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

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

  13. 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???

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

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

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

    🙂

    • 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. 🙂

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

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