AbleCommerce Shopping Cart Software

Where do they get stored? I did some testing and they aren't getting added along with the other user entries in ac_OrderItemInputs.

We're all flying blind until we get some docs, but there is a table ac_ProductTemplateFields

yeah that table holds the template definition. Once a product is displayed, the assigned template definition is rendered to the product page and the customer can populate the fields.

Once the item is written as an order, the values entered by the customer are written to ac_OrderItemInputs and tied back to the line item of the order via the field OrderItemID.

But that merchant part of the template is the mystery because it's not getting stored where the customer-supplied values are getting recorded.

Still no answer on this one...Logan, Mike, anyone?

Hello,

There are two tables 'ac_InputFields' and 'ac_InputChoices'.
Input Choices are linked to Input Fields (should be obvious)

Now product template fields are defined in 'ac_ProductTemplateFields'... and they are linked with ac_InputFields. (InputFieldId is FK in 'ac_ProductTemplateFields')

Hope this makes some sense...

Thanks,
Sohaib

ok, so the values entered by the merchant in the Merchant template fields of a product template are stored in ac_InputFields?

yes

Cool, thanks.