Sales report 2.0

[wolfderby]

I know this is a bit old, but I was running into the same problem. The issue is, the report is deducting the sales tax from the product sales, which it should not.

In admin/includes/classes/sales_report.php line 385, I changed it from

$product_price_inc_tax = (zen_add_tax($final_price, $tax) * $quantity) + zen_add_tax($onetime_charges, $tax);

to

$product_price_exc_tax = ($product_price_inc_tax - $product_tax);

Now it calculates correctly. It's a quick hack, but it works. Someone could take the time to make a more elegant solution. I don't understand why it's doing this since Sales Tax is clearly additive to the total.

...so the zen_add_tax( function (see admin/includes/functions/general.php) only adds the price in, if you have DISPLAY_PRICE_WITH_TAX_ADMIN set...

so if you have your zen-cart set-up so that DISPLAY_PRICE_WITH_TAX_ADMIN is 0 or off, your sales tax will appear to be deducted twice, when in fact it was just never really added in admin/includes/classes/sales_report.php line 385

$product_price_inc_tax = (zen_add_tax($final_price, $tax) * $quantity) + zen_add_tax($onetime_charges, $tax);

I changed line 385 to the following

$product_price_inc_tax = zen_round($final_price, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']) + zen_calculate_tax($final_price, $tax);
$product_price_inc_tax += zen_round($onetime_charges, $currencies->currencies[DEFAULT_CURRENCY]['decimal_places']) + zen_calculate_tax($onetime_charges, $tax);

Now I get VALID instead of DON'T MATCH and my tax revenue does not appear to be missing from the report.

[kavlito]

I just installed SALES REPORT Version 2.3.2. I have the same problem with Goods Value subtracting sales tax. Isn't this a basic bug that can be fixed?

I am curious if your changes are working properly and if you ever received feedback?

I appreciate your help.

While I see that this question has got no response to it, it did work for me. Thanks.

[rayzermatic]

Hi,

Can the "order date" be added to the report listing easily? Maybe between ID and Customer.

[lat9]

I've just submitted v3.2.0 of the "Sales Report" to the plugins for review; I'll post back here once it's available.

This version contains the following changes/bugfixes:

[CHANGE] Updated class selector for use under PHP 7.0 and later
[BUGFIX] Column-count "off" for CSV output when taxes are included.
[BUGFIX] Manufacturer filter was not being honored
[CHANGE] Applied PSR-2 styling to the various modules.
[BUGFIX] Correct year display for "Last Year" selection.

[Deno]

Hi

My customer has asked if I can produce a CSV report that has the following data:

Product Ordered
Number Of Products
Price of each product
Price of postage
Destination country of order

Is Sales Report capable of doing this?

Thanks

Dene

[lat9]

Hi

My customer has asked if I can produce a CSV report that has the following data:

Product Ordered
Number Of Products
Price of each product
Price of postage
Destination country of order

Is Sales Report capable of doing this?

Thanks

Dene

With custom modification, yes. It's not something that the plugin does out-of-the-box.

[Deno]

With custom modification, yes. It's not something that the plugin does out-of-the-box.

That sounds good. Is there any documentation I could get that would guide me in that direction?

Thanks

Dene

[lat9]

That sounds good. Is there any documentation I could get that would guide me in that direction?

Thanks

Dene

Unfortunately, the plugin's documentation is sparse at best. You'll be looking to make changes to the plugin's class-file (/admin/includes/classes/sales_report.php) to add the columns that your customer desires.

[Deno]

Thanks for the heads up, i'll check it out...

Dene

[Deno]

Thanks for the heads up, i'll check it out...

Dene

Is there anyone on here that can help me put this together as it's above my head?

I'll like it customizing to prepare a report like above. If this is possible please let me know how much it would cost.

Thanks

Dene