Product Importer Deluxe Plugin for WooCommerce

Product Importer Deluxe comes with a free license of Store Exporter Deluxe so you're ready to export/import/migrate Products!

You also get early access to the Store Importer Deluxe Plugin as it is being developed; all existing import purchases back to 2011 have been grandfathered in too! :)

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

: Import files can be sourced from your computer, a file path on your WordPress site or even external sites and FTP/SFTP servers.

: Importing files from your computer is quick and easy to use.

: Click Import file and upload to begin the import process.

: Link import file columns to WooCommerce Product fields.

: Indicators show automatically linked fields, clicking Cancel (x) beside any import field un-links that field.

: The import file dropdown list makes manual matching effortless.

: Product Importer Deluxe supports many WooCommerce Product details and other WooCommerce Plugins.

: Featured Image and Product Gallery URL’s are pre-processed and a thumbnail sample shown prior to import.

: Product Attributes are grouped and automatically selected at import time.

: Product imports can be customised to suit your import file needs.

: Choose from multiple Product image import methods tailored to suit your import file requirements.

: Advanced controls are available for finer control over Product imports.

: Review the Import Options prior to importing new Product.

: A full import report is shown as the import process runs and can be downloaded after imports.

: Watch as new Products are populated within your WooCommerce store.

: Product Importer Deluxe natively supports over 20 WooCommerce Plugins.

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

: Import files can be sourced from your computer, a file path on your WordPress site or even external sites and FTP/SFTP servers.

: Importing files from your computer is quick and easy to use.

: Click Import file and upload to begin the import process.

: The import file dropdown list makes manual matching effortless.

: Link import file columns to WooCommerce Product fields.

: Product Importer Deluxe supports many WooCommerce Product details and other WooCommerce Plugins.

: Indicators show automatically linked fields, clicking Cancel (x) beside any import field un-links that field.

: Product Attributes are grouped and automatically selected at import time.

: Product Importer Deluxe natively supports over 20 WooCommerce Plugins.

: A full import report is shown as the import process runs and can be downloaded after imports.

: Choose from multiple Product image import methods tailored to suit your import file requirements.

: Watch as new Products are populated within your WooCommerce store.

: Advanced controls are available for finer control over Product imports.

: Product imports can be customised to suit your import file needs.

Reviews

Here's a showcase of Plugin testimonials received from the Comments section which make our day. :)

Tim
1 week ago
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.
Pborde
3 months ago
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.
Dietrich
5 months ago
Product Importer Deluxe works excellent!
Osman Ahmed
7 months ago
Hi, thanks for this amazing plugin!
Andrew
2 years ago
Thanks Michael :)
Matt
5 years ago
Hi Michael, really happy with the plugin, features & support. Thanks, Matt.
Nikki
5 years ago
Thank you Michael. :-)
Joshua Wilson
5 years ago
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 :)
Ryan
5 years ago
Hi Michael, Many thanks for the plugin, it's a great timesaver. Thanks, Ryan
Paul Cutcliffe
5 years ago
Excellent, thanks Michael - keep up the good work!
Kim
6 years ago
Everything working GREAT :-)
Thanks Michael - saving me time already!
Russ
7 years ago
Thanks for the quick response. It's nice to see developers have this kind of interaction.
Robert
7 years ago
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

NicoWeb

6 years ago

v3.8.4

Parse error: syntax error, unexpected $end in /XAMPP/xamppfiles/htdocs/sandbox/wp-content/plugins/wp-e-commerce-product-importer-deluxe/includes/import-save.php on line 1339

Reply
- Trovar
  
  6 years ago
  
  V.3.8.4
  
  I get the same message. Parse error: syntax error, unexpected $end in …./shop/wp-content/plugins/wp-e-commerce-product-importer-deluxe/includes/import-save.php on line 1339
  
  Reply
- Michael Visser
  
  6 years ago
  
  Hi NicoWeb, spotted the culprit, had turned debug off while packaging the Plugin update, the minor Plugin update 2.8.4.1 fixes this, looking at _wpsc_meta spam against your CSV this morning. 🙂
  
  Reply
- Michael Visser
  
  6 years ago
  
  Hi NicoWeb, I’m watching your CSV file being imported as I type this, Categories have been imported and thumbnails are being generated, just need to confirm Products are linking to the correct Categories. I’ll finalise this latest Plugin update (3.8.4.2) and get it out the door.
  
  Reply
Sparklogix

6 years ago

Very excited that variant support is ready, but I have a question. How is the CSV file supposed to be formatted for variants? My client is trying to import a CSV file and is wondering what item from the dropdown menu to select for the “attributes” column which has the variants. Right now, this is how the variant column is formatted:

Color/Finish::Espresso||Storage::Center Drawer

Is that correct and if not, how should it be formatted? And should the column be labeled something other than “attributes”?

Thanks so much for all your hard work!

Reply
NicoWeb

6 years ago

V2.8.3 Bugs revue:

Products :
* Duplicated tags. I have DVD1,DVD2,DVD3,…,DVD15 instead of having just one tag=DVD
* Triplicated pictures to each product (when assigned an external URL column for Products in the CSV file )

Categories :

* Millions of records in DBs
* Missing categories : Languages>French and Country>French just gives French
* Slug’s name changes : Dictionary>Spanish gives french-dictionary BUT Dictionary>Chinese gives chinese. Strange isn’t it ?
* I have 756 categories CSV file (25Kb). Only 76 categories appear in e-Commerce

Hoping it helps

Kind regards

Nicolas

Reply
Kevin

6 years ago

The demo link is broken

Reply
Mongkol

6 years ago

i dont understand what you mean mo file

can you clear explain is it support Asain languages or not?

Reply
- Michael Visser
  
  6 years ago
  
  Hi Mongkol, can you please send me your CSV file to confirm compatibility, I’ll be getting the demo site back up shortly.
  
  Reply
NicoWeb

6 years ago

Hi Michael,

I imagine that fixing the State of the Art new v2.8.2 must be a hard work. Do you have a release date for the stable version of Categories and Products importers ?

I will try to send you more beer next time if it helps 😉

Kind regards

Nicolas

Reply
- Michael Visser
  
  6 years ago
  
  Hi NicoWeb, have shot you an early release of 2.8.3, I’m going through and throwing my test CSV files at it under all sorts of configurations to get this stable with the new WP e-Commerce 3.8+ framework. Official Plugin update later today, hold on guys, I’m sweating code!
  
  (waiting to enjoy those beers, stable Plugin = enjoy beers more!)
  
  Reply
  - NicoWeb
    
    6 years ago
    
    Thanks Michael,
    
    1st report on 2.8.3 :
    Importing sub-categories doesn’t seem to work (cat1>cat2 gives cat2)
    As you mentioned, still creating millions of records in database.
    
    Importing products just do not work. It stops (squeezed screen) after pushing button “upload file and import”. No changes in records database.
    
    Nicolas
    
    Reply
  - Michael Visser
    
    6 years ago
    
    Thanks NicoWeb, have thrown a few sample CSV’s and have sub-categories sticking correctly, will check yours in the morning and release an early build if yours doesn’t play nicely with 2.8.3! Here’s hoping it does though!
    
    Have added more checks during various Product import actions (e.g. manual vs. csv vs. external URL) as well as log notes after successful/failed imports, the next Plugin update(s) will be code/performance optimisation (culling that wp_wpsc_meta on large databases in particular). Thanks for your patience 🙂
    
    Reply
Adnan Rangwala

6 years ago

I am getting memory allocation errors when i use CSV importer to import products.. have 200000 products.

Will this plugin help me avoid that?

I am hosted WP

Reply
- Michael Visser
  
  6 years ago
  
  Hi Adnan, you’ll need to boost your memory allocation if you’re bringing in that many Products at a time, contact your hosting provider to do this else consider splitting the CSV into smaller ‘pieces’, say 50,000 per CSV.
  
  There is no standard memory allocation rule that hosting providers stick by, some are very generous (virtual hosting) while others can be very stringent (shared hosting). Hope this helps.
  
  Reply
Tom Lyga

6 years ago

Michael –

Still messing around with this plugin….I’ve imported a CSV file. The images do not show…I’ve added them as a column in the file, and have ftp’d them to the site following the directions above. Please advise if there are issues with the new release that I need to address.

also, when trying to update a product field, the products are added again to the database, rather than being updated. Please advise what info you may need from me to get this operational.

Thanks,

Tom

Reply
- Michael Visser
  
  6 years ago
  
  Hi Tom, please update to 2.8.3, let me know if you get stuck 🙂
  
  Reply
  - Trovar
    
    6 years ago
    
    What WP folder do we FTP the photos/pics to so the file name designation on the spreadsheet allows the pics to show up?
    
    Reply
  - Michael Visser
    
    6 years ago
    
    Hi Trovar,
    
    Thanks for reminding me, pictures need to be placed in the current WordPress year and month, today is the 4th of June so it would be uploaded to /wp-content/uploads/2011/06/. I’ll update the documentation to reflect this.
    
    Reply
Mike

6 years ago

Hi Michael,

I can’t seem to be able to download the plugin with my session id from Feb 2010.

How can I get my hands on the files?

Cheers,
Mike

Reply
- Michael Visser
  
  6 years ago
  
  Hi Mike,
  
  Shoot me an e-mail if you haven’t already and I’ll send the file manually to you, I’ll be looking at some missing Sales not linking up to my Download Manager Plugin. 🙂
  
  Reply
NicoWeb

6 years ago

Hi Michael,

When importing products (v2.8.2), it seems that the following items do not work properly :

– custom fields empty
– tags duplications : I’m getting 7 entries for “China” tag (with slug = china1, china2,china3,…)

Kind regards

Nicolas

Reply
- Zachary
  
  6 years ago
  
  Trying to import CSV with custom fields. None of the data for the custom fields are working, the log said everything went fine.
  
  Reply
  - Michael Visser
    
    6 years ago
    
    Hi zachary, custom fields are working in 2.8.3. Please update to the latest Plugin update 🙂
    
    Reply
- Bryan
  
  6 years ago
  
  I too get blank custom fields, I really need that to work.
  
  Reply
NicoWeb

6 years ago

Importing categories (985 lines csv file) with v2.8.2 …

After 35 minutes (!!), I get 300 categories. 1,520,555 records created in wp_wpsc_meta table (!!!!)

Is it normal ?

Reply
- NicoWeb
  
  6 years ago
  
  Trying then to import products:
  
  Results : 0 new entries have been added – with 195 products skipped – to your products list.
  
  Because : Could not find a Category by that name (for each product).
  
  Reply
- Michael Visser
  
  6 years ago
  
  Hi NicoWeb,
  
  Woah! Can you please send me your CSV file to reproduce this issue, from a guess each Product Category creates between 10-20 records within wp_wpsc_meta (expecting ~15,000 records) but 1,520,555 is ridiculous; there must be an endless loop!? Let’s sort this out and get a Plugin update out the door, thanks NicoWeb.
  
  Reply
  - NicoWeb
    
    6 years ago
    
    I sent you the CSV file by mail. did you get it ?
    
    Regards
    
    N.
    
    Reply
Mongkol

6 years ago

support thai language? or japan or asian laguages

Reply
- Michael Visser
  
  6 years ago
  
  Hi Mongkol, my suite of WP e-Commerce Plugins displays in U.S. English by default, that said all Plugins support language files (.mo) which I’ll be encouraging community involvement in my overhaul of the documentation section here on Visser Labs.
  
  Reply
  - Mongkol
    
    6 years ago
    
    is that mean support Thai language? when i type a product name your plugin will show it ?
    
    unlike importer default from wp e-commerce that
    does not show and delete Thai language, in all column (product name, product description , etc)
    
    Reply
  - Mongkol
    
    6 years ago
    
    Hi Mongkol, my suite of WP e-Commerce Plugins displays in U.S. English by default, that said all Plugins support language files (.mo) which I’ll be encouraging community involvement in my overhaul of the documentation section here on Visser Labs.
    
    US displays is ok for me what i want is Product name and other column shows Thai language
    
    Reply
Marc Wallburg

6 years ago

Hi Michael,

whats about the variant import?
Does it work with 3.8 ?
And do you have a sample CSV File for the deluxe importer including variant import?
Thx for your reply.

Marc

Reply
- Michael Visser
  
  6 years ago
  
  Hi Mark, now that 3.8 compatibility is here I can focus on Plugin enhancements and issue tracking, Product variation support is a head-liner going forward which Ill draft a CSV format to help store owners prepare their data file for import with Product Importer Deluxe. 🙂
  
  Reply
  - Christian Thibault
    
    6 years ago
    
    Hi Michael,
    
    Do you have an ETA for the support of variations?
    Thank you.
    
    Christian
    
    Reply
  - Michael Visser
    
    6 years ago
    
    Plugin updated, 1.6 is available for download 🙂
    
    Reply
    - Christian Thibault
      
      6 years ago
      
      Hi Michael,
      
      I just downloaded and activated Product Categories Importer 1.5.7 and Product Importer Deluxe 2.8.4.1.
      Now, how do I integrate the variations to the CSV file?
      Thank you.
      
      Christian
      
      Reply
Stephan Boehme

6 years ago

Hi Michael

do you have a sample CSV File for the deluxe importer including variant import?

eg.
T-Shirt
T-Shirt – red 1.99$
T-Shirt – blue 2.99$

or
T-Shirt – red – large 1.99$
T-Shirt – red – small 0.99$
T-Shirt – blue – large 2.99$
T-Shirt – blue – small 1.99$

Thx
Stephan

Reply
NicoWeb

6 years ago

Trying the new 2.8 plugin version. Impossible to activate because of an error :

Fatal error: Call to undefined function wpsc_get_major_version() in /Applications/XAMPP/xamppfiles/htdocs/sandground/wp-content/plugins/wp-e-commerce-product-importer-deluxe/product-importer-deluxe.php on line 16

Testing on WP 3.1 – WP e-Commerce 3.8.3

Am I doing something worng ?

Reply
- Michael Visser
  
  6 years ago
  
  Hey NicoWeb, taking a look at this now 🙂
  
  Reply
  - Michael Visser
    
    6 years ago
    
    Moved the functions.php include to play nice with WP e-Commerce 3.8.3+ compatibility, please update to 2.8.1 🙂
    
    Reply

Add a comment Cancel reply

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:

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.

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.