Reports are a useful tool to extract the information you require in spreadsheet format. This lesson will summarises the details and uses of each Products report in its default format.
The order of this list matches the order present on Zedonk for easy reference.
System Reports
Products
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Full Manufacturer'
Extract this report for a full summary for all Manufacturers within your system.
- Ac
- IS
- Material Category
- RM ID
- Supplier Colour Ref
- Our Ref
- Colour
- UM
- Ccy Symbol
- Ccy
- Cost
- FX Rate
- Rate Date
- Cost
- Memo Card
- Inventory Item
- Sales Required
- Production Required
- Combined Required
- PO Quantity
- PO Cost
- Composition
- Care Instructions
- Width Size
- Type for Product Costings
- External Reference
- Intrastat
- Supplier Category
- Supplier Name
- Supplier Full Address
- Supplier Country
- Supplier Contact 1
- Supplier Telephone 1
- Supplier Email 1
- Payment Terms
- Shipper
- Shipping Terms
- Agent
- Agent Telephone
- Agent Email
- Date Created
- Created By
- Date Last Modified
- Modified By
- Image Path
- Image
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Full Product'
Extract this report for a full detailed summary of your products.
- Season
- Ac
- IS
- Withdrawn
- Product ID
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Style
- Fabric
- Colour
- Description
- Size Category
- Sizes
- First Season
- Manufacturer
- Manufacturer Category
- Manufacturer Payment Terms
- Manufacturer External Reference
- Manufacturer Country
- Lead Time
- Minimums
- Comments
- Customs Type
- Textile Content
- Sales Order Notes
- MID
- Country of Origin
- HTS Code
- Intrastat Code
- Export Duty Rate
- Weight (KG)
- Manufacturing Type
- Production Notes
- Labels
- Ccy Symbol
- Ccy
- Unit First/Make Cost
- FX Rate
- Rate Date
- Unit First/Make Cost
- Unit RM Cost
- Freight Method
- Freight Percentage
- Freight Ccy Symbol
- Freight Ccy
- Freight Cost
- Freight Rate Per (KG)
- Freight Cost
- Import Duty
- Import Duty Cost
- Misc Method
- Misc Percentage
- Misc Rate
- Misc Cost
- Unit Cost
- WSP Markup
- Cost To WSP Markup
- Suggested WSP
- WSP
- Actual Markup
- Gross Profit Margin
- Unit Gross Profit
- Selected on SO
- Sales Order Quantity
- Total First/Make Cost
- Total RM Cost
- Total Freight
- Total Duty
- Total Misc
- Total Cost
- Avg Price
- Wtg Avg Price
- Wtg Avg Price After Discount
- Total SO Value
- Total SO Value After Discount
- Total Gross Profit After Discount
- Docket Quantity
- Booked Out Quantity
- Booked In Quantity
- In Transit Quantity
- Work In Progress
- Closed Quantity
- Picked Quantity
- Unshipped Quantity
- Shipped Quantity
- PT+DN Quantity
- RRP Markup
- WSP to RRP Markup
- Suggested RRP
- Date Created
- Created By
- Date Last Modified
- Modified By
- Image Path
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Cost Summary'
Extract this report for a summary of your product costs and wholesale prices.
- Season
- Ac
- IS
- Size Category
- Product ID
- Description
- Unit First/Make Cost
- Unit RM Cost
- Freight Cost
- Import Duty Cost
- Misc Cost
- Unit Cost
- Suggested WSP
- WSP
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Product Wh/RRP Prices'
Extract this report for a summary of product details, wholesale and retail prices.
- Ac
- IS
- Season
- Style
- Fabric
- Colour
- Description
- Textile Content
- Sizes
- WSP
- RRP
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Price List Wholesale'
Extract this report for a wholesale price list of your products
- Season
- Ac
- IS
- Size Category
- Style
- Fabric
- Colour
- Description
- Sizes
- WSP to RRP Markup
- Suggested RRP
- WSP
- Withdrawn
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Price List RRP'
Extract this report for a recommend retail price (RRP) list of your products
- Season
- Ac
- IS
- Size Category
- Style
- Fabric
- Colour
- Description
- Sizes
- WSP to RRP Markup
- Suggested RRP (GBP)
- RRP (GBP)
- Withdrawn
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Line Sheet'
Extract this report for an excel line sheet of your products, defaulted with wholesale prices only.
- Season
- Ac
- IS
- Size Category
- Product ID
- Description
- Sizes
- WSP (GBP)
- Image Path
- Image
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Product Customs Data'
Extract this report for a summary of the customs details of your products.
- Season
- Ac
- IS
- Size Category
- Style
- Description
- Fabric
- Colour
- Textile Content
- Customs Type
- HTS Code
- MID
- Intrastat Code
- Export Duty Rate
- Country of Origin
- Manufacturer
- Manufacturer Country
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Make Costs'
Extract this report for a summary of your product's costs.
- Season
- Ac
- IS
- Size Category
- Manufacturer
- Manufacturer External Reference
- Manufacturer Payment Terms
- Product ID
- Description
- Unit First Make Cost (GBP)
- Unit RM Cost (GBP)
- Freight Cost (GBP)
- Import Duty Cost (GBP)
- Misc Cost (GBP)
- Unit Cost (GBP)
- Sales Order Quantity
- Total First Make Cost (GBP)
- Total RM Cost (GBP)
- Total Freight (GBP)
- Total Duty (GBP)
- Total Misc (GBP)
- Total Cost (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Gross Profit'
Extract this report for a summary of your gross profit per product based on your sales order (SO) quantities.
- Season
- Ac
- IS
- Size Category
- WSP Markup
- Product ID
- Description
- Unit Cost (GBP)
- Suggested WSP (GBP)
- WSP (GBP)
- Gross Profit Margin
- Unit Gross Profit (GBP)
- Sales Order Quantity
- Total Cost (GBP)
- Wtg Avg Price (GBP)
- Wtg Avg Price After Discount (GBP)
- Total SO Value (GBP)
- Total SO Value After Discount (GBP)
- Total Gross Profit After Discount (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'WorkFlow'
Extract this report for a summary of your shipped and outstanding sales order units.
*For Inventory users*: You will also be able to analyse the Book Out/ Book In, and pick quantities
- Season
- Ac
- IS
- Size Category
- WSP Markup
- Product ID
- Description
- Unit Cost (GBP)
- Suggested WSP (GBP)
- WSP (GBP)
- Gross Profit Margin
- Unit Gross Profit (GBP)
- Sales Order Quantity
- Total Cost (GBP)
- Wtg Avg Price (GBP)
- Wtg Avg Price After Discount (GBP)
- Total SO Value (GBP)
- Total SO Value After Discount (GBP)
- Total Gross Profit After Discount (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Full Product Raw Material'
Extract this report for a total summary of your detailed raw material quantity requirements based on your sales order quantities.
Useful for extracting data for trackers and referencing when planning/shipping production raw material allocations.
- Season
- Ac (PC)
- IS (PC)
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Style
- Fabric
- Colour
- Description
- Date Created
- Created By
- Date Last Modified
- Modified By
- Manufacturer
- RM Code
- Material Type
- Our Ref
- RM Ref
- Material Category
- Ac (RM)
- IS (RM)
- RM Colour
- CCy
- Unit Cost
- FX Rate
- Rate Date
- Unit Cost (EUR)
- UOM
- Rating
- Extended Cost
- Extended Cost (EUR)
- Comments
- Production Quantity
- Total Rating
- Total Cost
- Total Cost (EUR)
- Memo Card
- Width Size
- Composition
- Care Instructions
- Raw Material External Reference
- Supplier
- Supplier Ref
- Supplier External Reference
- Supplier Enquiry
- Supplier Contact 1
- Supplier Full Address
- Supplier Address 1
- Supplier Address 2
- Supplier Address 3
- Supplier Town
- Supplier Postcode
- Supplier Country
- Supplier Telephone 1
- Supplier Telephone 2
- Supplier Fax
- Supplier Email 1
- Supplier Website
- Supplier Bank
- Supplier Payment Terms
- Supplier Shipper
- Supplier Agent
- Supplier Agent Telephone
- Supplier Agent Fax
- Supplier Agent Mobile
- Supplier Agent Email
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Product Raw Material'
Extract this report for a summarised version of the 'Product Raw Material' (above) only showing essential information for raw material quantities per product.
'Reports' > 'System Reports' > 'Products' > 'Product' > 'Full Product Notes'
Extract this report for all notes on your products. You can then filter by your note tags if required.
- Ac (PC)
- IS (PC)
- Material Type
- Our Ref
- RM ID
- RM Colour
- Supplier
- CCy
- Unit Cost
- Unit Cost (EUR)
- Rating
- Extended Cost
- Extended Cost (EUR)
- Product SO Quantity
- Total Rating
- Total Cost
- Total Cost (EUR)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product-Size' > 'Full Product Size'
Extract this report for a full breakdown of your sales order quantities delivery status
- Season
- Ac
- IS
- Withdrawn
- Size Category
- Manufacturer
- Manufacturing Type
- Product ID
- Style
- Fabric
- Colour
- Description
- Size
- Barcode
- WSP (GBP)
- Avg Price (GBP)
- Wtg Avg Price (GBP)
- Sales Order Quantity
- Total Wtg Avg Price (GBP)
- Book Out Quantity
- Book In Quantity
- Allocated Quantity
- Picked Quantity
- Unshipped Quantity
- Shipped Quantity
- PT+DN Quantity
- RRP (GBP)
- RRP (EUR)
- RRP (SEK)
- RRP (EUR (LANDED))
- RRP (USD)
- RRP (EUR 2)
- RRP (CURRENCY NAME)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product-Size' > 'Full Product Size Financial'
Extract this report for your costing and pricing summary for each product per size.
This is a useful point of reference if you use sized RM.
- Season
- Ac
- IS
- Withdrawn
- Size Category
- Product ID
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Style
- Fabric
- Colour
- Description
- Size
- Manufacturer
- Manufacturer Category
- Customs Type
- Textile Content
- MID
- Country of Origin
- HTS Code
- Intrastat Code
- Export Duty Rate
- Weight (KG)
- Manufacturing Type
- Production Notes
- Ccy
- Ccy Symbol
- Unit First Make Cost
- Unit First Make Cost (GBP)
- Unit RM Cost (GBP)
- Freight Cost (GBP)
- Import Duty
- Import Duty Cost (GBP)
- Misc Cost (GBP)
- Unit Cost (GBP)
- WSP %
- Cost to WSP Markup
- Suggested WSP (GBP)
- WSP (GBP)
- Gross Profit Margin
- Unit Gross Profit (GBP)
- Sales Order Quantity
- Total First Make Cost (GBP)
- Total RM Cost (GBP)
- Total Freight (GBP)
- Total Import Duty (GBP)
- Total Misc Cost (GBP)
- Total Cost (GBP)
- Avg Price (GBP)
- Wtg Avg Price (GBP)
- WSP (GBP)
- WSP (GBP 2)
- RRP Markup
- WSP to RRP Markup
- Suggested RRP (GBP)
- RRP (GBP)
- RRP (GBP 2)
- Date Created
- Date Last Modified
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product-Size' > 'Product Master & RRP'
Export this report for a summary of your products costs and retail price (RRP) per size
- Ac
- IS
- Season
- Product ID
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Style
- Fabric
- Colour
- Description
- Size Category
- Size
- Manufacturing Type
- HTS Code
- Intrastat Code
- MID
- Country of Origin
- Unit Cost (GBP)
- RRP (GBP)
- RRP (GBP 2)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product-Size' > 'Full Barcodes'
If you have the Barcode module. You can extract this report to view your product barcodes per size.
- Ac
- IS
- Product ID
- Style
- Fabric
- Colour
- Size
- Description
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Product-Size' > 'Full Product Size Raw material'
Extract this report to view all sized raw material quantities and costs per size of your products
- Ac (PC)
- IS (PC)
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Style
- Fabric
- Colour
- Description
- Manufacturer
- Sequence
- Material Type
- Our Ref
- RM ID
- Material Category
- Ac (RM)
- IS (RM)
- RM Colour
- Ccy
- Unit Cost
- FX Rate
- Rate Date
- Unit Cost (GBP)
- UOM
- Rating
- Extended Cost
- Extended Cost (GBP)
- Comments
- Product SO Quantity
- Total Rating
- Total Cost
- Total Cost (GBP)
- Memo Card
- Width Size
- Composition
- Care Instructions
- Raw Material External Reference
- Supplier
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Bestseller' > 'by Fabric'
Extract this report for bestseller analysis based on fabrics.
- Ac
- IS
- Size Category
- Mark Up Category
- Style
- Description
- Total SO Qty
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Bestseller' > 'by Style'
Extract this report to view your bestsellers by style.
- Ac
- IS
- Size Category
- Mark Up Category
- Style
- Total SO Qty
- Image
- Thumb Image
- Unit Cost (GBP)
- Wholesale Price (GBP)
- RRP Price (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Bestseller' > 'by Style Description'
Extract this report to view your bestellers by style description.
- Ac
- IS
- Size Category
- Mark Up Category
- Style
- Description
- Total SO Qty
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Bestseller' > 'by Style Fabric Colour'
Extract this report to view your bestsellers by Style, Fabric, and Colour.
- Season
- Ac
- IS
- Size Category
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Style
- Fabric
- Colour
- Description
- Manufacturer
- Selected on SO
- Sales Order Quantity
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Bestseller' > 'by Style Fabric Colour Image'
Extract this report to view your bestsellers by Style, Fabric, and Colour with images.
- Season
- Ac
- IS
- Size Category
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Style
- Fabric
- Colour
- Description
- Manufacturer
- Selected on SO
- Sales Order Quantity
- Image Path
- Image
- Unit Cost (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Bestseller' > 'by Size Category/Markup'
Extract this report to view your bestsellers by Size Category and Mark up.
- Ac
- IS
- CS
- Size Category
- Mark Up Category
- Total SO Qty
- Total Value (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Full Product Inventory'
Extract this report for a full detailed product inventory summary.
- Season
- Ac
- IS
- ZM
- Product ID
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Style
- Fabric
- Colour
- Description
- Size Category
- Size
- Barcode
- Manufacturer
- Manufacturer Category
- Customs Type
- Textile Content
- MID Code
- Country of Origin
- HTS Code
- Intrastat Code
- Manufacturing Type
- Production Notes
- Labels
- WFX Markup
- Ccy Symbol
- Ccy
- Unit First/Make Cost
- Unit First/Make Cost (GBP)
- Unit RM Cost (GBP)
- Freight Cost (GBP)
- Import Duty Cost (GBP)
- Misc Cost (GBP)
- Unit Cost (GBP)
- WSP (GBP)
- RRP (GBP)
- Opening
- Opening Cost (GBP)
- Adjustments
- Sold
- Closed SO
- Production
- Production Stock Cost (GBP)
- Closed Production
- In Transit
- Received
- Received Cost (GBP)
- Allocated
- Pick Tickets
- DNs Unshipped
- DNs Shipped
- PT+DN Quantity
- Closing
- Closing Cost (GBP)
- Consignment
- Available
- Available (WIP)
- Projected
- Production (WIP)
- Stock Alert
- Stock Alert (Closing)
- Stock Alert (Projected)
- Moved To Another Season
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Product Inventory'
Extract this report for a product inventory summary. (Smaller version of the above report)
- Season
- Ac
- IS
- ZM
- Product Category 1
- Product Category 2
- Product Category 3
- Product Category 4
- Product Category 5
- Size Category
- Style
- Fabric
- Colour
- Description
- Size
- Barcode
- Manufacturer
- Manufacturer Category
- Opening
- Opening Cost (GBP)
- Adjustments
- Sold
- Closed SO
- Production
- Closed Production
- In Transit
- Received
- Received Cost (GBP)
- Allocated
- PT + DN Quantity
- Closing
- Closing Cost (GBP)
- Consignment
- Available
- Available (WIP)
- Projected
- Production (WIP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Product Inventory Essential'
Extract this report for an essential product inventory summary. (Essential version of the above reports)
- Season
- Ac
- IS
- ZM
- Style
- Fabric
- Colour
- Description
- Size
- Barcode
- Adjustments
- Sold
- Production
- In Transit
- Received
- Pick Tickets
- DNs Unshipped
- DNs Shipped
- Allocated
- PT + DN Quantity
- Closing
- Consignment
- Available
- Available (WIP)
- Projected
- Production (WIP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Product Inventory Basic'
Extract this report for a basic product inventory summary. (Basic version of the above reports)
- Season
- Style
- Fabric
- Colour
- Description
- Size
- Closing
- Available
- Available (WIP)
- Projected
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Product Inventory Value'
Extract this report to review the value of your product inventory.
- Season
- Ac
- IS
- ZM
- Style
- Fabric
- Colour
- Description
- Size
- Unit Cost (GBP)
- WSP (GBP)
- RRP (GBP)
- Opening
- Opening Cost (GBP)
- Adjustments
- Received
- Received Cost (GBP)
- Closing
- Closing Cost (GBP)
- Available
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Full Product Adjustments'
Extract this report for a summary of stock adjustments and essential information on the products adjusted.
- Season
- Ac
- IS
- Date Created
- Created By
- Date Modified
- Modified By
- Product ID
- Style
- Fabric
- Colour
- Description
- Size
- Barcode
- Method
- Adjustment Description
- Adjustment
- Unit Cost (GBP)
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Full Product Moved To Another Season Log'
Extract this report for a summary of product stock movement between the relevant seasons and essential information on the products moved.
- Season
- Product ID
- Style
- Fabric
- Colour
- Description
- Size
- Barcode
- User Date
- Username
- Log Description
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Full Product Opening Log'
Extract this report for a log on the opening products for the relative season.
- Season
- Product ID
- Style
- Fabric
- Colour
- Description
- Size
- Barcode
- User Date
- Username
- Log Description
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Production Required by Manufacturer'
Extract this report for a summary of production quantities required by manufacturer based on existing inventory.
If you work with a lot of 'carry forward' styles and have the inventory module. This would be of use to you.
- Season
- Ac
- ZM
- Product ID
- Description
- Size
- Opening
- Adjustments
- Production
- Closed Production
- Sold
- Closed SO
- Projected
- TemplateColumn
- TemplateColumn1
'Reports' > 'System Reports' > 'Products' > 'Inventory' > 'Production Listing'
Extract this report for a summary of Production units per product, per colour, per size, and the costs.
- Season
- Ac
- IS
- ZM
- Manufacturer
- Product ID
- Style
- Fabric
- Colour
- Size
- Production
- Unit Cost (GBP)
- Production Stock Cost (GBP)
- TemplateColumn
- TemplateColumn1
Reports can have columns hidden/moved, and filtered before extracting from Zedonk if needed.
You are also able to save custom reports. These reports can then be scheduled if required.
To add records from other seasons/ to view all records throughout your system, please reference the following Zedonkopedia chapter: