Resolved Invoice Line Items export with custom field values

Hello,

CSVI should turn this into a human readable format. Which type of custom field are you using? The 89828 is the value you expect?

That data is being populated from the virtuemart_product_customfields table.

"89828" is the virtuemart_customfield_id field, but what is important is the customfield_value field, in my case "24x36 Framed Paper".

"3" is from the virtuemart_custom_id, which is relatively unimportant to me. If it were to be properly referenced, it would relate to the virtuemart_customs table, and use the custom_title field.

In previous versions of CSVI, that information would be properly referenced and populated, albeit with some added garbage that I would "find and replace" to strip out.

Thank you,

Art

Hello Art,

I do understand where the info is coming from. Which type of custom field are you using?

String, cart variant. See screenshot

Hello,

So I checked this but it exports fine here. When you updated CSVI, did you also update the VirtueMart addon? Perhaps do that first, download the VirtueMart addon and install it. After that see if the export works or not. If not, I can take a closer look.

Here's what I have installed (entire list as screenshot). Note that I also have K2 installed.

CSVI Pro - VirtueMart
Site Plugin 6.5.7 24 April 2016 RolandD Cyber Produksi csviaddon

CSVI Pro
Administrator Component 6.5.7 24 April 2016 RolandD Cyber Produksi N/A

Hello,

That all looks good. Can you sent me a private message with Joomla and FTP login? I will take a look why it isn't doing it.

Hello,

Thanks for that, I had a look. I see that the order items export have no special treatment for the product_attribute field. The order export however does, so that could be used I guess.

I just wonder if you had a patch in place if you were indeed using the order item export. Do you remember? If so, do you happen to know which patch?

I use commonly two different exports. The order export is just to report monthly gross sales. Then the order item export is for product accounting to analyze what's being sold.

I've never used a patch that I know of. Is there a way to simply reset everything?

Hello,

If you have a backup of your old site, you could send me the file administrator/components/com_csvi/models/addon/com_virtuemart/models/export/orderitem.php, so I can check it.

Other than that, from what I see, you can use the fields you use for the line items also with a regular order export. So if you make a copy of the existing line item template (so you have a backup) and modify the copy to be an order export and set the filters to your needs. You should get the same output.

Let me know if that helps.

What did you do to the order items export template? I'm looking at it, comparing it to my live site, and the options tab is much different. Why are there more options on that tab? Everything else looks the same.

Whatever changes you made make it work properly now. I would like to replicate those changes to my live site.

Hello,

I changed the operation from Order item to Order. That is why the tabs are different.

Thank you. That was exactly what I needed

I have another question regarding the order items export. Why are most of the items doubled in the export but not in the invoices? There are two occurrences per line item of most, but not all. This is curious.

Hello,

Why are most of the items doubled in the export but not in the invoices?

Actually they are not double. A duplicate means that every single field is exactly the same but if you look deeper into the data you may notice that not all fields are actually the same. One of the reasons is that VirtueMart stores the billing and shipping address separate.

You can check the Use of group and sort by fields document on how to manage the duplicates. One other way is, if you do not care about the addresses is to set the Order address type option to Billing address.