close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Web development tutorial

Duplicating Products in CafeCommerce

Tutorial created by Team WebAssist

Categories: CafeCommerce


Every once in a while an entry in your product catalog comes along that's just… just so beautiful, you know? So perfect that when you close your eyes you can almost see its producty face inanimately not looking back at you, smiling, except for the fact that it doesn't have a face. A product catalog entry so great, that you don't believe in a million years you could duplicate it.

Well guess what buster; if you use CafeCommerce you can. This tutorial is going to show you the bee's kneesiest way to go about creating an exact duplicate of a product in your catalog without the manual grind of adding each and every thing into a new entry. This way also retains that sparkle that your beloved product catalog entry has.

arrow downExport your existing catalog

In this step, we're going to export your existing product catalog into a .csv file that we can later open in Microsoft Excel.

  1. Log into your CafeCommerce admin
  2. Go to your Dashboard (
  3. Make sure the Store tab is selected
  4. Click the Import/Export button
  5. Under Export, set the File Format to CSV (.csv)
  6. Select Products from the Data to include options
  7. Click the Export button

arrow downDuplicate the product

  1. Open the .csv file that was just created in Mircosoft Excel
  2. Locate the row for the product you want to duplicate
  3. Click the row number to highlight the entire row
  4. Click Edit > Copy or CTRL+C in Windows or Command+C in OS X
  5. Right click on the row number of the top product in the list
    This should be row number 2
  6. Click Insert Copied Cells
  7. Under the Product ID column, change the Product ID for the newly duplicated product to an ID that isn't being used
    This lets CafeCommerce know this product isn't currently in your store, and will let it know to add it.
  8. Repeat steps 2- for each product you want to add to your catalog
  9. Save your .csv file

arrow downImport the updated catalog

This section is for users with existing CafeCommerce accounts that are currently using a payment gateway.

  1. Log into your CafeCommerce admin
  2. Go to your Dashboard (
  3. Make sure the Store tab is selected
  4. Click the Import/Export button
  5. Click the Choose File button for the Select .CSV file field
  6. Locate the .csv file with the duplicated products
  7. Select the file
  8. Click the Import button

arrow downWhat to do next

And there you have it. CafeCommerce will only add the products to the catalog that have new IDs (hence the reason we changed the IDs on the duplicated products) and leave any untouched that have existing IDs. The next step for you is to duplicate a million products! Well, only if you need to duplicate a million products, that is. If you don't, you're pretty much all set.

arrow downReviews and comments

Comments will be sent to the author of this tutorial and may not be answered immediately. For general help from WebAssist, please visit technical support.

Sign in to add comments

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.