VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: suraty on February 01, 2023, 13:56:19 PM

Title: Export orders with products names in an Excel file
Post by: suraty on February 01, 2023, 13:56:19 PM
Hello,

Is there any simple and fast way to export orders to an excel or csv file?
A file that contains these fields: customer name, order date, paid status, products_names, total_price
There are some extensions but they do not export product_names!
I am a beginner and English is not my native language.
Please help me step by step!
Thank you

Virtuemart version 3
Joomla version 3
Title: Re: Export orders with products names in an Excel file
Post by: Jumbo! on February 01, 2023, 14:15:32 PM
You can use "Reporter for VirtueMart" - https://www.virtueplanet.com/extensions/vm-reporter. Check the live demo site for a clear understanding.
Title: Re: Export orders with products names in an Excel file
Post by: suraty on February 01, 2023, 16:01:41 PM
Thanks so much
It is beneficial and powerful!
I wish it were free to download at least for a trial time!
Title: Re: Export orders with products names in an Excel file
Post by: pinochico on February 01, 2023, 22:00:17 PM
You can use EasyFeder https://www.minijoomla.org/extensions/virtuemart-extensions/xml-easy-feeder
It is perfect because every element for export you can add self from libraries for VirtueMart components (VirtueMart Products, Virtuemart Category, Virtuemart Orders, VirtueMart Orders Items) and more others (Acymailing, Joomla Content, Form2Content, PhocaCart, Core DB),.
And for export you can use 8 formats (Atom | Csv | Html | Json | Rss | Xls | Xlsx | Xml).
Title: Re: Export orders with products names in an Excel file
Post by: suraty on February 02, 2023, 12:31:46 PM
Thank you very much
Your suggestion is good
And I guess there is no free tool for doing that
Title: Re: Export orders with products names in an Excel file
Post by: jenkinhill on February 02, 2023, 13:11:59 PM
Quote from: suraty on February 02, 2023, 12:31:46 PM
And I guess there is no free tool for doing that

The only way to get "free" for an extension like this is to write it yourself. I'm sure it could be done using SQL in phpMyAdmin.