Next Coupon ID Number – How and where is it set?

[Robert]

Can you tell me where the ID number of the coupon is kept. How does the system know what coupon id number to assign the next coupon?

[wzp]

The coupon ID is merely the next sequential row number of the MySQL table that contains the coupon data.

[Robert]

So what happens if you delete a coupon? It seems to still up the id number. How does it track that?

[wzp]

It’s an auto increment column. MySQL uses the next highest number. It’s like the Product ID number; you have no say in what ID number gets assigned to what.

eStore is not “keeping track” of the ID number; the MySQL database is.

What really matters is the “Coupon Code” that you associate with the ID number. Your customers only ever sees or uses the Coupon Code. You can make each coupon code unique.

[Author]

Posts