Home
The Toolkit for Online Communities
15899 Community Members, 0 members online, 2543 visitors today
Log In Register

Forum OpenACS Q&A: ecommerce: is there a table row for a specific instance of a product?

OpenACS Home : Forums : OpenACS Q&A : ecommerce: is there a table row for a specific instance of a product?

Icon of Envelope Request notifications

is there a table that stores a specific product purchased? for example, if someone bought two wigits, would there be a table that has two additional rows because of that?

I'm asking because I want to sell non-shippable stuff, and when ecommerce tells me someone has purchased this product, I make a row in my table with a fk reference to the ecommerce table, so that later if they exchange or refund, I can see the ecommerce table row as well as my table row.

-Jim

Jim,

Look at ec_items table. The ecommerce doc at your-ecommerce-instance/doc/ecommerce-technical has information about the order states from ec_orders, which are linked.

cheers,

Torben