Author Topic: Export orders to Excel  (Read 11472 times)

lindapowers

  • Full Member
  • ***
  • Posts: 1335
  • If you're going through hell, keep going.
    • Los Angeles immigration lawyers
  • Skype Name: manu.gonzalez91
  • VirtueMart Version: Latest avi
Export orders to Excel
« on: December 22, 2012, 00:30:19 am »
Hi

Is there any way to export orders to excel or csv?

There used to be a hack for VM1.x but I can't find a single component or plugin that does it.

Except for that CSVI, but I mean in a more simple and friendly way.. to use daily and not to export products etc as CSVI does.

Is a nightmare not having an export buton and having to copy orders manually.

Yep we use xls for our transport sytem :o

bytelord

  • Nikos
  • Global Moderator
  • Full Member
  • *
  • Posts: 2369
Re: Export orders to Excel
« Reply #1 on: December 22, 2012, 00:37:16 am »
Hello,

I believe that CSVI is the easiest and more safe way to do it. You could easy create a template for that export and each time you want it you just run it or create a cron job to create it automatically and just pick up the file.

Regards
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

lindapowers

  • Full Member
  • ***
  • Posts: 1335
  • If you're going through hell, keep going.
    • Los Angeles immigration lawyers
  • Skype Name: manu.gonzalez91
  • VirtueMart Version: Latest avi
Re: Export orders to Excel
« Reply #2 on: December 22, 2012, 00:42:08 am »
Ill give it a try again then, thanks bytelord.

bytelord

  • Nikos
  • Global Moderator
  • Full Member
  • *
  • Posts: 2369
Re: Export orders to Excel
« Reply #3 on: December 22, 2012, 00:52:35 am »
Yes it's easy just need to work some hours with it, it's a little bit more complex because gives you too many options so you will be able to find your custom export template for you.
Also you could edit the template files (needs a little bit PHP knowledge) and ajdust them as you wish.
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

lindapowers

  • Full Member
  • ***
  • Posts: 1335
  • If you're going through hell, keep going.
    • Los Angeles immigration lawyers
  • Skype Name: manu.gonzalez91
  • VirtueMart Version: Latest avi
Re: Export orders to Excel
« Reply #4 on: December 22, 2012, 11:53:29 am »
The problem is that it exports to csv which is quite messy, but we can still change it to xls with columns.

Regards

bytelord

  • Nikos
  • Global Moderator
  • Full Member
  • *
  • Posts: 2369
Re: Export orders to Excel
« Reply #5 on: December 22, 2012, 12:06:22 pm »
Import your csv file into an xls file and make columns, etc as you wish ... automatically and that one ... you can have your excel file grap the csv from a http server and import the records as you want
http://office.microsoft.com/en-001/excel-help/import-or-export-text-txt-or-csv-files-HP010099725.aspx
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

lindapowers

  • Full Member
  • ***
  • Posts: 1335
  • If you're going through hell, keep going.
    • Los Angeles immigration lawyers
  • Skype Name: manu.gonzalez91
  • VirtueMart Version: Latest avi
Re: Export orders to Excel
« Reply #6 on: December 22, 2012, 12:12:15 pm »
Thanks a lot bytelord! I will look carefully in to this.

Regards

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 27767
  • Always on vacation
    • Jenkin Hill Internet
Re: Export orders to Excel
« Reply #7 on: December 22, 2012, 13:56:05 pm »
I import the csv file into OpenOffice Calc (it has more flexibility than Excel) and then it looks like an Excel spreadsheet, can be manipulated etc. Also it can be exported frpom Calc as .xls file for import into Excel.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

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

Currently using VM 3.8.4.10335 on Joomla 3.9.19 PHP 7.3.18

lindapowers

  • Full Member
  • ***
  • Posts: 1335
  • If you're going through hell, keep going.
    • Los Angeles immigration lawyers
  • Skype Name: manu.gonzalez91
  • VirtueMart Version: Latest avi
Re: Export orders to Excel
« Reply #8 on: December 22, 2012, 15:29:34 pm »
Thanks jenkinhill, I will look in to that too, first thing is creating a template in that CSVI to export orders, then ill try both of your suggestions and test,

Regards

lindapowers

  • Full Member
  • ***
  • Posts: 1335
  • If you're going through hell, keep going.
    • Los Angeles immigration lawyers
  • Skype Name: manu.gonzalez91
  • VirtueMart Version: Latest avi
Re: Export orders to Excel
« Reply #9 on: January 04, 2013, 20:56:00 pm »
Hi guys just to let you know or any one searching for the same, seems what we need can't be done with CSVI.

That component doesnt allow the export of fields from different tables, so basicly you can export order details but that won't include the product name for example.

We found this component which seems to be more capable of what we want http://extensions.joomla.org/extensions/administration/admin-reports/12250 or this one http://extensions.joomla.org/extensions/extension-specific/virtuemart-extensions/virtuemart-orders/19558

Regards

bytelord

  • Nikos
  • Global Moderator
  • Full Member
  • *
  • Posts: 2369
Re: Export orders to Excel
« Reply #10 on: January 06, 2013, 18:06:04 pm »
Nice,

Thanks for sharing :)
Production: Joomla 2.5.8 | VM 2.0.14 | PHP 5.3.13
Testing     : Joomla 2.5.8 | VM 2.0.16 | PHP 5.3.8
Testing     : Joomla 2.5.8 |    VM 2.1   | PHP 5.3.8

- Don't Forget to mark thread as solved when it is solved!
- Please do not PM with support questions, use the forum!

RolandD

  • Full Member
  • ***
  • Posts: 780
    • Home of CSVI
Re: Export orders to Excel
« Reply #11 on: June 19, 2014, 08:11:42 am »
Hello,

Old topic I know but people still read it and there is something I would like to clear up.

Quote
That component doesnt allow the export of fields from different tables, so basicly you can export order details but that won't include the product name for example.
This only applies to the Free version of CSVI, not the Pro version. The Pro version does allow to export the product_name.
Regards,

RolandD

CSVI
http://www.csvimproved.com/

lindapowers

  • Full Member
  • ***
  • Posts: 1335
  • If you're going through hell, keep going.
    • Los Angeles immigration lawyers
  • Skype Name: manu.gonzalez91
  • VirtueMart Version: Latest avi
Re: Export orders to Excel
« Reply #12 on: August 21, 2014, 11:24:27 am »
Hello,

Old topic I know but people still read it and there is something I would like to clear up.

Quote
That component doesnt allow the export of fields from different tables, so basicly you can export order details but that won't include the product name for example.
This only applies to the Free version of CSVI, not the Pro version. The Pro version does allow to export the product_name.


1. Can you export a file based in order status? I mean export all the "confirmed" orders for example?
2. Can you select the fields and ordering of the exported fields?

We dont mind if its CSV, XLS or PDF.

Exporting a simple list of orders in VM2 seems a nightmare.