Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Coupons New coupons can be imported into your CheckoutChamp campaigns via a CSV file which . This can help streamline your setup.
To import a CSV with coupons, navigate
Navigate to Admin → Import and then select the “Import Import New Coupons” option Coupons from the Import Type dropdown selector.
After you select “Import New Coupons” click

...


Click on the blue Download Example File link. This will download a file onto your computer which will show you how the file must be mapped.

Note

File headers must be the exact header that is shown on the example file.

That downloadable file is also posted below:

...

Expand
titleExpand for details about each header title

Field

Type

Description

Required

couponCode

String (max: 20 chars)

coupon the code for the newly created coupon

Y

campaignId

Integer

Id of the campaign the coupon should apply to

Y

applyTo

ENUM('BASE';'SHIPPING')BASE or SHIPPING or BOTH

specify if the coupon should apply to base price or shipping or both

Y

singleUse

Boolean (0 or 1)

should this be a single use coupon?

N

oneTimeCoupon

Boolean (0 or 1)

should this be a one time coupon?

N

isRecurring

Boolean (0 or 1)

is this a recurring coupon?

N

discountType

ENUM('FLAT';'PERCENT')FLAT or PERCENT

specify if the coupon should be a flat discount or percentage discount

Y

defaultCoupon

Boolean (0 or 1)

specify if this coupon should always be applied, even if a customer does not enter it in

N

productId

String (max 100 chars)

comma-separated list of campaign product Ids that the coupon will apply to (omit if applying to whole order)

N (Y if passing isRecurring=1)

productTags

String (max 100 chars)

comma-separated list of product tags that the coupon will apply to (omit if applying to whole order)

N

discount

Decimal

coupon discount amount

Y (N if passing isRecurring=1)

maxCycles

Integer

How many billing cycles should the coupon be valid for?

N (only applicable for recurring coupons)

recurringDiscount

Decimal

discount amount for recurring coupons

N (Y if passing isRecurring=1)

startDate

Date (mm/dd/yyyy)

the date on which to begin accepting the coupon

N

endDate

Date (mm/dd/yyyy)

the expiration date of the coupon

N

ruleTypestartValue

AMOUNT or QUANTITY or BUY_X_GET_Y_AMT or BUY_X_GET_Y_QTY

The type of coupon rule

Y

startValue1

Integer

the first quantity at which the coupon rule should start applying

Y (if QUANTITY or BUY_X_GET_Y_QTY)

endValue1

Integer

the beginning value in which the coupon should activate

N (Y if passing

endValue

Integer

the ending value in which the coupon should activate

N (Y if passing

ruleDiscount

product

Integer

productQty

Integer

...

first quantity at which the coupon rule should stop applying

Y (if QUANTITY or BUY_X_GET_Y_QTY)

discount1

Decimal

the first discount to give for this rule

product1

Integer

For Buy X Get Y discounts, the first product that should be discounted

Y (if QUANTITY or BUY_X_GET_Y_QTY)

productQty1

Integer

For Buy X Get Y discounts, the first product quantity that should be discounted

Y (if QUANTITY or BUY_X_GET_Y_QTY)

startValue2

Integer

the second quantity at which the coupon rule should start applying

Y (if QUANTITY or BUY_X_GET_Y_QTY)

endValue2

Integer

the second quantity at which the coupon rule should stop applying

Y (if QUANTITY or BUY_X_GET_Y_QTY)

discount2

Decimal

the second discount to give for this rule

product2

Integer

For Buy X Get Y discounts, the second product that should be discounted

Y (if QUANTITY or BUY_X_GET_Y_QTY)

productQty2

Integer

For Buy X Get Y discounts, the second product quantity that should be discounted

Y (if QUANTITY or BUY_X_GET_Y_QTY)

startValue3

Integer

the third quantity at which the coupon rule should start applying

Y (if QUANTITY or BUY_X_GET_Y_QTY)

endValue3

Integer

the third quantity at which the coupon rule should stop applying

Y (if QUANTITY or BUY_X_GET_Y_QTY)

discount3

Decimal

the third discount to give for this rule

product3

Integer

For Buy X Get Y discounts, the third product that should be discounted

Y (if QUANTITY or BUY_X_GET_Y_QTY)

productQty3

Integer

For Buy X Get Y discounts, the third product quantity that should be discounted

Y (if QUANTITY or BUY_X_GET_Y_QTY)

Once the CSV file is complete with all the new coupons, click the green Upload CVS Data File button and select . Select the appropriate CSV file from your computer.

The bottom portion of the Import page shows you the Pending and Completed uploads and . It will also show you if there were any errors on the import.

...