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

    I haven’t updated the products on my website for some time, as I’ve had other priorities recently, but I’m just running the importer now, using the latest Version 3.1.8, & I have to say I’m very impressed with the recent updates – live installation messages, and, for the first time, I’ve been able to import them (2,599 products, all with external image URLs) in one large file, whereas I always used to have to split the file into three.

    Keep up the good work, Michael!

    • Michael Visser au Michael Visser

      Hi PaulCutcliffe, good to hear we’re getting that memory allocation under control. We’re looking at variations as well as getting any new issues introduced by the jQuery-driven import engine under control. My favourite feature in 3.1.8 is the Advanced Import Log which shows a detailed per-Product view of imported Product fields and changes when merging. 🙂

      • Paul Cutcliffe GB Paul Cutcliffe

        Michael

        Yes, I’m very pleased with the way it works now.

        I don’t use product variations, as I haven’t even looked into what format I would need the products to be in, although my site would probably benefit from it.

        Is it still part of the plan to combine the adding and merging processes into one import? I guess at the moment, if our products list includes both new and updated products, then we should still run the import twice, once with and once without the merge setting – is that right?

        Thanks,

        Paul Cutcliffe

        • Michael Visser au Michael Visser

          Hi Paul, yes it’s on the roadmap to combine import/merge, whether that’s as a import and skip duplicates or import and merge/override import method. For now running the importer twice is the way to go.

          • PaulCutcliffe GB PaulCutcliffe

            Michael

            Sorry to keep asking, but is this still planned for a future release? The reason I ask is that I’ve just imported a new file, with around 2,500 products that may have been updated, and three new products, and I first ran it with the Merge option ticked. Then I just went to run it again without the Merge option ticked, & I noticed that the new products have already been added to the site.

            I believed that new products would simply be ignored if the Merge option is ticked – could you clarify this for me?

            Thanks,

            Paul Cutcliffe

  2. David AU David

    I’m having memory errors come up even though we have changed the allowed PHP memory. Won’t import more than one or products at a time. I have 528 products I want to upload currently but sometimes need to do more like 2000. Running latest plugin with WP e commerce 3.8.8.5., WordPress 3.4.1 Also I’m wondering if there is a support for a field to disable posts on product pages?

    • Michael Visser au Michael Visser

      Hi David, can you please update to the official 3.1.8 Plugin update. As I write this I’m watching an import run on one of our test stores with 600+ Products (and multiple images assigned to each Product), memory is capped at 64M, it also has 20 activated WP e-Commerce Plugins to keep it busy. From the WP Admin Dashboard it’s idling on 47M out of 64M giving less than 20M to the importer.

      Once they’re done I’ll be running an import with ~4,600 Products on the same site before working on a CSV and image filename generator to pull in over 10,000 Products (with multiple images).

      • David AU David

        Hi Michael,
        No worries I’ll give it a go and let you know.

      • David AU David

        Hi Michael,
        Please see Fatal Error Message below (I have deleted my folder structure):
        Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 24000 bytes) in /media.php on line 258

        Let me know your thoughts?

        • Michael Visser au Michael Visser

          Hi David, that error means WordPress has consumed the entire 128M available. The WordPress file media.php is called by our Plugin to handle thumbnail resizing, previously we handled this ourselves but since WP e-Commerce 3.8 all image thumbnails are generated by WordPress.

          If you can get in contact I can better understand whether this is due to too large images or a missing image library in PHP that WordPress can use which is less memory intensive.

          • David AU David

            Michael, once I dropped my product image file sizes below 400k everything went through ok. File size restrictions/recommendations for product images may be a good thing to ID in your documentation.

            Cheers,

            David.

          • Michael Visser au Michael Visser

            Hi David, been looking further into memory overrides, if you add this to your wp-config.php it ‘should’ lift the memory limit across WordPress and all the nooks and crannies we’re using (this means our Plugin and WordPress image functions that we’re calling).

            define( ‘WP_MAX_MEMORY_LIMIT’, ‘256M’ );

    • Michael Visser au Michael Visser

      Hi David, you can use the Comments Product detail to control whether comments are allowed on Products. The accepted values are on/off, 1/0 or true/false.

      • 1fabricco US 1fabricco

        Michael, For what its worth, I was having the same “out of memory” issues and I tried everything (disabling plugins, altering config.php, .htaccess, and the plugin itself. The thing that ended up working was reverting to the previous version of PHP. Im not sure how this worked and it might not make much sense, but thats what worked for me.

        • Michael Visser au Michael Visser

          Hi 1fabricco, that is weird. How much allocated memory was available within your store? It could be that some versions of PHP are more memory efficient than others, I tend to the latest software on our test sites. Will look into this further for an explanation.

  3. Jamie Milks US Jamie Milks

    Michael,
    I’m seeing the following message on my import screen:

    Script timeout cannot be adjusted as the server hosting your WordPress site is running PHP in ‘Safe Mode’. Contact your hosting provider to adjust the maximum execution time.

    I’ve contacted my hosting provider and he says this site is not in safe mode. This is the first time I’ve seen this. I know my site has been moved to a new server recently. I can only import around 20 products at a time before the server times out. Do you have any helpful advise? I have over 8k products to load asap.

    Thanks.

    • Michael Visser au Michael Visser

      Hi Jamie, our Plugin returns that prompt when the internal PHP ini_get( ‘safe_mode’) return true, this means that the safe_mode (ala Safe Mode) option is enabled for that hosting instance. Due to this we cannot override timeouts or memory limits which is why the importer is timing out. Our 3.1.8 Plugin update may get around this which will be let loose on Monday evening – just finalising testing of this major release – for updating within customer stores.

  4. Scott US Scott

    I am getting the error message “The file you uploaded exceeded the maximum allowed filesize.” The file is .csv and only has 20 rows and has a size of 8k.

    • Michael Visser au Michael Visser

      Just updating this topic for others, was due to an internal PHP function not being available. Once the original web developer re-instated this the import was successful. 🙂

  5. jdhart123 US Jdhart123

    Is there any way to bulk delete products? Having to delete 20 at a time when there are ovr 2,000 products is not feasible. If there is not an automated way, can I go into the database or another file via FTP and remove them?

  6. Adam AU Adam

    Guys are these timeout issues caused by the plugin or the database itself. Perhaps the database needs tweeking. Im no expert but thats where i would go looking first! Isnt there some restrictions on the free versions of mysql and sql?if u have 20,000 records im wondering if u exceed the restrictions for that version of each?

    • jdhart123 US Jdhart123

      I had the same error and assumed that none of the products got imported. However, they were listed under Products. Have you checked this? I eventually broke my list into increments of 1,000 but that’s not always feasible.

      • Michael Visser au Michael Visser

        Hi jdhart123, we’re introducing a new import engine which imports each Product as its own PHP process so we can display live progress of the import as well as the import log. The current importer loads a single PHP process and then just keeps turning until it either completes or times out/runs out of memory.

  7. Annika SE Annika

    Hi,

    I have some problems managing my stock with this plugin. The stock handling itself works if I handle it through the backend admin interface but not if I do it with the product importer. In the csv-file I have used these settings:
    Allow Backorders – Allow, but notify customer
    Manage Stock – Yes
    Quantity – (different stock for different products, from 0 to xx)

    I have also tried to set:
    Stock Status – In Stock

    but it didn’t help.

    The product page keep telling the customer that the product is out of stock.
    When I look at the product settings page in the backend under the tab Stock, nothing is there. The checkbox for “Handle the stock for me” is unchecked and the stock quantity is 0.

    Any suggestions?

    Thanks!

    • Jason US Jason

      I am having the same issue. Initial import works great, but updating quantity on an existing item does not update. This would be a HUGE time saver, if it worked properly.

      Anybody find a solution for this?

  8. Levitate US Levitate

    If you have all your products downloaded into a cvs file from Ecwid…how does your uploader upload the correct image to the correct product?

    • Michael Visser au Michael Visser

      Hi Levitate, I am not familiar with Ecwid e-Commerce Plugin but if you have either the image filename (image-1a.jpg) or absolute URL to the image (e.g. http://www.domain.com/images/image-1a.jpg) within an Image column in your CSV then the importer can import new Products. Please note this importer is only compatible with WP e-Commerce Plugin, other importers are designed for each platform (e.g. Jigoshop, WooCommerce, etc.)

  9. HW US HW

    How does this plugin handle product updates? For example, I load up 100 products. A week later, I make changes to my CSV file and I want to reload my products. Will this plugin duplicate my entries or will it match the product name and just update each entry? I’ve tried other plugins and unfortunately they duplicate my entries. I’m willing to buy this plugin if it can handle updates properly.

    Thanks.

    • Michael Visser au Michael Visser

      Hi HW, there is an import and merge option at import time. This will either import new Products and skip duplicate SKU’s or alternatively update Product details based on the SKU.

      Work is being done to improve variation support for both importing and merging Product changes and expect a release this week for this.

      • HW US HW

        That sounds pretty solid. Looking forward to the updates. Hopefully, this plugin will import everything from the CSV properly and allow me to make updates on a regular basis. Thanks!

    • Joy H US Joy H

      I have found that going into the store toolkit and deleting the products will eliminate dupes. However, make sure you have an up-to-date CSV file to re-import your products. Out of over 300+ products I have only had 1 item dupe.
      My issue is having to go back over every product and re-tick the boxes on all the product attributes to make them visible again and then re-order them because they sort in descending order of priority (opposite order of original CSV sheet).

      • Joy H. US Joy H.

        I have recently imported and merged many products merged. On initial import product image link does not re-attach to the image in that location.

        Also, Still have to re-tick attribute boxes on all products after merging. Many attributes (greyed out) are not available despite being on the CSV file and/or entered into Jigoshop in advance.

        Product attributes still do not export to csv file.

  10. Joshua Wilson 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 🙂

  11. Susie US Susie

    Question, I see on the example/template files provided up above there are attribute columns in the sample CSV files. But, when I import my file with the size attribute populated in the CSV nothing happens. The product is listed as variable but there is nothing that carries over in terms of attributes or variations. Am I missing something or does this not work?

    • Michael Visser au Michael Visser

      Hi Susie, you’ll need to create the Attributes before importing them. I’ve drafted a solution to generate the Attributes if they do not exist but it will require additional information (e.g. Type: text, select, multi-select, etc.).

      You can create new Attributes from Products > Attributes within the WordPress Administration.

  12. danigosa ES Danigosa

    Is it possible to do the job automatically? I need to do this operation daily and of course it would be a timesaver to automate it somehow. Right now I do it manually but could you state how to write some code to make the calls with a wp cron?
    Thanks

    • Michael Visser au Michael Visser

      Hi danigosa, imports will need to be run manually from the WordPress Administration by an Administrator. In the future we hope to add support for wp_cron() but this will require substantial changes to the current importer.

  13. Meghan US Meghan

    Hi,

    Is there a way to export products to a .csv file from my site? I currently use your importer with wp ecommerce.

    Thanks!

    Meghan

  14. Ryan US Ryan

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

  15. Huw Rowlands GB Huw Rowlands

    Can this be used to import products into Jigshop, if I export from WPEC?
    There doesn’t seem to be a straight plug n play plugin for this yet?

    • Michael Visser au Michael Visser

      Hi Huw, you can use my Exporter Plugin for WP e-Commerce to generate a CSV of your Products and then use this Plugin to import them into Jigoshop. We’re working on an easy migration Plugin for Jigoshop. 🙂

      http://www.visser.com.au/wp-ecommerce/plugins/exporter/

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.