Merge Product CSV Files for Shopify, WooCommerce & Etsy

Running an e-commerce store often means managing product data from multiple sources — supplier feeds, manufacturer exports, wholesale distributors, existing platform exports. Each comes with its own CSV format, different column names, and different field orders. Before you can import to Shopify, WooCommerce, or Etsy, you need them in one file.

The browser CSV merger handles this without a custom script or a developer. Drop in your product files, click Merge, and get one combined CSV ready for cleanup and import.

Common Situations Where You Need to Merge Product CSVs

The scenarios that come up most in e-commerce operations:

• Multiple supplier feeds: Three suppliers send weekly CSV exports. You need them combined into one master catalog before updating your store
• Platform migration: Moving from Etsy to Shopify (or vice versa) — exporting from one, reformatting, importing to the other, while preserving all products
• Wholesale + dropship catalog: Your owned inventory in one file, dropship products in another — combine before syncing to your store
• Seasonal catalog updates: Adding a new product line CSV to your existing catalog export without re-entering everything
• Multi-location inventory: Each location or warehouse sends its own inventory CSV — combine for a unified view

The challenge in every case: files rarely have identical column schemas. Supplier A might use "product_title" while supplier B uses "item_name." The merger auto-aligns by header name so the data ends up in the right columns regardless.

Merging Shopify Product CSVs

Shopify product imports use a specific format with columns like Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Option1 Name, Option1 Value, Variant SKU, Variant Price, etc.

When combining Shopify exports from multiple stores or sources:

1. Export products from each store as CSV (Products > Export)
2. Drop all export files into the CSV merger
3. Click Merge — the tool aligns all columns by header name
4. Open the merged file in Google Sheets or Excel to review and remove any duplicate Handle values (duplicate Handles cause import conflicts)
5. Import the cleaned merged file to the target store

Watch for the Handle column specifically — it must be unique per product in Shopify. If two products from different exports have the same Handle, one will overwrite the other on import. A quick filter-for-duplicates step in Google Sheets catches this before import.

Sell Custom Apparel — We Handle Printing & Free Shipping

Merging WooCommerce Product CSVs

WooCommerce's product CSV export (via the Product CSV Import Suite or built-in exporter) uses columns like ID, Type, SKU, Name, Published, Short description, Description, Price, etc.

The ID column creates a common issue when merging: if two product CSVs both have an "ID" column with internal WordPress post IDs, those IDs will conflict on import. Solutions:

• Delete the ID column before importing if you're adding new products (WooCommerce will assign new IDs)
• Keep IDs only if updating existing products and you're certain the IDs match

The CSV Column Editor lets you remove the ID column or any other column without touching the rest of the data — do this after merging.

Handling Different Supplier CSV Formats

The real world: supplier A calls the field "product_name," supplier B calls it "title," supplier C calls it "item_description." When you merge these CSVs, the auto-matcher creates three separate columns instead of combining them into one — because the column names are different.

The fix is a pre-merge renaming step. Before merging:

1. Open each supplier CSV in a text editor (or the CSV Column Editor)
2. Rename columns to match a standard schema — pick one convention and apply it to all files
3. Then merge the standardized files

This two-step process (standardize headers, then merge) takes a few extra minutes but produces a clean merged file that doesn't require post-merge cleanup. For recurring supplier imports, save a renaming script or a mapping document so next month's merge takes seconds instead of minutes.

After Merging: What to Check Before Import

Before importing the merged CSV to any platform:

• Duplicate SKUs: Filter the SKU column and look for duplicates — most platforms treat duplicate SKUs as conflicts
• Missing required fields: Each platform has required columns (Shopify needs Handle, WooCommerce needs SKU or Name). Look for blank cells in required columns
• Price format: Some exports include currency symbols, others don't. Standardize to plain numbers
• Image URLs: If your CSV references product images by URL, confirm those URLs are accessible from the target platform

Google Sheets makes this review fast — paste the merged CSV, use conditional formatting to highlight blanks in required columns, and filter the SKU column for duplicates before downloading the cleaned version for import.

For more on the pre-import cleaning workflow, see our guide on merging and cleaning CSVs without code.

Frequently Asked Questions

How do I combine product CSV files for Shopify import?

Export products from each source as CSV, drop all files into the browser CSV merger at wildandfreetools.com/spreadsheet-tools/merge-csv/, click Merge & Download, then review the merged file for duplicate Handles or SKUs before importing to Shopify. The tool auto-aligns columns by header name.

Can I merge WooCommerce CSV exports from multiple stores?

Yes. Export from each store, drop all exports into the browser merger, and download the combined CSV. Before reimporting, delete the ID column (WooCommerce will assign new IDs to new products) and check for duplicate SKUs which will conflict on import.

What if my supplier CSVs have different column names?

The merger creates a union of all column names — if supplier A uses "product_name" and supplier B uses "title", both columns appear in the merged file. Before merging, standardize column names across supplier files using a text editor or the CSV Column Editor to ensure data lands in the same column.

Is it safe to merge product CSV files containing pricing data online?

The browser CSV merger processes files locally — no upload to any server. Your product data, pricing, and SKUs never leave your device. This makes it safe even for sensitive pricing information.