Digital Product Key?

[pixelan]

I have just started to get into Zen Cart, and am excited. Installed the latest version fine. I'm not a heavy coder, but can do small code modifications. : } We sell software via downloads and have been using ejunkie, which is okay but we'd like to switch to Zen Cart for various reasons.

We need to have the customer get a serial number as part of the order confirmation email, as talked about in this thread. In our case, I'd like to have a simple database (one database per product; we have about 20 products -- or one database that can handle all of the products) that lists available unassigned serial numbers per product. When the serial number is retrieved, it is removed from the queue in the database. The database <> Zen Cart connection is the part I do not understand -- how/where does Zen Cart access this database for that info? What steps would I need to take in Zen Cart to set that up? Thanks in advance for whatever insights you can provide.

~ Michael

[gjh42]

The simplest approach may be to add one or more tables to the regular Zen Cart database - then there will be no new access issues.

A database expert could tell you how best to organize the new table(s).

[pixelan]

Thanks for the reply. "add one or more tables to the regular Zen Cart database" -- I understand at this early learning point for me the the database is accessed by using phpMyAdmin... but could you tell me the basics of adding a table to the database (without messing up the existing parts of it) and then the basics of pointing the serial number item in the customer email to that? Thanks.

~ Michael

[gjh42]

We need a database expert here...

You don't use phpMyAdmin for regular db access from Zen Cart. This is done with SQL statements in the PHP files.

[pixelan]

Sorry for my misunderstanding based on an initial quick-scan of a few Zen Cart help documents. Anyone else who can chime in and offer further help about my questions would be much appreciated! : )

~ Michael