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 Johann, from memory there is no filtering on the Product Name so it may be part of the CSV reading function that’s stripping it out. I’ll see what function is filtering that character out and add an international language option at import time in the next Plugin update.

  2. I’ve got a CSV file that follows the following format. Will your plugin handle importing this data?

    1 UNIQUE_KEY Unique Identifier created as combination of INVENTORY_KEY & SIZE_INDEX
    2 PRODUCT_TITLE Includes Manufacturer?s name
    3 PRODUCT_DESCRIPTION Description of product features
    4 STYLE# Mill style # same as style number used in catalogs
    5 AVAILABLE_SIZES Sizes available
    6 BRAND_LOGO_IMAGE File name of Brand image such as Port Authority or Ping
    7 THUMBNAIL_IMAGE File name of Small image for Lifestyle-Model picture
    8 COLOR_SWATCH_IMAGE File name of Colors available image for colors available in a style.
    9 PRODUCT_IMAGE File name of Lifestyle-Model picture jpg for web sites
    10 SPEC_SHEET PDF PDF or Word document listing specifications.
    11 PRICE_TEXT How price applies such as Price applies to?..
    12 SUGGESTED_PRICE Recommended retail
    13 CATEGORY_NAME Major categories such as Tee Shirts, Knit Shirts, Woven?s
    14 SUBCATEGORY_NAME Such as 100% Cotton Tee or Crewneck Sweatshirts or Camp Shirts
    15 COLOR_NAME Name of color
    16 COLOR_SQUARE_IMAGE File name of Image which creates the square in a color swatch.
    17 COLOR_PRODUCT_IMAGE File name of Regular (usually folded) image
    18 COLOR_PRODUCT_IMAGE_THUMBNAIL File name of Small picture of (usually folded) items
    19 SIZE Size of item
    20 QTY Quantity available as of this download ? all warehouses combined
    21 PIECE_WEIGHT Approximate Weight Per Piece ? lbs./piece ? Final weight determined at shipping.
    22 PIECE_PRICE Price Per Piece based upon a purchase of 05 pieces or less of a single style & Color
    23 DOZENS_PRICE Price Per Piece based upon a purchase of 6 pieces or more of a single style & color
    24 CASE_PRICE Price per piece based upon Case Purchase by Size / Color / Style
    25 PRICE_GROUP Pricing Group for white pricing group, lights pricing group, darks pricing group, etc.
    26 CASE_SIZE Total # of pieces of a single style /color/ size per case
    27 INVENTORY_KEY Proprietary Inventory Key
    27 SIZE_INDEX Size category number for each size grouping
    28 MAINFRAME_COLOR Color name as it exists in our Mainframe ? may be different from catalog color. Order submission with colors must use this color
    Folder Names for images
    Fields 6, 8, 9, 16, 17, 18

    Field 10 has its own folder

    • Hi Johann….

      have the same problem! But if you save your CSV File in UTF8 Modus it works 😉
      Gru? aus M?nchen

  3. Thanks Michael,

    Just keep me posted when it’s ready. I am ready to start adding the whole database to my site.

    thank you,
    Robert

  4. Hi Robert, now that the category-linking issue is on it’s way to being resolved I’ll reintroduce that code for Brands and push out another update before support for WP e-Commerce 3.8. I’ll do that later this afternoon.

  5. thanks Michael,

    what about the (Brands) group, Nothing I did made the Brands “sub group” get created.

    The “Brands” group already exist and has brands already, i.e. Canon, Nikon, Pentax etc. and I am trying to add the above.

    the Brands group would be a parallel group, such as

    Binoculars & Telescopes>Microscopes & Accessories|Brands>Astrodon

    do you have any thoughts about that.

  6. Hi guys, I’ve been banging my head against the wall since the weekend, you can now link Products to as far as 3 levels deep, with more to come once I switch to a recursive solution.

    This means:

    Crossbow>Scope>10x – will work (3 levels)
    Binoculars & Telescopes>GPS / Rangefinders / Outdoor – will work (2 levels)
    Binoculars & Telescopes>GPS / Rangefinders / Outdoor>GPS Accessories – will work (3 levels)

    I’ll continue to enhance this category linking feature in future Plugin updates, for now ensure you set the base Parent Category (e.g. Crossbow) and then build up with your Categories (separated by ‘>’ for sub-categories). Hope this helps, thanks for your patience.

  7. Robert – have not really spent much time with the tags.

  8. Thanks Bruno,

    I just noticed the Tags were not imported on the products side.

    I had them separated with ” | ” (pipe) just like the sample csv file.

    any thoughts about that???

      • Ok, the tags were imported but they were imported (as is) with pipe shown.

        meaning I got one tag like so:

        Tags Used
        X Flash|Lighting|Light Stands and Grip|Light Stands|Brands|Avenger

        the sample csv file uses pipe to separate them, should I use commas instead??

  9. don’t even bother with this plugin until the newest update. It will cause you nothing but frustration and anger.

    Michael is currently working on the categories to try and straighten them out.

    If you have say Crossbow>Scope>10x and another category Scope>Rangefinder>10x its going to default bad. It will not import the 10x in both spots because it all ready sees it as a category. So when you import the category it will start dropping sub categories.

    • Ok,

      I am getting confused a bit. is this issue in the (category importer) or the product importer????

      Do you mean that if I import the product per your example it will default to the 10x.

      Michael, you were on the 22nd you were saying you are four hours away to fixing the bug, could you give us a status please.

      Thank you,
      Robert

      • Hi Robert, I’ve sent you an e-mail.

        The same category-linking on unique categories issue affected Product Importer Deluxe as well as Product Categories Importer. Both have now been resolved. Please confirm.

        I’m aware of a permalink-related issue which I’m working with you to resolve, my suspicions are it’s to do with the Product Category name. I’ll keep this page up to date as well as the Blog.

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

    but the category thingy is giving me a hard time. I am tied to import the following file:

    Category
    Binoculars & Telescopes>Microscopes & Accessories
    Binoculars & Telescopes>GPS / Rangefinders / Outdoor>GPS Accessories
    Binoculars & Telescopes>Telescopes and Accessories>Telescope Accessories
    Brands>Bodelin
    Brands>GGI International
    Brands>Astrodon

    The Brands are refusing to show up under the Brands group!! the first time I imported the file, I got the (Brands) showing up under categories. then I separated the files and imported the Brands by themselves hoping they would show up under the Brand group but still no luck, they just don’t show up.

    Any thoughts what am I doing wrong???

  11. Hi Robert, no need for Gold Cart unless you’re assigning multiple Product image filenames via CSV, in the future I’ll add support for manually importing multiple Product images as well as File Downloads using this method.

    For now I’m working hard to resolve the category-linking issue affecting sub-directories, I’m making process (reduced the number of duplicates) and will make an urgent Plugin update ASAP. Thanks!

  12. Michael,

    Ignore my questions, I found the answer in the sample file I downloaded from your documentation page, the sample-deluxe1.csv file has all the answers. I’ll purchase it tonight.

    do I need the GoldCart for this plugin? (I had to ask something. LOL)

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