Importing Gift Cards from RMS

If you'd like to import your gift card data from Microsoft RMS when you're also using RITE Gift, here's how you can do it:

1.  Use this query to fetch gift card data:
select CardNumber as Code, Balance, 'St.Cloud' as OriginStore, DateCreated, LastUpdated from RITE_GiftCards

Adjust the OriginStore as needed.  It MUST match the description of a location in Cloud Retailer for the import to work properly.

2.  Import the data into an Excel spreadsheet like so:
http://screencast.com/t/bWCbVqqKYrh

3.  Use the import function on the Tools tab to import the gift card data.  Easy.. :)
Comments