MerchMettle / catalog handoff guide

A better catalog still needs the right import path.

Prepare the delivered file for the storefront you use, check a small sample, and then continue with that platform’s documented process.

01 / Before the full import

Prepare the handoff, then test the route.

The delivered CSV is a working handoff to review against your destination’s own importer. It is not evidence of a native connection or a guarantee that the same file can be imported unchanged on Shopify, WooCommerce, and Etsy.

Keep the source and delivery separate

Save an untouched copy of your original export. Read the delivery report, identify which columns contain rewritten titles and descriptions, and keep product identifiers and other source facts available for comparison.

Choose the destination before mapping fields

Use the importer and requirements for the storefront where the catalog will live. Similar fields do not guarantee matching CSV formats: Shopify, WooCommerce, and Etsy have different documented workflows and limits.

Try a small representative sample

As a practical starting point, test 3–5 products, including a product with options or variations if your catalog has one. Review the imported listing against the delivered file and source facts before processing the rest. If something is mapped incorrectly, correct the mapping and repeat the sample.

02 / Shopify

Check Shopify’s product CSV rules.

Start with Shopify’s official product CSV import and export guidance. Check these documented fields before importing:

Title and handle
Title is required. Each product needs a unique URL handle; it must not contain spaces.
Category
Use a category from Shopify’s Standard Product Taxonomy, entered as the full breadcrumb or category ID.
Tags
A product can have up to 250 tags.
Variants
A product can use up to three options to create variants.
Barcodes
The Barcodes column supports up to 20 semicolon-separated barcodes, with optional type prefixes.

The cited Shopify CSV guide does not specify image handling, inventory field names or values, or update behavior. Check those details in your store and test them with a small sample; this guide does not treat them as supported behavior of the delivered file.

03 / WooCommerce

Map the rows to WooCommerce’s importer.

Use the Product CSV Importer and Exporter documentation for the import steps and field mapping. For cross-site moves and version-specific matching, also check WooCommerce’s product migration guidance.

  1. Name and headers

    Include the required Name value. Normalize supplier headers and attribute values: trim leading and trailing whitespace, use consistent capitalization, and map synonyms to one value. Review the importer’s field mapping before continuing.

  2. Large files

    If the server cannot process the file in one request, split it into smaller batches and import them separately. Keep a variable product’s parent and its variation rows together when splitting the file.

  3. Images

    Put image URLs in the Images column. The first image listed becomes the featured image.

  4. Stock

    A numeric stock level enables stock management. Use “parent” for a variation that inherits stock settings, or leave the field blank to disable stock management.

Variable products need parent and child rows.

Use one parent row with Type set to “variable,” the parent SKU or ID, and the complete set of attribute values. Add a child row for each variation with Type set to “variation,” a unique SKU or usable mapped Global Unique ID, the parent value in the Parent column, and matching attribute values.

In WooCommerce 11.1 and later, an “Update existing products” import can create eligible new variations for an existing variable product instead of skipping them; this depends on the documented row structure and your store’s version. In 11.2 and later, update rows can match an existing product by a mapped GTIN, UPC, EAN, or ISBN Global Unique ID only when both ID and SKU are blank. If a row’s Type differs from the matched product’s type, the row fails rather than changing that type. Check the migration guidance and target store version before relying on either behavior.

04 / Etsy

Treat the CSV as a copy reference, not an Etsy import.

Etsy’s official help article on creating or editing multiple listings says Etsy does not support bulk CSV uploads for new listings. The documented alternative is to create a listing manually, then copy a listing to save time and edit the copied listing’s details. Use the delivered catalog to reference the rewritten title and description while you create or update listings in Etsy; the CSV does not import directly as new Etsy listings.

MerchMettle / source-grounded catalog service

Start with the platform you actually use.

The current Core offer covers rewritten product titles and descriptions grounded in your source catalog, delivered as an import-ready CSV and concise report. The destination platform still determines its own import rules; no single delivered file is promised to work unchanged across all three platforms. Review the relevant service page and the current order flow for scope and terms.