Product Data & Barcodes
This course covers advanced product data management in Quickenerp: multiple barcodes per product, auto-generating barcodes, minimum order quantities, standard margin tracking, category-level default taxes, and showing a customer's own product codes on invoices.
| Responsible | System |
|---|---|
| Last Update | 07/21/2026 |
| Completion Time | 1 day 4 hours |
| Members | 1 |
Speaking the Customer's Own Part-Number Language
Some B2B customers track purchases using their own internal part/reference codes for your products, different from your own SKU. Configure a customer-specific product code (via the product's Customer & Vendor info tab) so it can be shown on the customer's invoice line automatically alongside — or instead of — your own product code.
Setting It Up
- On the product, add a Customer entry under Purchase/Sales info, with that specific customer's code for this product.
- Enable Show Customer Code on that customer's contact record (or invoice) so it prints automatically.
- When invoicing that customer, the invoice line shows their own reference code, reducing confusion/back-and-forth on which product a line item refers to on their end.
This is a small detail that meaningfully speeds up accounts-payable matching for large B2B customers who process high invoice volumes against their own purchasing system.
Barcodes
View allSpeaking the Customer's Own Part-Number Language
Some B2B customers track purchases using their own internal part/reference codes for your products, different from your own SKU. Configure a customer-specific product code (via the product's Customer & Vendor info tab) so it can be shown on the customer's invoice line automatically alongside — or instead of — your own product code.
Setting It Up
- On the product, add a Customer entry under Purchase/Sales info, with that specific customer's code for this product.
- Enable Show Customer Code on that customer's contact record (or invoice) so it prints automatically.
- When invoicing that customer, the invoice line shows their own reference code, reducing confusion/back-and-forth on which product a line item refers to on their end.
This is a small detail that meaningfully speeds up accounts-payable matching for large B2B customers who process high invoice volumes against their own purchasing system.
Keeping Pricing Data Consistent Across the Catalog
Standard Margin & Markup
Each product can show its Standard Margin (sales price minus cost) and Standard Margin Rate/Markup Rate directly on the product form — a quick per-product profitability check while pricing, without needing to run a full Product Profitability report (Finance Insights course) for a single item.
Minimum Order Quantity (MOQ)
Set a Minimum Order Quantity on a product to prevent website customers from ordering fewer units than makes sense for you to fulfil (common for wholesale/bulk items) — the shop enforces it automatically, adjusting the cart or blocking checkout below the minimum rather than relying on customers reading a note.
Category-Level Default Taxes
Rather than setting sales/purchase taxes on every single product individually, set default Taxes and Supplier Taxes on a Product Category — every product filed under that category inherits the correct tax automatically, and (if Taxes Updatable From Category is enabled) an update to the category's tax propagates to its products. This is the fastest way to fix or set up tax defaults across a large catalog at once instead of editing hundreds of products individually.
Beyond One Barcode Per Product
Multiple Barcodes
A product's standard Barcode field only holds one value, but real products often have several valid codes in circulation — different suppliers may print different EAN/UPC codes for the same item, or a product may have both a case barcode and an individual-unit barcode. Add extra codes on the product's Additional Barcodes list so scanning any of them (at POS, in Inventory receiving, anywhere a barcode scanner is used) correctly identifies the same product.
Auto-Generating Barcodes
For products that don't come with a manufacturer barcode (own-brand/private-label goods, internal parts), configure a Barcode Rule and generation pattern so Quickenerp assigns a valid, correctly-formatted barcode automatically when a new product (or variant) is created, instead of someone manually inventing a number that might not scan correctly or might collide with another product.
- Choose a Generate Type matching the barcode standard you need (e.g. EAN-13).
- Set a starting Barcode Base number for the sequence.
- Works for both product templates and individual variants (e.g. each Size/Color combination gets its own generated code).