Zen Cart Logo
Forums / General Questions / Coupon insert 1000 at a time

Coupon insert 1000 at a time

Locked

Views: 1,224

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
25 May 2008, 6:27 AM
#1
greaseandgo avatar

greaseandgo

New Zenner

Join Date:
May 2008
Posts:
2
Plugin Contributions:
0

Coupon insert 1000 at a time

How could I insert 1000 coupons at a time from a text file?

:huh: :unsure: :lamo:

25 May 2008, 7:19 AM
#2
kuroi avatar

kuroi

Totally Zenned

Join Date:
Apr 2006
Location:
London, UK
Posts:
10,475
Plugin Contributions:
11

Re: Coupon insert 1000 at a time

The easiest way would be to convert your text file into two CSV files whose columns match those of the coupons and coupons_descriptions tables and then use a database management tool such as phpMyAdmin to import the CSV files into those tables.

Kuroi Web Design and Development | Twitter

(Questions answered in the forum only - so that any forum member can benefit - not by personal message)

2 Jun 2008, 1:23 AM
#3
greaseandgo avatar

greaseandgo

New Zenner

Join Date:
May 2008
Posts:
2
Plugin Contributions:
0

Re: Coupon insert 1000 at a time

Hi Kuroi

I will try it when I get a chance. This would be a great feature if you wanted to sell a cd with the coupon code on it, because the files that I license a viewing of will expire after a predetermined time. I have been doing html :frusty: and other webmaster stuff for 4 years, I got it all working and was able to add some pics and get the downloads to work. :clap: You can see the shopping cart at: http://secureshopping.greaseandgo.com if you have any sugestions how to make it work better or faster please let me know, I also left on the Parse Time, Number of Queries, Query Times to display.

you can also email me at: [email protected]

Thank you
Gene