Product catalog import
Your product catalog is your current product master file. Every completed import replaces the whole thing — products missing from the file are deleted. Always upload the complete file, not just the new rows.
How products are identified
A product is its barcode + SKU + external ID combination, exactly as written (letter case and leading zeros count). This combination is how the import recognizes an existing product.
How scanning finds a product
When someone scans a code, QuantalCount tries to find the product using your match order: up to three fields tried in sequence, for example barcode first, then SKU, then external ID. If several products match in the same step, the scan is flagged as ambiguous instead of guessing.
You set this order in the same Import Templates page.
What you can import
| Column | Required | Notes |
|---|---|---|
barcode, sku, externalId | At least one | Used to identify products; can have fix-up rules attached |
name | Yes | Product name |
description | ||
category | ||
unit | ||
retailPrice | ||
remark | ||
brand, color, size, style, spec | ||
costPrice | ||
custom1 … custom5 | Free text, kept as-is |
Only the identity columns are used for matching — everything else is just information.
Setting up the template (Admin)
Under Settings → Import Templates → Product catalog:
- Whether the file has a header row
- Column mapping — at least one identity column, or uploads will be rejected
- Encoding and fixed-width layout if your file needs it — see File formats & encodings
- Optional fix-up rules on identity columns, like "if a code is 14 digits, drop the last one" — see Code cleanup & fixes
Uploading without a template fails with a PRODUCT_IMPORT_PROFILE_REQUIRED error.
What happens after upload
Uploads run in the background:
- The file is parsed with your template.
- New and changed products are saved; missing products are removed.
- Conflicting rows land in a review queue — they don't block the rest.
- Retrying or rolling back always uses the template version from the original upload.
Plan limits
| Starter | Business | Enterprise | |
|---|---|---|---|
| Products | 1,000 | 100,000 | 5,000,000 |
| Rows per file | 10,000 | 500,000 | 6,000,000 |