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. kim kilpatrick US Kim kilpatrick

    Posting this in the right place this time as this is my version of product importer deluxe. It works great… except for all the google data. It shows you can match fields for it, there are no errors, it just doesn’t import that data, it skips it and gets everything else right. So what is going on?

    • Michael Visser au Michael Visser

      Hi Kim, can you confirm which version of Advanced Google Product Feed that you’re using as well as WP e-Commerce version. This is working with the latest of both on my development sites.

  2. BM TH BM

    Is it possible to upload products from Amazon?
    Is there a one click install?

    • Michael Visser au Michael Visser

      Hi BM, there is no support for importing Products from Amazon. If you would like to raise a feature request please get in touch as I’ll require more information to implement this.

  3. Brain IN Brain

    hi,
    Thanks for the plugin, this plugin is very useful for me, but how could i add a new filed in the csv whose value will store in the database for a particular plugin. Please help me.
    waiting for someone’s reply.

    • Michael Visser au Michael Visser

      Hi Brian, if you can further explain what field you’d like to add I can bake it into Store Toolkit or into Product Importer Deluxe for you. Store Toolkit, Related Products, Wholesale Pricing and a few others all use filters and actions to integrate with Product Importer Deluxe.

  4. PepperHorn AU PepperHorn

    Hi Mike …

    I’ve found a bug with Product Importer and WPEC 3.7.8 … the products are importing, but the permalinks aren’t being added to the db. I’ve tried both adding new products and updating existing products and in both cases there aren’t any new additions to ‘url_name’ in the ‘wpsc_productmeta’ table.

    The only way to correct the product’s permalinks is to open each individual product in the back end and click ‘update’ … which works but is a big drag 😉 ..

    I’ve tried this on both versions 3.09 and 3.12 of the plugin and both behave the same way.

    Thanks!

    Shaun

    • PepperHorn AU PepperHorn

      For anyone that’s had a similar problem I’ve created a work around. It’s here at Pastebin: http://pastebin.com/x07txEAN. I couldn’t get the WPEC Debug page to come up properly so I’ve grabbed the function to loop through all the products and rebuild the permalinks (url_name meta field in productmeta in WPEC 3.7.8). If you’re using 3.8.x please try this at your own risk.

      For those on 3.7.8 or so you can load this page template into a PRIVATE page on your site to update your product permalinks. PLEASE backup your database before trying this and don’t leave it sitting around on a publicly posted page for others to tinker with 😉 …

      Shaun

    • Michael Visser au Michael Visser

      Hi Shaun, I’ll check over legacy WP e-Commerce 3.7 support and make sure those permalinks are getting added to the wpsc_productmeta table. Apologies for the delay and thanks for the temp. solution in my absence.

    • Michael Visser au Michael Visser

      Hi Shaun, WP e-Commerce 3.7 support for permalinks has been fixed in the latest release.

  5. Sheena GB Sheena

    Hi Michael,

    I am using the importer and it worked ok when I uploaded the first time. However, I have tried to upload more products to the existing products and have noticed that it only imports one product at a time and eventually times out. My images are also showing up blank although I have created a location for this. Unfortunately, I am having to go in to each item and upload the feature image which is becoming painfully slow!

    Any help which you could provide would be appreciated.

    Thanks

  6. Simione PK Simione

    Hi Brian, you can enter the image filename (a1.jpg) into your CSV then uplaod the physical images to your Uploads directory as instructed at import time, the importer will fetch and generate thumbnails for each Product.Please note the importer does not support relative directories (/image/letters/a/ ) so you will need to uplaod all Product images to a single directory within your site as instructed.

  7. Nate US Nate

    I am attempting to change all the sale prices, but the plugin does not change any of the prices (although it seems to recognize the columns and information of the CSV file just fine. Do I have to delete the previous sale prices one-by-one in order to get this thing to work? Will it not update a field that’s already occupied with data?

    • Nate US Nate

      Update:

      Alright, that’s not it. I tried deleting the sale price of one of the products, then importing the CSV file again to see if it would update an empty field. Nope. After it was done, there was no sale price listed for that product.

      Here’s the message it displayed at the end of “importing” (which reads good — but it’s not actually doing anything!):

      Sufficient data was provided, beginning import…

      Detect and group Product columns…
      >>> SKU has been detected and grouped
      >>> Price has been detected and grouped
      >>> Sale Price has been detected and grouped

      Merge Product changes…
      >>> Skipping import first Product row
      Product changes have been merged

      Clean up…
      Clean up has completed

      Import complete!

  8. PepperHorn AU PepperHorn

    Hi Mike …

    Think there might be an issue with the plugin and WP 3.3.2. I’ve set up a test site to play around with WPEC 3.8.x and can’t get the Product Importer to add image or custom field data to the database. It’s finding everything in the CSV file and grouping them according to the installation notes, but there’s no data in the DB besides the basic product info (ie. title, description, etc.)

    Will try rolling WP back to an earlier edition and see if I can solve the problem for now. Just thought I’d let you know.

    Thanks!

    S.

    • PepperHorn AU PepperHorn

      Hey Mike …

      Tried WP 3.3.1 (which I have on my wpec 3.7 site and it working fine) but no luck. Also tried different combos of the Product Importer 3.0.9 and 3.1.2 with wpec 3.8.3, 3.8.8 and 3.8.1, but still having no luck getting custom fields to add at all. The installation notes say they’re being added to the array, but no data is being passed to the DB.

      I’ve also had mixed luck with images. I got them to import correctly once, but after that haven’t had any luck at all. It shows the images are gathered into the array (as per the install notes) but then on each product it says ‘Skipping Image Download …’.

      I’ve been using your nuker to clear out the product info each time I test. If you have any suggestions let me know.

      Thanks!

      Shaun

  9. Annika GB Annika

    Hi again,

    Du you have any plans on adding support for the ad-on “Up sells/Cross sells”?

    Would be awesome!

    • Michael Visser au Michael Visser

      Hi Annika, support for Up sells/Cross sells is being organised, as soon as I have my hands on a few other Jigoshop Plugins we’ll be cooking support in. 🙂

  10. Annika GB Annika

    Hi,

    I have some questions about images. Is it possible to upload (or connect from the media library) several images at a time and in that case how?

    I have also tried to upload only one image per product (that becomes the featured image). However, the image gets the wrong proportions in the product listings (on the category page) but when I click in to the product page it seems correct. I guess this has something to do with the height/width proportions for the category page thumbnails but I dont know how to fix this? If I instead of importing images in the csv-file add the images manually, one by one from the media library, everything works fine so this is just an import problem.

    I hope anyone can help me. Thank a lot!

    • Michael Visser au Michael Visser

      Hi Annika, thanks for raising this. An urgent Plugin update is going out to sort out the Attributes issue as well as some other fixes. In the next Plugin update I’ll confirm the Category thumbnail is being generated correctly during the import process.

  11. Matt Willson GB Matt Willson

    Hi Michael,

    Does the plugin support table rate pricing?

    Thanks,
    Matt.

    • Michael Visser au Michael Visser

      Hi Matt, table rate pricing on a per-Product basis is not supported. I’ve added this to my task list for a future Plugin update.

  12. Dagur US Dagur

    How do I import product name, category and description with foreign characters? þæóöíó etc.
    It seems they are just skipped when I try to import them.
    Is there a fix or a workaround so I can get my products imported?

    • Michael Visser au Michael Visser

      Hi Dagur, please update to the 3.1.2 Plugin update coming out shortly. I noted in a previous release that foreign characters were being stripped out. I have tested this latest Plugin update against my set of test CSV’s including foreign character sets. This requires no change on your end, it’s all Plugin side. 🙂

  13. mtomko CA Mtomko

    Hi, where can I get support for my woo commerce product importer deluxe when woothemes is down?

    • Michael Visser au Michael Visser

      Hi mtomko, please raise your support query with WooThemes directly, if you have purchased the Plugin here you can contact me for assistance.

  14. Giovanni Balletta IT Giovanni Balletta

    I like this plugin and I want to buy it but first of alla I need to say one thing:
    – I desire to import about 2 thousands article (photos oraganized by different formats) how can I do it? Can I add the images in the CSV file or I must assign the image after the CSV upload?
    Thanks

    • Michael Visser au Michael Visser

      Hi Giovanni, you can fill the Image column with your CSV file, either using the image filename (e.g. image-1.jpg) or an absolute URL (http://www.domain.com/images/image-1.jpg). Multiple Images per Product can be achieved using the Category separator character (defaults to ‘|’ character).

      image-1.jpg|image-2.jpg 🙂

  15. Stevie McKeown GB Stevie McKeown

    Hi Michael,

    I love the product by the way 🙂

    In the example of the spreadsheet that you provide there is a column called “sort order”, can you clarify what this is please?

    I have played about with adding attributes to the end of the example spreadsheet you provide, when I add a column to the end of the spreadsheet with an attribute and try to import it, at the point when i am matching products within WP the last column attribute is identified as “manufacturer” plus the product from the first column from the next row i.e. “manufacturer mighty mouse” Any ideas what I am doing wrong?

    When adding attributes, am I correct in thinking that if a cell is left blank that no attribute will be added for that column?

    Is it possible to add multiple attributes per call i.e. blue|green|black ?

    Can you give me a rough idea of when variations will be able to be imported within woocommerce?

    Thanks,

    Steve

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.