Product reports¶
New Stock Lines¶
| Report Name | Group columns | Detail columns | Total columns | Pivot column | Value column |
|---|---|---|---|---|---|
| New Stock Lines | product, barcode, ordercode, retail, unit_cost, tax_rate, margin, margin_per, date_added, employee | ||||
| New Stock Lines (by department) | department | product, barcode, ordercode, retail, unit_cost, tax_rate, margin, margin_per, date_added, employee |
Expiry date¶
| Report Name | Group columns | Detail columns | Total columns | Pivot column | Value column |
|---|---|---|---|---|---|
| Expiry date report (by date) | expiry_date | department, product, retail, clearance_price, clearance_qty | |||
| Expiry date report (by product) | department, product | expiry_date, retail, clearance_price, clearance_qty |
Non sellers¶
| Report Name | Group columns | Detail columns | Total columns | Pivot column | Value column |
|---|---|---|---|---|---|
| Non-sellers (by department) | department | product, ordercode, retail, cost, barcode, stockqty | |||
| Non-sellers (by supplier) | supplier | product, ordercode, retail, cost, barcode, stockqty |
Other product reports¶
| Report Name | Group columns | Detail columns | Total columns | Pivot column | Value column |
|---|---|---|---|---|---|
| Department List | department, age_check, earn_points, min_margin, web_upload | ||||
| Duplicate products | department | product, retail, cost, ordercode, count | |||
| Product Barcodes | department | product, productid, ordercode, retail, cost, barcodes | |||
| Product Edits | product, datetime, employee, action, field, original, new | ||||
| Product File Health | problem | name, barcode, costprice, retailprice, stockqty, supplier, ordercode | |||
| Retail Price Changes | dateeffective | product, barcode, retail_price, ssp, effective_store | |||
| Retail Price Changes (by product) | product, barcode, retail_price, ssp, effective_store, dateeffective | ||||
| Supplier List | name, address1, address2, address3, address4, postcode, contact_name, telephone, fax, email, other |
Promotional offer reports¶
| Report Name | Group columns | Detail columns | Total columns | Pivot column | Value column |
|---|---|---|---|---|---|
| Customer Promotions | promotion, start_date, end_date, type, qty1, price1, qty2, price2, qty3, price3, qty4, price4 | ||||
| Customer Promotions (Products) | promotion | product, barcode | |||
| Promotional Offer Clashes | product_name, barcodes, retailprice, promo_name, start, end, qty1, price1, qty2, price2 | ||||
| fresh Campaigns | campaign_name, issued, expires, no_issued_coupons, redemptions, max_redemptions, first_redeemed, last_redeemed, total_discount | no_issued_coupons, redemptions, total_discount |
Product Performance reports¶
| Report Name | Group columns | Detail columns | Total columns | Pivot column | Value column |
|---|---|---|---|---|---|
| Product Performance (by supplier) | store, supplier | line | month | qty | |
| Product Performance (by supplier & department) | store, supplier, department | line | month | qty | |
| Product Performance (by supplier & subdepartment) | store, supplier, department, subdepartment | line | month | qty |