Sales report 2.0

[kavlito]

hi. I installed sales report 2.3.0 by carlvt88. There is a new feature for reporting on product ids. However, when i enter my product id's and run the report, i get the following error:

1054 unknown column 'artekz1' in 'where clause'
in:
[select distinct pd.products_name from zen_products_description pd where products_id = artekz1]

i found the code in /admin/stats_sales_report.php on line 643. However, i am not a php programmer so i cannot troubleshoot the code.

Any thoughts?

Thanks in advance.

silly me! I was using sku's instead of product id's...

[solosolera]

Hi all,

I’m new using zencart and just I installed "Sales Report 2.3.0" but I think that “Goods Value” is off thus the reason why my totals are also off. Maybe this has been answered but can’t seem to find where or I’m misinterpreting the meaning of “Goods Value”. From what I can tell “Goods Value” is the sub-total of “goods sold” – taxes and I think it should be just the value of goods sold. Is there a reason why you would subtract the sales tax from the orders sub-total to get the value of “Goods Value” and not just report the orders sub-total?

Any help on this matter would be greatly appreciated since I like this report...

zc 1.3.9f

Thanks ahead of time..

[DML73]

I installed and played around with this module, it definately is great! However, just to make sure, am I correct that I cannot get a csv file with both the customer (eg name and shipping address) data AND the product data (eg product model number and price)?

[solosolera]

Hi all,

I’m new using zencart and just I installed "Sales Report 2.3.0" but I think that “Goods Value” is off thus the reason why my totals are also off. Maybe this has been answered but can’t seem to find where or I’m misinterpreting the meaning of “Goods Value”. From what I can tell “Goods Value” is the sub-total of “goods sold” – taxes and I think it should be just the value of goods sold. Is there a reason why you would subtract the sales tax from the orders sub-total to get the value of “Goods Value” and not just report the orders sub-total?

Any help on this matter would be greatly appreciated since I like this report...

zc 1.3.9f

Thanks ahead of time..

I really like this report but I have found what I believe is another problem with this report.

Besides the “Goods Value” being the (order value – taxes) the report TOTAL is missing the taxes so there seems to be a tax issue in this report. Also the taxes that are subtracted from the “goods value” are taxes before any discount (I have a group discount).

As it stands now the report’s GOODS VALUE = (order subtotal – taxes (before discount)) and the TOTAL = (order subtotal – discount + shipping) no taxes.

I believe that the GOODS VALUE should be the orders sub-total only and the reports TOTAL should be the orders total (order subtotal – discount + taxes (after discount) + shipping).

Again maybe I’m misinterpreting how this report works so here is an example...

ORDER:

Sub-Total: $69.95

Group Discount: -$3.50

FL State and Local Tax (6.5%): $4.32

United Parcel Service (1 x 5.00lbs) (2nd Day Air): $11.93

Total: $82.70

This report shows:

Goods Value = 65.40 (should be 69.95)

Total = 78.38 (should be 82.70)

After several days of trying to figure out how ZC and this report work (I have very little clue) I made some changes to get that results I think the report should give me. Can anyone that knows how this report works and has PHP experience tell me if the changes I made are correct or if they will adversely affect the report in a manner that I’m not aware.

Changes to: admin\includes\classes\sales_report.php

I CHANGED :

$product_price_exc_tax = ($product_price_inc_tax - $product_tax);

TO:

$product_price_exc_tax = ($product_price_inc_tax);

I’m obviously screwing with some rules here by changing “$product_price_exc_tax” to equal “$product_price_inc_tax“ but the value used to get the “GOODS VALUE” seems to be "product_price_exc_tax”. So please advice on the consequences of this change.

AND BELOW:

// (goods + tax + shipping + gc_sold) - (discount + gc_used)

I ADDED:

$order_goods_tax = zen_calculate_tax(($order_goods - ($order_discount + $order_gc_used)), $tax) ;

To get the taxes after any discount.

Now the report gives me what I believe are the correct values for my scenario:

GOODS VALUE = 69.95

TOTAL = 82.70

Can anyone knowledgeable please let me know what they think or if maybe there is some tax setting in ZC that I’m not setting thus getting the results I was getting.


Thanks…

[dave3009]

Hi

I searched the thread and could only find one reference to this question, and didn't see any solution. Hopefully someone can help. I was hoping to be able to include 'company name' in the +order line report. I can add the required column but lack the talent to actually populate the information from the database.

Any help would be greatly appreciated.

TIA

Dave

[wearethecure]

Hi dave3009,

Have you found the answer to your question? Because I have the same problem. I can get reports of total sales for a day, week or month but I cannot get a report that shows each individual sales, the name of the person, their address and what they ordered. Then I would love to export that to an excel sheet so I could print up shipping labels. So if you have discovered the answer or anyone else has the answer I would love to know

Gary

[carlvt88]

have you looked at the Super Orders add-in? It has a feature for batch-status-update and batch-form-print that I use to print invoices / packing slips for orders that haven't been shipped. I then update those orders to the 'shipped' status. It lines up with window envelopes too.

[swguy]

Posted version 2.3.1.

- Added "today" as a selection
- fixed a bug where defaults didn't work when some of the lists were empty (such as manufacturer).

[icemanchai]

Titles, drop menu and radio options of "Sort products by..." and "Then sort by..." are totally disappeared when using with non-english languages even have translated language files.

What can I do to make them display? Please help.

Thank you.

[icemanchai]

I solved the problem of showing "Sort products by" and "Then sort by" by inputting the correct date format in

define('DEFAULT_START_DATE' &

define('DEFAULT_END_DATE'

in language files.