Thread: Adding Batch of New Gift Cards

Is there a way to import a batch of new gift cards from an excel file? I have about 300 voucher codes to enter and can't see a way to do it in an automated fashion.

In the coupon.zip file is coupon.xls. It has all the columns of the coupon table (ML8.0.1.2). The last column is a formula used to create insert statements using just the basic information for creating new coupon records.

The examples are:

Code:

INSERT INTO Coupon (CouponCode,ExpirationDate,DiscountPercent,CouponType) VALUES ('test', getdate()+365,1,0)
INSERT INTO Coupon (CouponCode,ExpirationDate,DiscountPercent,CouponType) VALUES ('test2', getdate()+365,2.5,1)

The first called 'test' is a coupon which expires this time next year, has a discount value of 1% (I'm generous ) and applies to the order subtotal (coupontype=0).

The second is called 'test2', also expires in 365 days, has a discount value of 2.5%, and is applied to specific products, though I haven't named them.

You would need to expand/extend the SQL formula in the Q column to include any of the other columns needed.

I would strongly advise you to do this on a test/development server first before trying it on a production server to get the feel of what is going on.

Thank you for the help.