Resolved customer input for custom fields not exporting

Hello Ryan,

I can't figure out how to make those fields available

That makes two of us. The main problem here is that these custom field values are not stored in the orders.

All the custom field information (they are IDs) is stored in a single field called product_attribute by VirtueMart. So all this information will always export as a single field as well.

Now I see you don't have the product_attribute field in your export. Add this field to your export and see what comes out because CSVI does try to get some understandable values. We can take it from there.

Hi,

Thanks for helping out with this.

I ran it including product_attribute, but it only pulled the title of the field and what kind of custom field it is, not the information the customer fills out.

When I look at the individual orders in virtuemart, it seems like this information must be stored somewhere that allows it to show up on the order form. I've attached a sample order (with the student info blacked out). Under 'Product Name' the non-blacked out sections are the field titles and the blacked out sections have the information filled out by the customer. It shows up there just fine. So, it's somewhere...I just don't know where or how to get it to show up on a report.

Any ideas? This information is crucial for getting the reports we need (without having to manually sort through way too many orders and transfer the information by ourselves).

Thanks!

Ryan

Hello Ryan,

Is it possible to email me a backup of your site or give me Joomla/FTP/Database access to your site so I can see what is in there and what should be exported.

With custom fields it is difficult to get a clear idea without seeing them.