1. webstar
  2. RO CSVI
  3. Thursday, 22 September 2022
  4.  Subscribe via email
Hi I wonder if you can help, I'm not sure where to start with this one. We need to run a report that exports Order/products information but only for New users within the last month. Basically we are trying to find out how much NEW business we are attracting each month.

Ive started with the basic VM order export model. but I cant find a way to only segment by new users within the last month. Is there anyway to add extra MySQL into a report?

Many thanks
Derek
Accepted Answer
Accepted Answer Pending Moderation
Hello Derek,
Ive started with the basic VM order export model. but I cant find a way to only segment by new users within the last month.

In VirtueMart Order export template using Order customer name field you can export orders for specific users but there is no filter to find new users.

Is there anyway to add extra MySQL into a report?

You can create an override file for export and add an extra query for the export.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.