Home Page link  

Gift Cards Implementation

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Gift Cards Implementation dan 06-23-2007
Posted by dan on June 23, 2007, 7:15 pm
Please log in for more thread options
Hi.
I need advice on how to travel here please. I have 10 stores and an HQ
setup. I want to implement a gift card that is barcoded.
Here is what I envision:

1) All barcodes of giftcards are in the system and they have a dollar value
against them.
2) Gift card is then scanned and made active somehow at the POS ??????
(How?)
3) Money received goes to a common enterprise account and z-report is
modified to remove reporting of gift cards as this money does NOT belong to
the store.
4) Profit Margin report is reworked to remove seeing sales of gift cards as
the sale will stuff up the profit margin
5) Customer redeems the gift card at one of the stores and this is what
becomes the real sale. IE, gift card value is deducted from the sale amount
as a line item on the POS. (How do I get the system to deduct the gift card
amount?)

Your help and views in this scenario will go a long way for me. I would like
to try and avoid 3rd party add ons if possible. (The system is fragile
enough as it is).

Regards

Dan



Posted by Akber Alwani on June 24, 2007, 12:49 am
Please log in for more thread options
HI Dan,
Here are the answers to your query.

1. you can create an item in POS/RMS as Voucher and name it GC (Gift Card)
2. Then go to Serial Tab of Item and Create your already created barcode as
serial No. (click add button to add it)
3. You will not defined the pricing at this stage.
4. GO to POS and enter the item GC then the system will ask you the serial
No which is your barcode now, you can scan or manually enter the SKu #.
5. System will ask you now the price on the Gift Card enter the value
according to the card i.e 50.00, 100.00, 200.00
6. Received the money from customer by press F12 of tender screen and
perform the normal money receiving procedure.
7. Alter your reports not to capture GC sale (you can do this using notepad
and modfiy the .grp file let me know one report so I can email you the filter
criteria just giving you an example:
(select xxxx from [Transaction] Inner Join TransactionEntry
on [Transaction].TransactionNumber=TransactionEntry.TransactionNumber
Inner Join Item on TransactionEntry.Itemid=Item.ID
WHERE Item.ItemType<>9) This query can be write in more better way i just
give you an example

How to do redeem.
1. Make sure you have created the tender type "Voucher" and name it
anything, and have run the "Z" out.
1. On POS sell any item,
2. Now at the time of payment customer present you the gift card as redeem
which purchase from any store.
3. On the Tender Screen, select the tender type as Gift Card/Voucher
4. Once you select the Tender Type as Gift Card (created ealier as tender)
then it will ask you the Voucher No, scan the barcode or enter the barcode of
the gift card.
The system automatically reduce the balance, if the amount is greater than
the gift card value system give you warning and only take whatever balance in
the GC.

Hope you will like this proceudre and rate me.

"dan" wrote:

> Hi.
> I need advice on how to travel here please. I have 10 stores and an HQ
> setup. I want to implement a gift card that is barcoded.
> Here is what I envision:
>
> 1) All barcodes of giftcards are in the system and they have a dollar value
> against them.
> 2) Gift card is then scanned and made active somehow at the POS ??????
> (How?)
> 3) Money received goes to a common enterprise account and z-report is
> modified to remove reporting of gift cards as this money does NOT belong to
> the store.
> 4) Profit Margin report is reworked to remove seeing sales of gift cards as
> the sale will stuff up the profit margin
> 5) Customer redeems the gift card at one of the stores and this is what
> becomes the real sale. IE, gift card value is deducted from the sale amount
> as a line item on the POS. (How do I get the system to deduct the gift card
> amount?)
>
> Your help and views in this scenario will go a long way for me. I would like
> to try and avoid 3rd party add ons if possible. (The system is fragile
> enough as it is).
>
> Regards
>
> Dan
>
>
>

Posted by dan on June 24, 2007, 6:00 pm
Please log in for more thread options
Hi Akber,
Thanks for this. I will give it a go and post the result.
BTW, does the voucher that I create below go from HQ to all stores so all
stores know that this particular gift card/voucher has been (or not)
allocated and also when the card has been redeemed so it does not get
redeemed twice?
Cheers
Dan

> HI Dan,
> Here are the answers to your query.
>
> 1. you can create an item in POS/RMS as Voucher and name it GC (Gift Card)
> 2. Then go to Serial Tab of Item and Create your already created barcode
> as
> serial No. (click add button to add it)
> 3. You will not defined the pricing at this stage.
> 4. GO to POS and enter the item GC then the system will ask you the serial
> No which is your barcode now, you can scan or manually enter the SKu #.
> 5. System will ask you now the price on the Gift Card enter the value
> according to the card i.e 50.00, 100.00, 200.00
> 6. Received the money from customer by press F12 of tender screen and
> perform the normal money receiving procedure.
> 7. Alter your reports not to capture GC sale (you can do this using
> notepad
> and modfiy the .grp file let me know one report so I can email you the
> filter
> criteria just giving you an example:
> (select xxxx from [Transaction] Inner Join TransactionEntry
> on [Transaction].TransactionNumber=TransactionEntry.TransactionNumber
> Inner Join Item on TransactionEntry.Itemid=Item.ID
> WHERE Item.ItemType<>9) This query can be write in more better way i just
> give you an example
>
> How to do redeem.
> 1. Make sure you have created the tender type "Voucher" and name it
> anything, and have run the "Z" out.
> 1. On POS sell any item,
> 2. Now at the time of payment customer present you the gift card as redeem
> which purchase from any store.
> 3. On the Tender Screen, select the tender type as Gift Card/Voucher
> 4. Once you select the Tender Type as Gift Card (created ealier as tender)
> then it will ask you the Voucher No, scan the barcode or enter the barcode
> of
> the gift card.
> The system automatically reduce the balance, if the amount is greater than
> the gift card value system give you warning and only take whatever balance
> in
> the GC.
>
> Hope you will like this proceudre and rate me.
>
> "dan" wrote:
>
>> Hi.
>> I need advice on how to travel here please. I have 10 stores and an HQ
>> setup. I want to implement a gift card that is barcoded.
>> Here is what I envision:
>>
>> 1) All barcodes of giftcards are in the system and they have a dollar
>> value
>> against them.
>> 2) Gift card is then scanned and made active somehow at the POS ??????
>> (How?)
>> 3) Money received goes to a common enterprise account and z-report is
>> modified to remove reporting of gift cards as this money does NOT belong
>> to
>> the store.
>> 4) Profit Margin report is reworked to remove seeing sales of gift cards
>> as
>> the sale will stuff up the profit margin
>> 5) Customer redeems the gift card at one of the stores and this is what
>> becomes the real sale. IE, gift card value is deducted from the sale
>> amount
>> as a line item on the POS. (How do I get the system to deduct the gift
>> card
>> amount?)
>>
>> Your help and views in this scenario will go a long way for me. I would
>> like
>> to try and avoid 3rd party add ons if possible. (The system is fragile
>> enough as it is).
>>
>> Regards
>>
>> Dan
>>
>>
>>



Posted by Glenn Adams [MVP - Retail Mgmt on June 25, 2007, 9:53 am
Please log in for more thread options
No, it doesn't. You can't do multi-location vouchers without an Add-in.
Retail Realm has an add-in to enable global vouchers and there may be
others out there as well. Personally, I think a gift card solution run
through an external provider like Mercury Payments or GiveX is a better
solution.

Glenn Adams
Tiber Creek Consulting
http://www.tibercreek.com
glenn@tibercreek.com
----------------------------------------------
Please DO NOT respond to me directly but post all responses here in the
newsgroup so that all can share the information.


dan wrote:
> Hi Akber,
> Thanks for this. I will give it a go and post the result.
> BTW, does the voucher that I create below go from HQ to all stores so all
> stores know that this particular gift card/voucher has been (or not)
> allocated and also when the card has been redeemed so it does not get
> redeemed twice?
> Cheers
> Dan
>
>> HI Dan,
>> Here are the answers to your query.
>>
>> 1. you can create an item in POS/RMS as Voucher and name it GC (Gift Card)
>> 2. Then go to Serial Tab of Item and Create your already created barcode
>> as
>> serial No. (click add button to add it)
>> 3. You will not defined the pricing at this stage.
>> 4. GO to POS and enter the item GC then the system will ask you the serial
>> No which is your barcode now, you can scan or manually enter the SKu #.
>> 5. System will ask you now the price on the Gift Card enter the value
>> according to the card i.e 50.00, 100.00, 200.00
>> 6. Received the money from customer by press F12 of tender screen and
>> perform the normal money receiving procedure.
>> 7. Alter your reports not to capture GC sale (you can do this using
>> notepad
>> and modfiy the .grp file let me know one report so I can email you the
>> filter
>> criteria just giving you an example:
>> (select xxxx from [Transaction] Inner Join TransactionEntry
>> on [Transaction].TransactionNumber=TransactionEntry.TransactionNumber
>> Inner Join Item on TransactionEntry.Itemid=Item.ID
>> WHERE Item.ItemType<>9) This query can be write in more better way i just
>> give you an example
>>
>> How to do redeem.
>> 1. Make sure you have created the tender type "Voucher" and name it
>> anything, and have run the "Z" out.
>> 1. On POS sell any item,
>> 2. Now at the time of payment customer present you the gift card as redeem
>> which purchase from any store.
>> 3. On the Tender Screen, select the tender type as Gift Card/Voucher
>> 4. Once you select the Tender Type as Gift Card (created ealier as tender)
>> then it will ask you the Voucher No, scan the barcode or enter the barcode
>> of
>> the gift card.
>> The system automatically reduce the balance, if the amount is greater than
>> the gift card value system give you warning and only take whatever balance
>> in
>> the GC.
>>
>> Hope you will like this proceudre and rate me.
>>
>> "dan" wrote:
>>
>>> Hi.
>>> I need advice on how to travel here please. I have 10 stores and an HQ
>>> setup. I want to implement a gift card that is barcoded.
>>> Here is what I envision:
>>>
>>> 1) All barcodes of giftcards are in the system and they have a dollar
>>> value
>>> against them.
>>> 2) Gift card is then scanned and made active somehow at the POS ??????
>>> (How?)
>>> 3) Money received goes to a common enterprise account and z-report is
>>> modified to remove reporting of gift cards as this money does NOT belong
>>> to
>>> the store.
>>> 4) Profit Margin report is reworked to remove seeing sales of gift cards
>>> as
>>> the sale will stuff up the profit margin
>>> 5) Customer redeems the gift card at one of the stores and this is what
>>> becomes the real sale. IE, gift card value is deducted from the sale
>>> amount
>>> as a line item on the POS. (How do I get the system to deduct the gift
>>> card
>>> amount?)
>>>
>>> Your help and views in this scenario will go a long way for me. I would
>>> like
>>> to try and avoid 3rd party add ons if possible. (The system is fragile
>>> enough as it is).
>>>
>>> Regards
>>>
>>> Dan
>>>
>>>
>>>
>
>

Similar ThreadsPosted
Gift cards/over tendering Credit Cards/ Reload Vouchers November 22, 2005, 4:32 pm
Gift Cards or Rewards Cards November 20, 2005, 2:08 pm
Gift Cards September 12, 2005, 4:16 pm
Gift Cards- October 3, 2005, 11:06 am
Gift Cards October 3, 2005, 4:13 pm
mag gift cards January 26, 2006, 1:12 pm
Gift Cards for MS-POS April 24, 2006, 6:31 pm
Gift Cards for MS-POS July 23, 2006, 2:00 am
Gift Cards August 1, 2006, 3:17 pm
Gift Cards November 7, 2006, 1:22 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap