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

    • 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. 🙂

      • 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

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

          • 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. 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?

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

      • 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?

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

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

          • 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’ );

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

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

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

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

    • 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. 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. 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?

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

      • 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. 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!

    • 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. 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?

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

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

      • 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!

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

      • 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. 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. 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?

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

    • 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. 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. 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?

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