How to generate/import hundreds of coupons?

I need to have hundreds or thousands of coupons. Ho can i generate or import (even better) them?
If i will need to do it manually i'll probably will get old before i'll do that

Hi,

In HikaShop there is no batch generation or import system for the coupons.
But in HikaSerial, you have a batch generation for coupons. Using the "coupon generator", you can generate manually serials which will generate coupons.
You can also generate dynamically some coupons, for example if you want to send coupons in an Acymailing newsletter.

Regards,

so if i need to have a thousand coupons 00007,00008,00009,00010,00011 ... 01007 HikaSerial will do that for me?

Hi,

The coupon generator will create the coupon code, it uses a random algorithm for the coupon codes so it is not easy to "find" a code like that.
When you have a coupon generator used in a pack (a pack is a group of serials) you can "generate" serials and specify a number of coupon you want to create (it can be a thousand of coupon if you want).

Regards,

sorry, but it seems that it is something i don't need. I don't mind to pay for HikaSerial, but it just isn't what i need. I just need the possibility to generate a number of codes, shoose codes format and coupons options. Maybe i can use INSERT INTO function and add all coupons directly to database throught phpmyadmin?

Hi,

Yes you can insert directly your coupons in the database. The best is to copy the values of an existing coupon in order to right fill all columns correctly.

Regards,

i just run SQL guery on my datadase:

INSERT INTO qdvsk_hikashop_discount(discount_type, discount_percent_amount, discount_code, discount_published, discount_currency_id, discount_coupon_nodoubling, discount_coupon_product_only, discount_affiliate)VALUES( 'coupon','30','888','1','91','0','0','-1');

and it seems that did the trick. My coupon is ready to use. Now i need somehow to generate as many these queries as i need coupons, i think i'll use MS Access for that, because codes i already have in my excel table.

export excel table to csv, and there are doesn't of simple ways to script your import a csv to your table --
the most rudimentary would be a script to generate your sql insert statements from the csv.

perl, php, ruby, even a shell script could be used to create your sql insert statements.

ruby has some nice gems to make connecting to the db, and processing csv fairly simple. I have to do this -- and i"m going to use ruby -- I'll post my script here for the benefit of the community. As it looks like this is a fairly common request with things like groupon, etc.