Order Exporter Addon / Sales Report Addon
I am trying to find an Addon to use with http://www.irishshopper.com which will export all orders to a table or preferably a Spreadsheet so I can calculate at the end of every month the VAT due on EU orders.
Have used ORDERS EXPORTER which works 100% and gives most fields in a spreadsheet format the does not include the most important field - THE ORDER TOTAL. How can I get it to include this ?
As an alternative I added on the SALES REPORT Addon but something appears not to have worked as SALES REPORT is not listed in the drop down list of Reports in the Reports part of the ZenCart Control Panel.
HELP PLEASE my VAT deadline is at the end of this week !!!!
Re: Order Exporter Addon / Sales Report Addon
You have to pay VAT - thats a good sign!!
To get Sales report to show up you need to run the following SQL query:
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('salesReport', 'BOX_REPORTS_SALES_REPORT', 'FILENAME_SALES_REPORT', '', 'reports', 'Y', 999);
Re: Order Exporter Addon / Sales Report Addon
When I did this got
Failed: 1
ERROR: Cannot execute because table admin_pages does not exist. CHECK PREFIXES!
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
Re: Order Exporter Addon / Sales Report Addon
What version of Zen cart are you using?