Sales report 2.0

[Mr_B]

Great Mod,

Have it running on my Site using ver. 1.3.8.

Again Great Mod

[BlindSide]

Hey guys!

Saw the fixes you made. Love it! I've got them in the main module repository now. I'm going to try and push out a new version asap.

Also, for anyone wondering where the hell I've been.

[wapnoj]

This is great. I had an older version and upgraded. seems to work fine on 1.3.7, however I would do a back flip if this could show an attribute breakdown as well as products. I have sizes for clothes. It would be AWESOME to be able to se in a given timeframe the amount of every size that I sold. I have read some references to attributes in the mod but I have not seen them am I missing somthing?

thanks!!!

[BlindSide]

That request comes up every few months, but the reason stays the same: you cannot display attributes in a line item basis on a report with multiple products. Here's a little background:

http://www.zen-cart.com/forum/showpo...9&postcount=89

[sky1]

When I install a new product, I don't have the Profit Margin Calculator.
I have just installed Zen Cart 1.3.7
Am I missing something.

[wapnoj]

Yes I understand. thanks, however there must be away to account for individual sizes, colors etc. attributes. I love ZenCart but its getting impossible to account for dailey sales due to the lack of reporting at the attribute level. Does anyone have any suggestions?

I would really appreciate any advice.

That request comes up every few months, but the reason stays the same: you cannot display attributes in a line item basis on a report with multiple products. Here's a little background:

http://www.zen-cart.com/forum/showpo...9&postcount=89

[BlindSide]

When I install a new product, I don't have the Profit Margin Calculator.
I have just installed Zen Cart 1.3.7
Am I missing something.

That's not part of the Sales Report, and I'm pretty sure that's not part of the core either. Is this a 3rd party module you installed? Regardless, this isn't the thread you need.

Yes I understand. thanks, however there must be away to account for individual sizes, colors etc. attributes. I love ZenCart but its getting impossible to account for dailey sales due to the lack of reporting at the attribute level. Does anyone have any suggestions?

I would really appreciate any advice.

It's been a known problem for some time. Most Dev team effort has focused on the catalog side, and the reporting etc has remained woefully short in the meantime.

However there is light at the end of the tunnel starting in 1.4, which includes inventory tracking at the attribute level. You can read about it in the project roadmap.

Until then you're just going to have to sit tight; I have no plans to write code that will be outdated in the next 12 months or less.

[wapnoj]

Thanks...knowing that there is a light at the end of the tunnel makes all the difference for me. The roadmap looks great. Can't wait......but I will. HAHA

It's been a known problem for some time. Most Dev team effort has focused on the catalog side, and the reporting etc has remained woefully short in the meantime.

However there is light at the end of the tunnel starting in 1.4, which includes inventory tracking at the attribute level. You can read about it in the project roadmap.

Until then you're just going to have to sit tight; I have no plans to write code that will be outdated in the next 12 months or less.

[talisman-studios]

Alright so I've had a request to do something, I was hoping the sales report modules was going to cover all the monthly financial analysis needs and it actually might but I don't think so. Being hideously out of date with programming doing this myself could be 'interesting' even though it really doesn't strike me as the sort of thing that should be that tough - time consuming maybe. So I'm putting out the feelers now. I wants a report that can produce the following for a given calendar month:

OrderNo
Customer
Date
From Email Address
Address Line 1
Address Line 2/District
Town/City
State/Province/Region/County/Territory/Prefecture/Republic
Postcode
Country
ProductModel
ProductName
ProductPrice
SellPrice
Quantity
Total Earnings

Ideally outputting to csv file when done.

So folks, what do you think? Can this be done in sales report at present? If not would it be easier to add it to the functionality offered or to create something new. I just need to be able to gather this information and would like some pointers from those that might just know better where would be a good place to start. Should I even be trying to do this through the zen cart interface/reports?

[sky1]

I have just installed "Products Profit/Margin Calculator + Report" witch has given me extra features such as.

Profit Margin CalculatorProducts Cost: Markup Percent : %Gross Margin $: Gross Margin %: %