Product Description

Details

This user-friendly Product importer, with clear step-by-step instructions helps you import and update Products, Variations, Categories, Tags, and other Product details into your WordPress-powered store.

After successfully importing tens of thousands of Products across hundreds of WP e-Commerce, Jigoshop, WooCommerce and Exchange stores Product Importer Deluxe has become the standard for store owners and web developers to bulk import Products, Variations, Categories, Tags, Brands.

Product Importer Deluxe can merge Product changes against existing Products with live and post-import reporting.

Variations, Categories, Tags, Brands, Images and other 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. Our free Store Exporter Plugin can export Products from an existing WordPress store making importing changes to existing Products almost too easy!

Third-party integration

To enable the import options for the above 3rd party Plugins ensure the Plugin (e.g. Related Products) is activated and up to date, refer to the sample CSV’s available in the FAQ section on this page for examples. Support for additional Product details are introduced through regular free Plugin updates.

Screenshots

Compatibility

  •  WooCommerce (up to 2.6.*)
  •  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. 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?

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

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

          • 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

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

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

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

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

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

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

      • 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

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

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

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

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

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

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

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

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

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

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

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

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

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

    • 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

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

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

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

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

  9. i dont understand what you mean mo file

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

    • Hi Mongkol, can you please send me your CSV file to confirm compatibility, I’ll be getting the demo site back up shortly.

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

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

      • 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

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

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

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

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

      • What WP folder do we FTP the photos/pics to so the file name designation on the spreadsheet allows the pics to show up?

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

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

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

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

    • Trying to import CSV with custom fields. None of the data for the custom fields are working, the log said everything went fine.

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.

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 (141)

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