News:

Support the VirtueMart project and become a member

Main Menu

Export orders with products names in an Excel file

Started by suraty, February 01, 2023, 13:56:19 PM

Previous topic - Next topic

suraty

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

Jumbo!

You can use "Reporter for VirtueMart" - https://www.virtueplanet.com/extensions/vm-reporter. Check the live demo site for a clear understanding.

suraty

Thanks so much
It is beneficial and powerful!
I wish it were free to download at least for a trial time!

pinochico

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).
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds for FB, GMC,.. from products, categories, orders, users, articles, acymailing subscribers and database table
Virtuemart Email Manager - customs email templates
Import products for Virtuemart - from CSV and XML
Rich Snippets - Google Structured Data
VirtueMart Products Extended - Slider with products, show Others bought, Products by CF ID and others filtering products

suraty

Thank you very much
Your suggestion is good
And I guess there is no free tool for doing that

jenkinhill

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.
Kelvyn
Lowestoft, Suffolk, UK

Retired from forum life November 2023

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum