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.

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

    Will this importer work with CSV files from ebay? Is there a ton of reworking involved to list to my website? This will be for Jigoshop.Thanks

    • Luke Carbis US Luke Carbis

      Hi Steve,

      Send through a message to us from http://visser.com.au/contact/ and we’ll get your ebay file from you to test it, if you like.

  2. Susan S US Susan S

    I’m just checking to make sure that although “Additional Description” isn’t listed as being imported, it will, in fact, be imported. The exporter exports it, so it seemed to make sense that likewise it would be imported. 🙂 Thanks!

    • Michael Visser au Michael Visser

      Hi Susan, our importer supports Additional Description. 🙂

  3. [Plugin update] Related Products – 2.1.2 | Visser Labs au [Plugin update] Related Products – 2.1.2 | Visser Labs

    […] WPEC’ers, the 2.1.2 Plugin update for Related Products adds support for Harvest’s Chosen jQuery dropdown solution that enables live search of […]

  4. Scott US Scott

    Since updating to 3.2.1 I am not able to add variations to existing products. I was able to do this with 3.2.0 just fine.

    • Scott US Scott

      Discovered the problem.
      If you delete a product which has variations associated with it from WPEC then add the same product back again and try to add the same variations back to it, the importer fails. (Though it does not give any message that it failed) The original variations SKU still exists in the database and was never deleted.

      Product Importer Delux does not give a message that a duplicate SKU exists but just says the variation import was successful when it was not.

      One must go into the SQL db of WP-Ecommerce and manually remove any SKU’s which may conflict with a new import as there is no other way to view or delete variation SKU’s through the control panel of wpecommerce.

      FYI

      • mcfinch US Mcfinch

        Can someone please give me some explicit directions on how to import variations. I looked at the sample file and see how to set it up, but which field do I map it to when importing. I created variations, but they don’t show up as fields to import into. I tried to create custom fields with attributes, but the field is just displayed on my site and is not formatted as a dropdown to allow the customer to select a size or color. I would truly appreciate any assistance.
        Fashionablymodest.net

        • Scott US Scott

          I had my best success importing variations in these steps.

          First do an import of the main product so it is in the database before importing variations.

          Second do a separate import of the variations of this product. In this second import the sku of the variation needs to be different and the product name needs to have the name of the main product in it just like in the sample and instructions.

          • mcfinch US Mcfinch

            Scott,

            Thank you for responding. You stated that I should add the data just like in the sample and instructions. I cannot find any instructions for adding variations in the readme.txt. Where can I find instructions for adding variations?

              • mcfinch US Mcfinch

                Thank you very much for the link Scott. I found it very helpful and it answered my questions pertaining to variations. I have one more question regarding images. I have about 7 images per product, but I have a specific image that I want to use for the thumbnail. How can I specify which image I want to use for the thumbnail?
                In the documentation, it said that for version 3.7, thumbnail images should be uploaded to the folder: /wp-content/uploads/wpsc/product_images/. I’m using wp e-commerce version 3.8.9.4. Do I upload the images to the same directory?

                • Scott US Scott

                  The instructions say to upload images to: wp-content/uploads/2012/12. (Current year/month). I list the image I want to be the thumbnail as the first image in the csv file. So… thumbnailImage.jpg|otherimage.jpg… This would go in the image field of your csv import.

                • Michael Visser au Michael Visser

                  Hi scott, thanks for jumping in, that’s correct, just the filename when using the filename image import method.

                  I’m currently working on porting the site over to the 2013 theme and introducing a much clearer on-site support platform; good for everyone, customers and providing support.

      • Michael Visser au Michael Visser

        Hi Jesper, thanks for raising this, I’ll look at the Product Name filtering rules we’re using for generating variations, it sounds like it’s ripping them out incorrectly where multiple uses of the same word are in play.

  5. [Plugin update] Product Importer Deluxe – 3.2.1 | Visser Labs au [Plugin update] Product Importer Deluxe – 3.2.1 | Visser Labs

    […] As always download the latest Plugin update manually from Premium Plugin Updates or using the WordPress Updater via Dashboard > Updates within the WordPress Administration and for more information visit the Plugin detail page for Product Importer Deluxe. […]

  6. Jesse NZ Jesse

    Hey mate just wondering..

    I am merging 250 or so existing products with new prices, i have an SKU column and a Price column. Do I need to have the sku’s of every variation? I’m trying it on my local server as a test and I used only the main SKU’s, it’s currently up to “9000 out of -1” and I have only seen it change a few prices since then it has been saying
    >>merging
    >>skipping product

    • Michael Visser au Michael Visser

      Hi Jesse, yes the SKU column is required for each variation when merging changes. I can look at removing this requirement for variations only as we can detect the Variation Set and Variant from the Product Name format we’re using.

  7. Eric US Eric

    Anyone having issues with Importer Deluxe 3.1.9.1 failing to import or add products to variations? I’ve tried with WP-EComerce 3.8.9.2 and 3.8.8.5

    • Michael Visser au Michael Visser

      Hi Eric, I’m finalising testing of merging Product variation changes this morning and will release the 3.2.0 Plugin update for Product Importer Deluxe this afternoon.

    • Michael Visser au Michael Visser

      Hi Eric, the 3.2.0 Plugin update is available now with variations fixes.

      • Simon GB Simon

        THANK YOU!!! Thanks so much for this upgrade Michael, just managed to import a whole load of products with variations successfully and it has saved me so much time. The great plug-in I’d been waiting for!

  8. Jesse NZ Jesse

    Hey, just purchased and testing out, got everything working sweet except for the variations.

    I import the Main product in the first row then all the variations under it using “Ladies Close Pique Knit Polo|Size|M”, “Ladies Close Pique Knit Polo|Colour|Green” etc. but they don’t get added to the product.

    Cheers
    Jesse

    • Simon GB Simon

      Yep, join the list of people who bought this believing it worked with variations but discovered it doesn’t. Michael is working on a 3.2.0 release which we are told will fix variations, but this is now a week overdue and no response to questions about when it will be available. If 3.2.0 solves the issues it will be a great plugin.. here’s hoping.

      • Jesse NZ Jesse

        oh hope it comes soon

        • Michael Visser au Michael Visser

          Hi Jesse, the 3.2.0 Plugin update has been released. Check for it via Dashboard > Updates within the WordPress Administration. 🙂

      • Michael Visser au Michael Visser

        Hi Simon, the 3.2.0 Plugin update will be released later today, I’m finalising testing of merging variations then will fire the release cannon. I’ll send you the release as soon as I complete testing.

  9. Joao PT Joao

    Hi.
    Is there a product stock field to import with the csv file?

    Thanks

    • Michael Visser au Michael Visser

      Hi Joao, yes, the Quantity column manages stock levels for each Product. Empty will mark it for unlimited sales, 0 as out of stock and any positive number as the current number of available stock.

      • Joao PT Joao

        Thanks a lot. Good job!

  10. [Plugin update] Product Importer Deluxe – 3.1.9.1 | Visser Labs au [Plugin update] Product Importer Deluxe – 3.1.9.1 | Visser Labs

    […] within the WordPress Administration and for more information visit the Plugin detail page for Product Importer Deluxe. Share […]

  11. Matt GB Matt

    Michael – I’ve found that the importer turns the character % into “percent”, when used in the product title field. Is there any way around this (apart from using %, which isn’t too user-friendly for the staff updating the database from which the csv is exported)?

    Thanks,
    Matt.

    • Michael Visser au Michael Visser

      Hi Matt, from memory this had to be done for WP e-Commerce 3.7, the code has just carried across versions. I’ve added it to my todo list for next week’s update; 3.2.1, 3.2.0 is just variations + critical issues.

      • Simon GB Simon

        Any idea when we can expect 3.2.0.? I’ve got products piling up here that I need to upload and if 3.2.0 solves the Variation issues it will save me hours!

  12. Michael US Michael

    Im getting this error:

    Fatal error: Cannot use string offset as an array in /home/fabricco/public_html/wp-content/plugins/wp-e-commerce-product-importer-deluxe/includes/functions.php on line 2571

    This seems to be the offending line:
    height’ => $post_data->product_meta[‘dimensions’][‘height’],

    This is stopping the import after 2 or so products. I use this plugin to add three to four thousand products a day (when its working) HELP!!!!!

    • Michael Visser au Michael Visser

      Hi Michael, looking at this now. Will release a pre 3.2.0 Plugin fix for this.

      • 1fabricco US 1fabricco

        I’m Getting this too:

        Fatal error: Out of memory (allocated 57147392) (tried to allocate 3072 bytes) in /home/fabricco/public_html/wp-includes/media.php on line 1025

        • Michael Visser au Michael Visser

          Hi 1fabricco, can you please confirm the image import method you are using, and the file size and dimensions of some of the images you are importing.

          The error above indicates that one of the WordPress Media functions has eaten all available memory. Increasing your hosting memory allocation will allow for importing larger images.

          • 1fabricco US 1fabricco

            I am assigning an external url. Image sizes for this vendor are somewhere around 900×1100 px.

            I have 2048Mb of memory allocated to wordpress, PHP, wp-config, and pretty much everywhere the usual forums said to modify. I am allowed 2048Mb on the VPS that im on and I set all of it to be used. I got this to work by making the images smaller. But I still get:

            Fatal error: Cannot use string offset as an array in /home/fabricco/public_html/wp-content/plugins/wp-e-commerce-product-importer-deluxe/includes/functions.php on line 2571

            when I try to do merging.

            • Michael Visser au Michael Visser

              That fatal error will be resolved in the urgent minor update; 3.1.9.1.

              Although you’ve set that memory value (2GB) throughout your store WordPress’s media functions are only using 52M of it before crashing, our importer isn’t failing in this case.

              You can help me prepare a workaround once variations is stabilised (e.g. a filter for the media functions to boost memory) by packing up a sample of enough (e.g. does it consistently crash at Product 52, etc.) full-size Product images and a sample CSV with that many Products so I can run under a test store with 52M of allocated memory.

  13. Scott US Scott

    I am able to upload products and images fine, but when I want to go back and update my products which includes changes in the images the update/import erases all the images from all the products. The images are still in the wp-content directory but they are no longer linked to my products.

    • Michael Visser au Michael Visser

      Hi Scott, can you please confirm if this is still happening after updating to the 3.1.9 Plugin update.

  14. Jess Mallory US Jess Mallory

    Michael,

    I’m trying to create a record store, and am recognizing the limitations of the wp ecommerce plugin. I wonder if this plugin can solve this.
    I need:
    Import complete inventory each night- which will overrite current inventory.
    Import additional details for each item, from separate import fields.
    I also need to sell an item at new and used prices, and am hoping this could be automated also.

    Thanks, Jess

    • Michael Visser au Michael Visser

      Hi Jess, you can override the current inventory by importing new Products and merging changes to existing Products.
      You can import/export using standard spreadsheet columns saved in CSV format.
      For new/used prices you’ll likely need to import variations or ‘Product options’, variations import support is being stabilised in the 3.2.0 Plugin update which we’re working on.

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.