· DataEase · Tutorials  · 3 min read

Bulk Duplicate Shopify Products

Creating copies of many products manually — including variants, prices, tags, and media — can be extremely time-consuming. DataEase makes it easy: export your products with all their data, prepare a CREATE import, and duplicate them in bulk with validation.

🎯 Goal

Create copies of many products at once — including variants, prices, tags, and media — by exporting, preparing a CREATE import, and validating with DataEase.

📋 Step-by-Step Instructions

1. Export Products with Variants & Media

In DataEase, go to New Export → Products. Include at minimum:

Product:

  • id
  • title
  • handle
  • status
  • bodyHtml
  • vendor
  • productType
  • tags
  • option1Name / option2Name / option3Name

Variants:

  • variantId
  • variantTitle
  • option1Value / option2Value / option3Value
  • variantSKU
  • barcode
  • variantPrice (optionally compareAtPrice)

Inventory (optional):

  • inventoryQuantity or dynamic quantities: {Location}

Media (optional):

  • Media and enable Group product media into single rows

Tip: Use filters (tag, vendor, collection) to select the source products you want to duplicate.

2. Prepare the Duplication File (Turn Rows into CREATE)

Open the exported file in Excel or Google Sheets. For each row you want to duplicate:

Product rows:

  • Set command = CREATE
  • Clear id (leave empty)
  • Set status = DRAFT (recommended)
  • Adjust title (e.g., add “Copy”)
  • Set a unique handle (or leave blank to auto-generate from title)

Variant rows:

  • Set variantCommand = CREATE
  • Clear variantId (leave empty)
  • Ensure unique SKUs (or leave variantSKU blank to fill later)
  • Optionally set inventoryQuantity = 0 to avoid accidental availability

Media:

  • Keeping Media will copy images; note that Shopify stores media per product, so the same URLs will create media entries on each duplicated product (expected behavior)

Additional:

  • Copy over any needed SEO, metafields, collections/tags as desired

When done, save the file as .xlsx or .csv.

3. Import & Validate

  1. In DataEase, start New Import
  2. Upload your edited file
  3. Map columns (Product ID not used for CREATE; rely on fields + commands)
  4. Run Validation

Fix duplicate handles/SKUs or missing required fields flagged in the Validation Status column.

4. Run the Import and Verify

After validation passes, click Run Import to create your duplicated products in Shopify.

Once complete, download the result file, then spot-check several duplicated products (title, handle, variants, prices, and media) in Shopify Admin/storefront.

💡 Tips

  • Keep SKUs unique across your catalog; consider adding a prefix/suffix during duplication
  • If you don’t want images duplicated across the new products, omit Media during CREATE and attach images later following your media workflow
  • Leave id/variantId empty for rows you’re creating

💡 Minimal CSV Example

One product with one variant:

command,id,title,handle,status,bodyHtml,option1Name,option1Value,variantCommand,variantId,variantSKU,variantPrice
CREATE,,Organic Tee — Copy,organic-tee-copy,DRAFT,"<p>Same tee, new listing.</p>",Size,M,CREATE,,TEE-ORG-M-COPY,24.99

Note: Add additional variant rows for the same product by repeating the product fields and setting variantCommand=CREATE with their option values.

🎉 That’s it!

Your products are now duplicated in bulk.
If you run into any issues or have questions, feel free to contact our support team.

Share: