Super Orders v4.0 Support Thread for ZC v1.5.x

ShopVille:

Hi
I need help making a minor modifications, namely i need the amounts in the so_payments tables to be stored with the full decimals, now it will drop for example amount 10.00 will be stored as 10
This was correct, was wrong on my side thanks anyway.

As i post already I will also ask, is it possible to modify the virtual merchant module so that it integrates better with super orders just like paypal that the transaction ID & details etc. are stored and visible on the order page?

ShopVille:

This was correct, was wrong on my side thanks anyway.

As i post already I will also ask, is it possible to modify the virtual merchant module so that it integrates better with super orders just like paypal that the transaction ID & details etc. are stored and visible on the order page?

Don't know this module.. so I have no clue.. if you figure it out, submit a pull request on the Super Orders Github repo..

Ok I have found something that doesn't seem right - but I do not know if this is how it should should work

"Split orders"

We selected an order - highlighted the item that is NO in stock at this time and said split order

now:

1. the original order price drops to the amount of just those items in stock (as fully paid for this I don't want this to happen)
2. a new order is created (does it have too?) but no price is shown on the order details page - shows up blank
3. the original order says - this has been split with ? and then blank - ie no new number created or mentioned?
4. the item that was split off gets dropped - ie doesn't show up anywhere - neither orders show it - anything selected got dropped!
5. the full price shows on the child order - but no details are shown - just a link to a packing slip - which shows the other product with a red cross on it
6. original packing slip does show the item with a tick - but again anything we ticked has got lost

1.5.4

Any ideas what has gone wonky?

Was using older Super orders 139 - recently upgraded shop and plugin - but I had not tested the split orders until today

Any thoughts?

If it helps what we want is:

1. select "Split orders" and just have a packing slip created that has the red cross/green tick against items - as that is what is sent to client so they know we know about them and will follow

Debating if uninstalling is the best way - but first I am off to figure out what the zen cart standard does split orders wise if any

Thanks
Sarah

Hi guys,

I wonder if anyone can help me. I've recently installed Edit_Orders_4.1.4 and Admin_New_Order_1.4 and everything works beautifully. Yesterday I installed Super_Orders_4.0.9 and most features are working well. I have one (fairly major) problem and one (smaller) inconvenience that I'm trying to sort out.

The main reason that I installed Super_Orders is to make our payment management easier. We have many regular customers that will phone in their order, have us deliver the order and make the payment afterwards. (They are essentially placing a purchase order over the phone.) Previously we were using Admin_New_Order to add their order to our system from admin and using the order status to try to track payments.

I was hoping to use Super_Orders to place purchase orders and use that to track payments and draw payment reports. Unfortunately it seems like there is no way to select the payment method when placing an order from admin with Admin_New_Order and this means that the orders don't show up in the "Orders awaiting payment" report.

Is there any way around this? Can I somehow set an order as a purchase order after it has been placed to allow it to show up in the "Orders awaiting payment" report?

My minor inconvenience is that after installing Super_Orders, when I click the "Invoice" button, the invoice page doesn't load at all. I've replaced the invoice.php file that comes with Super_Orders with my backup from before installing and it then seems to load and work fine, albeit without any of the Super_Orders advatanges/changes.

Any help with any of these two issues will be much appreciated. Thanks :)

Loose_Moose:

The main reason that I installed Super_Orders is to make our payment management easier. We have many regular customers that will phone in their order, have us deliver the order and make the payment afterwards. (They are essentially placing a purchase order over the phone.) Previously we were using Admin_New_Order to add their order to our system from admin and using the order status to try to track payments.

I was hoping to use Super_Orders to place purchase orders and use that to track payments and draw payment reports. Unfortunately it seems like there is no way to select the payment method when placing an order from admin with Admin_New_Order and this means that the orders don't show up in the "Orders awaiting payment" report.

Is there any way around this? Can I somehow set an order as a purchase order after it has been placed to allow it to show up in the "Orders awaiting payment" report?
You will have to ask the author/maintainer of the Admin Add New Order module how to include a payment method with orders you create on the back end.. Not really a fix/mod to Super Orders..
Loose_Moose:

My minor inconvenience is that after installing Super_Orders, when I click the "Invoice" button, the invoice page doesn't load at all. I've replaced the invoice.php file that comes with Super_Orders with my backup from before installing and it then seems to load and work fine, albeit without any of the Super_Orders advatanges/changes.When I have time I will investigate/test the invoice function.. Dunno when I'll be able to get to this..

Hey Diva don't suppose you have any thoughts on my post above? ie the split orders part? thanks :)

SarahL:

Hey Diva don't suppose you have any thoughts on my post above? ie the split orders part? thanks :)

To my knowledge split orders works.. when I have time to test I will..

has anyone else got this appearing in their log files?

[13-Aug-2015 21:13:57 UTC] PHP Warning:  mysql_query(): Access denied for user ''@'localhost' (using password: NO) in /xxx/admin/orders.php on line 1217
[13-Aug-2015 21:13:57 UTC] PHP Warning:  mysql_query(): A link to the server could not be established in /xxx/admin/orders.php on line 1217
[13-Aug-2015 21:13:57 UTC] PHP Warning:  mysql_fetch_array() expects parameter 1 to be resource, boolean given in /xxx/admin/orders.php on line 1218

its generated a huge amount of log files - 1000's per day
looked like the wrong SQL code was being used

so locate admin/orders.php line 1215-1222

<!-- BOF added to get currency type and value for totals -->
                <?php $dbc="select currency, currency_value from " . TABLE_ORDERS . " where orders_id ='" . $_GET['oID'] . "'";
                $result = mysql_query($dbc);
                $row = mysql_fetch_array ($result, MYSQL_NUM);
                $cu = $row[0];
                $cv = $row[1];
                ?>
<!-- EOF added to get currency type and value for totals -->

and replace with

<!-- BOF added to get currency type and value for totals -->
                <?php $db="select currency, currency_value from " . TABLE_ORDERS . " where orders_id ='" . $_GET['oID'] . "'";
                $result = mysql_query($db);
                $row = mysql_fetch_array ($result, MYSQL_NUM);
                $cu = $row[0];
                $cv = $row[1];
                ?>
<!-- EOF added to get currency type and value for totals -->

seems to be it didn't like $dbc instead of $db

no idea if this is just mine of anyone elses :) but in case hope this helps

Thanks
Sarah

grr ignore still not liking it!!

SarahL:

grr ignore still not liking it!!

It is the use of mysql_query that your server/version of php doesn't like.

It is something that will need to be rectified at some point in the super-orders code.

All this bit of code is doing is getting the currency for the order to display in the page under the order totals. As the store that I used it on is single currency all I did was comment out the query and set the values by hand like this:

<!-- BOF added to get currency type and value for totals -->
                <?php $dbc="select currency, currency_value from " . TABLE_ORDERS . " where orders_id ='" . $_GET['oID'] . "'";
                //$result = mysql_query($dbc);
                //$row = mysql_fetch_array ($result, MYSQL_NUM);
                $cu = 'GBP';
                $cv = 1;
                ?>
<!-- EOF added to get currency type and value for totals -->

As you can see mine is in British Pounds but you could make it what you want

If you wanted a more complete solution you will have to do something like:

<!-- BOF added to get currency type and value for totals -->
                <?php $dbc="select currency, currency_value from " . TABLE_ORDERS . " where orders_id ='" . $_GET['oID'] . "'";
                $result = $db->Execute($dbh);
                $cu = $result->fields['currency'];
                $cv = $result->fields['currency_value'];
                ?>
<!-- EOF added to get currency type and value for totals -->

I have just writen that off the top of my head and it is not tested.

SarahL:

grr ignore still not liking it!!

Correct, it is not a good solution. First of all though, the details of 1. ZC version, 2. PHP version, and 3. SO version were not provided... More recent versons of these do not use mysql_ related functions. Renaming $dbc to $db replaces any use of the global $db value representing the database, so that is not a good thng to do/apply.

Verify that using the most recent version of Super Orders as action has been taken to remove this error...

Thanks Nick I have just hidden it - as like you its not really needed

as far as I am aware it is the latest version - but I will check though as it was certainly put on this year - but this isn't the first issue I am seeing with this super-order so maybe I did get a "odd" one

ZC1.5.4

and yes I was only trying DB and I could see that DBC was not used as well as the mysql_query was not used anywhere else either!

really frustrating - at least being hidden I avoid the logs files while I figure out whats gone wrong

thanks and yeah sorry premature posting and then I couldn't edit to add the real details back in!

@Sarah
Yes, check that you have the most recent version. Super Orders is a complex module and worth having the most recent anyway. But this does actually exist in the most recent version.
Hiding it is fine and won't cause any problems so it is a satisfactory solution for you.
Pretty sure that the second lot of code will work for anyone who runs a multi-currency site. But they could let us know.
And the updating of modules is constant work and done 100% voluntarily so this, I am sure, will get amended at some point but only when busy people find the time.

yes latest version :) I will leave hidden for now - thank you :)

niccol:

@Sarah
Yes, check that you have the most recent version. Super Orders is a complex module and worth having the most recent anyway. But this does actually exist in the most recent version.
Hiding it is fine and won't cause any problems so it is a satisfactory solution for you.
Pretty sure that the second lot of code will work for anyone who runs a multi-currency site. But they could let us know.
And the updating of modules is constant work and done 100% voluntarily so this, I am sure, will get amended at some point but only when busy people find the time.

The fix posted by niccol is equivalent to what is posted in the github version of Super Orders. Because the admin orders.php file is in line with the other base code initiation (and not within a function that needs to bring the $db variable in as a global variable), the use of $db->Execute should work and the use of the resulting fields also.

you also have the same thing in invoice.php in admin as well circa line 355

<!-- BOF added to get currency type and value for totals -->
                <?php #$dbc="select currency, currency_value from " . TABLE_ORDERS . " where orders_id ='" . $_GET['oID'] . "'";
                $result = mysql_query($dbc);
                $row = mysql_fetch_array ($result, MYSQL_NUM);
                $cu = $row[0];
                $cv = $row[1];
                ?>
<!-- EOF added to get currency type and value for totals -->

hidden for now - do you know if plugin code will get updated or not? as I am not who has control of this plugin at present as it seems a few people?! was not sure how it all worked

thanks
Sarah

Regarding updates

niccol:

And the updating of modules is constant work and done 100% voluntarily so this, I am sure, will get amended at some point but only when busy people find the time.

In the meantime one could ALWAYS grab the beta version in my Github repo (link has been posted in this support thread previously)

I find it a shame that a sincerely asked question was responded to with sarcasm - believe me I am well aware of the time and effort that goes into these plugins and then times that by 100 I am sure - however why slam people for asking!? As for github - actually no I had not seen those links - however is beta version a live version or for testing? usually I would say beta is just that a testing version vs a live shop. Anyway I will leave as is and see what else I can come up with - I just wanted to respond and say I am not sure what your issue is with me or others that ask questions. I hope your day gets better either way

Hi I am getting this error message and I cant spot the problem.. I really would appreciate some help.. I am trying to edit quantities in an order. Zen 1.54 with edit orders and super orders. everything else seems to be working ...

PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT p.products_quantity FROM products WHERE p.products_id = '199' ==> (as called by) /xxxxxxx/office/includes/functions/extra_functions/edit_orders_functions.php on line 1028 <== in /xxxxxx/includes/classes/db/mysql/query_factory.php on line 155