darikwaProducts · Free · Works in your browser
Product record and barcode check
Paste your product list and see which barcodes fail the GS1 check digit, which records are missing a cost, supplier or HS code, and which products sit below your target margin. Then download it as a formula-driven Excel workbook.
It answers
- 1.Which barcodes are wrong: bad check digit, wrong length or duplicated.
- 2.Which products are missing the fields reports, reorders and customs need.
- 3.Which products sit below your target margin.
- 4.How complete the product file is, as one score.
Settings
Data-quality score
20%
2 of 10 records complete
Barcode problems
3
Check digit, length, digits or duplicates
Below target margin
1
Target 55% on the price after VAT
Average margin
65.8%
Across products with a cost and a price
What to fix, by number of products
10 rows · example data, replace it with yours
| # | SKU | Net price | Margin | Barcode check | Issues | Barcode | Description | Category | Colour | Size | Supplier | Country of origin | HS code | Unit cost (£) | Retail price inc VAT (£) | VAT rate | Lead time (weeks) | MOQ | Returns window (days) | Status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| £65.83 | 71.9% | OK | Complete | |||||||||||||||||
| £65.83 | 71.9% | OK | Complete | |||||||||||||||||
| £65.83 | 71.9% | Bad check digit | Barcode Bad check digit | |||||||||||||||||
| £79.17 | 73.5% | Duplicate | Barcode Duplicate | |||||||||||||||||
| £79.17 | 73.5% | Duplicate | Barcode Duplicate | |||||||||||||||||
| £54.17 | 70.5% | OK | No HS code | |||||||||||||||||
| £40.83 | 41.2% | OK | Low margin | |||||||||||||||||
| £18.33 | – | OK | No cost | |||||||||||||||||
| £7.92 | 60.8% | OK | No lead time | |||||||||||||||||
| £7.92 | 57.1% | OK | No category | |||||||||||||||||
Take it into Excel
The download carries your rows and the same rules as live Excel formulas, so it keeps working as you add lines: yellow cells for your data, blue-grey cells calculated, drop-down lists, red and amber flags, frozen headers and filters. Tabs: Start here · Settings · Products (with checks) · Checks summary.
Your data never leaves this browser: nothing is uploaded, and the workbook is built on your device. Copy rows from Excel or Google Sheets and paste into any cell; include the header row to match columns by name.
Want this running on live data? Retail Loom does it over your shop platform, accounts and stock system, every day. See Retail Loom or get in touch.