Sales report 2.0

[spyderrobotics]

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!

[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.

[abcisme]

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.

[DarkAngel]

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

[abcisme]

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.

[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)

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
www.irissimulations.com

[iris - karen]

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.



Thank you again.

[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

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

[iris - karen]

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?!?

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
www.irissimulations.com

[carlvt88]

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.

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.