DOCS

CSV mapper

Import a product CSV in your own format, and let Zonos AI map it to Catalog.

Product exports from Shopify, BigCommerce, a supplier, or a spreadsheet rarely match the Zonos Catalog CSV template. The CSV mapper lets you upload that file as it is. Zonos reads your columns, matches each one to a Catalog field, and shows you only what needs a decision before you import.

  • A file that already matches the template imports exactly as before. The mapper doesn't open.
  • Any other file opens Map your CSV to the Zonos template. Zonos AI suggests a column for each field, with a confidence level and the reason for the match.
  • Saved mappings remember your choices. The next file with the same columns is mapped automatically.

The mapper uses the same field rules as Product CSV import, so your item key preference still decides whether a SKU or a product ID is required.

Import a CSV with the mapper 

  1. Go to Dashboard -> Products -> Catalog.
  2. Click More actions in the upper right-hand corner, then select Import products.
  3. Drag and drop your CSV file into the dialog, or click to browse for it. The maximum file size is 100 MB.
  4. Wait while Zonos matches your columns. This can take up to 45 seconds, so stay on the page until it finishes.
  5. Work through the Needs you tab. It lists only the fields that need a decision, such as a required field with no matching column or a match Zonos isn't sure about. For each field, you can:
    • Pick a different column from your file.
    • Set a Value for every row, e.g., USD for Currency when your file has no currency column.
    • Set a Default for blank cells, used only where the column is empty.
    • Check What your values mean to convert your values to the ones Zonos accepts. See Converted values.
  6. Optional: open All fields to review every mapped field, and the Not imported section to decide what to do with unused columns.
  7. Click Continue. Zonos checks every row against the Catalog import rules before anything is imported, and lists any rows that need fixing.
  8. On Review and import, check the number of products, fields mapped, and columns left out. To reuse this mapping, select Save this mapping for future uploads and give it a name.
  9. Click Save and import, or the Import button, which shows your product count, if you didn't save the mapping.

When a saved mapping fits your file and you don't change it, the review step is skipped and Continue imports your products directly.

If column matching is unavailable or takes too long, your file stays in the dialog. Click Retry, or Map fields manually to pick each column yourself.

Converted values 

Your file might use different values than Zonos for the same thing, like lbs, g, or Kilograms for a weight unit, or United States for a country of origin. Under What your values mean, the mapper lists each distinct value in the column with the Zonos value it converts to, e.g., lb -> POUND and grams -> GRAM. Zonos AI fills these in. Change any you disagree with, or use Set them all to... to convert every value to one Zonos value.

The Map your CSV dialog showing weight unit values g, lb, kg, and grams converted to GRAM, POUND, KILOGRAM, and GRAM

Extra columns 

Columns that don't match a Catalog field appear under Not imported -> Your unused columns. They are left out unless you choose otherwise. For each one, you can:

  • Map into a field to use it for a Catalog field after all.
  • Keep as metadata to save the column's value on each product under a key you choose.
  • Keep as attribute to save the column's value as a product attribute.

Saved mappings 

When you save a mapping, Zonos remembers which column feeds each field, your values for every row, your defaults for blank cells, and your converted values. The next time you upload a file with the same columns, in any order, the mapper uses the saved mapping automatically. The dialog shows Mapped using and the mapping's name.

The Review and import step with Save this mapping for future uploads selected and a mapping name entered

If you change a saved mapping during an import, the review step asks whether to update that mapping (Update and import), save your changes as a new mapping, or import without saving your changes.

Manage saved mappings

  1. Go to Dashboard -> Products -> Catalog.
  2. Click More actions, then select Manage CSV mappings.
  3. Click a mapping to see the columns it matches and its field mappings, rename it, or delete it.

You can keep up to 100 saved mappings. New mappings are created only during an import, on the Review and import step.

Was this page helpful?


Get support·Legal docs·© 2026 Zonos