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 561 to 580 of 882
9 Mar 2012, 3:55 PM
#561
stellarweb avatar

stellarweb

Zen Follower

Join Date:
May 2006
Location:
Montana
Posts:
293
Plugin Contributions:
8

Sales report 2.0

What version of Zen Cart are you running?

sharc316:

Hi,

I've installed this sales report mod but I'm not seeing it in admin under reports.

I've triple checked that I uploaded the file structure correctly. Dont know what to do at this point. Please help...

Thanks

9 Mar 2012, 3:58 PM
#562
sharc316 avatar

sharc316

Zen Follower

Join Date:
Mar 2011
Posts:
160
Plugin Contributions:
0

Re: Sales report 2.0

Your version of Zen Cart™ appears to be current.
(You are presently using: v1.3.9h)

9 Mar 2012, 4:04 PM
#563
stellarweb avatar

stellarweb

Zen Follower

Join Date:
May 2006
Location:
Montana
Posts:
293
Plugin Contributions:
8

Re: Sales report 2.0

Current version of Zen Cart is 1.5.0

I am guessing you downloaded the file written expressly for 1.5.0 instead of the download right below it for 1.3.9

Remove the files you put up on the server and replace them with the ones for your version of Zen Cart and it should work properly for you.

sharc316:

Your version of Zen Cart™ appears to be current.
(You are presently using: v1.3.9h)

9 Mar 2012, 4:06 PM
#564
sharc316 avatar

sharc316

Zen Follower

Join Date:
Mar 2011
Posts:
160
Plugin Contributions:
0

Re: Sales report 2.0

Yep you're right. I see that in the download page.

This might be off topic, but why does it say in my zencart admin that the version is current? Should I upgrade my zencart then?

9 Mar 2012, 4:16 PM
#565
stellarweb avatar

stellarweb

Zen Follower

Join Date:
May 2006
Location:
Montana
Posts:
293
Plugin Contributions:
8

Re: Sales report 2.0

It is always best to have the most current version of any software installed. :cool:

9 Mar 2012, 4:54 PM
#566
sharc316 avatar

sharc316

Zen Follower

Join Date:
Mar 2011
Posts:
160
Plugin Contributions:
0

Re: Sales report 2.0

Ok got it thanks.

I just installed the sales report for my version of zen cart. I seem to have an issue with exporting csc format. The data is all wrong. When I view the sales in print format it seems to display everything correctly with sales tax collected and discounts given with shipping amounts. When I export the same date range into csv everything is not correct at all. Sales taxes are full amounts, not taking to consideration discount coupons and so are the total sales.

Looks like the program just takes quantity sold and multiplies it by price ignoring everything else. Any idea why this is happening?

9 Mar 2012, 5:12 PM
#567
stellarweb avatar

stellarweb

Zen Follower

Join Date:
May 2006
Location:
Montana
Posts:
293
Plugin Contributions:
8

Re: Sales report 2.0

It definitely only gives you the total sale on the export - it does not reduce the total by the discounts, gift certificates, etc.

9 Mar 2012, 5:19 PM
#568
sharc316 avatar

sharc316

Zen Follower

Join Date:
Mar 2011
Posts:
160
Plugin Contributions:
0

Re: Sales report 2.0

Hmm well that's not good at all. It gave me a huge sales tax collected amount. Way more than was actually collected. Is there another mod that would allow to export the actual data? Because this one would give me wrong sales figures on export all the time.

9 Mar 2012, 7:04 PM
#570
sharc316 avatar

sharc316

Zen Follower

Join Date:
Mar 2011
Posts:
160
Plugin Contributions:
0

Re: Sales report 2.0

Thank you for your help.

9 Mar 2012, 8:38 PM
#572
darkangel avatar

darkangel

Totally Zenned

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

Re: Sales report 2.0

sharc316:

Yep you're right. I see that in the download page.

This might be off topic, but why does it say in my zencart admin that the version is current? Should I upgrade my zencart then?

Many of us are holding off upgrading since (especially if heavily modded) the majority of the mods are not updated to work with all changes in 1.5.

But if you are with a totally new store and no mods or just need the ones that are updated already then having the latest version is always better for most any software.

3 Apr 2012, 7:29 PM
#573
abcisme avatar

abcisme

Zen Follower

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

Re: Sales report 2.0

I am using quantity discounts mod. The totals in the report are off. Is there any way to fix this?

3 Apr 2012, 11:33 PM
#574
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,754
Plugin Contributions:
56

Re: Sales report 2.0

I could have sworn I fixed or documented this but it looks like all I did was add Better Together to the list of discounts.

Instructions on fixing it are here:
http://thecartblog.com/2012/04/03/sales-report-and-my-discounting-mods/

If the next person to update the mod would add these fixes that would be great.

Scott

That Software Guy. My Store: Zen Cart Support
Available for hire - See my ad in Services
Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
Do you benefit from Zen Cart? Then please support the project.

3 Apr 2012, 11:41 PM
#575
abcisme avatar

abcisme

Zen Follower

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

Re: Sales report 2.0

Scott, I can't thank you enough. You saved me a sleepless night!

7 Apr 2012, 1:53 PM
#576
abcisme avatar

abcisme

Zen Follower

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

Re: Sales report 2.0

I need to have the order line items report show the payment method and current status of the order. I have already figured out how to add the columns in the report, just not sure how to get the data to display in the line. Can anyone help me out?

29 Apr 2012, 5:38 PM
#577
laurelsstitchery avatar

laurelsstitchery

Zen Follower

Join Date:
Jun 2010
Posts:
145
Plugin Contributions:
0

Re: Sales report 2.0

Just wanted to say a quick thanks for this plugin. I installed it in about five minutes this afternoon and I'm in love with it already! :)

30 Apr 2012, 8:10 PM
#578
irishshopper avatar

irishshopper

Zen Follower

Join Date:
Apr 2010
Location:
County Down, Northern Ireland
Posts:
302
Plugin Contributions:
0

Re: Sales report 2.0

Have installed it to https://www.irishshopper.com using ZenCart 1.3.9b but while no errors were reported cannot find Sales Report as an option in any of the links in Reports or anywhere else in Control Panel.

HELP PLEASE ???

4 Jun 2012, 6:29 PM
#579
abcisme avatar

abcisme

Zen Follower

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

Re: Sales report 2.0

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.
4 Jun 2012, 6:44 PM
#580
spyderrobotics avatar

spyderrobotics

New Zenner

Join Date:
Oct 2007
Posts:
80
Plugin Contributions:
0

Re: Sales report 2.0

I am using the Optional Shipping Insurance Module with my cart and am having a problem with the different sales report modules out there. The insurance module sticks a field called ot_insurance under orders_total. This report doesn't account for the shipping insurance that was charged. Seems like I need a seperate field for the insurance and then also have that added into the total. Or just have the ot_insurance field added right into the shipping total so that it gets accounted for. I looked at the module but its beyond my skill to edit those in. Any help would be greatly appreciated!