7xjw43

Okay this is 100% solved, here are the steps i used to insert 300 vouchers at one time. Total time it took was 15 minutes.

Tables to be altered in phpMysql

1) ps_discount

2) ps_discount_lang

3) ps_discount_category

Steps for ps_discount

(id_discount    id_discount_type        behavior_not_exhausted  id_customer     id_group        id_currency name        value   quantity        quantity_per_user       cumulable       cumulable_reduction     date_from       date_to minimal active  cart_display    date_add        date_upd)

1 in a csv file, create and update values for above fields

2 note: id_discount is the primary reference key for the other tables, so please keep track of it

3 note: for the date, the format is yyyy:mm:dd hh:mm:ss (if it is not properly set, the import will have issues)

4 next goto import (in table ps_discount), browse to your csv file and select it

5 change the options for csv (fields terminated by "," and fields enclosed by "leave blank"

6 click import and you are done

Steps for ps_discount_lang

(id_discount    id_lang description)

- in a csv file update the values for the above fields

- note id_discount should be the exact same values copied from the ps_discount csv file

- follow the same steps as above (4, 5, 6)

Steps for ps_discount_category

(id_category    id_discount)

-in a csv file update the values for the above fields

- note id_category are the category numbers for all the categories you want the voucher to be active in

- note id_discount should be the exact same values copied from the ps_discount csv file

- follow the same steps as above (4,5,6)

And thats it, you are done.

Enjoy !!