815
We currently have a global gift card solution with thousands of gift cards out in circulation but would like to switch over to the Global Voucher solution that came with RMS Feature Pack 1. Does anyone know of a way to get our current card numbers and balances into the system?
*This post is locked for comments
Hey Krista,
The global voucher data is stored in the headquarters database in the voucher and voucheronline tables. I think your best bet would be to set up global vouchers as if you were doing a new implementation, then export your old data into a csv file, perform a bulk insert into a temporary table, and then transfer the information from there into the two respective tables. This will take a little bit of SQL know-how to pull off.
I will caution, though, that my experience with the global vouchers function hasn't been the greatest. The major sticking point for me is that (as far as I've been able to find) it does not support partial authorization and will simply say "insufficient funds" if the purchase amount exceeds the balance on the card. Instead, you have to look up the balance on the card (ctrl+shift+F3, check balance, scan the card), back out of the balance check window, enter the tender window, manually type in the current balance in the gift card space, and then type the amount of money paid in an alternate tender into the appropriate blank.
If your current solution has more functionality than this, it may be worth it to just stick with what you have.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (