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

MODERATOR NOTE:
IF YOU ARE LOOKING FOR SUPER ORDERS v4 see the new support thread at: http://www.zen-cart.com/showthread.php?200406-Super-Orders-v4-0-Support-Thread-%28for-ZC-v1-5-x%29

The kids are moving out dad!:laugh:

Welcome to the new support thread for Super Orders v3.0.

Super Orders v3.0 is available for download here:
http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=257

The previous support threads can be found here:
Super Orders v2.0: http://www.zen-cart.com/forum/showthread.php?t=44668

Super Orders v1.0: http://www.zen-cart.com/forum/showthread.php?t=34981

First off a BIG THANK YOU goes to Blindside. Not only for creating this fabulous module for me an my partners in crime to work with, but for his support and encouragement for THIS upgrade effort.. (Yep that's right.. I spoke to 'DA MAN himself!! faint)

Blinside, your advice and insight was INVALUABLE and truly appreciated!!! :clap:

Muchos Gracias!!!!

BIG HUGE thanks to my co-contributors JTheed and tonyniemann.

BIG GINORMOUS thanks to our SUPER eagle eyed beta tester TonyBenedetti for finding all those very small and very BIG gotchas!!!

So on to the good stuff.. What's new, and what does Super Orders do..

Here's the answer to the most frequently asked question: "What does Super Orders do?"
(which BTW REALLY IS explained in detail in the readme for those who REALLY wanna know.. it doesn't hurt to download the fileset..)

PURPOSE & AIM

Super Orders is exactly what its name implies: Zen Cart's default order management on steroids.

It's more in all the areas Zen users are asking for more:

• More order control

• "Batch Form Printing" and "Batch Status Updating" including support for PDF invoices.

• "Batch Form Printing" and "Batch Status Updating" both offer expanded order search options.

• Editing of hidden "admin only" comments

• “Split Orders” allows you to split individual lines on an order. So for example:

  Customer orders:        
  3 Super Widgets
  4 Super Duper Widgets
  
  You've only got 3 of the Super Duper Widgets in stock. With Split Orders,       you can move the Super Duper Widgets to another order creating a new       (child) order which is split from the parent (original)       
  
  So you will end up with 1 order (parent) with 3 Super Widgets and a child       order with 4 Super Duper Widgets.
  

• More thorough data

• Order payment tracking -- allows shopowners to enter and track order payment details (check, money orders, etc.) Payments made via Authorize.net, Linkpoint and PayPal are entered for you automatically. Send customer payment notification/verifications

• Order refund tracking -- allows shopowners to enter and track order refund details. Send customer refund notification/verifications

• More detailed reports

• EASY integration* with Edit Orders, USPS Click-N-Ship, Fedex Automated Labels, and Ty Package Tracker

• More navigation options

• More shortcut icons on the orders listing screen. Now there is a corresponding shortcut icon on each order line that matches the buttons that appear in the sidebox
  *Edit Orders, USPS Click-N-Ship, Fedex Automated Labels, and Ty Package Tracker MUST be installed to use these built-in integration features

That said I STRONGLY suggest that anyone THINKING about this mod download it and READ the readme.. The readme goes into a LOT more detail about what Super Orders can do.. It should answer any questions about what this mod provides..

If you are upgrading you too should read the readme file BEFORE you upgrade.

Change Log - v3.0

• Clean up and reorganize the readme file (again!!!)

• MANY misc bug fixes and corrections

• Overall cleanup of the files to remove deprecated and unused code

• Countries now included as search option in "Batch Form Printing" and "Batch Status Updating"

• The "Edit Status History" feature has been restored and the functionality modified. Editing of order comments is now limited to hidden "admin only" comments. Additionally in previous versions of Super Orders the "Edit Status History" feature inserted HTML and ASCII line breaks into the database, and this ugly line break code was displayed when the customer viewed their order history from "Status History & Comments". This particular problem goes back to 2006, and has now been FULLY resolved/addressed.

• Customer comments modified to incorporate the latest Zen Cart 1.3.9 functionality/format

• Packing slip images are now a simple on/off admin configurable option.

• Batch print functionality has been expanded to include PDF invoices!! All options for the PDF invoices are admin configurable

• “Split Orders” has been improved to help shopowners more easily reconcile a split order.

  “ Split Orders” now creates a parent and child order. Paid split orders will display the grand total paid for both parent and child order.

  For orders paid via PayPal, Authorize.net or Linkpoint, the admin payment panel will not display on the child order.

• Order total and customer address edit features have been removed in their entirety. (use Edit Orders if you need order/customer address editing functionality)

• Added missing shortcut icons on the orders listing screen. Now there is a corresponding shortcut icon on each order line that matches the buttons that appear in the sidebox.

• Restoration of missing default Zen Cart orders.php functionality. This now allows payment processor generated (PayPal, Authorize.net or Linkpoint) refunds to now be processed within Super Orders. (no longer requires the retention of the default orders.php to process PayPal, Authorize.net or Linkpoint refunds)

• AUTO PAYMENT FOR ORDERS PAID VIA PAYPAL!!!!!!! 'Nuff said...

• Improved graphics and buttons to SPRUCE UP the Super Orders UI (thought while were doing everything else, why not make it purty too! :smile:)

• If you have Edit Orders installed, you can enable Edit Order in the Super Orders admin to enable Edit Orders buttons in Super Orders (No code merging required.. Simply install Edit Orders and "turn on" Edit Orders in the Super Orders admin!!)

• If you have Ty Package Tracker v3.0 installed, you can enable the Ty Package Tracker fields for Super Orders (No code merging required..) Simply install Ty Package Tracker and "turn on" Super Orders from the Ty Package Tracker admin!!)

• If you have USPS Click-N-Ship installed, you can enable USPS Click-N-Ship in the Super Orders admin to enable USPS Click-N-Ship fields/buttons in Super Orders (No code merging required.. Simply install USPS Click-N-Ship and "turn on" USPS Click-N-Ship in the Super Orders admin!!)

• If you have FedEx Automated Labels installed, you can enable FedEx Automated Labels in the Super Orders admin to enable FedEx Automated Labels buttons in Super Orders (No code merging required.. Simply install FedEx Automated Labels and "turn on" FedEx Automated Labels in the Super Orders admin!!)
  Let me stress something here so that it's CLEAR.. With regards to the mod integration options: You are NOT required to install ANY Edit Orders, Ty Package Tracker, FedEx Automated Labels or USPS Click-N Ship to use Super Orders.. You can use Super Orders even if you don’t use these other modules. That said turning on the admin flags for mods you DO NOT have installed WILL CAUSE ERRORS IN YOUR STORE!!

BUT...

If you are running any of these mods, you don't have to tear your hair out trying to get the correct Super Orders code merged into the Super Orders files to use these mods.. Install them as normal and TURN IT ON in the Super Orders admin (Ty Package Tracker will need to be turned on in the Ty Package Tracker admin)

In support of this new release there are updates to Edit Order and Ty Package Tracker that are now available in the downloads.. (See the Ty Package Tracker and Edit Orders respective support threads for details on those updates -- PLEASE do not post non Super Orders related questions here..)

Finally we are also supplying the properly merged files needed for those running FEC and COWOA. (no admin flags for these mods.. simply use the provided pre-merged files for these mods)

Lastly I want to ask a SMALL favor.. :smile:

When posting bugs/issues about Super Orders v3.0, it's a WHOLE LOT more helpful to resolve them if you post details. Just saying "it's broken" or "doesn't work" does not provide nearly enough information to help YOU resolve YOUR issue.:smile:

Please provide as MUCH information as possible including the version of Zen Cart you are running, the version of Super Orders you are running, any other add-ons you may have also installed.. Also hosting/server information (PHP versions, mySQL versions, hosting provider etc) is helpful too.

AND if you're REALLY detail oriented, tell us the install sequence/method you used to install Super Orders.:smile:

Because folks like nohart did just this we were able to FINALLY figure out WHY direct credit card and PayPal refunds worked from the default orders.php, but NOT from super_orders.php. As a result this is FIXED in v3.0..:clap:

Anyway.. carry on.. Enjoy the new version..

The mod works great and looks awsome great job, only issue I can see for the time being is when editing an order you see this in the shipping table for example

FedEx Ground (FedEx Home Delivery^{<font size="1">®</font>} ):

I attached a screen shot for you to see I have not been looking for the code to fix but just in case thought you may want to know about it

Again overall nice work.

Forgot to mention all other pages such as super_invoice, packing slip etc look fine

knuckle-101:

The mod works great and looks awsome great jobThanks!!!!

knuckle-101:

only issue I can see for the time being is when editing an order you see this in the shipping table for example

FedEx Ground (FedEx Home Delivery^{<font size="1">®</font>} ):

I attached a screen shot for you to see I have not been looking for the code to fix but just in case thought you may want to know about it

Again overall nice work.Not to be the detail police, but that's an Edit Order issue, and it should be posted in the Edit Orders support thread.. :smile:

what version of COWOA did you put into super orders, one of the reasons i'm asking is that there is a lot of cowoa code missing from includes>classes>order.php.
is it handled differently in super orders?

Kezza

Kezza:

what version of COWOA did you put into super orders, one of the reasons i'm asking is that there is a lot of cowoa code missing from includes>classes>order.php.
is it handled differently in super orders?

KezzaCOWOA Version 2.0c

There aren't any "missing" files.. We only included Super Orders specific files with the required COWOA modifications. We did not provide merged versions for any other files core Zen Cart files that COWOA and Super Orders may have in common (including includes/classes/order.php) . You will have to use a file merging program and make those merges/changes yourself.

HTH

that works for me, will merge the extras myself and let you know how it goes.
thanks

Kezza

Kezza:

that works for me, will merge the extras myself and let you know how it goes.
thanks

Kezza
Awesome!

Diva et al - Many thanks for zensational work - and especially for delivering this mod before Xmas.

Missing Files - do we delete or retain the following file from previous version?
admin/includes/languages/english/super_customers.php

In the Readme > Files > Required_Core_Edits - there is no mention of what to do with the following files:
/includes/languages/english/YOUR_TEMPLATE/account_history_info.php
includes/modules/pages/account_history_info/header_php.php
/includes/templates/YOUR_TEMPLATE/templates/tpl_account_history_info_default.php

Could you please give me a brief explanation of what DOUBLEBOX does. From my brief play so far, I have a few boxes in the subtotal area that dont seem to do anything.

Happy Holidays

dw08gm:

Diva et al - Many thanks for zensational work - and especially for delivering this mod before Xmas.You're welcome..:smile: But I can't take all of the credit.. JTheed was the MAN on this release.. and tonyneimann was a real doll for sharing his PDF invoice code.. So gotta give PROPS to both of these guys too.. :clap:

dw08gm:

Missing Files - do we delete or retain the following file from previous version?
admin/includes/languages/english/super_customers.php

In the Readme > Files > Required_Core_Edits - there is no mention of what to do with the following files:
/includes/languages/english/YOUR_TEMPLATE/account_history_info.php
includes/modules/pages/account_history_info/header_php.php
/includes/templates/YOUR_TEMPLATE/templates/tpl_account_history_info_default.phpMy bad for not including this in the readme..:blush:

both super_customers.php files are deprecated in v3.0

/includes/languages/english/YOUR_TEMPLATE/account_history_info.php
includes/modules/pages/account_history_info/header_php.php
/includes/templates/YOUR_TEMPLATE/templates/tpl_account_history_info_default.php

These files from the optional edits folders in the last version are no longer needed as their only purpose was to hide certain comments from customers (a rudimentary version of "admin" comments) Zen Cart 1.3.9 natively supports hidden comments, and that functionality was ported over to Super Order v3.0.

That said these are core files, you just need to backout the mods made for Super Orders and reatina any other mods you may have in these files.. If you have no other mods other than the Super Orders mods, you can SAFELY delete

• /includes/languages/english/YOUR_TEMPLATE/account_history_info.php
• /includes/templates/YOUR_TEMPLATE/templates/tpl_account_history_info_default.phpYou will need to carefully remove any Super Orders changes from:
• includes/modules/pages/account_history_info/header_php.php> dw08gm:

Could you please give me a brief explanation of what DOUBLEBOX does. From my brief play so far, I have a few boxes in the subtotal area that dont seem to do anything.

Happy Holidays

dw08gm:

Could you please give me a brief explanation of what DOUBLEBOX does. From my brief play so far, I have a few boxes in the subtotal area that dont seem to do anything.If I am remembering correctly (not in from of my home PC) This code comes from the FEC merges, you should post your query in the FEC support thread as to what it actually does..

dw08gm:

Happy HolidaysSame to you..:smile:

I just upgraded to v 3.0 and am getting a couple of errors.

1. When I go into an order's detail I get the following at the top:

1054 Unknown column 'split_from_order' in 'field list'
in:
[select split_from_order, is_parent from orders where orders_id = '3625']
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.

2. Below the Payment Method is says...

No Order Payment Data Available

...and there is no more information. It is completely blank. It doesn't show any order info or payment info.

Any thoughts?

stevelucky:

I just upgraded to v 3.0 and am getting a couple of errors.

1. When I go into an order's detail I get the following at the top:

1054 Unknown column 'split_from_order' in 'field list'
in:
[select split_from_order, is_parent from orders where orders_id = '3625']
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.Your DB is missing a required column.. Did you run the upgrade script?????

stevelucky:

2. Below the Payment Method is says...

No Order Payment Data Available

...and** there is no more information**. It is completely blank. It doesn't show any order info or payment info.

Any thoughts?It sounds like an incomplete/incorrect install which is causing the rest of the page not to draw in the browser.. Check your install.. Make sure you did not skip any steps..

Never mind, I figured it out (I'm an idiot and didn't install the SQL upgrade file).

But, it still says, "No Order Payment Data Available" even though it shows their payment as having gone through. Why is that?

Quote:
Originally Posted by stevelucky View Post
I just upgraded to v 3.0 and am getting a couple of errors.

1. When I go into an order's detail I get the following at the top:
   Quote:
   1054 Unknown column 'split_from_order' in 'field list'
   in:
   [select split_from_order, is_parent from orders where orders_id = '3625']
   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
   .
   Your DB is missing a required column.. Did you run the upgrade script?????

Quote:
Originally Posted by stevelucky View Post
2) Below the Payment Method is says...

Quote:
No Order Payment Data Available
...and there is no more information. It is completely blank. It doesn't show any order info or payment info.

Any thoughts?
It sounds like an incomplete/incorrect install which is causing the rest of the page not to draw in the browser.. Check your install.. Make sure you did not skip any steps..

stevelucky:

But, it still says, "No Order Payment Data Available" even though it shows their payment as having gone through. Why is that?Because there is no Super Order payment record for that order..

If you are expecting that payment records will be created where none existed before that is not going to happen.. The SQL script adds the necesarry tables to store payment data, it is not going to go through all your orders and create payment records for all your PayPal and credit card paid orders..

Would that imply that new orders going forward would have that information? I've received a couple orders in the last few minutes and they didn't have that info either.

Quote:
Originally Posted by stevelucky View Post
But, it still says, "No Order Payment Data Available" even though it shows their payment as having gone through. Why is that?
Because there is no Super Order payment record for that order..

If you are expecting that payment records will be created where none existed before that is not going to happen.. The SQL script adds the necesarry tables to store payment data, it is not going to go through all your orders and create payment records for all your PayPal and credit card paid orders..

stevelucky:

Would that imply that new orders going forward would have that information? I've received a couple orders in the last few minutes and they didn't have that info either.
If you are referring to the auto generation of Super Orders payment records, yes and no..

What was the payment method for these orders??

Only orders paid via credit card (Authorize.net & Linkpoint) and PayPal will auto generate a Super Orders payment record.. All other payment methods (as in previous versions of Super Orders) still require you to manually enter a payment record..

I really love the new PDF packing slips. Is there a way to format them more like the standard packing slips? They look more like invoices. The packing slip shouldn't show the price. Also, it tries to fit the item and all the attributes on 1 row in a small box. If they run too long, they just run off the edge of the page.

stevelucky:

I really love the new PDF packing slips.They are indeed one of the coolest new features..:smile:

stevelucky:

Is there a way to format them more like the standard packing slips? They look more like invoices. The packing slip shouldn't show the price.
Our goal with EVERYTHING we did with Super Orders v3.0 was to remain true to the modules original purpose and expand upon that. We also wanted to provide features that would be useful for a majority of shopowners.. That said as with anything, there are some features that some shopowners will fiind more useful than others, and other features shopowners would like to see tweaked in a particular way. This is one of those features for you:smile:..

After a fair bit of discussion on the merits of including/excluding the pricing information on the PDF packingslip/invoices amongst the developers of v3.0, it was a deliberate design desicion to include the pricing data on the PDF packingslip/invoice. This way whether you needed a invoice or packing list you could use one form.. BTW, this is not an unusual design either.. There are companies who's packingslips include pricing information (Amazon.com being one of them)

IF we decide to update this, in the spirit of keeping this module useful for a WIDE variety of shopowners, it would probably be done as an admin controlled option.

stevelucky:

Also, it tries to fit the item and all the attributes on 1 row in a small box. If they run too long, they just run off the edge of the page.If you can show me an example of what this looks like I can work on correcting it.. Can you upload a sample PDF packingslip here?? (using the post attachments option)