OLD Super Orders 2.0 (See v3.0 thread instead)

tedcaldwell:

Hi;

Not sure if you're aware of this bug, but I noticed that when you update an order and check the Notify Customer box, it mistakenly sets customer_notified to 0 in the order status history table, which results in a red X instead of a green check mark. I traced the problem to the update_status method in admin/includes/functions/extra_functions/super_orders_functions.php - it checks for $notified being set to 'on', whereas in super_orders.php around line 115 it is set to '1'.

Hope this is useful...

Ted.
Experience same issue, agree with problem location, can't find solution...

Any help?

tedcaldwell:

Hi;

Not sure if you're aware of this bug, but I noticed that when you update an order and check the Notify Customer box, it mistakenly sets customer_notified to 0 in the order status history table, which results in a red X instead of a green check mark. I traced the problem to the update_status method in admin/includes/functions/extra_functions/super_orders_functions.php - it checks for $notified being set to 'on', whereas in super_orders.php around line 115 it is set to '1'.

Hope this is useful...

Ted.

:clap: I've found the solution: :clap:

In admin/includes/functions/extra_functions/super_orders_functions.php,
in function update_status around line 401
change ** if ($notified == 'on') ** to ** if ($notified == 1) **

Because value for function update_status which is going to $notified is not on, but 1

This works for me... Helped to anyone?

This is not the total solution as you will now find that the batch update will not work correctly, you really need to change the code in super_order.php from line 109 ```php
if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
$customer_notified = '0';
if (isset($_POST['notify']) && ($_POST['notify'] == 'on')) {
$customer_notified = '1';
}

      update_status($oID, $status, $customer_notified, $comments);

      if ($customer_notified == '1') {
        email_latest_status($oID);
      }

```php
$notify = $_POST['notify'];
if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
    update_status($oID, $status, $notify, $comments);

    if ($notify == 'on') { 
         email_latest_status($oID);
    }
```Frank knows about this and it will be fixed on the next update
> **loutka:**
>
> **:clap: I've found the solution: :clap:**
> 
> In *admin/includes/functions/extra_functions/super_orders_functions.php*,
> in *function update_status* around line 401 
> change **  if ($notified == 'on') ** to **  if ($notified == 1) **
> 
> Because value for function **update_status** which is going to **$notified** is not **on**, but **1**
> 
> This works for me... Helped to anyone?

Thank you very much...!

Couldn't find solution...

jmeca:

Hello:
I install the super orders but it don't edit product and for me is necesary edit product, change quantitys, prices etc..

Any body konw if is compatible whit "Edit Order" and how i can install it.

Thank you very much for your help.
Regards.

I use both due to flaws in both. For Edit Orders I can't send a comment to the customer without getting an error but I can edit the credit card info so that it doesn't show on the left hand side of the file and I can edit the orders

On Super_Orders I can edit the totals (but not the contents of the orders) and send a comment to the customer.

It's frustrating and would be nice NOT to have to use both and would be wonderful if they were integrated but I have made them work for me.

Now if I can only figure out HOW to make the program calculate the sales tax properly ... I followed the instructions online but it adds tax to the tax so I use Super_Orders to adjust the tax as well.

Beth-katherine

Hi.

I have installed Super-Orders on my ZenCart 1.37 version, but have an issue understanding "Balance Due".

It does not equal the actual total, and I cannot seem to work out how to make it work correctly!

Unless I can fix or understand this, the mod is more or less useless to me.

Please can somebody tell me how to fix this?

Thanks.

chris parker:

Hi.

I have installed Super-Orders on my ZenCart 1.37 version, but have an issue understanding "Balance Due".

It does not equal the actual total, and I cannot seem to work out how to make it work correctly!

Unless I can fix or understand this, the mod is more or less useless to me.

Please can somebody tell me how to fix this?

Thanks.

To add, I have done some looking around and discovered my problem but I do not know the solution.

What happened, is I was using the "Edit Order" mod to change prices on some of the products in an order. This created a new "subtotal","tax amount" and "Total" amount in the table zen_orders_total.

The problem is though, that SuperOrders only reads those figures once - i.e. when the order is submitted, to calculate it's total and tax figures which it then copies across and stores in the zen_orders table under order_total and order_tax.

I had to manually change these using phpMyAdmin.

I really do think that there should be a simple button or link to "refresh totals" in the SuperOrders mod, which re-loads the values from the zen_orders_total table for when we have changed an order.

Is this possible? I'd do it myself but I don't know PHP or SQL, only HTML.

Alternatively, could somebody suggest a different way to give away freebies to special customers? Should I refund them a certain amount of cash or something? How is it done?

Cheers.

EDIT: Actually, an easier way of doing this might be to get SuperOrders to simply get it's totals and tax totals from the the zen_orders_total table instead of zen_orders, seeing as the values change to reflect any order edits automatically.

What happened, is I was using the "Edit Order" mod to change prices on some of the products in an order. This created a new "subtotal","tax amount" and "Total" amount in the table zen_orders_total.

I am also using "EDIT ORDER" and found that, by merely clicking on 'Edit Order Totals' on the "Super Orders" screen and then, without having to change anything, click on 'Submit' in the pop-up, the totals are refreshed and reflects correctly in Super Orders.

Sploodge:

Did anyone manage to incorporate the "Time Zone" mod to work with "Super Orders"?

Its a right pain that Zen Cart does not have a feature to change the time zone globally..

Change line 409 from ```php
now(),

```php
date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR),
``` in admin\includes\functions\extra_functions\super_orders_functions.php.  

The times will now reflect correctly on your order status updates.

OK here one for everyone and anyone that can help me. I was running SO on version 1.3.7 on SQL version 4.1.22. I moved to another server running SQL version 4.1.12 and now when I run batch print or batch status I get a blank page, but the rest of SO seems to be working as usual. I really need the batch function back. any help would be great.

Thanks

I have tried everything. Anyone have ideas as to what would cause a situation where the super orders seem to work but just not the Batch print and status funtions? They both just go to blank pages however I have double checked and confirmed that all files are where they are suposed to be. this was working perfectly until i moved servers and somehow this was the only thing that broke.

wapnoj:

OK here one for everyone and anyone that can help me. I was running SO on version 1.3.7 on SQL version 4.1.22. I moved to another server running SQL version 4.1.12 and now when I run batch print or batch status I get a blank page, but the rest of SO seems to be working as usual. I really need the batch function back. any help would be great.

Thanks

I would suggest using the debug tool by drbyte which can be found at http://www.zen-cart.com/forum/showthread.php?t=84613
Hopefully you will be able to see where the errors are coming from.

wapnoj:

I have tried everything. Anyone have ideas as to what would cause a situation where the super orders seem to work but just not the Batch print and status funtions? They both just go to blank pages however I have double checked and confirmed that all files are where they are suposed to be. this was working perfectly until i moved servers and somehow this was the only thing that broke.

Please help!

I installed this on zencart 1.38 and now when you checkout the order total is wrong.

Here is an example:
Sub-Total: $12.95
Local Pickup (Dallas-Ft Worth Local Pickup): $0.00
Tax: $1.07
Total: $12.22

Please help! I have users trying to make purchases that have emailed me this morning and I dont know how to fix this.

Thank you. I got things working again. I had a error is the log "php fatal bytes exhausted allowed etc" so I just increased the size limit on the server for phoph scripts to 16mb and things came back up. turns out all the files and database were all fine it was just a limitation of the new server. This script uses a pretty good amount.

topcat24:

I would suggest using the debug tool by drbyte which can be found at http://www.zen-cart.com/forum/showthread.php?t=84613
Hopefully you will be able to see where the errors are coming from.

Just in case something else comes across this post having the same problem here is what I found out about my issue...

I had installed the store credit mod. I didn't realize there was a bug in it which was causing my order total to be off. It was actually subtracting the customer credit even though it was not checked to subtract it. That is why the total was off. There was an update to the store credit mod 2 days ago that fixed this.

After finally geting S.O. installed, I am working on the file edits that need to be done. I realized that I am not seeing:

Payment Modules/Purchase Order (doesn't exist)
Admin > Customers > Super Orders (doesn't exist)

Admin > Configuration > Super Orders exists though.

Any suggestions?
Thanks!

wapnoj:

Thank you. I got things working again. I had a error is the log "php fatal bytes exhausted allowed etc" so I just increased the size limit on the server for phoph scripts to 16mb and things came back up. turns out all the files and database were all fine it was just a limitation of the new server. This script uses a pretty good amount.
The batch update/print pages grow based on the size of your store. the more customers and products, the bigger the script, because each tables populate dropdown menus. I already have an ajax-based solution, I just have to apply it to these pages.
HMG:

After finally geting S.O. installed, I am working on the file edits that need to be done. I realized that I am not seeing:

Payment Modules/Purchase Order (doesn't exist)
Admin > Customers > Super Orders (doesn't exist)

Admin > Configuration > Super Orders exists though.

Any suggestions?
Thanks!
You ran the SQL file fine, but your file upload either didn't happen, or you put the files in the wrong place. Make sure you upload the contents of the "admin" folder to the admin in your store. Make sure you don't have something like "admin/admin".

BlindSide:

You ran the SQL file fine, but your file upload either didn't happen, or you put the files in the wrong place. Make sure you upload the contents of the "admin" folder to the admin in your store. Make sure you don't have something like "admin/admin".

Okay, you were of course, correct. Some files were missing. I placed them in the appropriate spot but still do not see the missing categories in the Admin tools. Do I need to re-run the script? If so, any other edits to the script since it's already been installed?

Thanks.

HMG:

Okay, you were of course, correct. Some files were missing. I placed them in the appropriate spot but still do not see the missing categories in the Admin tools. Do I need to re-run the script? If so, any other edits to the script since it's already been installed?

Thanks.

I went ahead and tried to re-run the script, keeping in mind the usual issues with duplicate entries for payment types. I rec'd the following note in the admin console and still see nothing for Super Orders other than in Admin --> Configuration --> Super Orders:

ERROR: Cannot ADD column date_completed because it already exists.
ERROR: Cannot ADD column date_cancelled because it already exists.
ERROR: Cannot ADD column balance_due because it already exists.
ERROR: Cannot create table customers_admin_notes because it already exists
ERROR: Cannot create table so_payments because it already exists
ERROR: Cannot create table so_payment_types because it already exists
ERROR: Cannot create table so_purchase_orders because it already exists
ERROR: Cannot create table so_refunds because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_STATUS" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_PAYTO" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_SORT_ORDER" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_ZONE" because it already exists
ERROR: Cannot insert configuration_key "MODULE_PAYMENT_PURCHASE_ORDER_ORDER_STATUS_ID" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PO" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_PO_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_STATUS_REFUND" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PO_PAYMENT" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_PO" because it already exists
ERROR: Cannot insert configuration_key "AUTO_COMMENTS_REFUND" because it already exists
ERROR: Cannot insert configuration_key "FED_TAX_ID_NUMBER" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_CANCELLED" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_COMPLETED" because it already exists
ERROR: Cannot insert configuration_key "STATUS_ORDER_REOPEN" because it already exists
Note: 25 statements ignored. See "upgrade_exceptions" table for additional details.

how can I reverse the bill to and ship to on the packing slip ?