how can I cancel or delete gift voucher that I sent

[peter]

Hi,

Can anyone tell me how can I cancel or delete gift voucher that I sent to customer? Thanks

[lhotch]

I would like to know this as well. There doesnt seem to be a way to delete redeemed vouchers from the admin panel.

[fridgemags]

You must erase them directly from the database using PhpMyAdmin tool

When you view the tables in your oscommerce database you will see a table called "coupon_gv_que" open this table and you will see the gift vouchers in there. Find the ones that have been redeemed and erase them from the database.

You can pick up a handy tool called mySqlcc where you can manage your db from your desktop computer.

Find it at http://oscdox.com/modules.php?op=mod...load&cid=5

It is a very handy tool and I use it often.

hope this helps

[lhotch]

Thanks fridgemags. I was afraid that was the case and looked at that already. I have no problems running eventhe mysql client from an SSH connection, but I am setting this up for a friend who is not quite as computer literate as myself. Heck I would be happy with a "Delete all redeemed GV's" option. Perhaps I will just add the code to do that and add a button for him.

[peter]

fridgemags: I dont't see there is table called "coupon_gv_que" but I see "coupon_gv_queue" the data in that table doesn't look like the gift voucher code I need to delete. It shows the following:

unique_id customer_id order_id amount date_created ipaddr release_flag
1 2 7 10.0000 2003-07-29 13:05:52 68.3.210.157 Y
2 2 9 20.0000 2003-07-29 15:17:57 68.3.210.157 Y
3 2 9 8.3333 2003-08-31 04:13:28 64.166.208.164 Y

And of course I search around but still don't see the coupon code in any of the voucher related table. Does it mean we are using different version or I'm searching the wrong area? Thanks