How to perform bulk import of coupon codes? Getting error code 1054.

[kobra]

when I go to my ZenCart admin portal and look under the coupon admin section, I don't see the new coupon listed. Do you know if there is perhaps something else that also needs to be done, such as making an insert into the coupons_description table?

I didn't and it showed in the admin???

Not positive but you have "0's" for these
uses_per_coupon`, `uses_per_user
and maybe as there are no uses it does not show???

[Ajeh]

Are you trying to create Discount Coupons or Gift Certificates (cash for people) ...

coupon_type G

is for Gift Certificates ... meaning you are giving away cash that never expires to people ...

[angeline12]

For an advanced chore since you have done a wonderful work here, let me share you something. When I needed to import bulk of codes into another site, my friend told me to use iMacros for the Firefox to be able to read in the CSV. As a result, I was able to import the 800 coupon codes in Groupon in just 15 minutes.

[thegoodlifestore]

Wow, angeline12.

Thanks for the pointer in the direction of that iMacros plug-in for Firefox.

Once I got the Macro set up properly, it works like a charm on importing a lot of coupon codes!!!

and

[wakenine]

I have just figured out how to successfully bulk-import coupon codes for events like Groupon, Jasmere, etc. If anyone is interested in a pretty quick and easy run-down on how to do it, let me know. If enough people are needing help with this, I might do a write-up that could possibly be added to the FAQs or something. Either way, I am glad to help.

[marleyman]

Wakenine - I would be VERY interested in your "How To"!! I need to implement Groupon on my Zen Cart 1.3.9 Site. Thanks so much!

[jansuh.nl]

Wakenine - I would be VERY interested in your "How To"!! I need to implement Groupon on my Zen Cart 1.3.9 Site. Thanks so much!

Count me in also!!

Just got a call to deliver 80.000 vouchercodes that are going to be printed on packages........ sigh/cheer

If nessecary i'll do it by hand but i hope there is a way to automate this

[carlvt88]

I ended up creating a vbs script file that would generate the necessary sql command. This was because:

1. I received a list of ascii string codes from dealChicken
2. I already had existing coupons in the database
3. I couldn't use autoincrement because
4. I had coupon restrictions (only useful for certain items)

It worked great, but I don't know if this is the best way to go about this. The UI in Zencart doesn't seem to work well for many (>100) coupon codes - it can't sort, or filter, or do batch manipulations. This makes me wonder if I'm overcomplicating things and there's an easier way.

[familynow]

Hi.

I'm working on a WagJag campaign and would be very intersted in working out a simple bulk import solution as mentioned above. Was the "how-to" pm'd or something? There's no follow-up to this thread...

[KnowNoneSince]

I ended up creating a vbs script file that would generate the necessary sql command.

Would you mind to share your vbs script? I'm trying to do the same.
Thank you very much!