Product Reports

 

Back Office > Reports > Products

 

Description

 

Nearly all of the Reports in SwiftPOS can be filtered by either a date range or data. The date range can either be selected from the drop down list of Periods or entered manually.

 


Reports

 

Report Name

ID

Sample

Report Description

Category Listing

PRD001

R

Reports on Product Categories. Lists Category # and Description, Points per Dollar value spend, F - Fractional, AA - Auto Add, I - Instruction, R - Restricted Purchase Category, NS - Non Sale, Print Group, Tax 1 checkbox, Web Link Category, Min/Max Order Qty and Products. This report can be sorted by Category # or Description.

Current Promotions

PRD002

R

Reports on current Product Promotions. Lists Promotion # and Description, Promo From/To Dates,  Cost Price (averaged when a range of Locations is selected), Promo Price, Promo Gross Profit %, Normal Price and Normal Gross Profit %. This report can be sorted by Product Description or Product Code. This report can also be grouped by Product Group.

Discontinued Products

PRD003

R

Reports all Discontinued Products grouped by Product Group. Lists Product Group # and Description, Product Code and Description, Price and Date/Time Last Sold. This report can be sorted by Product Description or Product Code.

Happy Hour

PRD004

R

Reports on all Happy Hour Products. Lists Happy Hour Description, Days active and Start/End times, PLU # and Description, Cost Price (averaged when a range of Locations is selected), Happy Hour Price, Happy Hour Gross Profit %, Normal Price, Normal Gross Profit %, Category # and Bonus Points. This report can be sorted by Product Description or PLU #.

Inactive Discontinued Keyboard Products

PRD005

R

Reports on all Inactive/Discontinued Products that are still assigned to Keyboards, grouped by Keyboard. Lists Keyboard Name, Layout Name, Key Position, POS Key Caption, Product Code and Description and Inactive/Discontinued indicators. This report can be sorted by Product Description or Product Code.

Inactive Keyboard Products by Location

PRD020

R

Reports on all Products by Location that are inactive in the Location but assigned to Keyboards. Lists Location # and Description, Keyboard Name, Layout Name, Key Postion, POS Key Caption, Product Code and Description. This report can be sorted by Product Description or Product Code.

Inactive Products

PRD006

R

Reports on all Inactive Products, grouped by Product Group. Lists Product Group # and Description, Product Code and Description, Price and Date/Time Last Sold. This report can be sorted by Product Description or Product Code.

Price List by Location

PRD011

R

Reports on Product prices for a specific Location, grouped by Product Group. Lists Product Group # and Description, PLU # and Description, Cost Price, Prev Cost Price and the Price and Gross Profit % of the 10 Price Levels. This report can be sorted by Product Description or PLU #.

Price List with Stock on Hand

PRD012

R R

Reports on Stock on Hand and Price information for stocked items, grouped by Location and Master Group/Product Group. Lists Location, Product, Barcode, Size, Active status, Case Qty, Preferred Supplier, Draw From Location, Re-order Qtys (in units), SOH (Stock on Hand), Sell Price for the selected Price Level, Cost Price, Gross Profit % and Margin (Gross Profit $ value). This report can be sorted by Product Description or Product Code/PLU.

Product Draw from Exception

PRD013

R

Reports on Products that draw their stock from a Location other than their own, grouped by Product Group. Lists Product Group # and Description, PLU # and Description, Current Location # and Description and Draw From Location # and Description. This report can be sorted by Product Description or PLU #.

Product Edit List by Category

PRD014

R

Reports on all Products currently flagged as Active, grouped by Location and then Category. Lists Location # and Description, Category # and Description, Loyalty Points / $ Value, Fractional/Auto Add/Instruction/Restricted Purchase/Non Sale Category checkboxes, Print Group Heading, Tax1/2 checkboxes, Product Code and Description, Product Group # and Description, PLU #, Cost Price, Price Levels 1 to 4 and Recipe Item indicator. This report can be sorted by Product Code, PLU # or Product Description.

Product Group Listing

PRD015

R

Reports on all Product Groups and Master Groups. The Product Groups section of the report lists Product Group # and Description, Count (No. of Products assigned to the Product Group) and the Master Group # and Description the Product Group is assigned to. The Master Groups section of the report lists Master Group # and Description, Count (No. of Products assigned to the Master Group) and the Product Group #s and Descriptions assigned to the Master Group.

Products by Family Listing

PRD021

D S

Products by Family Listing reports on all Products assigned to selected Families, grouped by Location. Ensure the Show Detail option is selected. Lists the Location # and Description, Family ID and Description, Include in Barrel Draw indicator and the Web Family indicator. Also lists the Product Code and Description, PLU #, Product Group # and Description, Cost Price, Price Levels 1 to 4 and the Recipe Indicator. The report can be sorted by Product Code, PLU or Product Description.

 

Family Listing reports on selected Families. Ensure the Show Detail option is NOT selected. Lists the Family ID and Description, Include in Barrel Draw indicator and the Web Family indicator.

Products With No Barcode

PRD016

R

Reports on all Products With No Barcode, grouped by Product Group. Lists Product Code and Description, and PLU #. This report can be sorted by Product Description or Product Code.

Promotion Buy Period

PRD017

R

Reports on Products in Promotions, grouped by Product Group. Lists Product Code and Description, Promo Days Left, Buy Period Days Left, Avg Weekly Sales, Avg Weekly Sales, Avg Max Qty, Total On Hand, Reorder Qty and Reorder Value. This report can be sorted by Product Description or Product Code.

Promotions

PRD018

R

Reports on Products in Promotions, grouped by Promotion and then Price Level. Lists Promotion Description, Price Level Description, Product Code and Description,  Cost Price (averaged when a range of Locations is selected),  Promo Price, Promo Gross Profit %, Normal Price and Normal Gross Profit %. This report can be sorted by Product Description or Product Code. This report can also be grouped by Product Group.

Unused PLU Numbers

PRD019

R

Reports on Unused PLU Numbers.

 


Import Promotions Reports

 

Report Name

ID

Sample

Report Description

Unmatched Products

SPRM001

R

Reports on Products that were not able to be matched using the selected Matching field. Lists the Promotion, Start/End Date/Times, Start/End Buy Period, Barcode/Product Code, Description and Promotion Price.

 


Wholesale Discount Reports

 

These reports can be generated from here.

 

Report Name

ID

Sample

Report Description

Wholesale Discount List

PRD022

R

Reports on Wholesale Discounts/Rebates configured to date. Lists the Product, Description, Enabled status, Contract Start/End Date, Discount Type, Value, Rebate Type and Value.

Wholesale Discount Price List

PRD023

R R

Reports on Wholesale Discount Prices by the selected Account and grouped by either Master Group or Product Group. Lists the Account, Master/Product Group, Product and the first 4 Price Levels.

 


Related Topics

 

  1. Products
  2. Reports