News:

Support the VirtueMart project and become a member

Main Menu

VM Sales Reports

Started by dylanphelan, May 31, 2021, 17:21:43 PM

Previous topic - Next topic

dylanphelan

Any recommendations for an extension that improves reporting functionality in Virtuemart?

I am registering for VAT and need to be able to generate better reports.

I am not sure what exactly my accountant needs, but it sounds like I will have to provide a report every 2 months, including invoice numbers with corresponding order totals and customer details.

The existing report feature allows you to list monthly sales by order, it then gives you the total with each order number, but it doesn't include the invoice number or customer details.

I bought "virtuemart advanced reports' many years ago and continuously had problems with it. I see there are a few different websites advertising reporting extensions now.

I need to be able to export this data to CSV.


dylanphelan

Anyone used the extension from Total Apps?

Just a little hesitant to buy another reporting extension after the bad experience I had last time.

GJC Web Design

If u just require a csv export then a relatively simple script can do this
GJC Web Design
VirtueMart and Joomla Developers - php developers [url="https://www.gjcwebdesign.com"]https://www.gjcwebdesign.com[/url]
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 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
[url="https://extensions.joomla.org/profile/profile/details/67210"]https://extensions.joomla.org/profile/profile/details/67210[/url]
Contact for any VirtueMart or Joomla development & customisation

Jumbo!

You can take a look at "Reporter for VirtueMart" - https://www.virtueplanet.com/extensions/vm-reporter

Invoice number column will be available in the next update which will be released very soon.
One Page Checkout for VirtueMart - [url="//www.virtueplanet.com/extensions/vp-one-page-checkout"]www.virtueplanet.com/extensions/vp-one-page-checkout[/url]
VirtueMart Email Manager - [url="//www.virtueplanet.com/extensions/vp-email-manager"]www.virtueplanet.com/extensions/vp-email-manager[/url]
Conversion Tracking for VirtueMart - [url="//www.virtueplanet.com/extensions/vp-conversion-tracking"]www.virtueplanet.com/extensions/vp-conversion-tracking[/url]
Reports for VirtueMart - [url="//www.virtueplanet.com/extensions/vm-reporter"]www.virtueplanet.com/extensions/vm-reporter[/url]
Responsive VirtueMart Templates - [url="//www.virtueplanet.com/joomla-templates/"]www.virtueplanet.com/joomla-templates/[/url]

Jörgen

I have bought the reporter for Virtuemarts. There are some issues when using hidden categories and some inconsistensies when a product belongs to more than one category. But overall a nice extension.
Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

Jumbo!

Quote from: Jörgen on May 31, 2021, 22:18:00 PM
I have bought the reporter for Virtuemarts. There are some issues when using hidden categories and some inconsistensies when a product belongs to more than one category. But overall a nice extension.
Jörgen @ Kreativ Fotografi

Hi Jörgen, thanks for your inputs. Please post the exact problems in the support forum of the extension (https://www.virtueplanet.com/forum/vm-reporter-virtuemart-reporting-tool) so that we can fix them in the next update.
One Page Checkout for VirtueMart - [url="//www.virtueplanet.com/extensions/vp-one-page-checkout"]www.virtueplanet.com/extensions/vp-one-page-checkout[/url]
VirtueMart Email Manager - [url="//www.virtueplanet.com/extensions/vp-email-manager"]www.virtueplanet.com/extensions/vp-email-manager[/url]
Conversion Tracking for VirtueMart - [url="//www.virtueplanet.com/extensions/vp-conversion-tracking"]www.virtueplanet.com/extensions/vp-conversion-tracking[/url]
Reports for VirtueMart - [url="//www.virtueplanet.com/extensions/vm-reporter"]www.virtueplanet.com/extensions/vm-reporter[/url]
Responsive VirtueMart Templates - [url="//www.virtueplanet.com/joomla-templates/"]www.virtueplanet.com/joomla-templates/[/url]

dylanphelan

yes, need CSV exports.

order and invoice numbers, customer names,  etc. I looked at the DB, wondered if i can export directly, but i don't see all the required info on the invoice table.

wonder if CSV improved can do this.

dylanphelan

Quote from: Jumbo! on May 31, 2021, 20:58:49 PM
You can take a look at "Reporter for VirtueMart" - https://www.virtueplanet.com/extensions/vm-reporter

Invoice number column will be available in the next update which will be released very soon.

Many of my products belong to more than one category.

Although when I require sales reports for tax purposes, I wouldn't need the category to be exported.

Jörgen

You can of course do this with sql queries and csv improved can do this. Setting up these tasks will take some time. Reporter will do this quicker for You. Excluding columns is no problem for reports. It is easy to cutomize.

It is all up to You :)

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

dylanphelan

Quote from: Jumbo! on May 31, 2021, 20:58:49 PM
You can take a look at "Reporter for VirtueMart" - https://www.virtueplanet.com/extensions/vm-reporter

Invoice number column will be available in the next update which will be released very soon.

Is the invoice number column available yet?
The extension won't help with VAT / TAX returns without this.

Jumbo!

Quote from: dylanphelan on June 08, 2021, 11:05:51 AM
Quote from: Jumbo! on May 31, 2021, 20:58:49 PM
You can take a look at "Reporter for VirtueMart" - https://www.virtueplanet.com/extensions/vm-reporter

Invoice number column will be available in the next update which will be released very soon.

Is the invoice number column available yet?
The extension won't help with VAT / TAX returns without this.

The update will be released this week. We are also adding an inventory reporting system to the component in this update.
One Page Checkout for VirtueMart - [url="//www.virtueplanet.com/extensions/vp-one-page-checkout"]www.virtueplanet.com/extensions/vp-one-page-checkout[/url]
VirtueMart Email Manager - [url="//www.virtueplanet.com/extensions/vp-email-manager"]www.virtueplanet.com/extensions/vp-email-manager[/url]
Conversion Tracking for VirtueMart - [url="//www.virtueplanet.com/extensions/vp-conversion-tracking"]www.virtueplanet.com/extensions/vp-conversion-tracking[/url]
Reports for VirtueMart - [url="//www.virtueplanet.com/extensions/vm-reporter"]www.virtueplanet.com/extensions/vm-reporter[/url]
Responsive VirtueMart Templates - [url="//www.virtueplanet.com/joomla-templates/"]www.virtueplanet.com/joomla-templates/[/url]

dylanphelan

Quote from: Jumbo! on June 08, 2021, 22:31:24 PM
Quote from: dylanphelan on June 08, 2021, 11:05:51 AM
Quote from: Jumbo! on May 31, 2021, 20:58:49 PM
You can take a look at "Reporter for VirtueMart" - https://www.virtueplanet.com/extensions/vm-reporter

Invoice number column will be available in the next update which will be released very soon.

Is the invoice number column available yet?
The extension won't help with VAT / TAX returns without this.

The update will be released this week. We are also adding an inventory reporting system to the component in this update.

Ok. I need to send my accountant a report urgently.
If you can let me know when this update is available, then I will purchase the extension.

Am a little surprised that invoice numbers haven't been included in sales reports in the past.
I may just generate the report with orders numbers for now... see if that is accepted.

Jumbo!

Quote from: dylanphelan on June 09, 2021, 10:13:01 AM
Quote from: Jumbo! on June 08, 2021, 22:31:24 PM
Quote from: dylanphelan on June 08, 2021, 11:05:51 AM
Quote from: Jumbo! on May 31, 2021, 20:58:49 PM
You can take a look at "Reporter for VirtueMart" - https://www.virtueplanet.com/extensions/vm-reporter

Invoice number column will be available in the next update which will be released very soon.

Is the invoice number column available yet?
The extension won't help with VAT / TAX returns without this.

The update will be released this week. We are also adding an inventory reporting system to the component in this update.

Ok. I need to send my accountant a report urgently.
If you can let me know when this update is available, then I will purchase the extension.

Am a little surprised that invoice numbers haven't been included in sales reports in the past.
I may just generate the report with orders numbers for now... see if that is accepted.

Reporter for VirtueMart v2.8 has been released. This update includes the Invoice Number plugin. We have added the Inventory Status report option in this update. You can also download the inventory reports in CSV format. We have also added the ability to include child products of the selected products, selected categories and selected manufacturers in the report's template settings. This should resolve the hidden category issue.
One Page Checkout for VirtueMart - [url="//www.virtueplanet.com/extensions/vp-one-page-checkout"]www.virtueplanet.com/extensions/vp-one-page-checkout[/url]
VirtueMart Email Manager - [url="//www.virtueplanet.com/extensions/vp-email-manager"]www.virtueplanet.com/extensions/vp-email-manager[/url]
Conversion Tracking for VirtueMart - [url="//www.virtueplanet.com/extensions/vp-conversion-tracking"]www.virtueplanet.com/extensions/vp-conversion-tracking[/url]
Reports for VirtueMart - [url="//www.virtueplanet.com/extensions/vm-reporter"]www.virtueplanet.com/extensions/vm-reporter[/url]
Responsive VirtueMart Templates - [url="//www.virtueplanet.com/joomla-templates/"]www.virtueplanet.com/joomla-templates/[/url]

dylanphelan

QuoteReporter for VirtueMart v2.8 has been released. This update includes the Invoice Number plugin

Great, will purchase tomorrow.