CCS Point of Sale
This is an old revision of the document!
====== Groupons and Tracking Groupon Campaigns ====== To setup a groupon, you can use the discounts video. Once you setup the discount, make sure the item has 'Requires Serial' checked off in the item info options. ===== Reporting ===== You can do a custom report to track the Groupon Campaign. Office => Main Toolbar => Reporting => Pivot Reporting => Advanced Tab Use this SQL Statement to setup your report: SELECT DisplayTotal as TotalOfOrder,Serial,UnitPrice FROM tblProductOrderDetails WHERE ProdcutName='Input Your Groupon ProductName' You can then open the report and get the results, the serial numbers. The total spend on the order, the serial number and the amount of the discount.
Trace: • groupons