Groupons

Groupons are commonly used, but to use them with CCS you will have to have a clear picture of what you are going to be offering with them.

Senarios:

Spend up to 10 dollars on anything at one visit:

This would be typically applied as a cash based coupon.

Spend up to 10 dollars on anything, but not all on one visit.

This would be applied by importing the Groupon list into the Gift Certificate section of CCS. You will receive this file from the Groupon company. You will need the file with columns in this format. Once you import this file you would use the groupon as a gift certificate when applying payment to the order. The groupon would stay in the system and provide a balance of the remaining amount each time the customer made a purchase.

Value,PurchaseDate,CardNumber,CardNumber

Example:

Value,PurchaseDate,CardNumber,CardNumber
$5.00,10/20/2010,1383191,1383191
$5.00,10/20/2010,1383192,1383192
etc…

Save the file as a csv file (comma delimited) to your desktop (groupon.csv). You can use Excel or other spreadsheet programs to setup and save this file.

Back up your database next!

From the Office go to - CRM - Gift Cards/Gift Certificate and Store Credit.

From the Gift Card / Certificate window, select View - Import from File. Locate the file from your desktop and import.

Review the import and verify the file was uploaded correctly.

Then start a new order, place items on it, go to the payment screen and apply a payment through the gift certificate payment using a groupon number.

Trace: • groupons