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

    Thank you Michael

  2. Tom AU Tom

    Howdy Michael, I’ve got everything working now, which is awesome, however the product weight and weight unit is not acting correctly. if i say 14 kilograms it converts the weight to 6.35 kgs. In the list view you see 6.35 kgs but when you edit the product it says 6.35 Pounds. Bit unsure why it converts the weight but all the other dimensions whether they are in cm, inches, etc works correctly

    I’ve done an import with the default importer that comes with WP E-Commerce and it puts in the correct weight according to my csv.

    • Thomas SE Thomas

      Same problem here… I put in g for grams but it shows up at pounds and my weight based shipping get screwed up.

      • Michael Visser au Michael Visser

        Hi guys, spotted the issue, it’s been fixed in 2.8.4.5. 🙂

        • thomasojala SE Thomasojala

          Hey! Now grams work fine, but it converts the value… I put in 500 g and in the product it shows up as 226796.19 g??? I need help with this asap please =)

          • Michael Visser au Michael Visser

            Hi Thomas, I’m seeing this only affecting Products with ‘grams’ in the unit weight. It’s being stored correctly in the database, I’ll do some playing and make sure WP e-Commerce itself isn’t causing the grief. 🙂

  3. NicoWeb ES NicoWeb

    Category importer : 2.8.4.3

    It seems that Category importer supports only 1 sub-level…. The instructions mentions that should drill down up to 3 levels deep

    Clothes>Men >Casual

    Am I doing doing wrong ?

    Regards

    Nicolas

  4. NicoWeb ES NicoWeb

    v 2.8.4.3

    Category importer :

    When importing 2 sub-categories :
    * dictionary>French
    * Language>French

    Just ONE ‘French’ category is imported

    Thanks in advance

    Nicolas

  5. Julie US Julie

    Hi, I was wondering if you have a sample file for the latest version that has the variation support. I am wondering how to format my file with the variations so they upload correctly.

    Thanks, Julie

  6. kim ZA Kim

    To which folder do I upload images if i am using WP E-Commerce 3.8.3?
    Thanks
    Kim

    • Michael Visser au Michael Visser

      Hi Kim, in WP e-Commerce 3.8.3 you upload Product images to /wp-content/uploads/%year%/%month%/, replacing %year% and %month% with the current date. This is explained within the provided readme.txt within the Plugin archive.

      • kim ZA Kim

        Oh, I was reading the readme on the website and it says coming soon . . . will use the readme inside the plugin files from now on.
        thanks

        • kim ZA Kim

          Everything working GREAT 🙂
          Thanks Michael – saving me time already!

          • kim ZA Kim

            Hi
            OK, the only thing that I can’t get right is the Stock Quantity. How do I set this in the csv to zero stock so it can’t get ordered?
            I currently have it as 0 in the quantity column which isn’t working.
            Thanks
            Kim

  7. Bill US Bill

    Just purchased Product Importer Deluxe today. My plugin page shows version 2.8.4.3, wp e-commerce is 3.8.4, Gold Cart is 2.9.2 and WP is 3.1.3. I’m setting up the site under MAMP (localhost install).

    I’ve set up a test CSV file with image info but after I import it, image is not included in field mapping nor do I see any of the Step 3 import options.

    Any ideas?

    • Michael Visser au Michael Visser

      Hi Bill, please check that you’ve given WordPress enough memory. There are no conditional checks on version for the Image field or Import Options so you should be seeing both regardless of WP e-Commerce version or Gold Cart, etc. If you can send me your vl_wpsc_productimpoertdeluxe-2.8.4.3.zip I’ll compare it against my own to be sure it’s fine. Thanks Bill 🙂

      • Bill US Bill

        Michael found the problem offline. It involved poor reading skills on my part! Thanks.

  8. kim ZA Kim

    I am sure I can, but just wanted to confirm that I can use Importer Deluxe to add products to an existing WP E-Commerce shop with hundreds of existing products? (Assuming that I should definitely back up my database and files before hand ;-))

    And also how do I format the Categories & Tags fields in the CSV file?
    You’ve got the following in your example: Party>Federalist|Home State>Massachusetts,Federalist|Massachusetts,

    What are the > and the | ?

    Thanks, Kim

  9. NicoWeb ES NicoWeb

    v 2.8.4.2

    Hi Michael,

    Things are working much better with this update. Very good job !

    I detected a couple of things to be fixed or explained:

    Category :
    * 316 categories are still producing more than 700.000 records in wp_wpsc_meta

    Products :
    * When merging changes into existing products, price update do not work (message : “A duplicate SKU already exists”). If SKU is the same, the record should be update. Isn’t it ?

    * When merging changes into existing products, a new product is not added if not found in catalogue. If SKU is different when merging records, the new record should be add to the catalogue…. BUT this option works when importing WITHOUT merging changes into existing Products (old records are omitted and new record is add).

    Thanks again

    Nicolas

    • zachary US Zachary

      I get this error after a couple seconds of attempted import.
      “Fatal error: Out of memory (allocated 31719424) (tried to allocate 871 bytes) in …/wp-includes/media.php on line 254”

      I have added “define(‘WP_MEMORY_LIMIT’, ’96M’);” to wp-config as suggested in documentation.

      • zachary US Zachary

        With that said, 19 of my 800 products were successfully imported. Custom fields, images, etc. It’s a start! 🙂

      • zachary US Zachary

        False alarm! I tested it on my MAMP server and everything worked great!

        I’ll see what the deal is with my host.

        Thank you for the hard work, Michael. Any hope in the ability to merge custom field updates?

        • Michael Visser au Michael Visser

          zachary, good stuff. You had me worried!

          I’ll be looking at this for the next minor Plugin update, currently file download is not working within merge which I’ll be sorting out too. Thanks for your patience 🙂

          • zachary US Zachary

            I’m also having trouble updating Categories? What are the instructions for doing this…particularly if I would like to add a category to a product that already exists in other categories?

    • zachary US Zachary

      NicoWeb,

      Did you have success merging category changes into your products? I can’t find documentation on how to do this on this website.

      • NicoWeb ES NicoWeb

        Zachary

        Managing (and importing) categories still seems something tricky. I’m actually working manually on my 333 categories. I will wait for an plugin update to test merging categories.

        Regards

      • Michael Visser au Michael Visser

        Hi zachary, I’m updating the documentation section for this Plugin as well as outlining current features and pending features.

        Product Importer Deluxe does not yet support the updating of Categories to existing Products through the merge feature, once I have a recursive solution for the sub-Category drill-downs I can apply this feature to merge but until then you will need to remove and re-insert Products requiring new Category associations.

        • kim ZA Kim

          Just an additional voice: I would also like to see the updating of categories through the merge feature.

  10. Ben CA Ben

    In Importer Deluxe. I can’t seem to get the File Download working. I tested with supplied sample CSV file and created a dummy downloadable file with same name as the one in the CSV (Thomasjefferson.zip). But it does not get attached. Is there something I am missing? The rest of the process seems to be working. I have about a thousand files to attach to products.

    • Michael Visser au Michael Visser

      Hi Ben, let me confirm that this is working, are you using WP e-Commerce 3.7 or 3.8?

      • Ben CA Ben

        3.8.4 for WP e-commerce. 2.9.2 for Gold Cart and 2.8.4.1 for Importer Deluxe. I will update to 2.8.4.2 during the day. 3.1.3–en_US for WP.

        • Ben CA Ben

          Michael, Any news on this?

          • Michael Visser au Michael Visser

            Hi Ben, checking into this today 🙂

            • Adam GB Adam

              any news on this we have the same problem…

              • Ben CA Ben

                Michael? Any progress? I am shurely not the only one with this issue.

                • Michael Visser au Michael Visser

                  Hi Ben, I can confirm that file downloads are working in 3.8.4.4, please upload your File downloads as in WP e-Commerce 3.7 to ‘/wp-content/uploads/wpsc/downloadables/’. 🙂

  11. Tom AU Tom

    When I am importing products i use the “Assigned an external URL column for Products in the CSV file” option for uploading images. Now the images are uploading to the wpsc/product_images folder and it creates the thumbs but, when i view the products the images aren’t attaching to them. also the price, sale price and all the dimensions are not being applied. I’ve followed the CSV format they suggest but i’m still having these issues.
    Does anyone have any suggestions?

    • Michael Visser au Michael Visser

      Hi Tom, can you please confirm if you are using WP e-Commerce 3.7 or 3.8 on your store, thanks Tom.

      • Tom AU Tom

        Hi Michael, much appreciated for getting back to me. the version of e-commerce i’m using is 3.8. and just to reiterate, the images are not attaching themselves to the products but they are uploading. also the dimentions are not being actioned, as well as the sku and prices are just incrementing not being added form the csv.

        cheers again.

        • Michael Visser au Michael Visser

          Hi Tom, I’ll be looking at this today, can you shoot through WP Admin, CSV and FTP access so I can confirm my changes are working in your store.

          Just pushed out the 2.7.4.3 minor Plugin update to support merging Products in WP e-Commerce 3.8 with the additional of Permalink, Height, Length and Width dimensions.

          • Tom AU Tom

            Howdy Michael, I’m sorry if I’ve missed your reply but how did you go with this issue. I currenly have the images working fine now but the others (dimentions, sku, prices) are still not working correctly
            Cheers mate

  12. Trovar US Trovar

    This is very frustrating…but I have tried to update the products and load the images. I get two different messages:

    Products that failed minimum data requirements…which each product had all of the required data fields…and then

    A duplicate SKU already already exists. I have permanently deleted all the products twice now to try to get this to work.

  13. zachary US Zachary

    Michael,

    -upload is locking up (shows the “Grab a beer…” screen for a few seconds and goes to white) and only 28 of my 840 products are imported.
    -I have tried importing just the minimun fields (sku, name, price, category) and that bumps me up to 84 of 840 successful imports. Still with no success or error message.
    -I have also tried converting everything to plain text, and have tried doing a “;” separated csv

    Not sure where to go from here.

  14. NicoWeb ES NicoWeb

    Importer v2.8.4.1

    * ‘Additional Description’ field doesn’t seem to be imported
    * When merging changes into existing Products, NO changes (in price for example). Message line saying : A duplicate SKU already exists.

    Thanks

    • zachary US Zachary

      I’m having this same issue…right now – any luck?

      • zachary US Zachary

        I’ve also tried reverting to 2.8.2 and it ended up making duplicates of everything. I had “merge” selected on step 2.

    • Trovar US Trovar

      Me too! Same issue … duplicate SKU exists. I have even perm deleted and then re-imported with no avail.

      • Trovar US Trovar

        And the photos have been put into the folder with nothing appearing.

      • zachary US Zachary

        I’ve finally figured out my images problem –

        upload to wp-content/uploads/2011/06 and make sure you reference the file directly to the csv (ie. “wp-content/uploads/2011/06/100001.jpg”)

        choose the first option on the Are You Importing Images? box

        that worked for me, anyway.

        still really needing the duplicate SKU issue fixed :-S

      • Michael Visser au Michael Visser

        Hi zachary, looking at merge support today. You’re right on CSV filename, wouldn’t it be easier just entering the Product image filename? I’ll take a look at this too 🙂

      • Michael Visser au Michael Visser

        Hi Zachary, I can confirm that Product image import via CSV filename is working as expected; without adding ‘wp-content/uploads/2011/06/’ to the CSV filename.

        Try the following:

        1. Place the Product images within the current WordPress month directory within /wp-content/uploads/%year%/%month%/
        2. Open Product Importer Deluxe and upload your CSV
        3. Ensure your Image filename column is matched to Image on the dropdowns
        4. Click ‘Are you importing images?’ then the first option ‘Assigned an image column for Products in the CSV file’.

        Fire away! 🙂

        • zachary US Zachary

          Michael,

          Images are displaying as thumbnails on the Product list, but are not showing on the front end. The image URL shows this error:

          Warning%3C/b%3E:%20%20array_merge()%20[%3Ca%20href=’function.array-merge’%3Efunction.array-merge%3C/a%3E]:%20Argument%20#2 is not an array in <wp-content/plugins/wp-e-commerce/wpsc-includes/product-template.php on line 1210

          followed by the actual working url…

          I’m stumped.

    • zachary US Zachary

      Which version of Product Importer Deluxe works for product merging?

      I have done a fresh install of WordPress 3.1.1 and tried both wp-ecommerce 3.8.1 with PID 2.8.4.1 AND 2.8.2 as well as wp-ecommerce 3.8.4 with the same two versions.

      I have a test CSV with only 1 product in it. The file imports just fine (even with an image now, yay!) but when I change a number, price for instance, and re-import with the “merge” box selected, it merely creates a duplicate product with a new price.

      • zachary US Zachary

        More specifically, I get a duplicate product when I use PID 2.8.2 while getting the same error as NicoWeb when using 2.8.4

        Thanks!

    • Michael Visser au Michael Visser

      Hi NicoWeb, spotted the Additional Description, I had assumed it was removed in WP e-Commerce 3.8! It’s back in there, looking at merge support now.

      • Simon East NZ Simon East

        Hi there,

        I still can’t get the “Additional Description” to import. Any ideas?

        Thank you!

        • Michael Visser au Michael Visser

          Blasting out the 2.8.4.2 Plugin update to fix Additional Description and merge support shortly.

          • zachary US Zachary

            really excited! refreshing like crazy 🙂

  15. Jeromy Darling US Jeromy Darling

    I upgraded 2.8.4 and now after selecting the corresponding columns of my csv, it goes to the next page, shows the loading bar (grab a beer, this may take awhile), than just stops. I had successfully imported over 200 products with 2.8.2 but my ftp’d images didn’t lined up. So I deleted them, upgraded, than tried importing them again with no luck. What am I missing?

    • Michael Visser au Michael Visser

      Hi Jeremy, there was an unclosed statement within the 2.8.4 import script, please update to 2.8.4.1, I’ll be putting out a few minor Plugin updates until 3.8+ support stabilises.

      • Jeromy Darling US Jeromy Darling

        Thanks man. Where can I download the update? The premium update link in my email still has 2.8.4

      • Michael Visser au Michael Visser

        Give it another go, usually takes a minute for the caching to refresh after releasing a Plugin update 🙂

      • Jeromy Darling US Jeromy Darling

        Great, so it imports again, but still doesn’t recognize my images. I uploaded all the images via the WP Media Uploader, verified they went to the /wp-content/uploads/2011/06 folder – am I doing something else wrong?

      • Michael Visser au Michael Visser

        Hi Jeremy, can you shoot me login details so I can diagnose this further, the CSV filename Product image method is working a treat here on my Windows and *nix test sites.

      • Jeromy Darling US Jeromy Darling

        I managed to futz around more and get them in after manually adding the wp-content/uploads/2011/06/ path to the image, which created a double path somehow in all my images, like this:

        wp-content/uploads/2011/06/wp-content/uploads/2011/06/

        So I fixed all those in phpmyadmin, which got the images working, but the thumbnails are showing as the full image, so they’re all squished. Any way to fix that?

        • Michael Visser au Michael Visser

          Hi Jeremy, was this with the 2.8.4.2 Plugin update or an earlier release? Thanks Jeromy.

          • zachary US Zachary

            is 2.8.4.2 out? i only show 2.8.4.1…

            having the issue described here, currently.

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

    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

    Product Importer Deluxe works excellent!

  3. GB Osman Ahmed

    Hi, thanks for this amazing plugin!

  4. IE Andrew

    Thanks Michael :)

  5. GB Matt

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

  6. GB Nikki

    Thank you Michael. :-)

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

  8. US Ryan

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

  9. GB Paul Cutcliffe

    Excellent, thanks Michael - keep up the good work!

  10. ZA Kim

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

  11. US Russ

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

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

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