CSV import and export
For catalog-wide edits that are easier in a spreadsheet than one product at a time, use Import/Export (from the Products page, or directly at Products → Import/Export). It exports and re-imports feed overrides, not your Shopify product data itself.
Exporting
Section titled “Exporting”Choose a Market and select Download CSV. The file contains one row per product variant, and covers every product Máximo currently syncs for that market.
File structure
Section titled “File structure”- Row 1: column headers (machine names; don’t edit these).
- Row 2: a description of each column with a reference link. This row is skipped automatically on import.
- Row 3 onward: one row per product variant.
Columns fall into three groups:
| Group | Examples | Notes |
|---|---|---|
| Identifiers | product_id, variant_id, title, variant_title | Read-only; ignored if you edit them and re-import. |
| Product-level overrides | title_override, description_override, image_overrides, google_product_category, custom_label_0 through custom_label_4, brand, condition, gender, age_group, product_type, identifier_exists, adult, is_bundle, multipack, shipping_label, min_handling_time, max_handling_time, auto_pricing_min_price | Apply to the whole product. Repeated on every variant row of that product. |
| Per-destination overrides | title_override_google, title_override_meta, title_override_tiktok, and the matching description_override_* and image_overrides_* columns | Override a single destination within the selected market, taking priority over the matching global column. See Per-destination overrides. |
| Destination exclusions | exclude_google_merchant, exclude_meta_catalog, exclude_tiktok_catalog | Set to yes to exclude the product from that destination, no to include it. |
| Variant-level overrides | color, size, mpn, material, pattern | Apply to the individual variant on that row. |
The per-destination columns cover Google, Meta, and TikTok. Pinterest supports per-destination overrides and exclusions, but doesn’t have CSV columns yet, so set those from the product page instead. See per-destination overrides and exclude and include.
image_overrides and its per-destination variants take pipe-separated image URLs (https://…|https://…), with the first URL used as the main image.
Editing and re-importing
Section titled “Editing and re-importing”Edit the file in any spreadsheet tool, then upload it back on the same page and select Import. A few rules govern how Máximo applies your edits:
- Blank cell: leaves the existing value unchanged. You don’t need to fill in every column, only the ones you’re changing.
__clear__: enter this exact value in a cell to remove the override for that field, falling back to the next source in line (see Overrides and Per-destination overrides for that fallback order).- Column order doesn’t matter: columns are matched by their header name in row 1, not their position.
- Product-level fields use the first non-blank row: since a product-level column is repeated across all of a product’s variant rows, Máximo uses the first non-blank value it finds for that product and ignores the rest.
Validation and errors
Section titled “Validation and errors”After an import, Máximo reports how many products were updated and how many rows were skipped. Rows that fail validation are listed individually with the row number, product ID, and the reason, so you can fix just those rows and re-import rather than starting over.
Limits
Section titled “Limits”A single import processes at most 500 variant rows. If your file has more, Máximo processes the first 500 and tells you it truncated the rest, split larger catalogs into multiple files.