Resolved Virtuemart export of Order Items, but with more customer details

Hello,
VirtueMart order item export does not get customer details as that export is to get only product details linked to order. You can use Advanced order XML export to get order with customer details and order items. Let me know if that helps.

Hi Tharuna,

The customer only accepts CSV and not XML. But there are customer details in the Order Item export. The Full_Name field of the customer details is in!
So is for instance email and address not possible?

Hello Paul,

When you export customer details with order items, you will get a lot of duplicate data because CSV does not support nested output. However you can still use the Advanced Order XML export to get your CSV file.

The name is a bit misleading because if you are creative you can output a CSV file with it as well. To get a CSV file you put in the column headers in the header of the XML layout. In the order section you only put [orderlines] and in the Orderlines you put the fields you want as comma separated values and double quote enclosed. The footer section you can leave empty.

This way you can use the export to get what you want.

Thx I will try.

Hi Roland,
Can you please give me a bit more explanation.

I am getting this error: "
Status error: 200
Status message: parsererror
Warning: Undefined property: stdClass::$billing_first_name in public_html/plugins/csviaddon/virtuemart/com_virtuemart/model/export/orderadvanced.php on line 1214"
The strange thing is that I don't use the field billing_first_name!

What do I put in the order section: [orderlines], <orderlines> or just orderlines?
The Header, what kind of format? Just column name and comma-separated values?

Cheers Paul

Hello Paul,

I am getting this error: "
Status error: 200
Status message: parsererror
Warning: Undefined property: stdClass::$billing_first_name in public_html/plugins/csviaddon/virtuemart/com_virtuemart/model/export/orderadvanced.php on line 1214"
The strange thing is that I don't use the field billing_first_name!

The field full_name uses billing_first_name, billing_middle_name and billing_last_name combined and since you don't have these added in the template, you have this warning. You add these fields and set them to Unpublished so RO CSVI use their value for full_name field but will not include in export file.

What do I put in the order section: [orderlines], <orderlines> or just orderlines?
The Header, what kind of format? Just column name and comma-separated values?

Please see attached screenshots for example. Two more things to do, in export template on File tab set filename as orders.csv and save the template and in template fields page set CDATA field to No and save the fields. Run the export and check.

Hi Tharuna,
I did all the steps, and removed the full_name field, but I still have a lot of warnings on fields I don't use.

An error has occured during the export. Below the information received from the server.
Status error: 200
Status message: parsererror

Warning: Undefined property: stdClass::$billing_first_name in /public_html/plugins/csviaddon/virtuemart/com_virtuemart/model/export/orderadvanced.php on line 1214
etc.....
End of the screen: (no log file created BTW)
{"process":false,"records":119,"downloadurl":"/administrator\/index.php?option=com_csvi&task=exports.downloadfile&tmpl=component&file=L2hvbWUvdTE0NTY0MTA2NC9kb21haW5zL3BpeG93YWxsLmNvbS9wdWJsaWNfaHRtbC90bXAvY29tX2NzdmkvZXhwb3J0L2FkdmFuY2VkLW9yZGVyLWV4cG9ydC1waXhvd2FsbC5jc3Y=","url":"https:/administrator\/index.php?option=com_csvi&view=logdetails&run_id=135&return=aHR0cHM6Ly93d3cucGl4b3dhbGwuY29tL2FkbWluaXN0cmF0b3IvaW5kZXgucGhwP29wdGlvbj1jb21fY3N2aSZ2aWV3PXRlbXBsYXRlcw=="}

Hello Paul,

I did all the steps, and removed the full_name field, but I still have a lot of warnings on fields I don't use.

I did not tell you to remove full_name field but asked you to add billing_first_name, billing_middle_name and billing_last_name so they can be used for full_name field.

End of the screen: (no log file created BTW)

You can get the log file from RO CSVI logs page provided you have set Enabled logging to yes in export template. Can you post the debug log file to check? Also post template XML file. To get the template XML file from RO CSVI templates list page select the export template and click on Backup templates button. Post the downloaded XML file.

Ok, I have put error reporting level to none. Because of all the warnings, it wasn't generating a file to download.
Now it does.
One more question: the output lists the field name when a field has no data. How can I solve this?
Eg. "20-08-2024","Dennis","[billing_middle_name]","Janssen"

Hello Paul,

One more question: the output lists the field name when a field has no data. How can I solve this?

You will see the field name not when there is no data but when there is no template field added. Check your export template fields and see if you have billing_middle_name added.

Hi Tharuna,
Yes, I have billing_middle_name as oe of the Fields, also as Header and in Orderline "[billing_middle_name]". So that is all good.
Found it.
Sorry, I had "Include empty node values" set to No in one of my earlier trials.

Hello Paul,
So your issues are all solved?

Yes, the only thing I still have to test is what happens with 1 order number with multiple order items!

Hello,
Let us know on how it goes and if you need any more help.