Sales report 2.0

[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

[MB1]

anyword on how i can get the quantity discount to show as default?

[candywrap]

Does anyone have this mod working on 1.3.7?
I have installed it on my fresh install of 1.3.7, but no "Sales Report" comes up under "Reports" in the Admin.

[candywrap]

Does anyone have this mod working on 1.3.7?
I have installed it on my fresh install of 1.3.7, but no "Sales Report" comes up under "Reports" in the Admin.

Doh! Never mind. Forgot I re-named my admin folder for security reasons.

[FullUp]

I just installed Sales Report (rev 104) on a fresh copy of Zen-cart 1.3.7. When I click on Sales Report from the admin/reports/ menu I get a blank screen. Any thoughts or help would be appreciated.