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. Any updates on the timeframe of when you will include the ability to mass upload an individual wholesale (using your wholesale pricing module) price for each product?

    Thanks,
    Anhtony

    • Hi Anthony, it’s sitting in the #5 spot in my todo list. Have a few intense development days ahead so I’ll do my best to get it in next week. 🙂

  2. Michael, are custom fields suppose to update during a “merge” CSV upload? They fail to update for me. The only solution I have is to delete the items and then re-upload.

    • Hi Lucas, Custom Fields are not yet supported within the merge feature which would explain why they’re not updating. I’ll get this sorted in the next Plugin update, there’s been another batch of cool changes. 🙂

      • That would be great Michael, we are working with over 2,000 items and updating custom fields, categories, and images is crucial for our growth. Note, we are having issues updating images as well.

        FYI – Ian (from other comments) and I are working on SirBingley.com with your plug-in

      • Hi David and Andrew, Product variations are not yet supported, I’ll be introducing this feature in the new year. It’s been on my todo list for some time but has needed a whole overhaul in the way Products are processed by the importer which makes this now possible. 🙂

  3. Hey Michael, is the admin for this supposed to be under Settings still (as per your screen grabs)? Can’t find it anywhere. I have the latest version of WP and WPEC and v2.8.7 of the importer.

    • Hi t-racer, I’ll need to update those screenshots as they’re causing some confusing since integrating the Product importer under Tools > Import, I’m putting a post together now explaining that the Categories importer step has been merged into the Products importer so now you don’t need to separately import Categories and then Products. 🙂

      • Thanks Michael. That’s a tad confusing. Would make more sense under Products I’d reckon seeing as that’s where you go to add products…

        Anyway, I found it and tried the import, got the success message but there’s no products. I checked in phpMyAdmin as well and there’s nothing. Pretty sure my spreadsheet is fine as I downloaded the sample one then modified it. Any ideas?

        • Also, when importing (I think this may be the problem) it can’t seem to tell when the rows start and end. So when assigning columns it has all the header row data then all the other rows following, wanting to assign columns to them. As I said, I used your sample spreadsheet as a template so I don’t think I have any weird formatting in my spreadsheet.

        • Hi t-racer, that sounds like a possible session/csv reader issue. I’ve dumped support for sessions in the next Plugin update so will be keen to hear how it works after this update. 🙂

  4. hello there.. i already purchased this awesome plugin but my customer asks wpml support to their website.. and they have 567 items 🙂 i already have 4 different language in the excel file in the individual tabs.. my questions are:

    1. is this plugin supports wpml with e-commerce?
    2. is it possible to share new csv template for wpml support if it is yes for the Q#1

    thank you!

    • Hi flayzeraynx, good timing. WPML support will be included in the next Plugin update shipping shortly. I’ll be putting together a tutorial to explain how to format your CSV file to support this, basically though set a column for each Product title and description (e.g. Product Name – English, Product Name – French, Product Name – Italian, etc.). We’ll be building this out further in future Plugin updates. 🙂

      • that’s very good news indeed. But what about more than 10 language?

        it’s getting weird isn’t it 🙂

        • Once support is introduced there will be no limit on language numbers, just as long as you’ve enabled your chosen languages within WPML they’ll tie into the importer and make additional column options available. 🙂

      • hey michael, can you give e a target date for next release of update with WPML support? my customer asks me every day to update their website but i am waiting for the WPML support before i do..

  5. Hi,
    I did my first product import last night. Some of the photos were not linked correctly and I had to upload new photos. I made some corrections to the CSV and re-imported however this time it will not link or update photos, it is completely ignoring them. How do I get this to import and link the product photos?

    • Hi Sarah, can you please confirm what import method you are using; whether it’s external URL or Image filename and that you’re following the import steps laid out in the Plugin’s readme.txt. Thanks Sarah. 🙂

      • I am selecting the option for image column in CSV on import and also the merge with existing product data option. I have followed the instructions in the readme.txt. What I am doing is exporting current products that don’t have photos (as CSV) and then adding the image column and importing using the above options. I have tried to save my CSV file as a new file.
        I noticed there was an update to the plug in today and installed it. Still no photos on import.

        Thanks!
        Sarah

        • I have had the same scenario as Sarah, but I have worked around by re-uploading the images. After re-uploading the images they reconnected to the items.

  6. When uploading items and merging new changes, I can’t get images to update, i.e. if I want to use a new image, I would change the image name in the CSV and upload the image, however the image doesn’t get updated. Any idea what I am doing wrong?

    FYI – I can successfully load images for new items and I can upload changes for other fields successfully, just cant get the images to update via Product Importer Deluxe

    • Similarly, I can’t get the “Category” to update with new data when doing an upload of pre-existing products.

      • If it turns out that I can’t update categories during a merge, perhaps I could upload more than one category during the initial item upload. Ultimately, I want the same item in two different categories, i.e. a brand page and a category page.

        • Hi Lucas, I’ll re-add support for merging Category updates to existing Products in the next minor Plugin update. Shouldn’t be far off. 🙂

  7. oh… one more question, sorry…. can it import from many spreadsheets? i have several vendors and i keep them separate because they don’t all update at the same time….

          • michael, where does that product exporter put the csv file? it says it exported successfully, but didn’t give me a filename or a path…. thanks.

            • Hi fontaholic, the exporter will generate a download file, just save the CSV file either from the download prompt or via Save Page As (this is for Firefox). 🙂

              • i think i wasn’t selecting products or categories the first few times i tried. now it seems to be doing its thing. thank you.

  8. hi… wondering if the Product Importer Deluxe is able to import meta tag information for products?

      • oooo yes please. So does that mean it can or can’t yet do this? Can I import meta tags via csv? Thanks, Michael

        • Hi Isabella, spinning this up now, please note though that the free version of AIOSEO does not have an interface for managing the Product’s SEO details; yet. I’ll make a small Plugin that adds a widget to the Add/Edit Products page to allow management of those imported Product meta details. 🙂

        • Hi Isabella, support for All in One SEO Pack meta details have been added in the 2.9.6 Plugin update. I’ll update the sample spreadsheet to show how to use it; very easy as always. 🙂

          • Hi Michael,
            I posted in the forum about an issue I’m having with merging updates into existing products. Can you explain how it is supposed to work. Perhaps I am doing something wrong. Either way I have not been able to update my products.

            Here is a link to the thread http://www.visser.com.au/forums/topic/no-merging/

            Thanks in advance.

          • Hi Michael, thanks for offering AIOSEO pack integration. I am just looking for the sample spreadsheet you talk about. It appears the one listed at the top of the page is still for the older version.
            What are the column titles we need for the DB entries? Thanks 🙂

            • ok, so it looks like I’ve figured it out. Thought I’d post it here for anyone else wondering how to do it. It was one of those things that was so simple, it was assumed, but not particularly clear to me at first.

              Basically when you go Import>> upload your csv

              and you get to the page where you see your csv’s ‘first row’ entries in a vertical column on the left and then in the ‘CSV-> Wp e-commerce’ column next to that on the right, each variable has a drop box.
              THAT DROPBOX is where Michael has added the AIOSEO selections,
              I was confused (as you may be) because I couldn’t immediately see those options (you have to scroll each one down). Also, in the past we’ve had to add these custom variables ourselves using the custom fields plugin. So I couldn’t work out what the titles needed to be in csv. These titles are what need to go in the first row of the csv file and their corresponding values in the csv column beneath.
              All you need to do on import is SCROLL DOWN in these CSV -> WP ecommerce drop box options, then select the title that matches the column in your csv on the left of it.

              Hope that helps someone. I was puzzled for days. Cheers.

              • BLAH! Although I found the dropboxes, I still can’t get it to work. I did a csv import, but I see no data being entered into the AIOSEO boxes in a product listing in WP admin and also when I go into phpmyadmin in cpanel to see whether it’s been entered into the DB, it’s not appearing – at least I can’t find it. Can you please point me in the right direction. Thanks.

                • getting closer…. that time it worked if I have no commas, just a single word in the csv cell….

  9. Ok… just so im clear.

    First, set up my cvs spreedsheet with all the categories and custom fields included.

    During the import… your “product importer” will not only create the products.. but will also create the categories and custom fields associated with those products. No need to create the categories/custom fields “before the import”? correct?

    So its probably a good idea to get rid of any existing categories/custom fields?

    So, If the custom fields are created “during the import”… im assuming… that “after the import” would be the time to go in and format the “type of custom field” (text box, pulldown, etc)?

    • Hi Chuck, that’s mostly correct. You will need to create the Custom Fields prior to the import as this is not yet supported. I like you idea of importing them as generic custom fields initially.

      You use the Product Categories option within Tools > Import to use your CSV file to generate the Category structure, then the Products option to import the Products and populate the WordPress database. 🙂

  10. Hi Michael,

    Anyway the product importer can do the opposite and export all my products?

    Also any updates on the ability to mass import individual wholesale prices per product when we are using the wholesale pricing plugin?

    Thanks,
    Anthony

    • Hi Anthony, I have an exporter Plugin I will be announcing soon that exports Product details to a CSV file. I hope to add Wholesale Pricing support within Product Importer Deluxe next week. 🙂

    • Hi EvyDee, if you have an OScommerce site that you’d like to migrate I’d be happy to build a CSV exporter if you can provide me with access to the store. 🙂

        • Hi EvyDee, if you get in touch with me I’ll request a copy of your existing OScommerce database and look to create a Plugin/solution to export store data out of that platform. 🙂

  11. Product variations work great when adding a specific product to a page. However: when adding a product category to a page they no work.

    any idea what could be the issue here?

  12. Hello.

    I have more than 250 products migrating from another store. Each one of those products have custom fields. Question: Once my custom fields are set up with your “Custom Fields for WP e-Commerce product”…… Does “Product Importer Deluxe” populate those custom fields with the info from each product? If not… I would have to go into each product.. and manually enter the info for each custom field??? ughh.

    • Hi Chuck, Custom Fields support is ready to go in Product Importer Deluxe. Just create an additional column in your CSV (e.g. Material or Classification) and populate that column just like the rest, Product Importer Deluxe will detect the Custom Field column and assign those details for you. I’ve made it as easy as possible to set up a new store in one hit.

      My next mission is to get variations stable as I am well aware there’s demand for it but it’s a nightmare to impliment within a Plugin. I’ll be working on this as soon as the new site is up! 🙂

      • Thanks Michael… this plugin is heaven sent! I hope it works as good as it sounds. 🙂

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