Sales report 2.0

[tianxin]

sorry but where is the link to sales report 2.2 ?
i see the downloads section is version 2.0.

thanks

[whitekisses]

Hi all,

I realised that

1) Sales Report are showing even those deleted orders, can i actually do something to not let them showing up?

2) I realised that Sales Report did not show orders if I shop for them (eg. I use Master Password to log in to their account and shop for them)

Is there anyway to fix both problems?

Thanks alot!

[BlindSide]

1) Sales Report are showing even those deleted orders, can i actually do something to not let them showing up?

They only way to prevent orders from appearing in the Sales Report is to delete them. Not sure how you are "deleting" your orders, but if they are still stored in the DB, they will be processed.

2) I realised that Sales Report did not show orders if I shop for them (eg. I use Master Password to log in to their account and shop for them)

Not sure what you mean here. Any orders in the system are eligible to display in the report; whether or not they display is determined by your report criteria. The fact that you are logging into your users' accounts using the master password is not relevant.

[whitekisses]

Ya i figured that out, i'm just dumb hahaa

But i had another problem, as I use my cart with the Edit Order module, i realised i can't edit those with discounts.

For instance on the Edit Order module,

Total Price: $27
Discount: -$3.00
Total: $24

But it will show up on Sales Report module as;

Goods Value: $27
Discount: -$3.00
Total: $30

I tried without the minus sign, and this is what i get,

Edit Order Module;

Total Price: $27
Discount: $3.00
Total: $30

Sales Report module;

Goods Value: $27
Discount: $3.00
Total: $24

Any idea how to fix it? Thank you so much for your help!

[BlindSide]

The Edit Orders module is not storing the discount value properly. If you can look at your database using a tool like phpMyAdmin, browse the orders_total table. You'll note there's a field called "class." This field is internal to this table (i.e. it's not used anywhere else), and defines exactly the "type" of order total for a given record. Core Zen cart functionality allows discounts to be defined using a class string of either "ot_gv" or "ot_group_pricing". Anything else is considered an expense, and increases the cost.

Based on your examples, it would appear that Edit Orders does not follow this convention, and simply appends a minus sign to the number stored in "value". The Sales Report picks this up as an expense (correctly) and counts accordingly.

I warn people all the time about the Edit Order modules out there. They are based on some way old code, and can cause some serious issues. This is (fortunately) a more minor one.

[redmonds]

Firstly let me say this is an excellent contrib and always one of the first that I install.

I wanted to add something to the wishlist of Sales Report if there is one. I would like to generate reports where the output is more about customers then sales. It seems like it would be easy to add into, or mod from, Sale Reports (he says knowing nothing og PHP or sql).

For example I would like to generate lists of customers that purchase product x, during period y. Or a list of customers that made x number of purchases during period y. Or a list of customers that purchased product A and B either together or seperately. Or a list of customers that have spend more/less then X dollars. Filters also for State, postcode

I have a need for this in trying to select choice customer to get feedback from. For example I could generate a report of everyone that purchased X and then purchased y later. This report would be centred around customer details, showing name, address, phone, order date, order value/products. etc. because this customer made 2 seperate purchases I presume they would have something positive to say about the product or service that they received.

I hope that makes sense. I think it is (logically not code) as simple as generating a customer list with filters for date range, state, post code, order value, product1, product2, number of transactions...

I am currently trying to find a cheap coder to write this for me so am certainly willing to contribute to it being done.

Thanks for listening.

[infocom]

Hi. This is a great reporting mod. But is it possible to change the date format? We need it in dd/mm/yy. I have looked in the files and seems there are loads of references to date("m"), date("d") which I tried swapping but didn't work. Couldn't find a solution on this thread. The Zencart date format does not affect the format of this mod.
Thanks

[infocom]

I also notice another probem... using the Custom date selection results in UK date format (perhaps its based on the Zencart date format we have?) so when we run the query we get an error message saying date format is wrong. i.e. if we choose 30th June 2008 (using Custom box its 30/06/08) we get an error probably because the system thinks 30 is the month.

So please can you let us know how to switch between US/European date formats (mm/dd/yyyy and dd/mm/yyyy). Thanks.

[CES]

Try searching this thread for "conor" and you should find some posts and solutions.

Craig

[athena]

Thanks again for this, Frank. It's come a long way and is quite exciting with my new 1.3.8a install....

I am concerned about the edit orders mod based on your comment.

Have not made this new store live yet...any tips on an alternative? Our goal is to be able to "edit orders" ;)