Resolved How to export virtuemart order with orderlines to Excel

Hello Jacobo,

I would like to csv export my virtuemart orders to excel; it is working fine but only first orderline (product order) is included in column information; would it be possible to export all orderlines as concatenated text, using per example some special separator; I would need to have order line information also exported to my Excel sheet.

It depends on what field you are having in your export template. You need to tell us the fields you are trying to export and include the information requested in the section Looking for a useful answer? on top of the page so we can help you.

I have seen your tutorial to do adavanced virtuemart order export to XML and orderlines are included as additional lines; that is not useful for me as for excel I would need a concatenated text with all orderline information.

Yes, order advance export will export only XML file. Just to make things clear as you saying as excel, CSVI can export data in CSV, HTML or in XML format only. Can you also clarify on what you mean with concatenated text? does it mean multiple product details of an order?

Hello,

Thank you for your fast reply.

Yes, I know, it exports CSV format that I open with Excel.

About fields I am trying to export; these fields from my virtuemart order:
product_item_price
product_price_total
product_ordered
product_quantity
product_sku

About "contactenated text"... what I mean?

Ok, as an order may have multiple items (orderlines) I understand that I want to export multiple items to one excel column (one csv column, NOT multiple csv lines) I have to put all information toguether from my virtuemart before I export; so one method would be to put multiple orderlines (defined by fields specified boefore) as a "concatenated text", I just need information at excel for information purposes, so it is not a problem to concatenate all fields from multiple product order toguether and just include that on just one column.

Thank you,

Jacobo

Hello Jacobo,

Ok, as an order may have multiple items (orderlines) I understand that I want to export multiple items to one excel column (one csv column, NOT multiple csv lines) I have to put all information toguether from my virtuemart before I export; so one method would be to put multiple orderlines (defined by fields specified boefore) as a "concatenated text", I just need information at excel for information purposes, so it is not a problem to concatenate all fields from multiple product order toguether and just include that on just one column.

Multiple items in one column is not possible with CSVI export. We read data and put it in each row which makes it as multiple items in multiple row. One way is you can try doing it by writing your custom code using Override for import/export routine and see if it helps.