Sales report 2.0

Is there anyway to get the sales report to show product attributes? Would be a good addition to Sales Report 3.0... I saw that the old zen-cart sales reports included attributes, but the new one doesn't.... Sort of a step backwards, anyway if you are looking to include another feature consider allowing the stats to be shown by attribute. Thanks! :yes:

Hello!

I installed version 2.2.0 and can see that I can group orders by month, but I would also like to further separate them by customer ID. Is this possible?

If not, does anyone know if there is a similar contribution that can do this, i.e. "view orders by customer per month"?

Thanks!

edit: I see that I can already display by "Order ID" - is it possible to group the results together that are by the same customer? I have a bit of PHP/MySQL experience so am prepared to do some hacking if needed - just need to be pointed in the right direction!

Seems like the stock sales report system is a bit lacking and I'd be intereted in a 3rd party sales report system that can display product attributes, but I'd also like to be able to generate sales reports based more criteria than is included in the stock sales report. Any thoughts? Good luck with your customization, wish I could help. Seem like a weak link in the system. :oops:


:cry:

Quote:

---

Originally Posted by zepher

Is there anyway to get the sales report to show product attributes? Would be a good addition to Sales Report 3.0... I saw that the old zen-cart sales reports included attributes, but the new one doesn't.... Sort of a step backwards, anyway if you are looking to include another feature consider allowing the stats to be shown by attribute. Thanks! :yes:

---

Quote:

---

Originally Posted by k4satin

Any response on this? I already have a cost field in my db from 'cash on hand' calculator. Would love to have a column added to sales report with the cost field! It doesn't seem like it would be hard to do.

---

I'm wondering if this has ever been added too. This would be an awesome addition. Any word on adding a way to measure cost in this report? The sales report is a great mod! Thanks so much for offering it to us!

Quote:

---

Originally Posted by IronTank

Hi,

I don't know if I'm asking this in the correct topic. If not, I apologize and please direct me to the right topic. :oops:
I had asked the same question in another topic regarding a similar report module, but thought I'd try here also. :blush:

I want to keep track of the product cost( the price I pay for) and the price I sell it for, so that I can keep track of Revenue. So, in addition to the sales reports, I was wondering if this module have revenue reports.

I had thought this is what the NET and GROSS prices are for while adding the products, but after some research it turns out they are for taxing products.

I'm thinking maybe the Product Cost has to be added while I'm adding the products... so this might be the wrong topic. But, maybe this module could include a feature where I could put in a product's cost(price I paid for).

Sorry if I'm asking, and this is already available in ZC. I'm new to ZC's system :blush:

Thanks much in advance!
ITF :bigups:

---

It looks like quite a few folks would love to have this addtion. Anyone working on adding this?

Quote:

---

Originally Posted by wickedklown

sorry to slam this forum over and over. but the questions are just flying right now....

as i dig into the new sales report, i notice that order which have been set to canceled, or refunded, are still showing up in the report as a sale. but we cant account for that money since it was refunded. sometimes we give store credit, but that is set under another status.

but in any event, how would i setup super orders, to not calculate that order as a sale, since it was refunded. i use the refunded button and return the money to reflect in the total *shows customer still owes whole balance again* then i look at the report and its still being calculated in the total.

so how do i set it up, maybe im running super orders wrong, and its not understanding that it was a canceled order. im sure some of you guys are pros with this, so just fill me in... please..

also, what exactly do that COMPLETED and CANCELED buttons do on the bottom of the order? im using those too, but they dont see to do anything, at least that i can tell.

---

Quote:

---

Originally Posted by wickedklown

well im looking into your report now.
and im not sure if i found errors, or what

but for some reason, i have a guy that orderd 1 item, at 55.67 total w/ shipping.

for some reason, when i pull up his order with the sales report, its showing 5428.89 with 108 products in his order. whats up with that? im filtering by manufacture, and +product line for display. on last month.
ALSO- along with that- when i display by +Order Line, it shows me all the orders from that timeframe, but its only calculating items from the selected manufacture, correct? and only the goods value?

when i change it to show (dont matter) for the manufacture, it displays correct for his order. and i see no problems.

im also noticing that its calculating shipping costs for some that didnt order those manufacture items. why is that? dont calc the goods value (i assume becuase its not the selected manufacture) but it is calculating its shipping total. and for those orders that do have the selected manufacture its calcuating the goods value and not the shipping.. am i missing somthing?

why is it working like that?

any help would be great

---

I'm pretty sure that since it's not the core functionality of zen-cart to cancel re-stock refund or return an order, it's going to be pretty hard for the sales report add-on to incorporate the functions of another add-on.

Perhaps if we can figure out how to include a commented out if statement in the code that people can uncomment if they have the super orders add-on installed, that will no include figures from refunded products/orders?

Also in the mean time I just deleted the row for the order from the orders table in my database directly.

If you'd like to remove "cancelled" orders from the sales report data (marked "cancelled" through a manually created order status, under admin > localization > order status > "insert")...

Go into your stats_sales_report.php file (in your admin folder) and around line 49 you'll find this line of code

Code:

---

    $orders_status = $db->Execute("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . "
                                  where language_id = '" . (int)$_SESSION['languages_id'] . "'
                                  order by orders_status_id asc");

---

you'll want to change it to:

Code:

---

$orders_status = $db->Execute("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . "
                                  WHERE language_id = '" . (int)$_SESSION['languages_id'] . "' AND NOT (orders_status_id = 5)
                                  ORDER BY orders_status_id asc");

---

(note: my cancelled order status was the 5th possible status under order status, if your status has a different id number you'll have to change the orders_status_id to the appropriate number)

for other information regarding cancelled orders check here:
http://www.zen-cart.com/forum/showthread.php?t=151168

Quote:

---

Originally Posted by wolfderby

Go into your stats_sales_report.php file (in your admin folder) and around line 49 you'll find this line of code

---

Oh... I was soooo excited to see this option, :clap: and I have replaced the line as suggested (my cancelled status was 4), yet the report does not exclude those items in status 4. :dontgetit

Interestingly enough, when I run the report to *include* only cancelled items I get correct numbers, so I know I have my status correct, and I am sure I am editing the correct file since I thought maybe I had put my code in the wrong line so I put it in the instance of that text higher up on the page and it removed status '4' from my drop-box of choices. I fixed that but am not sure what to try next. :lookaroun

Any suggestions would be appreciated! :bigups:

Oh, the version I am using is:
SALES REPORT 2.2.0RC1
on the Zen Cart 1.3.8p3 build

Will this add-on allow me to find out how many orders I have received of a particular item over a chosen time period? I'm very new to all of this!