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. If I want to update my products with Sale Prices, can I just import a CSV file with only 2 columns (SKU and Sale Price) and expect it to merge all the products correctly? Or will it delete all the other fields for each SKU (leaving me with a bunch of products with only SKU’s and sale prices? Was hoping to figure out how this worked before I screwed up all the products on my site…

    • Hi Nate, spot on. Link the SKU and Sale Price columns then hit the merge import option at import time. It will update the Sale Price for those Products found. I do recommend backing up your store database before you do this as I’m pushing out a Plugin update shortly to fix overriding of default details (the scenario above where the importer has previously cleared existing Product details).

    • Hi steve, glad you got it, the Quantity column is used to manage stock levels. You can also set the Manage Stock and Allow Backorders options for each Product. 🙂

      • Hello Michael!

        I have some problem when I use the CSV import plugin:

        1 – Warning: Invalid argument supplied for foreach() in /home/ezus34/public_html/ezustpengo/wp-content/plugins/jigoshop/classes/jigoshop_product.class.php on line 1004

        2 – I cant find the new version, but Iam login: 1.2.4(?)

        3 – Iam from Hungary and my ÁÉ?ÜÓÚÖ characters is wrong after when I upload the CSV. (I use openoffice and save with UTF-8)

        Thanks!!

  2. Using the Jigoshop bulk uploader I’m running into an interesting problem.

    I had at one point uploaded around 2,000 products to the store but the csv file was … poorly formatted. At great effort I combined all 4,500 items into one single csv and split that csv into nine, 500 item, csv’s. More manageable that way.

    So, I went into the Jigoshop product list and deleted all of the products I had imported before redoing the csv file. Deleted them to the trash, then removed them permanently from the trash. So my store was completely empty … in theory, anyway.

    When I attempted to upload the first set of 500 items, I was only able to upload 48 and was greeted by the summary screen that said “48 items have been created, 452 items have been skipped” then it cited the duplicate SKUs. But those SKUs are no longer in the Jigoshop product list; so what’s going on?

    I’ve been through my PHP control panel, checking wp_posts and wp_postmeta (per a random posting I found in the forums) to no avail.

    Where is Jigoshop caching my old products? If not in the database, then where? I can’t find anything in the bulk uploader plugin folders, nor in the Jigoshop folders.

    I need some support for this issue, I’m approaching deadline in 48hours and did not foresee this issue. Please help.

    • Hi Tanner,

      Did you ever sort this out? I am having the same problem and I see no replies in this thread that describe a fix.

      Thanks,
      John

    • Hi Tanner, just updating your comment for others to read, you need to permanently delete Products via the Trash view under Products within the WordPress Administration. If you use my Store Toolkit Plugin it will permanently delete your Products in one hit.

  3. Hi – just downloaded the extension an are playing around with it – excellent results in first 20 mins – congrats!

    First question I have is related to custom fields! My import CSV file had fields like brands, brand logo, wholesale store name, wholesale store logo, wholesale store url. Can I append these custom fields to the upload and late use in the taxonomy? Can there be a possiblity of importing custom fields: Custom field 1, Custom field 2, Custom field 3

    Thanks
    Scandic

  4. Hey guys we just purchased this plugin and am having major issues with importing.

    We keep getting the message


    Product Importer
    Insuffient data was provided. Please ensure the required product import fields are available and have been matched.

    The minimum data requirements for importing Products into Jigoshop are:

    Duplicate SKU detected
    Product Name
    Category
    SKU

    Any ideas?

    • You’re probably mistaking product name with product description. At a minimum you must have a PRICE, a PRODUCT NAME, and a SKU.

      • Just updating this, since zero price support has been introduced I’ve made Price an optional field. The minimum required fields are SKU, Name, Category and for merging Product changes you only need SKU.

    • Hi itmanager223, as Tanner has mentioned. I’m packing a Plugin update with smarter validation prompts to assist store owners.

  5. I’m got a csv that has has over 64,000 products in it. Can this plugin handle that sized import? Also, I need to import images(via path, so an image might be located at: images/AF000464.jpg). Does this tool handle this as well?

    Thanks,
    Chad D. Bryant

    • Hi Chad, large stores will require substantial memory allocations. I have worked with some clients to success while others have been unable to import their catalogues due to timeouts and memory-relatad corrupted imports.

      You can use the external URL import method to bring in images in different folders within your store but relative filepaths as they are are not supported. Simply make the directory visible to the WordPress installation and use absolute links to the Product images (e.g. http://www.domain.com/images/…).

  6. I have an issue I’ve had before where the import file results in a server error (HTTP Error 500 – Internal Server Error), & also trying to view the Products list in the dashboard does exactly the same.

    Last time I updated the site I had to break the file up into quite small chunks and then I could get it to import okay, although it was very laborious.

    Would you like a sample of the import file so you can give it a try at your end? As before, I’m using the external URL option for images with an absolute URL, although the URL is actually part of the same site. But if you import the file, your server should still find all the images so it should still work.

    Do you, or anyone else, know a good way I can delete all the products wtihout accessing Products in the dashboard? This would no doubt resolve the issue with viewing the products, and I may have some old products to remove, so it’s easier to delete them all & reimport them, or at least it would be if I could!

    Finally I know you develop the same plugin for Woocommerce – is that a better option in your opinion?

    Thanks in advance for your continued support Michael.

    Paul Cutcliffe

  7. hey buddy,

    i have all the products installed etc via CSV but when i try to turn some products off after they have already been published using the Visibility and Product Status options nothing works? is there a way to turn items on and off at all? or once the product is published there is no way of taking some down on a mass scale? we are doing this becuase one vendor we have is not being very nice so we are taking down all there products until they play nice and then bring them back online.

    • Hi J, please download the 3.1.1 Plugin update which includes a fix for merging Product Status against Products. You can use the Draft and Publish status to toggle visibility of Products. 🙂

  8. Hi Michael.

    I need to export all of my products out of WP e-Commerce into a csv file. Will this product allow me to do that and will it include images? Thank you.

    Crista

  9. Hi Michael!
    I’m sorry, but i find another bug… 🙁

    This concerns product attributes.
    In the plugin I saw that you added the prefix ‘pa_’ for product attributes, but quen I load single product template are shown only attribute names but not values??.

    I tried to solve the problem deleting all prefix ‘pa_’ present in functions.php, but this generates an error at line 1008 (Can not use object of type WP_Error as arrays) due to ‘Incorrect Taxonomy’.
    After several attempts to run the import I had to:
    1. add ‘pa_’ prefix for all mine product attributes slug (brand slug becomes pa_brands)
    2. change the lines 1027 and 1668 by modifying:
    $ attributes [‘pa_’. $ attribute [‘name’]] = array (
    ‘name’ => ‘pa_’. $ attribute [‘name’], …

    with:
    $ attributes [$ attribute [‘name’]] = array (
    ‘name’ => $ attribute [‘name’], …

    Only in this way everything works fine!!!

    In addition in the same lines 1027 and 1668, you must replacing:

    ‘is_visible’ => 1,
    ‘is_variation’ => ($ product-> type == ‘variable’)? 1: 0,

    with:

    ‘visible’ => 1,
    ‘variation’ => ($ product-> type == ‘variable’)? 1: 0,

    In summary:
    1) for Tax Classes replace ‘tax_class’ with ‘tax_classes’
    2) fix use of plugin in conjunction with Google Product Feed
    3) see above = D

    For tonight it’s all.
    Bye!

    • Hi Davide, gone through each item and patched it for this release. Thank you for your contribution, if you have any feature suggestion going forward please let me know as I owe you one. Thanks Davide.

  10. Hey Micheal,
    Your Plugins great and has saved me alot of time and money but I have a big issue with my rims and tire site. I need to create attributes to sort by car make and model. When I insert all the attributes for e.g. all the car models it only inserts about maybe 5 or 6 instead of all of them maybe suming up to a 100. I’ve seperated them by the “I” sign. I can’t seem to overcome this issue please if you can help asap I’m trying to get the site up and running by next week Thank you

  11. Hi guys

    great plugin have used it twice now and really like it. I hit upon an issue though with my second client and basically it imported the data and some images but because some images were at a CDN with funny urls they didnt import correctly. I am wondering if I can turn off the requirement for various bits leaving the product title as the only requirement and upload again with local files – if so how would this be done?

    • Hi Andy, ‘funny URLs’/CDN links are hell for the importer to deal with. I will add an import option to ignore dynamic URL’s that the importer cannot detect the filename from. Expect this in the next Plugin update that I’m preparing.

  12. Hi, I’ve created a product Category and Sub-category. Bags ( Parent ), Backpacks ( Child ) When I import the spreadsheet I also specify the structure ( Bags>Backpacks ), put it only puts the product in the Parent, and not the Child. Please help

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