AwoCoupon » Imports

Import
The import feature allows the user to import multiple coupons by uploading a csv file.

A sample of the file is displayed at the bottom of the screen. Each row represents one coupon. Capitalization of letters is irrelevant.
Field Values:
  • ID - must be unique per coupon
  • Coupon Code - can have up to 32 alphanumeric characters and must be unique per coupon
  • Published - published or unpublished
  • Function Type - coupon or gift certificate, shipping, buy x get y, or parent
  • Percent or Amount - percent or amount
  • Discount Type - overall or specific
  • Value - a number or leave blank if using Value definition field
  • Value Definition
  • Number of uses
    • first column needs to be set to either total, per customer, or left blank
    • second column requires a number (if the first column has been populated)
  • Minimum Value
    • first column needs to be set to either overall, specific, or left blank
    • second column requires a number (if the first column has been populated)
  • Start Date - date in YYYYMMDD format, or left blank if no start date
  • Expiration - date in YYYYMMDD format, or left blank if no expiration date
  • Customer
    • [first column] Customer Type - customer or shopper group
    • [second column] (mode): include or exclude the asset
    • [third column]
      • for customer enter the user IDs seperated by a comma
      • for shopper group enter the shopper group IDs seperated by comma
  • Asset 1
    • first column (type): product, category, vendor, manufacturer, shipping
    • second column (mode): include or exclude the asset
    • third column (number): the number of assets (only used by Buy X get Y)
    • fourth column: comma separated IDs of the asset
  • Asset 2
    • first column (type): product, category, vendor, manufacturer, shipping
    • second column (mode): include or exclude the asset
    • third column (number): the number of assets (only used by Buy X get Y)
    • fourth column: comma separated IDs of the asset
  • Exclude Products on Special - valid values include 'Yes', 'No' or leave blank. If left blank, no is assumed
  • Exclude Gift Certificate Products- valid values include 'Yes', 'No' or leave blank. If left blank, no is assumed
  • Admin note - a note about the coupon or leave blank
  • Process Type - used by Parent and Buy X Get Y coupons
    • for parent: first, lowest, highest, all, allonly
    • for buy x get y: first, lowest, highest
  • Maximum Discount Qty - only used by Buy X get Y to set the maximum number of discounts
  • Do not Mix Products - only used by Buy X get Y to make sure buy x product matches get y product in cart
  • Automatically add to cart "Get Y" product - only used by Buy X get Y to add get y product into cart automatically
  • ID - must be unique per coupon
  • Coupon Code - can have up to 32 alphanumeric characters and must be unique per coupon
  • Published - published or unpublished
  • Function Type - coupon or gift certificate, shipping, buy x get y, or parent
  • Percent or Amount - percent or amount
  • Discount Type - overall or specific
  • Value - a number or leave blank if using Value definition field
  • Value Definition
  • Number of uses (Total) - total numer of time the coupon can be used
  • Number of uses (Per customer) - number of times each customer can use the coupon
  • Minimum Value
    • first column needs to be set to either overall, specific, or left blank
    • second column requires a number (if the first column has been populated)
  • Start Date - date in YYYYMMDD format, or left blank if no start date
  • Expiration - date in YYYYMMDD format, or left blank if no expiration date
  • Customer
    • [first column] Customer Type - customer or shopper group
    • [second column]
      • for customer enter the user IDs seperated by a comma
      • for shopper group enter the shopper group IDs seperated by comma
  • Asset 1
    • first column (type): product, category, vendor, manufacturer, shipping
    • second column (mode): include or exclude the asset
    • third column (number): the number of assets (only used by Buy X get Y)
    • fourth column: comma separated IDs of the asset
  • Asset 2
    • first column (type): product, category, vendor, manufacturer, shipping
    • second column (mode): include or exclude the asset
    • third column (number): the number of assets (only used by Buy X get Y)
    • fourth column: comma separated IDs of the asset
  • Exclude Products on Special - valid values include 'Yes', 'No' or leave blank. If left blank, no is assumed
  • Exclude Gift Certificate Products- valid values include 'Yes', 'No' or leave blank. If left blank, no is assumed
  • Description - a note about the coupon or leave blank
  • Process Type - used by Parent and Buy X Get Y coupons
    • for parent: first, lowest, highest, all, allonly
    • for buy x get y: first, lowest, highest
  • Maximum Discount Qty - only used by Buy X get Y to set the maximum number of discounts
  • Do not Mix Products - only used by Buy X get Y to make sure buy x product matches get y product in cart
  • Automatically add to cart "Get Y" product - only used by Buy X get Y to add get y product into cart automatically
Before uploading the file, there are 2 options to consider.
- Exclude the First Row: select the checkbox if you have a header row
- Even with errors in the batch, Save coupons with no errors: This options is a mare choice of preference as some users prefer to fix errors and re-upload the whole file while others prefer to re-upload the corrected rows only. Checking the box will save any coupons that do not have errors and unchecking the box will save all coupons only if there are no errors.

To upload the csv file click the browse button, open your csv file and click the "Upload" button in the upper right corner. Any errors will be clearly displayed on the screen, and you will be notified of any savings.
You can view the successfully imported coupons in the Coupons screen.