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

My apologies! I couldn't find the solution to my display problem in the forum, so I automatically posted a new question - it never occurred to me to look in Zen's Admin->MaxValues area first! There it was, and it works perfectly. Lesson learned - I'm reviewing all Admin functions again, and now making better notes.

Like the genie said in the movie Aladdin, "Boy, do I feel sheepish!"
:oops:

BlindSide:

You shouldn't comment from that point forward all the way to the end, just to the end of the payment_types section. The last line to comment out should look like this:

INSERT INTO so_payment_types VALUES (NULL, 1, 'DISC', 'Discover');

 ---is there another way to do that other than restoring the database? ... I guess I don't have a backup...   thanks!! Pat

aeibc:

First, we love this mod and it's working great so far! However, we just noticed one minor thing today:

Some of our products have a one-time option attached to it to handle extra shipping charges (i.e. tube mailer for posters). Now, while the extra charge shows up in admin and in the 'print data sheet' window, it's not on the invoice.

On the invoice, it lists the mailer, but has no unit price, yet the total is correct. While it's ok for us, the customers may get 'confused'. Is there a quick fix for it?

Thanks,
Andrea
Andrea, I'm not sure I understand exactly what you're experiencing. The totals are right, which is my first concern. Is this value an attribute of a product, or an order total line?
Randolph Hoppe:

Thanks, topcat.
Yes, thanks topcat! :bigups:
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.
Several people have brought this to my attention. Fixed in the next release.

babynatura:

---is there another way to do that other than restoring the database? ... I guess I don't have a backup... thanks!! Pat
Yes, you can compare the SQL file to your DB and figure out which pieces are still missing. Relax, it's easier than it sounds. SQL commands are fairly straightforward - tables, fields in tables, stuff in those fields in tables. Go down the SQL file and look up the corresponding information in your DB using phpMyAdmin or similar DB tool.

I'd start with the section after the payment types. You know those went in correctly, because you're getting a "duplicate entry" error (i.e. they are already there). You could copy everything after the payment types into the SQL box in phpMyAdmin and run it, then see if you hit any errors. It's entirely possible that the duplicate payment types are your only problem, and the rest of the code will go in no sweat.

If you hit a wall, PM me and I'll try and help you directly.

Andrea, I'm not sure I understand exactly what you're experiencing. The totals are right, which is my first concern. Is this value an attribute of a product, or an order total line?

Hi Frank,

yes, it's an attribute value. I attached you a couple of screenshots, one from the standard admin super orders screen, the other from the invoice. I underlined both. Thanks!

Andrea

Frank,
Just installed SO2.0(rev46) on a ZC1.38a cart. Install was clean and easy and I even modified the 3 admin/boxes/extra_boxes files to work with the Admin Profiles mod. FYI, all of the SO options will NOT show in the Admin Profiles Contributions window to allow permissions to be set until you actually call them the first time (and get the error that you don't have permission). But that's not your problem.

1. Found an error when I clicked on the "Print" button from the Orders Listing window to print the Order Details. Error message was:
   Fatal error: Call to undefined method super_order::get_admin_notes() in E:\wamp\www\newzen\admin\super_data_sheet.php on line 262.
   I checked super_data_sheet.php and noted that the code from line 261 to line 300 was commented out. So it shouldn't have seen the call in line 262. BUT I also noted what looks like an error in line 260. It reads "<?" instead of "<?php". Correcting that did not help. The error persists.

2. Is there an "easy" way to restyle the invoices so that they would print:
   Products, Model, UnitPrice, Subtotal Price (Quantity*UnitPrice), Tax(%), Tax($), TotalPrice? I have no reason to print BOTH the Price and Total with and without Tax.

3. If I don't accept Purchase orders (Heck, I don't even accept checks), is there any reason to load the PO module?

Frank,
Clarification from my previous post.

mauryg:

2. Is there an "easy" way to restyle the invoices so that they would print:
   Products, Model, UnitPrice, Subtotal Price (Quantity*UnitPrice), Tax(%), Tax($), TotalPrice? I have no reason to print BOTH the Price and Total with and without Tax.
   I was referring to the Order Details sheet, NOT the invoices.

However, I noted another problem with the invoices.

1. On the invoice the Tax column on each item reads "None!" (the item IS taxable) and then the tax is applied after the subtotal for the order.
2. On the Order Detail sheet for the same order, the Tax is shown as 7.25% which is correct.

I have a question about the display of shipping methods. In the standard orders details page, it will display the specific shipping method, but Super Orders willl not.

For example: United Parcel Service (4.00lbs) (3 Day Select)

In the super orders detail page it only says: United Parcel Service. This has caused me to mis-ship several products to customers and incur some extra expense. Is there a setting that I am not seeing?

I will try to fix this myself, but wanted to post here in case there is a fix for it or if it's a new bug...

TIA

Here is how I found it can be done:

Search for this:

// Short shipping display
// Formats shipping entry to remove the TEXT_WAY define
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
if ($order->totals[$i]['class'] == 'ot_shipping') {
$format_shipping = explode(" (", $order->totals[$i]['title'], 2);
$clean_shipping = rtrim($format_shipping[0], ":");
$display_title = $clean_shipping . ':';
}
else {
$display_title = $order->totals[$i]['title'];
}
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $display_title . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
}

Replace with this:

// Short shipping display
// Formats shipping entry to remove the TEXT_WAY define
for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
//if ($order->totals[$i]['class'] == 'ot_shipping') {
// $format_shipping = explode(" (", $order->totals[$i]['title'], 2);
// $clean_shipping = rtrim($format_shipping[0], ":");
// $display_title = $clean_shipping . ':';
//}
//else {
// $display_title = $order->totals[$i]['title'];
// }
echo ' <tr>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
' <td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Amount">' . $order->totals[$i]['text'] . '</td>' . "\n" .
' </tr>' . "\n";
}

You can also change it on the details page:

Search for this: (around line 1147)

// format shipping method to remove ()
$clean_shipping = explode(" (", $oInfo->shipping_method, 2);
$clean_shipping = rtrim($clean_shipping[0], ":");
$shipping_method = $clean_shipping;

Comment it out like:

// format shipping method to remove ()
//$clean_shipping = explode(" (", $oInfo->shipping_method, 2);
//$clean_shipping = rtrim($clean_shipping[0], ":");
//$shipping_method = $clean_shipping;

Then on around line 1250, Search for this:
$contents[] = array('text' => TEXT_INFO_SHIPPING_METHOD . ' ' . $shipping_method);

Replace with this:
$contents[] = array('text' => '<br />' . ENTRY_SHIPPING . ' ' . $oInfo->shipping_method);
//$contents[] = array('text' => TEXT_INFO_SHIPPING_METHOD . ' ' . $shipping_method);

Hope that helps.

Fantastic Kim, thanks VERY much! This solved my problem perfectly!

Hopefully this will be integrated into future releases for other users to take advantage of.

As a follow-up, I should mention that I corrected my Invoice page by searching for:

'<td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $display_title . '</td>' . "\n" .
``` and replaced it with:

```php
'<td align="right" class="'. str_replace('_', '-', $order->totals[$i]['class']) . '-Text">' . $order->totals[$i]['title'] . '</td>' . "\n" .
```I also updated the Packing Slip by searching for:

```php
$format_shipping = explode(" (", $order->totals[$i]['title'], 2);
$shipping_method = rtrim($format_shipping[0], ":");
```...and replacing it with:

```php
//$format_shipping = explode(" (", $order->totals[$i]['title'], 2);
//$shipping_method = rtrim($format_shipping[0], ":");
$shipping_method = rtrim($order->totals[$i]['title'], ":");

Is super orders available for 1.38?
Or will the current version work with 1.38?

Tracy

tracyselena:

Is super orders available for 1.38?
Or will the current version work with 1.38?

Tracy

I am currently running Super Orders v2.0 rev 46 on a 1.38a cart and it works quite well.

KimArtist and Gezuvor,
I just made the mods suggested by Kim to super_orders.php and super_data_sheet.php and the mods suggested by Gezuvor to super_invoice.php and super_packingslip.php. Worked perfectly for my UPS shipping.
Thanks to both of you :clap::clap:

I have installed SuperOrders 2.0 on my 1.37 zen-cart. At least I think I have. I copy the admin and includes folders to my catalog.

I go to Admin - Tools - Install SQL Patches, and I copy the contents of the super_orders_sql.sql file into the box "enter the query to be executed."

I get a "Failed" message:
1062 Duplicate entry 'CA' for key 2
in:
[INSERT INTO zen_so_payment_types VALUES (NULL, 1, 'CA', 'Cash');]
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 have tried just entering the file name in the box, but that doesn't work. :blink:

I really was hoping that this would work. I see many others have run it without any problems - what am I doing wrong?

Thanks
Susan

BlindSide:

You shouldn't comment from that point forward all the way to the end, just to the end of the payment_types section. The last line to comment out should look like this:

INSERT INTO so_payment_types VALUES (NULL, 1, 'DISC', 'Discover');

> 
> Barring that, the easiest thing to do is restore your database from backup and try again.  That remove all traces of SO and allow you to try again.  You DO have a backup, right?

Okay, I think I'm getting somewhere. I managed to get a little further, Instead of getting the same error from the example above I now get:

1062 Duplicate entry 'STORE_FAX' for key 2
in:
[INSERT INTO zen_configuration VALUES ('', 'Store Fax', 'STORE_FAX', '', 'Enter the fax number for your store.
You can call upon this by using the define STORE_FAX.', 1, 4, now(), now(), NULL, NULL);]
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.

This is confusing, I had no problem installing SO on my local environment. This error is from the live server. Neither, btw, have store fax #'s.

I ran into this last night myself - you keep getting the errors because the MySQL code that comes with Super Orders doesn't have an "IF" statement - it says "PUT THIS HERE" instead of "IF THIS EXISTS, OVERWRITE, OTHERWISE CREATE IT"

If for some reason the first try at installing the MySQL patch doesn't work, you'll keep getting the error unless you know how to drop the database tables yourself or change the MySQL code.

I'm finishing up a project right now, but give me about 1/2 hour and I'll post a MySQL file that will see if you have the tables already, and if so, know what to do.

Give me 1/2 hour.

Thanks!
Michelle

Ok...I guess I don't know MySQL like I thought - but I know "how" it works...

If someone else wouldn't mind modifying the SQL file, basically it just needs to check to see if everything exists first, if not, then add.

I was able to just delete rows out when I did it last night, but it would have been super cool to have that all done already.

Thanks!
Michelle

VS4Hire:

Ok...I guess I don't know MySQL like I thought - but I know "how" it works...

If someone else wouldn't mind modifying the SQL file, basically it just needs to check to see if everything exists first, if not, then add.

I was able to just delete rows out when I did it last night, but it would have been super cool to have that all done already.

Thanks!
Michelle

Michelle, I agree. I finally got it installed but I had to delete the reference in the table for store fax and store phone. Having the script skip what already exists would be helpful. Perhaps in a future version, I'm guessing that BlindSide has tons on his plate already.

:)

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.

sorry to be so thick .. but .. what does this add-on exacly do ? any screenshots ?