Export invoices/orders to Excel or CSV

[jlabuelo_sm]

Hello

We are using VirtueMart 3.0.18, but to obtain Invoicing information that we need every month we need to run a SQL query in the db. This must be done by a person with SQL knowledge and we would like to check if there is any pluggin or extension, so an user from the Backend UI can be able to export the order information or invoice information between two given dates to a csv/excel file.

Any suggestions please??

Cheers

[Roderic]

I use RO CSVI for exporting orders automaticaly for a couple of sites.

https://rolandd.com/documentation/ro-csvi/virtuemart/virtuemart-orders-export

I'm sure this would work for your situation as well.

[pinochico]

We use our Easy Feeder for exporting orders automaticaly for our sites (to Helios or other ERP):

https://www.minijoomla.org/cs/joomla-rozsireni/virtuemart-rozsireni/xml-easy-feeder

I'm sure this would work for your situation as well too.

[Mike J]

Hello jlabuelo_sm,

We also use RO CSVI which provides a lot of granular control.

It takes a bit of time to set up but once created, you simply click 'run' next to your desired saved template and you'll get exactly what you want on demand every time.

I wasn't aware of Easy Feeder but it looks promising too... Thanks pinochico.

[Jumbo!]

You can also take a look at "Reporter for VirtueMart" which is specifically designed for these reports.

https://www.virtueplanet.com/extensions/vm-reporter

[Mike J]

I couldn't live without VP One Page Checkout, VP Email Manager, VP Advanced User & VP Conversion Tracking, so I'll have a look at Reporter for VirtueMart next time round.

I didn't realise that it could export to CSV, so thanks for sharing!

[pinochico]

for Mike J

Perfect.

I can't live without OPC from Rupostel,
Email Manager for Virtuemart, EasyFeeder, Import product for VirtueMart, OPC Shipment Rupostel/Minion, Gopay payment, Module VirtueMart Product Extended, Module EasySlideshow, GTM, GTM for VirtueMart. All applications are our production more then 6-12 years, so we don't have to pay anything and we can make perfect eshops with our extensions.