Import Your Product Catalog in QRGold and Compare Expected vs. Counted Stock
On this page (4)
With your own product catalog, QRGold shows your product names and prices when you scan, even without internet. Add the expected stock and the app shows shortages and surplus while you count.
Step 1: Prepare the file
Use an Excel or CSV file with one product per row. Possible columns: barcode, name, brand, category, price, stock, sku. The order does not matter, and English or Turkish headers both work. Only the barcode column is required. Tap Sample file in the app for a ready-made example.
Excel sometimes turns long barcodes into numbers like 8.69E+12. Format the barcode column as Text in Excel before you save, or those rows are skipped.
Step 2: Import it
- Open My product catalog and tap Import CSV / Excel.
- Choose the file. Turn on Replace the existing catalog if you want to start fresh.
- The app reports how many products were imported. Repeated barcodes keep the last row; rows without a barcode are skipped; barcodes that lost a leading zero are repaired.
Step 3: Count against your expected stock
When the catalog has a stock column, every count list shows Expected, Counted and the Difference. Sort by Biggest shortage first to see what is missing, and check how many catalog products have not been counted yet.
Step 4: Export the result
In the export, the totals row and the difference column are included. Turn on Also list catalog products that were not counted (quantity 0) for a complete stock report.
Limits: the file can be up to 40 MB. Split larger files into smaller ones.