Super Orders v3.0 Support Thread (for ZC v1.3.9)

I was quite happy to read this:

Full integration of Super Orders functionality into the into Zen Cart core. Eliminate once and for all the separate Super Orders versions of the core "cousin files". Replace super_orders.php, super_invoice.php, super_packingslip.php with Super Order enhanced versions of orders.php, invoice.php, & packingslip.php.

in this post summarizing the current state of SO updating to 1.5: http://www.zen-cart.com/forum/showpost.php?p=1097253&postcount=647

I think this is absolutely the right choice.

swguy:

I was quite happy to read this:

in this post summarizing the current state of SO updating to 1.5: http://www.zen-cart.com/forum/showpost.php?p=1097253&postcount=647

I think this is absolutely the right choice.
Thanks Scott..

It's the direction I took the Ty Package Tracker in and I'm kicking myself that I didn't do the same with the Super Orders v3.0 launch as well.:unsure:

I think I was still trying to "stay true" to the original Super Orders, but ultimately I have realized that keeping these "separate and KINDA equal" filesets makes keeping up with Zen Cart updates a real nightmare.. This point was driven home as I started trying to get SO v1.5 compliant. (it was -- to put it not so delicately -- a clusterf***)

I think that this change also makes other mods which modify orders.php easier to use with Super Orders.. There were mod authors who tried to keep Super Orders versions of their mods in parallel, but ultimately they too seem to have gotten tired of maintaining the parallel filesets.

Anyway, this will be a good move forward, and your endorsement confirms my thought on moving in this direction.. :smile:

As we learned in Brown v. Board of Education, separate but equal is wrong. :smile:

And no kicking yourself. The decision was fine for 1.3.9, and it allowed you to release in a timely manner.

swguy:

As we learned in Brown v. Board of Education, separate but equal is wrong. :smile:I am learning this lesson..:laugh:

swguy:

And no kicking yourself. The decision was fine for 1.3.9, and it allowed you to release in a timely manner.Funny the gentleman who worked on SO v3.0 with me would disagree on this point..:laugh: I postponed the initial release date because I wanted it to go out right the first time (or as close to right the first time as it could get.. :laugh:). He was not pleased with this decision :laugh:..

thank you for making such a great mod...

i have run into a problem...searched this forum...read through a lot of it but no answer...

here's my question...when i print an invoice or packing slip in super orders...the admin url prints on the bottom...how can i avoid this?

Zadris:

thank you for making such a great mod...

i have run into a problem...searched this forum...read through a lot of it but no answer...

here's my question...when i print an invoice or packing slip in super orders...the admin url prints on the bottom...how can i avoid this?

This is a function of your browser that is unrelated to zen cart's or SO3's functionality. Adjusting your browser's printer settings is a basic zen cart security measure that should be taken upon install per this zc tutorial. Have a look at the tut...I believe you'll find the help you're looking for there.

Good luck and happy zenning :smile:

One last thing..

I will be removing the integration code for USPS Click and Ship (AKA USPS Autofill) and FedEx Shipping Label add-ons.. My research indicates that at the moment neither has been updated for Zen Cart 1.5. It doesn't look likely that the will be upgraded for v1.5 compatibility anytime soon either. Therefore I will be removing the EZ integration code for both. EZ integration with Ty Package Tracker and Edit Orders will remain in place as there are v1.5 compatible releases planned for both of these mods.

DivaVocals:

Working on a v1.5 updgrade/bugfix release. DO NOT ASK ME for an ETA on the release date. I think that I finally have the bandwidth to work on this with some regularity now.. Please understand that I do this work in MY spare time and I prioritize free mod work based on my workload/availability from paid work. In other words, I am working on it, but paying work will ALWAYS take priority over free mods work.

That said I am feeling good that I will have something soon.. :blush:

So here's where we last left our heroine:laugh::

In addition to the changes noted above, and making the app v1.5 compatible, the following bugfixes and improvements that I have been trying for over a year to finish and release will be included. (Some of these fixes were probably already addressed in Scott's recent SO update, but I will note them here anyway..)

2. Full integration of Super Orders functionality into the into Zen Cart core. Eliminate once and for all the separate Super Orders versions of the core "cousin files". Replace super_orders.php, super_invoice.php, super_packingslip.php with Super Order enhanced versions of orders.php, invoice.php, & packingslip.php.

This change is huge and I am sure there will be those who disagree with it. So let me explain the reason for moving in this direction.

I appreciate the original author's desire to not modify core files, but over time this put the Super Orders files out of step with it's core "cousin files". There many other mods which do indeed modify core admin files, and we don't feel there's any further need for Super Order to not follow suit. (caveat, with GOOD documentation and adequately marked code to make it CLEAR where core edits begin.)

In the version 3.0 release we worked hard to bring the Super Orders "cousin files" back in alignment with the core files they are meant to replace. This brought back much of the default order management functionality missing from Super Orders back into the mod (processing PayPal refund from the order window for example).

However, this still leaves us with somewhat nightmarish upgrade issues when Zen Cart is upgraded. (for this discussion assume I am NOT referring to the 2.0 flavor of Zen Cart) In order to have a reasonable assurance that core changes to Zen Cart order files are included in Super Orders, we decided to incorporate Super Orders functionality directly into the core order files. This should make future Zen Cart core updates easier to integrate into Super Orders.

3. http://www.zen-cart.com/forum/showpost.php?p=1008080&postcount=275

4. http://www.zen-cart.com/forum/showpost.php?p=1012083&postcount=279

5. Batch Form Printing. When shopowners print multiple invoices they are presented with a new window with all the selected invoices in separate frames. Printing frames is only supported by IE and Firefox (the 2 most commonly used browsers when SO was initially released). This code still works, but is showing signs of it's age. (the 80s called.. :laugh:) Frame printing is not supported in Chrome, Safari, or Opera. Therefore, this function is to be modified so that batch invoices no longer render in frames and the selected invoice prints on its own page. Align batch invoices and packingslips so that they look/act like the single printed versions.

6. http://www.zen-cart.com/forum/showpost.php?p=977572&postcount=54[

http://www.zen-cart.com/forum/showpost.php?p=977666&postcount=55](http://www.zen-cart.com/forum/showpost.php?p=977666&postcount=55)

Fix super_data_sheet.php lines around lines 225 where TY Tracker is spliced in.

7. http://www.zen-cart.com/forum/showpost.php?p=1029359&postcount=489

Correct PDF packing slip to intepret and output currency and other symbols correctly. (trademarks, currency symbols, copyright, etc)

8. Eliminate the need for the common_orders_functions.php file. Edit Orders and Super Orders should have their own functions files.

9. http://www.zen-cart.com/forum/showpost.php?p=983195&postcount=161

10. Update comments using “Batch Status Update” not working correctly.

Comments in “Batch Status Update” should work the same way default order comments work. (support for e-mail, no e-mail, or hidden comments) . If working properly should allow shop owner to create batch hidden order comments.

Currently does not create the correct comment type. Hidden comments and no e-mail comments are not e-mailed to the customer, but they are stored and displayed in the store as if they are e-mail comments.

11. PDF Packing Slip needs to support wrapping display long attributes names

Word wrapping works for product names and models, but not attributes.

12. PDF Packing Slip does not print all order comments

Seems to only print the 1st comment. Should print comments the same way comments print on the regular invoice.

13. PDF Packing Slip incorrectly displays the “Balance Due” Amount

Hi! Attempting to install super orders... using 1.3.9.h. Initially, followed the install guidelines and ftp'd the super_orders_patch.sql in main directory. Attempted the query executor. Got this:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'edit_orders_install.sql' at line 1
in:
[edit_orders_install.sql;]
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.

:frusty:

Thanks

A couple of things in your post stand out.. (I've highlighted them..

FrankinWV:

Hi! Attempting to install super orders... using 1.3.9.h. Initially, followed the install guidelines and ftp'd the super_orders_patch.sql in main directory.
You FTP'd the SQL patch to your store and executed it from there?? (I assume from your site's cPanel???) Where in the install instructions did you find directions to do this??? You should copy and paste the install SQL using the SQL installer in the Zen Cart admin (as the readme instructs you to do)

FrankinWV:

Attempted the query executor. Got this:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'edit_orders_install.sql' at line 1
in:
[edit_orders_install.sql;]
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.

:frusty:

ThanksAre you installing SUPER Orders or EDIT orders?? If this is an EDIT Orders issue, you are in the wrong support thread..

and BTW, the way to install the SQL scripts for BOTH mods is the same..

Hello!

I am trying to install. However, I am not smart enough for it. The last step is

Run the edit_orders_install.sql using the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches).

However, I never uploaded the edit_orders_install.sql. I uploaded the install and required core files. Where/how do I upload that sql file?

Thanks!

Frank

FrankinWV:

Hello!

I am trying to install. However, I am not smart enough for it. The last step is

Run the edit_orders_install.sql using the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches).

However, I never uploaded the edit_orders_install.sql. I uploaded the install and required core files. Where/how do I upload that sql file?

Thanks!

Frank
Are you installing SUPER Orders or EDIT orders?? If this is an EDIT Orders issue, you are in the wrong support thread..

I know... sorry. I was referring to the wrong sql filename... I figured it out, though... On the sql query executor, after you upload all the files (and after I changed the YOUR_ADMIN to my admin's name - you pick the RIGHT sql file in the "Upload File" window, click upload - and voila - it works.

THAT"S what' I couldn't figure out to do. I knew I needed the sql file on the site, but never saw it in the directions of HOW to get it there, so I manually uploaded it and tried to use it in the large "Enter the query" field above.. which -obviously - didn't work.

Thanks for your help and pointing me the right way!:smile:

Glad you worked it out, but the readme files does say WHERE to upload this SQL file.. That's part of the reason why the SQL files needed for Super Orders are in a separate location than the rest of the install files.. (so people don't "accidentally" upload this file)> Run the edit_orders_install.sql using the "SQL Query Executor" tool in the Admin (Tools > Install SQL Patches).Are you saying that this instruction wasn't clear?? If this wasn't clear to you do you have a suggestion on how we could make it clearer for the next SO update??

FrankinWV:

I know... sorry. I was referring to the wrong sql filename... I figured it out, though... On the sql query executor, after you upload all the files (and after I changed the YOUR_ADMIN to my admin's name - you pick the RIGHT sql file in the "Upload File" window, click upload - and voila - it works.

THAT"S what' I couldn't figure out to do. I knew I needed the sql file on the site, but never saw it in the directions of HOW to get it there, so I manually uploaded it and tried to use it in the large "Enter the query" field above.. which -obviously - didn't work.

Thanks for your help and pointing me the right way!:smile:

Hello! I am getting that "strcasecmp()" error that nagelkruid got as well. this happens when i try to use batch-update to change orders from pending to processed and use the "check all" button. it works fine when i select individual boxes.

the page hangs, then ends in blank, so i hit back, refresh the page and get the message stack saying the orders were updated (which they were).

any thoughts?

apogeerockets:

Hello! I am getting that "strcasecmp()" error that nagelkruid got as well. this happens when i try to use batch-update to change orders from pending to processed and use the "check all" button. it works fine when i select individual boxes.

the page hangs, then ends in blank, so i hit back, refresh the page and get the message stack saying the orders were updated (which they were).

any thoughts?Nope.. and I'm not familiar with this issue.. What post by nagelkruid speaks about this issue??

DivaVocals:

Nope.. and I'm not familiar with this issue.. What post by nagelkruid speaks about this issue??

About a year ago, #195
http://www.zen-cart.com/forum/showpost.php?p=991516&postcount=195

Sorry, I hadn't realized it'd been that long, so it's not as fresh in ppls minds. :P The error i'm getting:

PHP Warning: strcasecmp() expects parameter 1 to be string, array given in *****\apogeeadmin\includes\functions\extra_functions\common_orders_functions.php on line 61

apogeerockets:

About a year ago, #195
http://www.zen-cart.com/forum/showpost.php?p=991516&postcount=195

Sorry, I hadn't realized it'd been that long, so it's not as fresh in ppls minds. :P The error i'm getting:

PHP Warning: strcasecmp() expects parameter 1 to be string, array given in *****\apogeeadmin\includes\functions\extra_functions\common_orders_functions.php on line 61And my answer is the same today as it was over a year ago.. Can't reproduce the error.. :no:

Wow, ok. Just tried again and it went fine this time. I haven't changed anything, so wonder why it worked now...

Perhaps if you DO hit the button enough times something else will happen. ;)

apogeerockets:

Wow, ok. Just tried again and it went fine this time. I haven't changed anything, so wonder why it worked now...

Perhaps if you DO hit the button enough times something else will happen. ;)Without knowing how the error happened to begin with it's hard to say. Since I cannot reproduce the error.. well you get the point..:smile:

Hello. Super Orders is finally installed. However, when we do a batch status update we get:

1366 Incorrect integer value: 'on' for column 'customer_notified' at row 1
in:
[INSERT INTO orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) VALUES ('22559', '3', now(), 'on', '')]
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 know we could try and get MYSQL out of Strict Mode. But our web server holds the my.ini file so we cant edit. Is there another way around this?

Thanks in advance to anyone that can help.