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

[gezuvor]

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.

[gezuvor]

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:

'<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:

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

...and replacing it with:

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

[tracyselena]

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

Tracy

[mauryg]

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.

[mauryg]

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

[WeebleSue]

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.

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

[HMG]

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.

[VS4Hire]

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

[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

[HMG]

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.

:)