Forums / All Other Contributions/Addons / Order Exporter Addon / Sales Report Addon

Order Exporter Addon / Sales Report Addon

Started by irishshopper on 24 Apr 2012, 10:09 AM · Views: 1,228

Results 1 to 4 of 4
24 Apr 2012, 10:09 AM
#1
irishshopper avatar

irishshopper

Zen Follower

Join Date:
Apr 2010
Location:
County Down, Northern Ireland
Posts:
302
Plugin Contributions:
0

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 !!!!

24 Apr 2012, 10:55 AM
#2
fermeen avatar

fermeen

New Zenner

Join Date:
Jan 2012
Location:
Galway
Posts:
1
Plugin Contributions:
0

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);

24 Apr 2012, 12:42 PM
#3
irishshopper avatar

irishshopper

Zen Follower

Join Date:
Apr 2010
Location:
County Down, Northern Ireland
Posts:
302
Plugin Contributions:
0

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.

28 Apr 2012, 1:03 PM
#4
objective avatar

objective

New Zenner

Join Date:
Apr 2012
Posts:
1
Plugin Contributions:
0

Re: Order Exporter Addon / Sales Report Addon

What version of Zen cart are you using?