CSV / Excel Catalog Format

A spreadsheet using the headers below can be used in two ways:

• Create a new catalog — Upload through the scan flow; the AI recognizes the products and builds your catalog.
• Bulk price update — Open an existing catalog and tap "Bulk update prices via CSV / Excel". Two options appear: download the current catalog as Excel (recommended — the file ships with a stable id column so renaming a product in Excel won't break the merge), or upload a sheet you already have. Items are matched by id first, falling back to name; matched rows have their price, currency, unit, packaging, stock and category fields refreshed.

Columns

• id — stable product identifier (optional). Filled in automatically on the Excel file downloaded from the app. When present, matching is independent of the name — renaming a product in Excel still hits the same record (the rename surfaces as another diff line). Leave blank in hand-authored sheets; the importer falls back to name match.
• name — product name. Required. Used as the merge key when id is empty (case-insensitive, extra whitespace collapsed).
• price — selling price (discounted). No thousands separator: 12.50, 149.99. European format 1.234,50 is also accepted.
• original_price — list price (rendered as strike-through). Leave empty to show only the price.
• currency — ISO code: TRY, USD, EUR, GBP, AED, etc. (3 letters). On bulk update, write the new ISO code to change an item's currency. An empty cell or a non-ISO value (e.g. "lira") is a no-op — the existing currency is preserved.
• unit — unit of measure. E.g. pcs, kg, lt, pack.
• package_info — packaging. E.g. 500g, 12-pack, 1L.
• stock — remaining count (optional integer). Empty = no stock tracking. 0 = sold out.
• disabled — soft "out of stock" flag (optional). Accepts true / false, 1 / 0, yes / no. Use it to hide several items from the cart in one go.
• description — long-form description (optional, up to 2000 characters). Use it for ingredients, materials, allergen notes, "vegan", "gluten-free" tags, care instructions, and similar supporting copy. Renders as an expandable section beneath the item on the public catalog.
• category — category name (optional). For bulk updates, the category must already exist in the catalog; unknown names are silently ignored.

Tips

• Recommended flow: "Download as Excel" from the app → edit in Excel / Numbers / Google Sheets → "Pick file" to re-upload. You'll see a preview before anything is applied.
• Bulk update never deletes: items not present in the CSV stay in your catalog.
• Bulk update does not add new items: rows in the CSV that aren't in the catalog are reported as "unmatched" but left alone. Add new items individually via the app.
• An empty cell does not clear the matching field — the existing value is kept. This prevents accidental clears in hand-edited sheets. Exception: an empty cell in the description column does clear the existing description, so you can intentionally wipe a stale spec.
• The downloaded Excel locks the id and name columns and adds a dropdown to the category column. You can remove sheet protection (Excel: Review → Unprotect Sheet), but don't hand-edit id cells — they're the merge key.
• Turkish headers also work: ürün, fiyat, liste fiyatı, para birimi, birim, paket, stok, stokta yok, açıklama, kategori.
• Don't embed images in the CSV — ZipOrder lets you add per-item images inside the app after import.
• Each catalog can hold up to 2000 items — the Excel file can't exceed that either. For a bigger list, split the catalog into two.

Example

id,name,price,original_price,currency,unit,package_info,stock,disabled,description,category
,Tam yağlı süt 1L,9.99,12.50,TRY,adet,,,false,Pastörize · oda sıcaklığında saklayın,Süt ürünleri
,Yumurta L (15'li),35.00,,TRY,koli,15,30,false,Köy yumurtası — gezgin tavuk,Süt ürünleri
,Beyaz peynir 500g,79.99,89.50,TRY,paket,500g,15,false,Tam yağlı · vakumlu,Süt ürünleri
,Zeytin yeşil 500g,55.00,,TRY,paket,,,true,Edremit körfezi · az tuzlu,Mezeler