How do you mass input coupons?

[bradlawson]

I am running 1.3.7 and was trying to see if there was a way I could mass input single use $35 dollars off coupons, so I different code for each. I am guessing it would be with a SQL update instead of manually updating them. But what flags what I have to set for it to work properly.

Thanks,

Brad

[Ajeh]

Create 1 and you can see all the settings required in the coupons table for this ...

[stevehare]

I don't know if you are still looking for a solution, but I have done this; it's pretty simple.

First, create an excel spreadsheet using the column headers in the coupons table (if you need these, let me know and I can send you my template).

Then populate the spreadsheet with all the information needed (you might want to create one in the admin, then download the coupons table to use as an example as how all the information should be formatted.

Convert the spreadsheet to a CSV file and import into your coupons table using CSV with LOAD DATA.

Works like a charm.

[Shirin]

Hi I am trying to figure out how to input 500 coupons, please elaborate on your suggestion and would be glad if you could email me the template that you mentioned.
Thanks.