What this checks
- Missing barcodes — rows without a barcode are flagged, since most ordering and POS systems key off it
- Missing or zero prices — a cost price or sell price of zero or blank usually means the row was left incomplete
- GST rate sanity check — flags rates outside 0% and 10%, which is unusual for standard Australian GST
- Duplicate barcodes — the same barcode appearing twice, which can cause mismatched pricing on import
- Missing product names — rows with a barcode but no name
It doesn't check whether a GST rate is correct for a specific product — only whether it looks like a valid rate. You remain responsible for checking the correct GST treatment of each product.
Expected column format
| Column | Example |
|---|---|
| Barcode | 9300123450012 |
| Product name | Organic Rolled Oats 5kg |
| Unit | carton |
| Cost price (ex GST) | 18.50 |
| Sell price (inc GST) | 26.00 |
| GST rate | 10 |
Common questions
Is my file uploaded anywhere?
No. The CSV is read and checked entirely in your browser using JavaScript. It is never sent to a server.
Do I need an account to use this?
No. This tool is free and doesn't require sign-up.
Can I use this file directly in MenoLink?
MenoLink recognises the same six column names checked here. This tool helps catch common issues before import, but you'll still see an import preview in MenoLink to confirm the details before anything is added.