Creating large number of coupons

[Nidzo]

I need to create 100 coupons with unique codes that will bi physically printed on gift cards.
Creating vouchers one by one is a pain. I tried to speed up the process by exporting the phocacart_coupons table and editing it in LibreOfficeCalc.
I noticed that after restoring the table it is fine except for the Rules where the category should be.
In the Phoca Cart coupon settings there is an empty field for the categories to which the coupon code applies. Then I found the phocacart_coupon_categories table which cannot be edited from PHPMyAdmin


Is there a way to edit this too to speed up the process? Can an option be introduced from the Phoca Cart admin area for situations like this?

[Nidzo]

OK I managed it. I exported phocacart_coupon_categories table and edited coupon_id and category_id columns in LibreOfficeCalc and then reupload it.

[Jan]

OK