Sales report 2.0

[wmarcy]

I was wondering if there was some way to do this:

I want to feed a URL to my ezpages so that a manufacturer (actually an author but, hey!), could access their designated ezpage and have a sales report run for the, month to date would be fine.

So what I am asking for, is there some way to generate the sales report via the URL, with the report defaults built into it? (say, monthly, manufacturer)

[BlindSide]

Sure, run the report, then take a look at the URL.

[wmarcy]

Blah, must be one of those kinda days for me <s>.

Any way to lose the report header (allowing someone to re-run the report? I just want to display the data.

I would gather I could display it frm the CSV, but that is outta my ken right now.

[bettysue]

Please excuse me if I missed thi ssomewhere in the past 14 pages.

I have some custom fields added to my products that I need to show up on sales reports. Does this reporting system pull all info from sales? For example I have added a redular field for UPC code, and in my attributes for downloads have also added a place to put UPC codes and ISRC codes (needed on every song). The ISRC codes from sales need to be transmitted daily to an agency.

We hired a programmer, however he disappeared after putting in the fields for the UPC and ISRC and never installed the reporting system.

thank you,
betty

[BlindSide]

Blah, must be one of those kinda days for me <s>.

Any way to lose the report header (allowing someone to re-run the report? I just want to display the data.

I would gather I could display it frm the CSV, but that is outta my ken right now.

Well obviously for your needs, you'll need to modify the basic contrib. Fortunately for you, all the calculations are done in an independent class file; you'll just need to call and feed it the necessary info, then handle the output. I think you're going to need a pretty solid PHP foundation for this project; and if you don't have one, this will definitely supply it.

I have some custom fields added to my products that I need to show up on sales reports. Does this reporting system pull all info from sales? For example I have added a redular field for UPC code, and in my attributes for downloads have also added a place to put UPC codes and ISRC codes (needed on every song). The ISRC codes from sales need to be transmitted daily to an agency.

There's no "plug-in" way to add fields, it's all custom. However if you've added the fields to the product table, you should be able to add them without much trouble. You'll need to modify the class file to find and collect the field, then the display file to actually output it. It will require basic programming knowhow, however.

We hired a programmer, however he disappeared after putting in the fields for the UPC and ISRC and never installed the reporting system.

I hear stories about disappearing programmers way more than I should, it's a real shame. I promise we're not all like that.

[jeffmic]

Blindside,

Is there a proper method to do the following in your contribution?
I've search quite a bit in the language file and this forum, but I can't find all the info I need.

1. I'd like to remove the following columns from the screen display and maybe the csv output.

Base Price, Tax, Total, Product Total

I just need Product ID, Product Name Model No. and Quantity to show for output to my suppliers for sales.
I know I can delete columns when it gets to Excel, but I'l trying to see if I can streamline it and get it right on the first pass.


2. Is there a way to modify the output from csv to text.
I have various product names that have commas in them.
When I open the csv file in Excel, the items with the extra commas get pushed over to the next Excel column with each comma in the name.
This probably won't happen in a text output.


3. Is there a way to look up multiple manufacturers at once if I modify the URL? I tried it a couple times, but it only found the first one.
Is it only set up to do 1 manufacturer or all?

thank you for your time.....

Jeff

[MB1]

i have a quantity discount module running and i just noticed that on a report it doesn't show this discount at all? is there a way i can do this? it only shows the group discounts and becasue of this the reports are wrong

[BlindSide]

1. I'd like to remove the following columns from the screen display and maybe the csv output.

Base Price, Tax, Total, Product Total

I just need Product ID, Product Name Model No. and Quantity to show for output to my suppliers for sales.
I know I can delete columns when it gets to Excel, but I'l trying to see if I can streamline it and get it right on the first pass.

Simple, just find those outputted columns in the report and comment them out. The regular and print displays will be in admin/stats_sales_report.php, and the CSV is located within the class, admin/includes/classes/sales_report.php. Don't forget to comment out the header column as well.

2. Is there a way to modify the output from csv to text.
I have various product names that have commas in them.
When I open the csv file in Excel, the items with the extra commas get pushed over to the next Excel column with each comma in the name.
This probably won't happen in a text output.

By it's very nature, you can't have commas in a field in CSV files. SO you can either (1) remove all the commas through the admin, or (2) dynamically remove commas from product names when running a CSV. I'll assume you voted for the latter. Open the class file (see above) and find this line:

echo $p_data['name'] . CSV_SEPARATOR;

Change it to read as follows (new code in bold):

echo str_replace(',', '', $p_data['name']) . CSV_SEPARATOR;

Repeat for any other fields where you use commas.

3. Is there a way to look up multiple manufacturers at once if I modify the URL? I tried it a couple times, but it only found the first one.
Is it only set up to do 1 manufacturer or all?

The manufacturer filter was added specifically for users who generate per manufacturer reports to deliver to their contracted suppliers. In that case you only ever need to see one. I suppose I could add the ability to do one or more, but that's more logic that I just don't have time for right now...

Best best is to not use the filter, and instead sort by manufacturer in the product line item display.[/quote]

thank you for your time.....

Your welcome!

i have a quantity discount module running and i just noticed that on a report it doesn't show this discount at all? is there a way i can do this? it only shows the group discounts and becasue of this the reports are wrong

The report calculates based on actual quantities sold and purchase price, so any per product discounts should automagically be calculated in.

Try this. Run the report for a timeframe that includes several orders for your qty-discounted product, and use per product line items. Take a look at the Base Price, Qty., and {B]Product Total[/B] fields. The math probably doesn't match up, which I think prompted your post.

But what you don't realize is that the Product Total field actually contains the correct value. Base Price is gathered the first time a given product_id is hit upon. It obviously could be different, but I can't display every base value for the the product on a single line. So it's a bit of an assumption, but it's usually correct, and when it's not the Product Total is always correct. Check the math if you're still unsure.

[MB1]

no it's all off it calculates the group discount but not the quantity discount. and when i tallied up the product totals it was way off.

for yesterdays single order the main total was right if you took off the quantity discount, as for the individual product totals they were to high the totals were bang on.

invoice total was 1,725, the sales report total was 2035.82 (if you took off the quantity discount of 310.59 it would be aok) and if you calculate the product totals you get 2443.58.

anysugestions?

[jeffmic]

Thanks so much for your help.
I was able to customize my screen and csv layouts exactly as I needed.

This is a wonderful add on!

Jeff