CCS Point of Sale

Groupons and Tracking Groupon Campaigns

To setup a groupon, you can use the discounts video to setup your preferred discount method.

Discount video

Once you setup the discount, make sure the item has 'Requires Serial' checked off in the item info options.

Requires - 3.15.54Q and above.

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 ProductName='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.


Navigation

^From the Ground Up!| |[[Getting Started:]]| |[[Installation Guide:]]| |[[Pre Installation:]]| |[[Install CCS:]]| |[[Install New Database:]]| ^Guides| |[[Guides:]]| |[[FAQ:]]| |[[Trouble Shooting:]]| ^Credit Card Setup| |[[Data Cap Epay:]]| ^CCS Administration| |[[ Office:Office - General Management]]| ^CCS Terminal| |[[Office:Terminal]]| ^Hand Held Setup| |[[Hand Held:|Tablet]]| ^Kitchen Display| |[[KDS Software Setup:]]|