Custom Sales Reports by Product (item total and by qty)

opstech · #71 11-17-2009, 10:18 PM

If this could work for v4.3 that would be fantastic. I am willing to work with anyone to continue this project. Currently I am getting a my_thread_global_end() error after the report runs. Any help is appriciated.

Charon · #72 11-18-2009, 12:09 PM

If anyone is interested, I have completely rewritten this mod to use it in 4.2 and up and integrated it into both the system and through ajax. It is not complete but it has about 20 reprots in it now and I am modding it right now to do graphs and create whatever reports you might like. It also has the ability to save reports that you run. The whole mod is about 50% done, but if anyone is interested in looking and assisting, I will give you the files and the implementation for it. If I finish it and all goes well I will make it into a full addon module. PM me if you are interested at all.

opstech · #73 11-18-2009, 02:58 PM

Quote:

Originally Posted by Charon

If anyone is interested, I have completely rewritten this mod to use it in 4.2 and up and integrated it into both the system and through ajax. It is not complete but it has about 20 reprots in it now and I am modding it right now to do graphs and create whatever reports you might like. It also has the ability to save reports that you run. The whole mod is about 50% done, but if anyone is interested in looking and assisting, I will give you the files and the implementation for it. If I finish it and all goes well I will make it into a full addon module. PM me if you are interested at all.

I will be happy to offer my site up for v4.3 dev and testing. Let me know what I can do to assist.

opstech · #74 11-21-2009, 04:46 PM

Just as a FYI to all looking for product sales / fulfillment / pick list / restock / reports Charon has some excellent reports that I am in the process of testing for him. For the past few years I have looked for useful reports and these are it. I am not sure when he intends on releasing the reports for sale, but in my opinon this is it. Look no further. I will be publishing some screen shots when I have enough sales data to support good quality reports.

lownoma925 · #75 01-15-2010, 08:04 AM

Is there any way to break this down by items sold by month?

ladybird · #76 05-07-2010, 07:44 PM

Quote:

Originally Posted by Charon

If anyone is interested, I have completely rewritten this mod to use it in 4.2 and up and integrated it into both the system and through ajax. It is not complete but it has about 20 reprots in it now and I am modding it right now to do graphs and create whatever reports you might like. It also has the ability to save reports that you run. The whole mod is about 50% done, but if anyone is interested in looking and assisting, I will give you the files and the implementation for it. If I finish it and all goes well I will make it into a full addon module. PM me if you are interested at all.

I am using 4.1.9 and am adding a fresh fruit and vegetable service to our site... what I want to be able to do is print a report once a day that summarises all the products sold by category, so I can order teh correct amount of fruit and vege from my supply - can anyohne help me here?

Thanks

Ladybird.

peakay · #77 05-21-2010, 01:48 PM

This script works for me (thanks to the developer), BUT our skus are all at the variant/option level, so this only shows a total of sales by the product category, not to our sku level.

Does anyone know if this can be used to get down to the variant/option level?

thanks!

peakay · #78 07-01-2010, 02:00 PM

Quote:

Originally Posted by peakay

This script works for me (thanks to the developer), BUT our skus are all at the variant/option level, so this only shows a total of sales by the product category, not to our sku level.

Does anyone know if this can be used to get down to the variant/option level?

Nobody has any ideas on this? the script is exactly what we need, but all our sales are at the variant/option level and the report as-is does not tell us this.

thanks!

peakay · #79 08-06-2010, 08:34 AM

bump.

Learner · #80 09-14-2010, 04:18 AM

Quote:

Originally Posted by Charon

If anyone is interested, I have completely rewritten this mod to use it in 4.2 and up and integrated it into both the system and through ajax. It is not complete but it has about 20 reprots in it now and I am modding it right now to do graphs and create whatever reports you might like. It also has the ability to save reports that you run. The whole mod is about 50% done, but if anyone is interested in looking and assisting, I will give you the files and the implementation for it. If I finish it and all goes well I will make it into a full addon module. PM me if you are interested at all.

I have seen your post and Jeremy has done a great jobs.

Can you help me to do the report in this format additionally-

1) Report by manufacturer wise as I have Pro.

2) Top selling Brands(manufacturer)
field-Name,No of orders,% of total, Total value.

3) Also Top selling Category
field-Name,No of orders,% of total, Total value.

4)Report by customer or user wise
field- Existing,New

5)Unique Order(order by coupon or gift certificate)
field-No,Value

6)Lastly this report will be display from admin area by login only not from outside.

I have x cart Pro 4.1.9.

Can you give me all of the requirements.If not then send at least your modified files.

Waiting for your reply.