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. Hi Michael, it appears that the AIOSEO options don’t show in the drop boxes if custom fields have been set up, is this right? I get all the custom fields showing in the drop boxes, but not the AIOSEO ones. Any ideas, how to get the AIOSEO options to show to line them up with the csv?
    Thanks for your help.

    • Hi Isabella, I’ll confirm this as I’m preparing a Plugin update this morning to sort out some merge import issues as well as improve the Product image import process; support for pre-uploaded Product images via Media Library and an early release of WPML-support. 😉

    • Hi Isabella, just confirming that you have All in One SEO Pack activated as well as WP e-Commerce 3.8 and above. I’m adding WP e-Commerce 3.7 in the next Plugin update. 🙂

      • Thanks Michael, yes you’re right. Forgot to turn it on for this site! Question though, it appears that the SEO columns don’t merge INTO an existing import, only a fresh one. Is there a way to get them to get added? Thanks for your ongoing help. 🙂

  2. I’ve got the plugin to work, a SUPERB plugin SWEET!

    Now i have a problem with 2 things:

    1. The first thing im facing trouble with, is the product images. I upload them from an external URL and all works fine so far. But when im viewing my store, the images does not appear on category-view, but if i go inside a productpage, the image is there and works perfect. I need to go to each product and “Manage productimages” and then hit “Use as product thumb”, why, do i need to do this on all my thousand products? Then its worthless, sorry :-/

    2. The second problem is when im trying to import a External Link Text, the value i enter here, does not appear on the products settings for this field. It’s like the information does not get imported.

    I would be very glad if i could get an answer on my problems.

    Thanks in advance!

    • Hi Joel, I’ve sorted the external link text issue in the latest Plugin update. I’m looking at how WP e-Commerce reads the Product images under the various views; unfortunately there’s no single standard so I’ll have a play locally and release a minor Plugin update to correct this. 🙂

      • Michael

        There seems to be an issue with the product thumbnails on this plugin. The images upload fine, but it does not automatically assign it as a thumbnail. You have to go through each product manually and click ‘use as product thumbnail’

        Any ideas on how to resolve this?

  3. Gahhhh…!
    I just bought this Product Importer Deluxe but im using WP E-commerce 3.8.7.2, and probaly thats the reason this module doesn’t work, am i right?

    If yes, when will there be an upgrade for this module to work with the latest WP E-commerce?

    • Hi Joel, 3.8.7.2 is just a minor Plugin update, I’ll be confirming support in the following few days. If you are looking for the import option please open Tools > Import > Products from the WordPress Administration. 🙂

      • Please, have a look at my latest comment above. I really need your help in this.

  4. Michael when I load multiple images using a vertical pipe to separate the image names in the CSV, it always results in my images laying out incorrectly as shown here:http://www.screencast.com/t/7msSgDIZU5

    Is this a known issue with the Product Importer? Or is this an issue with my site’s code?

    • Hi lucas, I’m not aware of this issue affecting customers or my own test sites. Please reset to the Twenty Ten Theme and see if this is resolved, if so, then it’s likely your WordPress Theme at fault. 🙂

  5. Michael, I have an urgent matter. My session ID is showing invalid when I try to update our Product Importer Deluxe. We purchased it in April of this year and need this update in order to launch our website. I emailed you as well, please respond as quickly as possible.

    Thanks!
    Ian

    • Hi Ian, your e-mail got trapped by the spam monster. I’m fishing it out now and will confirm your Session ID. Thanks Ian. 🙂

  6. Any updates on the timeframe of when you will include the ability to mass upload an individual wholesale (using your wholesale pricing module) price for each product?

    Thanks,
    Anhtony

    • Hi Anthony, it’s sitting in the #5 spot in my todo list. Have a few intense development days ahead so I’ll do my best to get it in next week. 🙂

  7. Michael, are custom fields suppose to update during a “merge” CSV upload? They fail to update for me. The only solution I have is to delete the items and then re-upload.

    • Hi Lucas, Custom Fields are not yet supported within the merge feature which would explain why they’re not updating. I’ll get this sorted in the next Plugin update, there’s been another batch of cool changes. 🙂

      • That would be great Michael, we are working with over 2,000 items and updating custom fields, categories, and images is crucial for our growth. Note, we are having issues updating images as well.

        FYI – Ian (from other comments) and I are working on SirBingley.com with your plug-in

      • Hi David and Andrew, Product variations are not yet supported, I’ll be introducing this feature in the new year. It’s been on my todo list for some time but has needed a whole overhaul in the way Products are processed by the importer which makes this now possible. 🙂

  8. Hey Michael, is the admin for this supposed to be under Settings still (as per your screen grabs)? Can’t find it anywhere. I have the latest version of WP and WPEC and v2.8.7 of the importer.

    • Hi t-racer, I’ll need to update those screenshots as they’re causing some confusing since integrating the Product importer under Tools > Import, I’m putting a post together now explaining that the Categories importer step has been merged into the Products importer so now you don’t need to separately import Categories and then Products. 🙂

      • Thanks Michael. That’s a tad confusing. Would make more sense under Products I’d reckon seeing as that’s where you go to add products…

        Anyway, I found it and tried the import, got the success message but there’s no products. I checked in phpMyAdmin as well and there’s nothing. Pretty sure my spreadsheet is fine as I downloaded the sample one then modified it. Any ideas?

        • Also, when importing (I think this may be the problem) it can’t seem to tell when the rows start and end. So when assigning columns it has all the header row data then all the other rows following, wanting to assign columns to them. As I said, I used your sample spreadsheet as a template so I don’t think I have any weird formatting in my spreadsheet.

        • Hi t-racer, that sounds like a possible session/csv reader issue. I’ve dumped support for sessions in the next Plugin update so will be keen to hear how it works after this update. 🙂

  9. hello there.. i already purchased this awesome plugin but my customer asks wpml support to their website.. and they have 567 items 🙂 i already have 4 different language in the excel file in the individual tabs.. my questions are:

    1. is this plugin supports wpml with e-commerce?
    2. is it possible to share new csv template for wpml support if it is yes for the Q#1

    thank you!

    • Hi flayzeraynx, good timing. WPML support will be included in the next Plugin update shipping shortly. I’ll be putting together a tutorial to explain how to format your CSV file to support this, basically though set a column for each Product title and description (e.g. Product Name – English, Product Name – French, Product Name – Italian, etc.). We’ll be building this out further in future Plugin updates. 🙂

      • that’s very good news indeed. But what about more than 10 language?

        it’s getting weird isn’t it 🙂

        • Once support is introduced there will be no limit on language numbers, just as long as you’ve enabled your chosen languages within WPML they’ll tie into the importer and make additional column options available. 🙂

      • hey michael, can you give e a target date for next release of update with WPML support? my customer asks me every day to update their website but i am waiting for the WPML support before i do..

  10. Hi,
    I did my first product import last night. Some of the photos were not linked correctly and I had to upload new photos. I made some corrections to the CSV and re-imported however this time it will not link or update photos, it is completely ignoring them. How do I get this to import and link the product photos?

    • Hi Sarah, can you please confirm what import method you are using; whether it’s external URL or Image filename and that you’re following the import steps laid out in the Plugin’s readme.txt. Thanks Sarah. 🙂

      • I am selecting the option for image column in CSV on import and also the merge with existing product data option. I have followed the instructions in the readme.txt. What I am doing is exporting current products that don’t have photos (as CSV) and then adding the image column and importing using the above options. I have tried to save my CSV file as a new file.
        I noticed there was an update to the plug in today and installed it. Still no photos on import.

        Thanks!
        Sarah

        • I have had the same scenario as Sarah, but I have worked around by re-uploading the images. After re-uploading the images they reconnected to the items.

  11. When uploading items and merging new changes, I can’t get images to update, i.e. if I want to use a new image, I would change the image name in the CSV and upload the image, however the image doesn’t get updated. Any idea what I am doing wrong?

    FYI – I can successfully load images for new items and I can upload changes for other fields successfully, just cant get the images to update via Product Importer Deluxe

    • Similarly, I can’t get the “Category” to update with new data when doing an upload of pre-existing products.

      • If it turns out that I can’t update categories during a merge, perhaps I could upload more than one category during the initial item upload. Ultimately, I want the same item in two different categories, i.e. a brand page and a category page.

        • Hi Lucas, I’ll re-add support for merging Category updates to existing Products in the next minor Plugin update. Shouldn’t be far off. 🙂

  12. oh… one more question, sorry…. can it import from many spreadsheets? i have several vendors and i keep them separate because they don’t all update at the same time….

          • michael, where does that product exporter put the csv file? it says it exported successfully, but didn’t give me a filename or a path…. thanks.

            • Hi fontaholic, the exporter will generate a download file, just save the CSV file either from the download prompt or via Save Page As (this is for Firefox). 🙂

              • i think i wasn’t selecting products or categories the first few times i tried. now it seems to be doing its thing. thank you.

  13. hi… wondering if the Product Importer Deluxe is able to import meta tag information for products?

      • oooo yes please. So does that mean it can or can’t yet do this? Can I import meta tags via csv? Thanks, Michael

        • Hi Isabella, spinning this up now, please note though that the free version of AIOSEO does not have an interface for managing the Product’s SEO details; yet. I’ll make a small Plugin that adds a widget to the Add/Edit Products page to allow management of those imported Product meta details. 🙂

        • Hi Isabella, support for All in One SEO Pack meta details have been added in the 2.9.6 Plugin update. I’ll update the sample spreadsheet to show how to use it; very easy as always. 🙂

          • Hi Michael,
            I posted in the forum about an issue I’m having with merging updates into existing products. Can you explain how it is supposed to work. Perhaps I am doing something wrong. Either way I have not been able to update my products.

            Here is a link to the thread http://www.visser.com.au/forums/topic/no-merging/

            Thanks in advance.

          • Hi Michael, thanks for offering AIOSEO pack integration. I am just looking for the sample spreadsheet you talk about. It appears the one listed at the top of the page is still for the older version.
            What are the column titles we need for the DB entries? Thanks 🙂

            • ok, so it looks like I’ve figured it out. Thought I’d post it here for anyone else wondering how to do it. It was one of those things that was so simple, it was assumed, but not particularly clear to me at first.

              Basically when you go Import>> upload your csv

              and you get to the page where you see your csv’s ‘first row’ entries in a vertical column on the left and then in the ‘CSV-> Wp e-commerce’ column next to that on the right, each variable has a drop box.
              THAT DROPBOX is where Michael has added the AIOSEO selections,
              I was confused (as you may be) because I couldn’t immediately see those options (you have to scroll each one down). Also, in the past we’ve had to add these custom variables ourselves using the custom fields plugin. So I couldn’t work out what the titles needed to be in csv. These titles are what need to go in the first row of the csv file and their corresponding values in the csv column beneath.
              All you need to do on import is SCROLL DOWN in these CSV -> WP ecommerce drop box options, then select the title that matches the column in your csv on the left of it.

              Hope that helps someone. I was puzzled for days. Cheers.

              • BLAH! Although I found the dropboxes, I still can’t get it to work. I did a csv import, but I see no data being entered into the AIOSEO boxes in a product listing in WP admin and also when I go into phpmyadmin in cpanel to see whether it’s been entered into the DB, it’s not appearing – at least I can’t find it. Can you please point me in the right direction. Thanks.

                • getting closer…. that time it worked if I have no commas, just a single word in the csv cell….

  14. Ok… just so im clear.

    First, set up my cvs spreedsheet with all the categories and custom fields included.

    During the import… your “product importer” will not only create the products.. but will also create the categories and custom fields associated with those products. No need to create the categories/custom fields “before the import”? correct?

    So its probably a good idea to get rid of any existing categories/custom fields?

    So, If the custom fields are created “during the import”… im assuming… that “after the import” would be the time to go in and format the “type of custom field” (text box, pulldown, etc)?

    • Hi Chuck, that’s mostly correct. You will need to create the Custom Fields prior to the import as this is not yet supported. I like you idea of importing them as generic custom fields initially.

      You use the Product Categories option within Tools > Import to use your CSV file to generate the Category structure, then the Products option to import the Products and populate the WordPress database. 🙂

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