Database Documentation

[rwuhrman]

Hello,
Is there any documentation on the database? ie. a lay of the land as to what information is in the various tables? I could just go browsing through all the tables myself and make sense of it, but perhaps someone has already done this and documented it?

Reason I ask is that I need to make a customization for our site. We sell widgets that save my customers x or y dollars depending on the widget they are buying. What I want to have is a calculator that automatically calculates how much money they are saving based on the items in their cart. So if widget x saves them $200 over its lifetime, and widget y saves them $100 over its lifetime, the I want to write some code that'll calculate the total lifetime savings based on the quantities of each of these widgets in their cart.

My theory is they will see they are saving say for example $400 with the items in their cart, which will add an extra justification for following through the checkout process if the cart total is substantially less than $400. We also want to dynamically calculate the total savings we've provided to all of our customers at any given time so the marketing folks can brag about it on the homepage.

Anyway, to the point, is there documentation on the db schema for zen cart? At first, I just need to know how to determine a shoppers cart contents at runtime so I can write the lifetime savings calculator, but going forward it would be good to understand all of the tables and what they are for.

[rwuhrman]

Hey folks I just found this through a google, so perhaps it is all here:


http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema

but you have additional resources for developers I'd be interested.

Thanks.

[gjh42]

Yep, that's it! There is related information for developers that you will find as you browse the wiki.