Sample report
What a CatalogPilot check looks like
This report was produced by the real checking engine from an example supplier file (fictional products) — a semicolon-separated, Windows-1252 price list with a title row, European prices and kg weights. No customer data is shown.
- Rows
- 7
- Products
- 4
- Errors
- 2
- Warnings
- 7
- Auto-fixed
- 25
File
Encoding: Windows-1252 · Separator: “;” · Header found on row 2 · 16 columns
Column mapping
| Supplier column | Shopify column | Confidence |
|---|---|---|
| Parent SKU | Groups variants (Parent SKU) | 99% |
| Item Code | SKU | 98% |
| Product Name | Title | 97% |
| Long Description | Description | 99% |
| Brand | Vendor | 98% |
| Category | Type | 86% |
| Colour | Variant option (Size, Color…): Colour | 99% |
| Size | Variant option (Size, Color…): Size | 98% |
| RRP (EUR) | Price | 99% |
| Wholesale | Cost per item | 100% |
| Stock | Inventory quantity | 92% |
| Weight (kg) | Weight (grams) (from kg) | 99% |
| EAN | Barcode | 100% |
| Image 1 | Product image URL | 100% |
| Image 2 | Product image URL | 100% |
| Internal Notes | Don't import | 100% |
Problems found
Missing required data (1)
- Error · Row 9 · Title — Empty product name. Product "bag-tote" has no title. Shopify needs a title to create a product. CatalogPilot won't invent one — add it in your source file.
Variants & options (1)
- Error · Row 6 — Duplicate variant. This row repeats the option combination "Black / S" already used on row 5 for "organic-tee". Each variant needs a unique combination of option values.
File structure (3)
- Note — The file uses CRLF line endings. The file uses CRLF line endings. Shopify recommends LF; the corrected file uses LF.
- Warning — The file uses semicolon separators. The file uses semicolon separators. Shopify expects commas; the corrected file will use commas.
- Warning — The column headers were found on row 2, not row 1. The column headers were found on row 2, not row 1. Rows above it were skipped. Shopify requires the header on the first row; the corrected file fixes this.
Columns & headers (1)
- Warning · Internal Notes — Column not included in the Shopify file. "Internal Notes" doesn't match a Shopify product column, so it's left out of the corrected file (Shopify can reject unknown columns). If it holds product data, map it to a Shopify column in the mapping step.
Handles, SKUs & barcodes (5)
- Note · Row 3 · URL handle — URL handle created. A handle was created from the title "Organic Tee": "organic-tee". Shopify does the same when a handle is blank, but variant rows need it to attach to the right product. Fixed → organic-tee
- Note · Row 7 · URL handle — URL handle created. A handle was created from the title "Wool Scarf – Grey": "wool-scarf-grey". Shopify does the same when a handle is blank, but variant rows need it to attach to the right product. Fixed → wool-scarf-grey
- Note · Row 8 · URL handle — URL handle created. A handle was created from the title "Enamel Mug « Café »": "enamel-mug-cafe". Shopify does the same when a handle is blank, but variant rows need it to attach to the right product. Fixed → enamel-mug-cafe
- Note · Row 9 · URL handle — URL handle created. A handle was created from the group "BAG-TOTE": "bag-tote". Shopify does the same when a handle is blank, but variant rows need it to attach to the right product. Fixed → bag-tote
- Warning · Row 6 · Item Code — Duplicate SKU. SKU "TEE-ORG-BLK-S" is also used on row 5. Shopify allows it, but duplicate SKUs cause inventory, fulfillment and reporting mix-ups.
Inventory & shipping (8)
- Note · Row 3 · Weight (kg) — Weight in the wrong format. Shopify's weight column takes whole grams. Fixed → 180
- Note · Row 4 · Weight (kg) — Weight in the wrong format. Shopify's weight column takes whole grams. Fixed → 190
- Note · Row 5 · Weight (kg) — Weight in the wrong format. Shopify's weight column takes whole grams. Fixed → 180
- Note · Row 6 · Weight (kg) — Weight in the wrong format. Shopify's weight column takes whole grams. Fixed → 180
- Note · Row 7 · Weight (kg) — Weight in the wrong format. Shopify's weight column takes whole grams. Fixed → 250
- Note · Row 8 · Weight (kg) — Weight in the wrong format. Shopify's weight column takes whole grams. Fixed → 300
- Note · Row 9 · Weight (kg) — Weight in the wrong format. Shopify's weight column takes whole grams. Fixed → 600
- Warning · Row 3 · Inventory tracker — Stock quantities won't be tracked. 6 variant(s) have an inventory quantity, but the file has no Inventory tracker column. Shopify only tracks stock (and uses these quantities) when Inventory tracker is "shopify". Suggested: set Inventory tracker to "shopify" and "Continue selling when out of stock" to "deny" for those variants.
Formatting (1)
- Warning · Row 8 · Stock — Placeholder instead of a value. "n/a" is a placeholder, not a real inventory quantity. Shopify would import it literally. Suggested: leave the cell blank.
Encoding & characters (1)
- Warning — The file is not valid UTF-8 (it looks like Windows-1252 / Latin-1, common in older Excel exports). The file is not valid UTF-8 (it looks like Windows-1252 / Latin-1, common in older Excel exports). Shopify requires UTF-8, so accented characters may import incorrectly. The corrected file is saved as UTF-8 — check accented characters in the preview.
Prices & numbers (14)
- Note · Row 3 · RRP (EUR) — Invalid price. Shopify needs plain numbers here (no currency symbols or thousands separators). Reformatted to the number Shopify expects. Fixed → 29.95
- Note · Row 3 · Wholesale — Invalid cost per item. Shopify needs plain numbers here (no currency symbols or thousands separators). Reformatted to the number Shopify expects. Fixed → 11.20
- Note · Row 4 · RRP (EUR) — Invalid price. Shopify needs plain numbers here (no currency symbols or thousands separators). Reformatted to the number Shopify expects. Fixed → 29.95
- Note · Row 4 · Wholesale — Invalid cost per item. Shopify needs plain numbers here (no currency symbols or thousands separators). Reformatted to the number Shopify expects. Fixed → 11.20
- Note · Row 5 · RRP (EUR) — Invalid price. Shopify needs plain numbers here (no currency symbols or thousands separators). Reformatted to the number Shopify expects. Fixed → 29.95
- Note · Row 5 · Wholesale — Invalid cost per item. Shopify needs plain numbers here (no currency symbols or thousands separators). Reformatted to the number Shopify expects. Fixed → 11.20
- Note · Row 6 · RRP (EUR) — Invalid price. Shopify needs plain numbers here (no currency symbols or thousands separators). Reformatted to the number Shopify expects. Fixed → 29.95
- Note · Row 6 · Wholesale — Invalid cost per item. Shopify needs plain numbers here (no currency symbols or thousands separators). Reformatted to the number Shopify expects. Fixed → 11.20
- …and 6 more
Corrected Shopify CSV (excerpt)
Title,URL handle,Description,Vendor,Type,SKU,Variant Barcodes,Option1 name,Option1 value,Option2 name,Option2 value,Price,Cost per item,Inventory quantity,Weight value (grams),Product image URL,Image position Organic Tee,organic-tee,"<p>Organic cotton t-shirt, garment dyed.</p>",Example Goods Co.,T-Shirts,TEE-ORG-WHT-S,4006381333931,Colour,White,Size,S,29.95,11.20,14,180,https://cdn.example.com/tee-white.jpg,1 ,organic-tee,,,,TEE-ORG-WHT-M,4006381333948,,White,,M,29.95,11.20,22,190,https://cdn.example.com/tee-back.jpg,2 ,organic-tee,,,,TEE-ORG-BLK-S,,,Black,,S,29.95,11.20,0,180,https://cdn.example.com/tee-black.jpg,3 ,organic-tee,,,,TEE-ORG-BLK-S,,,Black,,S,29.95,11.20,5,180,, Wool Scarf – Grey,wool-scarf-grey,"<p>Brushed wool scarf, 180 cm.</p>",Example Goods Co.,Accessories,SCARF-WL-GRY,,Colour,Grey,,,45.00,17.00,9,250,https://cdn.example.com/scarf.jpg,1 Enamel Mug « Café »,enamel-mug-cafe,<p>Enamel mug for café-style coffee.</p>,Example Goods Co.,Kitchen,MUG-ENM-01,,,,,,1234.50,6.10,,300,https://cdn.example.com/mug.jpg,1 ,bag-tote,<p>Tote without a name.</p>,Example Goods Co.,Bags,BAG-TOTE-01,,Colour,Olive,,,39.00,14.00,3,600,,