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

Running Super Orders 2.0 with ZenCart 1.3.7 with Paypal and Authorize.net...

We are having a problem when hitting the submit button. We get a 1062 error, the order gets "lost" but Authorize.net receives the order and info and charges the card. Info is not coming back to zencart.

1064 You have an error in your SQL syntax near 's Spatula 6"(qty: 1) + Hand
Truck, Pneumatic Wheels(qty: 1) + Canvas Pastry Bag ' at line 1
in:
[insert into zen_authorizenet (id, customer_id,order_id, response_code,
response_text, authorization_type, transaction_id, sent, received, time,
session_id) values ('', '1', '5130', ... 

Authorize.net said they don't believe it's on their end. They system seems to be working correctly before installing super orders.

Any suggestions on how to test and correct this would be really appreciated! I am not even sure this is associated with super orders. Help! Please!!

-CJ

oxxyfx:

This is a problem with the individual orders - I have not needed to try the batch processing.

Have you tried to load all the files back on the server as you may be missing the
super_orders_functions file as this deals with updating the order status?

Are you sure that the notify customer is ticked and you hit update button and not the completed?

Can you see if the batch status works (you can try with just one order) as if that works then there may be a change in code to the super_orders file that will work

I have just looked at the code in super_orders_functions.php (The file can be found in admin/includes/functions/extra_functions) found in v46 and this has been changed so change it back to the one in v45 as this works correctly or you can change it manually at line 398 to the following code

function update_status($oID, $new_status, $notified = 0, $comments = '') {
  global $db;

  $db->Execute("INSERT INTO " . TABLE_ORDERS_STATUS_HISTORY . "
                (orders_id, orders_status_id, date_added, customer_notified, comments)
                VALUES ('" . (int)$oID . "',
                '" . $new_status . "',
                now(),
                '" . $notified . "',
                '" . $comments . "')");

If you make the changes above then you will also have to change the code in super_batch_status.php at line 353 from

if ( ($check_status->fields['orders_status'] != $status) || zen_not_null($comments)) {
    update_status($oID, $status, $notify, $comments);
```to the following code
```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);
```In order to get the batch status to update correctly

I've been setting up Super Orders and have run into a problem with order totals editing. From this thread I can see that the problem is quite common.

In Australia, and other countries, prices need to always be shown including tax. This means that invoices include the total of all item prices (inc. tax) in addition to a tax field.

So an invoice might have the following:
Order subtotal: $45
Included Tax: $4.09
Total: $45

If one edits the order totals using Super Orders then the new total will have the tax summary incorrectly added to the tax inclusive subtotal. Using the above totals as an example, if one opens the edit totals window and clicks submit without actually changing anything then the totals would be changed to:
Order subtotal: $45
Included Tax: $4.09
Total: $49.09

The quick and dirty fix I'm using for this problem is to comment out line 491 in super_edit.php which will remove tax from the running total calculated there.

Obviously a better solution would be required for people who do sometimes need tax added. The addition of tax in the total could be made conditional but I'm unsure of what to test...

Hope this helps.

chadderuski:

Running Super Orders 2.0 with ZenCart 1.3.7 with Paypal and Authorize.net...

We are having a problem when hitting the submit button. We get a 1062 error, the order gets "lost" but Authorize.net receives the order and info and charges the card. Info is not coming back to zencart.

1064 You have an error in your SQL syntax near 's Spatula 6"(qty: 1) + Hand
Truck, Pneumatic Wheels(qty: 1) + Canvas Pastry Bag ' at line 1
in:
[insert into zen_authorizenet (id, customer_id,order_id, response_code,
response_text, authorization_type, transaction_id, sent, received, time,
session_id) values ('', '1', '5130', ...

> 
> Authorize.net said they don't believe it's on their end. They system seems to be working correctly before installing super orders. 
> 
> Any suggestions on how to test and correct this would be really appreciated! I am not even sure this is associated with super orders. Help! Please!!
> 
> -CJ

Answered my own question: This problem is not related to super orders, but was a problem with the authorize.net code with product titles used single quotes. Supposed to be fixed in 1.3.8.

Hello. I'm having a problem with the install. For some reason, SuperOrder link does not appear at all under my Admin>Configuration. I received an error when I ran the sql file. I tried to upload the file and run it using the browse button in Admin>Tools>Install SQL Patches. When I got the error, I tried to copy and paste the code and run it like that. It worked, but only partially. Any way you can help without knowing the specific error? I didn't save it. Thanks.

Hi I just wanted to let you know about a Super Orders problem I ran into.

If the value of a currency is changed in the admin, after an order has been recieved, the Balance Due as shown in the Super Orders details/edit page is shown using the new value, but the order total is shown using the old value.
e.g If the old USDcurrency value was 1.0, and the total was 100, then the total will be USD100
But if we subsequently change the USD currency value to 1.1 The balance due will say USD110, but the order total will still be USD100.

I don't use the balance due function, but all these odd values showing up were bugging me. So I fixed it like this
i) in super_order.php around line 780, I did this
//$amount_applied = $currencies->format($so->amount_applied);
//$balance_due = $currencies->format($so->balance_due)
$amount_applied = $so->amount_applied;
$balance_due = $so->balance_due;

ii) in super_order.php around line 200 I did this
// $this->balance_due = $this->order_total - $this->amount_applied;
$this->balance_due = round(($this->order_total * $order_query->fields['currency_value'])- $this->amount_applied,2);

Also you had better be careful when you enter payment information (if you do that) that you enter it in the currency of the original order. Of course you would be silly not to wouldn't you.

I hope this is useful to someone.

Hello,

I need customers to be able to enter their PO number in checkout process.

I created field in Step 3 of 3 - Order Confirmation:

define('MODULE_PAYMENT_PURCHASE_ORDER_TEXT_DESCRIPTION','
<font size=2 color="red"><b>PLEASE READ!<br>Important Payment Information:</b></font><p>

<B>Your order will not be processed until we have received your purchase order.</B><br>

Authorize your PO payment to:<br>
' . MODULE_PAYMENT_PURCHASE_ORDER_PAYTO . '<br><br>

You can Enter your PO number here: <input type="text" size="10" name="PO_number" />  <input type="submit" value="Save" /><br><br>

Alternatively, you may fax us a <b>signed copy</b> of your P.O. for immediate order processing to <b>' . STORE_FAX . '</b>. 

Be sure to display your <b>invoice number</b> prominently somewhere on the fax.');

But I don't know how to send value of PO_number field to right order...

Any help welcome!!!

Thank you!

Hello,

I need customers to be able to enter their PO number in checkout process.

I created field in Step 3 of 3 - Order Confirmation for PO number entry:

define('MODULE_PAYMENT_PURCHASE_ORDER_TEXT_DESCRIPTION','
<font size=2 color="red"><b>PLEASE READ!<br>Important Payment Information:</b></font><p>

<B>Your order will not be processed until we have received your purchase order.</B><br>

Authorize your PO payment to:<br>
' . MODULE_PAYMENT_PURCHASE_ORDER_PAYTO . '<br><br>

You can Enter your PO number here: <input type="text" size="10" name="PO_number" />  <input type="submit" value="Save" /><br><br>

Alternatively, you may fax us a <b>signed copy</b> of your P.O. for immediate order processing to <b>' . STORE_FAX . '</b>. 

Be sure to display your <b>invoice number</b> prominently somewhere on the fax.');

But I don't know how to send value of PO_number field to right order...

Any help welcome!!!

Thank you!

Hello, I was wondering if Super Orders should show the shipping method on the screen with the customer's order data. I can't find it anywhere except the order email. A little help please?

Hi,

I have a small problem with super orders and shipping labels.
When I click the shipping label button for orders which have been made with credit card payments, everything is fine, but when I do the same for anyone who has paid by Paypal, the shipping label just shows my sender address and the order number, but no delivery address.

Does anyone have any ideas on how to solve this as I haven't a clue why this happens and really need to print the labels.

Thanks

MyLibros.com:

Hello, I was wondering if Super Orders should show the shipping method on the screen with the customer's order data. I can't find it anywhere except the order email. A little help please?

I have no problem seeing the shipping method. It is viewable on the right side on the summary page (super_orders.php) for each item. It is also listed for each line on the summary page (super_orders.php). When I view any order in detail, it is clearly listed there also (super_orders.php?page=1&oID=1316&action=edit)....so I guess I do not understand which page you are refering to.

:huh:

MyLibros.com:

Hello, I was wondering if Super Orders should show the shipping method on the screen with the customer's order data. I can't find it anywhere except the order email. A little help please?
You may be refering to the details about the shipping method. SO may be displaying USPS, for example, but not whether its Priority Mail, Express Mail, Parcel Post or whatever. If that's the problem see http://www.zen-cart.com/forum/showpost.php?p=456907&postcount=720

jeffwebb:

You may be refering to the details about the shipping method. SO may be displaying USPS, for example, but not whether its Priority Mail, Express Mail, Parcel Post or whatever. If that's the problem see http://www.zen-cart.com/forum/showpost.php?p=456907&postcount=720

I think your guess is probably correct.

Skipper_2: In super_order.php, look for these lines:

$contents[] = array('text' => TEXT_INFO_SHIPPING_METHOD . ' '  . $shipping_method);
$contents[] = array('text' => TEXT_INFO_IP_ADDRESS . ' ' . $oInfo->ip_address);

and change to:

$contents[] = array('text' => TEXT_INFO_SHIPPING_METHOD . ' '  . $oInfo->shipping_method);
$contents[] = array('text' => TEXT_INFO_IP_ADDRESS . ' ' . $oInfo->ip_address);

That will make the detailed shipping type appear on the summary page (on the right hand side of the page for the order line you have selected). Use the same logic to make it change on the other pages also.

Super Orders 2.0 no longer automatically apply credit card payments to the order. This means the orders show a balance due. The payment authorization and transaction ID show up in the status history, so the payments are going through--but they're no longer being applied to the balance.

Any help?

Never mind... The module was set to authorize but not capture. Doh. Fixed.

Does anyone know how to make the product image smaller on Super packing slip? At the moment, it looks too big and stretched. Thanks in advance.

OK. super orders is still broken. I've got the AIM module set to authorize and capture, which is working on the authorize.net side... but SO is not applying the payment to the order. Any ideas? The payment shows up in the notes of the job, but it used to put the payment in the 'payments' line...

Any help is appreciated.

swan:

OK. super orders is still broken. I've got the AIM module set to authorize and capture, which is working on the authorize.net side... but SO is not applying the payment to the order. Any ideas? The payment shows up in the notes of the job, but it used to put the payment in the 'payments' line...

Any help is appreciated.

Have you read the readme file that comes with super orders and did you change the orders.php?