VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: EvanGR on September 30, 2021, 13:14:18 PM

Title: [Database]: How to get the custom fields for products in an Order?
Post by: EvanGR on September 30, 2021, 13:14:18 PM
Database related question, didn't know which subforum to ask...

I am building a custom SQL query, and I want to get the selected custom fields for each product in a given Order.
I mostly care about the strings (labels) so I can print a report.
e.g.
T-shirt Red XL

Can you help me find the DB structure for that info, and perhaps some pseudocode for the logic?

Thank you