Sales report 2.0

[docfx]

changed this:
$product_tax = (zen_calculate_tax($onetime_charges, $tax)) +
(zen_calculate_tax(($final_price * $quantity), $tax));

to this:
$product_tax = (zen_calculate_tax(($final_price * $quantity), $tax));

Sorry, this is a blind alley... didn't fix the symptom after all. Problem still exists in PROD section of report, but not in the TIMELINE or ORDER sections of report. Turned on the "DISPLAY ONE-TIME FEES" category in the report and it shows 0 in fees.

<sigh>back to the drawing board</sigh>

[scottydvt]

BlindSide,

Just an FYI - I needed a quick tax report by region, so I started with your Order Line Items report and modified it to print tax region line items. Each line item is a sum of all taxable sales in a region over that timeframe.

The result is a report that lets you see your total sales and taxes for each region where you have to remit taxes. I'd be happy to share the code if anyone else would find this useful.

Scott

[BlindSide]

Sure! PM me with the details, I'll give you an e-mail address where you can send files (if necessary).

[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

[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