Sales report 2.0

Absolutely, I'll send you a PM.

Jeking - Thanks for your help in testing and giving good feedback. I've submitted a final copy as an update to the sales report package.

Beinart - This should provide the functionality you're looking for too.

It's based off of the 2.2.0 release, so it should have those bug fixes in as well.

I need the reporting by customer as well. I have yearly maximums set for each of my products and need to generate reports to show the quantity of each item a specific customer ordered over a calendar year.

If the current version of Sales Report can generate such a report, can anyone provide instructions on how to do so? Or, if the updated version of Sales Report 2.0 is ready for use, where can I download it? The latest version available was posted in December 2009.

I'm really looking forward to this reporting. It is an integral part of the management of my store.

~Lindsey

The latest version allows you to specify one or more customers and it merges them together. If this is good, PM me and I can send you a copy.

I posted it to the add-ons section. It said it would take a week to get approved, but this was a while ago now.

What it doesn't do is break out the list by customer, in the way it breaks it out by product number or order number.

I'm looking for a report where I can display the following:
- Pull data and generate report by customer name or ID
- Displays the all individual product names the customer ordered
- Displays the quantity of each product the customer ordered
- Report sorted by the date order was placed, date range specific.

Is this what your add-on update can do?

Yes, it can do this.

when I click on this *Yesterday (June 28)* and click *show me the money*.. It shows todays sales (june 29th)

Now I dont have any orders on June 28th, because I deleted them.

If i specify a date like June 1 2010 - june 28th 2010.. i just get todays date showing.

Does it only show orders that were made on a specific day?

Because i had a test order on june 28th and today i went to see if it would show anything on June 28th, and nope it didnt. It would just list June 29th 2010 only..


Also, i like specified a custom date and I just get this

6-29-2010 thru
6-29-2010

is that normal?

thanks

WOW! Holy Crap it works.

I deleted all the files for sales report, installed it. Then I had two test orders I made today June 29. So one of the test orders I went into the database via phpmyadmin, and changed the data from june 29 to june 28 and went back to sales report and click on Yesterday and the report showed the order june 28 and I WAS OH MY GOD THIS WORKS!

Thank you. Now I just need to understand how to use some of the options.

Glad it's working. Just for fun, I dug in and found where the dates entered are used. They generate an SQL query that's >= to the start date AND < the end date+1. All times assume midnight, so your custom date would be

Code:

---

SELECT DISTINCT o.orders_id from zen_orders o
WHERE o.date_purchased >= '2010-06-29 00:00:00' AND o.date_purchased < '2010-06-30 00:00:00'
ORDER BY o.orders_id DESC

---

If you're using presets, and it says "Yesterday (6/29)", it'll do the search for transactions marked in the database 6/29.

My host is actually in a different timezone, those are the times entered in to the database when the transactions happen.

Please excuse my ignorance if this has already been discussed... but one feature of the Sales Reports that would absolutely be phenomenal would be the option to show 'attributes'.

For example. I run a store that sells apparel items. Often I want to know what is my best selling sizes. I'd love to be able to select a group of item, and see what the best selling size is for those items (i.e. mens tshirts).

Also, one thing that always bugged me was there is no 'forever' option on the sales reports. I can pull a sales overall report by day, week, month, and year... but there is no 'forever' option to show all sales reported for the entire time I started running my store up to today. That would be incredibly useful. Especially given the option above... say I wanted to see how many XL's I've sold since I started the store.

Can someone clue me in? Is this possible? Or can it be?