Author Topic: VM Extension to sort orders on a specific date and export to Excel  (Read 179 times)

Mylène

  • Beginner
  • *
  • Posts: 2
  • A beginner
I will use my Virtuemart webshop to get people to order on a specific day. They willl pick up their orders, and pay in the fysical shop.
Which VM made extension would I need if I want to:
- gather orders for that specific date
- export those orders to an Excel sheet

I am using Joomla! 3.10.2 and VM 3.8.8.

GJC Web Design

  • 3rd party VirtueMart Developer
  • Super Hero
  • *
  • Posts: 10247
  • Virtuemart, Joomla & php developer
    • GJC Web Design
  • VirtueMart Version: 3.6.8
Re: VM Extension to sort orders on a specific date and export to Excel
« Reply #1 on: October 10, 2021, 18:56:26 pm »
I don't know of any extension to do this .. what I would do is a small script to export the required info ..  this could be cron called so the export happens e.g. at midnight each night.

Contact me if u need this
GJC Web Design
VirtueMart and Joomla Developers - php developers http://www.gjcwebdesign.com
VM3 AusPost Shipping Plugin - e-go Shipping Plugin - VM3 Postcode Shipping Plugin - Radius Shipping Plugin - VM3 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
http://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

jflash

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 50
Re: VM Extension to sort orders on a specific date and export to Excel
« Reply #2 on: October 11, 2021, 08:35:40 am »
I use Plotalot https://www.lesarbresdesign.info/extensions/plotalot for various queries. In query options set table typte to 'Table (Google)' - then you can download csv file.

Mylène

  • Beginner
  • *
  • Posts: 2
  • A beginner
Re: VM Extension to sort orders on a specific date and export to Excel
« Reply #3 on: October 15, 2021, 14:11:09 pm »
Thank you, I am working on my shop right now and will see which ch=oice I will make.