This is an old revision of the document!

---

====== Import Gift Cards & Groupons ====== To import lists of Gift Cards or Groupons you will need the file in CSV Format. CSV Files can be downloaded from the provider of your gift cards or groupons, or you can make them in Excel, and then save the Excel file in CSV format. ===== Setup ===== There are specific columns that need to be filled, and formated. The follow is the order and data type for each column ||Gift Card Columns|Data Type| |Card / Groupon Value|Number| |Purchase Date| Date| |Gift Card Number|Number| |Gift Card Track Data|Text| Example Report: |Card Value|Date|Gift Card # | Gift Card Track Data| |$3.00|01/01/2010|18194|18194| |$10.00|01/02/2010|18193|18193| |$25.00|01/02/2010|18194|18194| ==== Import ==== To import this list you have saved, go to the Office Toolbar, then 'CRM - Gift Cards/ Certificates Store Credit' From the toolbar of the gift card window: View - Import from File. Locate the csv file, it will then import. You can confirm it has imported by looking up numbers on the gift card list, select 'View - All'.