Redeem Coupon Manager Codes Using Data Loader

You can use Data Loader to redeem Coupon Manager codes.

About this task

In order to use this Data Loader import, you must also have the Coupon Manager app. When you use the Redeem Coupon Codes import, you can also update order data related to the order the coupon code was used for.

To redeem codes:

Procedure

  1. Go to Settings > Data Loader.
  2. Click Create Import.
  3. Enter the relevant information in the Create Import Job window.
    1. Enter a name for the import in the Name box.
    2. Enter a description for the import in the Description box.

      The description is a good way to distinguish between similar imports.

    3. Select Redeem Codes from the Type list.
    4. Click Create Import Job.
  4. Click Upload Sample File To Begin Mapping to map the categories in your file to fields in Bronto.

    This let's Bronto know how to appropriately manage your data as it is imported.

  5. In the Upload Sample File window, select the delimiter used in your file from the Delimiter list.
    The delimiter is the character that is used to offset, or indicate, unique pieces of information in your file. For example, if there is a comma between the fields in your file, then your file uses a comma as a delimiter. Data Loader supports:
    • Pipes |
    • Commas ,
    • Semicolons ;
    • Tabs
  6. If you have not transferred your file to the server, upload the file as a sample file so you can use it to complete the import mapping:
    1. In the Upload Sample File window, select Upload a file.
    2. Select your file from the Files list.
    3. Click Upload Sample File.

    If the file upload is successful, the mapping page will be displayed. This does not upload the file to the FTP server or import the data into Bronto. You will still need to complete a file transfer and configure your import for that to occur.

  7. If you have transferred a file to the server that you want to map data for:
    1. In the Upload Sample File window, select Select one of the files in your account.
    2. Click Choose File, select your file in the finder window, then click Open.
    3. Click Upload Sample File.

    If the file upload is successful, the mapping page will be displayed.

  8. On the mapping page, map the values in the file by selecting a value from the Mapped to list.

    Make sure you map the Coupon Code to the coupon code in the file and map other order details as appropriate. At a minimum you must map a coupon code and an email address.

  9. On the Configuration tab in the General area, configure the general settings for your import:
    1. Select Yes or No in the Skip First Row Header list.
    2. Select 30 days or 3 days from the Cleanup Schedule list.

      This determines if you want the files to persist on our servers for the minimum of 3 days or the maximum of 30 days.

    3. Select the method you want Bronto to use for filename matching from the Filename Matching Scheme list
      • Ends with will match files based on the extension specified for the Filename Matching Pattern. Only use Ends with when this your only import that uses this file type and you are only submitting one type of file for this import. If you have multiple Data Loader import jobs and want the file extension taken into consideration, Custom Glob is the best choice.
      • Starts with will match files based on the characters specified for the Filename Matching Pattern starting with the first character. For example, if you have contact for the Filename Matching Pattern then all files on the FTP server that start with the word contact will attempt to be imported.
      • Custom Glob will match files based on the characters and the extension specified for the Filename Matching Pattern. This allows you to use wildcards in order to build more complex import queries.
    4. Enter a full or partial filename in the Filename Matching Pattern box.

      This is used in conjunction with the Filename Matching Scheme to recognize what files on the FTP server should be imported using this import job. If you use the Custom Glob option for Filename Matching Scheme you can use wildcards. Make sure the information you include here is specific enough that the import job won't attempt to import files on your FTP server location that are intended for other import jobs you may have configured. But also keep the filename general enough that the import will be able to import multiple files with slightly different names if your import requires using multiple files.

    5. If you want to receive an email notification when your imports complete, enter an email address in the Confirmation Email box.

      The notification email contains high-level information about the import and includes a link to download a run log that contains any errors the import may have.

  10. In the Expected Data Format area, configure how you want the data in your file to be managed as it is imported:
    1. Select a delimiter from the Delimiter list.
    2. If you plan to import date-based data, click the calendar icon under Date Format and fill in the options in the Date Format Builder window.

      You must map a date-based field before you can configure Date Format. In the Date Format Builder, select a data from the Example Date & Time list, click Go, then click on each number in the date to select whether it is a Day, Month, or Year, and then click Done.

    3. Select a currency type from the Locale list.

      The currency should match the Locale setting you have set for your Bronto account. For more information see Formatting Settings.

  11. In the Bronto Settings area, enter the list name in the Add Contacts to Specified Lists box if you want to add contacts to a list as they are imported.
  12. When you have finished import configuration, click Save & Close.
  13. If you haven't already, Transfer Your Files to the FTP Server.
  14. Find the import you just configured and Perform a Test Run to ensure that the files are valid.

    Based on the results of the test run, fix any issues as necessary.