Skip to main content

​
Import products from CSV

CSV import is the fastest way to add a large catalog when you’re getting started, or to update many products at once.
  1. In the Shopify Admin, open PopUp and go to Products
  2. Select Import CSV
  3. Download the template, fill it in, and upload it

​
Download the template

The template is available directly from the Products page. It includes the correct column headers and example rows.

​
Column reference

ColumnRequiredValuesNotes
SKUYesAny textAuto-generated by PopUp — do not change or delete. See note below.
NAMEYesAny textProduct name shown in POS
TYPEYesweight or itemWeight products use a scale; item products have a fixed price
UNITWeight products onlylbs, oz, kg, gLeave blank for item products
PRICEYesNumber (e.g. 3.50)Price per unit for weight; flat price for items
ACTIVEYestrue or falseWhether the product appears in POS
CATEGORYNoCategory nameMust match an existing category name exactly, or a new one will be created
imageurlNoURLDirect URL to a product image
id (readonly)NoNumberOnly present in exported files — lets the importer match rows to existing products for updates. Do not add this manually.
Don’t change or delete the SKU column. PopUp automatically generates a unique SKU for every product (e.g. VEG-TOM-001) — it doesn’t appear in the product form, but it’s present in every exported file. When you re-import a CSV, PopUp uses the SKU to find the matching product and apply your updates. If you change or delete a SKU, PopUp won’t recognise the row as an existing product and will create a duplicate instead.

​
Rules

  • Column headers are case-insensitive — SKU, sku, and SKU* all work
  • Lines starting with # are treated as comments and ignored
  • A row is skipped if sku, name, or price is missing
  • type must be exactly weight or item — other values are rejected
  • If a category name doesn’t exist yet, it will be created automatically
  • Existing products are matched by id first, then by SKU as a fallback

​
Example rows

SKU,NAME,TYPE,UNIT,PRICE,ACTIVE,CATEGORY
VEG-TOM-001,Tomatoes,weight,lbs,3.50,true,Vegetables
VEG-CAR-002,Carrots,weight,kg,2.00,true,Vegetables
BAK-CRO-003,Croissant,item,,1.75,true,Baked Goods

​
Import results

After uploading, PopUp shows a summary:
  • Created — new products added
  • Updated — existing products changed
  • Skipped — rows with errors (listed with row number and reason)

​
Export your catalog

  1. In the Shopify Admin, open PopUp and go to Products
  2. Select Export CSV
  3. The file downloads to your device
The exported file includes all columns from the table above, plus id (readonly). You can edit it and re-import to bulk-update your catalog.