Merchant fields in a product template

AbleMods · Post by **AbleMods** » Sat Nov 24, 2007 12:13 pm

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

jmestep · Post by **jmestep** » Sat Nov 24, 2007 1:56 pm

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

AbleMods · Post by **AbleMods** » Sat Nov 24, 2007 2:10 pm

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.

AbleMods · Post by **AbleMods** » Wed Nov 28, 2007 5:23 am

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

Post by **sohaib** » Wed Nov 28, 2007 6:22 am

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

AbleMods · Post by **AbleMods** » Wed Nov 28, 2007 6:14 pm

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

Post by **sohaib** » Thu Nov 29, 2007 12:40 am

AbleMods · Post by **AbleMods** » Thu Nov 29, 2007 7:00 am

Cool, thanks.