Forums / Addon Admin Tools / Sales report 2.0

Sales report 2.0

Started by blindside on 29 Aug 2006, 2:41 AM · Views: 248,185

Results 581 to 600 of 882
4 Jun 2012, 6:55 PM
#581
abcisme avatar

abcisme

Zen Follower

Join Date:
Jun 2006
Posts:
298
Plugin Contributions:
0

Sales report 2.0

abcisme:

Am getting the following error when trying to run reports without selecting an order status... Does anyone have any clue how to fix this?

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select orders_status_name from zen_orders_status where orders_status_id = ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


I've determined this to be one particular order status that is causing problems.  Not sure why that would be the case, but when I removed the order associated with that status, I don't get an error anymore.  It happens to be an order status that I added called "cancelled" #116.  No clue what the issue is.
4 Jun 2012, 7:08 PM
#582
abcisme avatar

abcisme

Zen Follower

Join Date:
Jun 2006
Posts:
298
Plugin Contributions:
0

Re: Sales report 2.0

wolfderby:

If you'd like to remove "cancelled" orders from the sales report data (marked "cancelled" through a manually created order status, under admin > localization > order status > "insert")...

Go into your stats_sales_report.php file (in your admin folder) and around line 49 you'll find this line of code

$orders_status = $db->Execute("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . "
                               where language_id = '" . (int)$_SESSION['languages_id'] . "'
                               order by orders_status_id asc");
> 
> you'll want to change it to:
> ```
$orders_status = $db->Execute("SELECT orders_status_id, orders_status_name FROM " . TABLE_ORDERS_STATUS . "
                                   WHERE language_id = '" . (int)$_SESSION['languages_id'] . "' AND NOT (orders_status_id = 5)
                                   ORDER BY orders_status_id asc");

(note: my cancelled order status was the 5th possible status under order status, if your status has a different id number you'll have to change the orders_status_id to the appropriate number)

for other information regarding cancelled orders check here:
http://www.zen-cart.com/forum/showthread.php?t=151168

Did anyone ever actually figure out how to exclude a status from the reports? This just removes it from the dropdown, but it still shows the data on the report.

4 Jun 2012, 7:16 PM
#583
darkangel avatar

darkangel

Totally Zenned

Join Date:
Oct 2007
Location:
Emporia, Kansas
Posts:
1,729
Plugin Contributions:
0

Re: Sales report 2.0

abcisme:

Am getting the following error when trying to run reports without selecting an order status... Does anyone have any clue how to fix this?

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
in:
[select orders_status_name from zen_orders_status where orders_status_id = ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.


Is this a fresh install? was it working before now?

version of zen cart and link would be most helpful

have you opened the zip and compared your server files with the contents to ensure all was uploaded...sometimes they get messed up on upload, I try to reupload them all to their proper places then check if it works properly again
4 Jun 2012, 7:17 PM
#584
abcisme avatar

abcisme

Zen Follower

Join Date:
Jun 2006
Posts:
298
Plugin Contributions:
0

Re: Sales report 2.0

DarkAngel:

Is this a fresh install? was it working before now?

version of zen cart and link would be most helpful

have you opened the zip and compared your server files with the contents to ensure all was uploaded...sometimes they get messed up on upload, I try to reupload them all to their proper places then check if it works properly again

1.3.9h - heavily modified.

It has been working until now. Can't really provide a link, as the report is in my admin.

Just reuploaded and still getting the error. So strange. Wish there were a way to just exclude the cancelled order status.

It's only on the order line items report, and it only happens in timeframes where there is a cancelled order status.

7 Jun 2012, 2:43 PM
#585
iris_karen avatar

iris_karen

New Zenner

Join Date:
May 2012
Location:
Melbourne, Australia
Posts:
15
Plugin Contributions:
0

Re: Sales report 2.0

Hi all,
Running ZC 1.5 & Sales Report 2.0 & Reward Points Module also in use native discount coupons (we also have other mods running)

I am running a monthly report for my manufacturer royalties and I can get the monthly report to show up:
Order ID | Customer | Num Products | Goods Value | Shipping | Discounts | Gift Cert. Sold | Gift Cert. Used | Order Total

However, in the instances where there is a 100% coupon used the discounts is double (instead of $50 - $100) and there is no way to view if a reward point value has been cashed in.

Is there a way to also incorporate the Reward Points value in as a new column and how do I fix the error on the 100% discount voucher?

I can manually go through & update the orders for the report to the manufacturers, but the hope is that the store will get too busy for me to do so! I have yet to install a manufacturers login mod as the ones I've found are too complex (they either treat the store as a mall {manufacturers can update their own products & price values} or they don't allow a manufacturer to simply login each month and see the orders & totals).

We also have installed a basic Order Export which again can show me the orders & how many times a product has been ordered, but no break down of the values in the store and what the final value paid.

Any help would be truly appreciated as I don't want to delay my manufacturers royalites!

IRIS - Karen
https://www.irissimulations.com

Flight Simulation Add-ons for MS: FSX & DCS: World
| web | cart |
v1.5 (reward points; master pw; paypal exp; paymate; orders 2.0 - selling digital software only)

7 Jun 2012, 2:57 PM
#586
iris_karen avatar

iris_karen

New Zenner

Join Date:
May 2012
Location:
Melbourne, Australia
Posts:
15
Plugin Contributions:
0

Re: Sales report 2.0

Apologies for the extra post (I had tried to edit but the option was no longer there).

Here is a screenshot of the settings, and also the error with the discount.
I am hoping this clears up what I was trying to say.

Attachment 10574

Thank you again.

Flight Simulation Add-ons for MS: FSX & DCS: World
| web | cart |
v1.5 (reward points; master pw; paypal exp; paymate; orders 2.0 - selling digital software only)

7 Jun 2012, 6:36 PM
#587
darkangel avatar

darkangel

Totally Zenned

Join Date:
Oct 2007
Location:
Emporia, Kansas
Posts:
1,729
Plugin Contributions:
0

Re: Sales report 2.0

sorry the image does not wish to grow in order to see the setting. I am though able to tell you of the mod that I use called Private Area by customscriptz.com

It allows your vendor to have a login area where they can see what was sold and the price sold at. You have to hunt a bit to customize their vendor page to let them know that pricing shown is with discounts or sale. You add the vendor in the merchants area then go under Tools/Private Area and add (if not already done by system) the vendor, set their commission percentage, email and password--that you assign them and what area they can view (I created a seperate section for each of mine since they are able to upload their product descripts/promo images, if they wish, mine start with ^followed by their name) then set their permissions.

Easy to install and use, has recently been updated for ZC 1.5 too. No I don't work for him I am just one happy customer, it is worth its cost. Might be something to look into. This is his link to the requirements page

16 Jun 2012, 2:36 PM
#588
iris_karen avatar

iris_karen

New Zenner

Join Date:
May 2012
Location:
Melbourne, Australia
Posts:
15
Plugin Contributions:
0

Re: Sales report 2.0

DarkAngel:

sorry the image does not wish to grow in order to see the setting. I am though able to tell you of the mod that I use called Private Area by customscriptz.com

Thank you DarkAngel. At the moment I need to sort out the report before the Private Area (also cost prohibitive) I have however bookmarked the link to look to next month.

Please, anyone with any ideas on how to mod this, I would truly be thankful. I have some sugar cookies if that helps?!?

iris - karen:

Hi all,
Running ZC 1.5 & Sales Report 2.0 & Reward Points Module also in use native discount coupons (we also have other mods running)

Is there a way to also incorporate the Reward Points value in as a new column and how do I fix the error on the 100% discount voucher?

We also have installed a basic Order Export which again can show me the orders & how many times a product has been ordered, but no break down of the values in the store and what the final value paid.

Any help would be truly appreciated as I don't want to delay my manufacturers royalites!

IRIS - Karen
https://www.irissimulations.com

Flight Simulation Add-ons for MS: FSX & DCS: World
| web | cart |
v1.5 (reward points; master pw; paypal exp; paymate; orders 2.0 - selling digital software only)

17 Jun 2012, 8:22 PM
#589
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Yes, I've done that. Requires some more extensive changes. I never released that though.

I could send you some files - you could 'diff' them against yours to see what I did, if it's useful.

abcisme:

Did anyone ever actually figure out how to exclude a status from the reports? This just removes it from the dropdown, but it still shows the data on the report.

1 Jul 2012, 5:08 PM
#590
mariscrap avatar

mariscrap

New Zenner

Join Date:
Jun 2012
Posts:
31
Plugin Contributions:
0

Re: Sales report 2.0

Hi evryone, may some one help me please.

i have a digital scrap book store with some providers.
When I created their private aera I marked "sales report" but it didn't appear for them...how can i can please???

3 Jul 2012, 12:55 PM
#591
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Assuming this is 1.39h zencart - and are you using another plug-in to manage multiple users? Sounds like something isn't quite right to play nice with that plug in.

3 Jul 2012, 8:14 PM
#592
mariscrap avatar

mariscrap

New Zenner

Join Date:
Jun 2012
Posts:
31
Plugin Contributions:
0

Re: Sales report 2.0

I have v1.3.9h and a pluging "private area" install...is that thelp you???

4 Jul 2012, 1:23 AM
#593
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Sorry, I can't find that plugin. Have you tried asking the maker of that plugin for help?

Mariscrap:

I have v1.3.9h and a pluging "private area" install...is that thelp you???

6 Jul 2012, 10:52 AM
#594
mariscrap avatar

mariscrap

New Zenner

Join Date:
Jun 2012
Posts:
31
Plugin Contributions:
0

Re: Sales report 2.0

one more question...I have my fisrt sale today...hip hip...but the prize show was the prize with paypal fees deduct...I chekc my paypal and it was less.
How can I configure sales report to show the prize after paypal fees???

6 Jul 2012, 2:21 PM
#595
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

Congratulations!

As for the paypal fees - it's not a direct configuration change, but could be done with some custom programming.

To be done right, all payment types should be covered, not just paypal. For just the paypal payments, it would require searching a different database (zen_paypal) for records that match the order ID, then summing the mc_gross and mc_fee values to ensure you get all effects of reversals and refunds. This would need to be done for each order. You may want to only subtract mc_fee from the order value so that non-paypal orders are covered, but refunds are not automated (you'd need to manually remove the items from a refunded order).

Combining with SuperOrders may offer help with this too, as non-paypal payments can be tracked with the paypal payments in SO_PAYMENTS. But, I believe this isn't automated until the ZenCart 1.5 version of SO, and I haven't checked it out firsthand so I'm not sure how completely the refunds are implemented.

Mariscrap:

one more question...I have my fisrt sale today...hip hip...but the prize show was the prize with paypal fees deduct...I chekc my paypal and it was less.
How can I configure sales report to show the prize after paypal fees???

6 Jul 2012, 5:05 PM
#596
mariscrap avatar

mariscrap

New Zenner

Join Date:
Jun 2012
Posts:
31
Plugin Contributions:
0

Re: Sales report 2.0

thank you so much , I will look at that!!!

6 Jul 2012, 5:33 PM
#597
divavocals avatar

divavocals

Totally Zenned

Join Date:
Jan 2007
Location:
Los Angeles, California, United States
Posts:
10,011
Plugin Contributions:
3

Re: Sales report 2.0

carlvt88:

Combining with SuperOrders may offer help with this too, as non-paypal payments can be tracked with the paypal payments in SO_PAYMENTS. But, I believe this isn't automated until the ZenCart 1.5 version of SO, and I haven't checked it out firsthand so I'm not sure how completely the refunds are implemented.Only payments are automated in Super Orders 4.0 (the Zen Cart 1.5 version of Super Orders), refunds must still be manually entered..

My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.

16 Jul 2012, 11:55 AM
#598
carlvt88 avatar

carlvt88

Zen Follower

Join Date:
Aug 2007
Location:
Williston, Vermont
Posts:
180
Plugin Contributions:
0

Re: Sales report 2.0

I just posted a new version in the addins section. Sales Report 3.1. It's been checked out against ZenCart 1.5, but won't support older versions of zencart (the 'boxes' were removed in favor of the newer auto-installer method of the admin menus). Thanks too to stellarweb.

Also a couple of new features - ability to omit a selected payment method from the results. I also added some date presets for 'Last year' and 'YTD' (year to date).

Known bug slated for the next release: the up_arrow icon conflicts with the one in Super Orders - I'm renaming the Sales Report icons to up_arrow2 and down_arrow2.

25 Jul 2012, 10:34 AM
#599
dysfunctional avatar

dysfunctional

Zen Follower

Join Date:
Apr 2008
Posts:
159
Plugin Contributions:
0

Re: Sales report 2.0

Hi all,

I've been using Sales Report for years and I love it!

However, I have this new product with 3 attributes and I really must know how many I've sold of each attribute.

Is there a way to export this information? Or should I instead create a product for each attribute (not as fancy :))

Many thanks in advance

Best regards Peter

3 Aug 2012, 3:42 PM
#600
bseller avatar

bseller

New Zenner

Join Date:
Mar 2010
Posts:
8
Plugin Contributions:
0

Re: Sales report 2.0

solosolera:

I really like this report but I have found what I believe is another problem with this report.

Besides the “Goods Value” being the (order value – taxes) the report TOTAL is missing the taxes so there seems to be a tax issue in this report. Also the taxes that are subtracted from the “goods value” are taxes before any discount (I have a group discount).

As it stands now the report’s GOODS VALUE = (order subtotal – taxes (before discount)) and the TOTAL = (order subtotal – discount + shipping) no taxes.

I believe that the GOODS VALUE should be the orders sub-total only and the reports TOTAL should be the orders total (order subtotal – discount + taxes (after discount) + shipping).

Again maybe I’m misinterpreting how this report works so here is an example...

ORDER:

Sub-Total: $69.95

Group Discount: -$3.50

FL State and Local Tax (6.5%): $4.32

United Parcel Service (1 x 5.00lbs) (2nd Day Air): $11.93

Total: $82.70

This report shows:

**Goods Value = 65.40 (should be 69.95)

Total = 78.38 (should be 82.70)**

After several days of trying to figure out how ZC and this report work (I have very little clue) I made some changes to get that results I think the report should give me. Can anyone that knows how this report works and has PHP experience tell me if the changes I made are correct or if they will adversely affect the report in a manner that I’m not aware.

Changes to: admin\includes\classes\sales_report.php

I CHANGED :

$product_price_exc_tax = ($product_price_inc_tax - $product_tax);

> 
> TO:
> 
> ```
$product_price_exc_tax = ($product_price_inc_tax);

I’m obviously screwing with some rules here by changing “$product_price_exc_tax” to equal “$product_price_inc_tax“ but the value used to get the “GOODS VALUE” seems to be "product_price_exc_tax”. So please advice on the consequences of this change.

AND BELOW:

// (goods + tax + shipping + gc_sold) - (discount + gc_used)

I ADDED:

$order_goods_tax = zen_calculate_tax(($order_goods - ($order_discount + $order_gc_used)), $tax) ;

> 
> To get the taxes after any discount.
> 
> Now the report gives me what I believe are the correct values for my scenario:
> 
> **GOODS VALUE = 69.95
> 
> TOTAL = 82.70**
> 
> Can anyone knowledgeable please let me know what they think or if maybe there is some tax setting in ZC that I’m not setting thus getting the results I was getting.
> 
> 
> Thanks…

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.