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

Mylène

  • Beginner
  • *
  • Posts: 3
  • 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: 10300
  • 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: 3
  • 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.

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10144
  • VM3.9 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Studio 42

  • Contributing Developer
  • Sr. Member
  • *
  • Posts: 4518
  • Joomla & Virtuemart developper
    • Studio 42 - Virtuemart & Joomla extentions
  • VirtueMart Version: 2.6 & 3
Re: VM Extension to sort orders on a specific date and export to Excel
« Reply #5 on: October 25, 2021, 14:01:06 pm »
It should work with that one https://extensions.virtuemart.net/back-office/import-export/vm-products-csv-ultimate-detail
I do not see any details about orders export, only import or export Products

Milbo

  • Virtuemart Projectleader
  • Administrator
  • Super Hero
  • *
  • Posts: 10144
  • VM3.9 Eagle Owl
    • VM3 Extensions
  • VirtueMart Version: VirtueMart 3 on joomla 3
Re: VM Extension to sort orders on a specific date and export to Excel
« Reply #6 on: October 26, 2021, 00:24:07 am »
Just a reason to add it :-)
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/