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

Status on the upcoming release (highlights):

Super Orders Auto Payment Generation for PayPal Orders:
So after a LOT of trial and error, I was able to fix the PayPal auto payments code.. Still dunno why the code in the current v3.0 fileset worked on my client's store.. (and still does) But no matter got it all working. Felt I needed to explain HOW the PayPal auto payments will be generated so that it is CLEAR how this functionality will work.

A Super Orders payment record will be auto-created for PayPal paid orders if:

• There is no existing Super Orders payment record for the order
  AND

• The PAYPAL payment status is "Completed"
  IF BOTH conditions are true, then a Super Orders payment record will automatically be created for the order.

NO AUTO PAYMENT will be generated if:

• There is an existing Super Orders payment record for the order
  OR

• The PAYPAL payment status (NOT THE ORDER STATUS) is NOT "Completed"

The benefits to this are two-fold:

• Super Orders payment records will generate for older orders now.:clap: (All you have to do is open the target order and the Super Orders payment record will be auto created for you!!)
• Super Orders will not inadvertently generate a Super Orders payment record until the PayPal payment has been completed and cleared by PayPal. (preventing orders in which the payment is NOT "Completed" from being inadvertently marked as a paid order when in fact it is not) When the PayPal payment status is updated (an automatic Zen Cart function), then the Super Orders payment record will automatically be created!
  **

Credit Card Auto Payment Generation Tweak:**
I decided to update the class file that auto generates Super Orders payments for credit card paid orders based on Blindside's post here:
http://www.zen-cart.com/forum/showpost.php?p=276219&postcount=207. (just the part of this code which relates to credit payments.. PayPal auto payments are handled differently)

I meant to include this in the v3.0 release, but it slipped my mind..:laugh:

I liked the fact that it no longer hardcodes the credit card codes, and instead relies on the data in the Super Orders payments types table. IF a NEW credit card type is supported by Zen Cart, the only thing Super Orders users need to do is to create a corresponding Super Orders payment type (the Super Orders payment code must match the corresponding credit card as it does now for supported credit cards).. This is loads easier for all I think!!

This will help keep people -- particularly newbies -- "out of the code" just to update the module.. Having to edit module files is often where things go wrong for newbies:smile:..

*Just so it's clear -- Auto payment generation for credit cards is slightly different than the new PayPal auto payment generation.

Auto payment generation for credit cards happens at the time of checkout. While PayPal auto payments are generated when the order is accessed from the Super Orders management screen.

The reason for this difference has everything to do with the general assumption that credit card payments are collected at the time of the sale, while PayPal payments may not be confirmed until 24-28 hours after the order is completed.*

**===============================
**

Got a lot ready for the next release (these are just some highlights).. I still have a few buglets left to grapple with.. I'll post here when I have additional updates on the next release.. (Please don't ask for an ETA.. I have to fit this work in between all my other obligations.. I am working as fast as my free time allows folks.. But I am hoping you will see something REALLY soon!:smile:)

Woot! Looking forward to it! Great work Diva! :clap:

ScriptJunkie:

Woot! Looking forward to it! Great work Diva! :clap::laugh: Thanks.. Still working out ALL the kinks.. but hopefully this will be the last bugfix update for a long time....

Well...it's a huge mod (in terms of how much it does) and a very cool one to boot! Since it ties in to some of the most complex operations in Zen Cart, it's bound to need a few re-visits to the code :smile:

I just love it! I'm just so grateful to you and the other developers who have worked/are working on it for all of your hard work in developing, improving, and most of all supporting it!

ScriptJunkie:

Well...it's a huge mod (in terms of how much it does) and a very cool one to boot! Since it ties in to some of the most complex operations in Zen Cart, it's bound to need a few re-visits to the code :smile:

I just love it! I'm just so grateful to you and the other developers who have worked/are working on it for all of your hard work in developing, improving, and most of all supporting it!Thank you and you're welcome..:laugh:

Actually the biggest challenge in the v3.0 release and the thing I have been hammering on all day today for the upcoming bugfix release has been trying to get all of the Super Orders functionality to line back up to the equivalent default Zen Cart functions. The default orders.php which Super Orders is based on has changed a bit since Super Orders was first released..

The biggest PITA has been getting all the various comment editing and updating functions to behave like the default orders.php, or just behave as expected.... (this includes not only order comments, but the batch status comments, and the comments editing functions as well)

The good news is that I think that I have finally worked out the LAST of all the comments bugs/functionality issues. This includes all the formatting, notification misfires, and other functionality issues that have been reported over the years.:clap:

I have more testing to do for other items that will be included in this bugfix release so I don't think that I'll be able to submit this tonight.. I may not have the bandwidth to finish the testing and bundle this all up for at least 1 week. I really want to make sure that I do a FULL proper QA of the code before it's released, and I need time to do this as my paid work and dayjob come ahead of free modules work..

So I appreciate everyone's patience..:smile:

Using the advanced search facility of Free Software Add Ons, SuperOrders3.0 is not yet listed amongst the mods released since 1st December 2010.

Not a criticism, just an observation.

dw08gm:

Using the advanced search facility of Free Software Add Ons, SuperOrders3.0 is not yet listed amongst the mods released since 1st December 2010.

**Not a criticism, just an observation.**And not taking it as a criticism since this is not something I can control.

But since you posted this, it this isn't really a Super Orders issue.. You should address your concerns with the Advanced Search functionality of the Free Software Add Ons with the Zen Cart admins.. That search function only returns results when the search criteria matches the FIRST released date (as opposed to the last modified date -- which is why Edit Orders v3.0 is listed while all the updated modules I submitted at the SAME time are not)

You'll simply have to check back this on thread when the update has been submitted. As I always do, I will also post when the update is available in the free downloads.

I wonder if it would work by renaming Super Orders to SuperOrders3. Just a thought.

dw08gm:

I wonder if it would work by renaming Super Orders to SuperOrders3. Just a thought.Only if I had submitted Super Orders 3 as a BRAND new module.. It technically was not brand new. Hence why it was submitted as an update (as it really is that).. We started a new support thread as the old one is quite long, and most of what's posted there in terms of bugs and enhancements was incorporated in to the v3.0.x codebase.

This is kinda off topic here, but you are probably wondering WHY Edit Orders wasn't submitted as an update.. Let me explain so the FULL story is clear..

Edit Orders v3.0 was a different story. It was submitted as a new module because at the time I submitted it, it was presumed it would be a new seperate release.. At the time we were in the middle working on an Edit Orders update (based on the v2.04 codebase in support of the Super Orders v3.0x release) there was a gentleman who began working on development of Edit Orders based on the Edit Orders v1.53 codebase.

Now as you know, Edit Orders v3.0.x was based on Edit Order v2.04 which IS the upgrade to Edit Orders v1.53.

This gentleman had declared in the old edit orders support thread that all versions of Edit Orders v2.x were considered by him to be a fork of v1.53, and that his development path was not going to be based on the Edit Order v2.0x codebase at all. He would in effect be starting with the v1.53 codebase and based on his statements, he would be developing Edit Orders v1.5x on a seperate path..

Therefore any release I did based on the Edit Orders v2.04 codebase would technically be a NEW release. To minimize any confusion, and allow both dev paths to continue on, I was advised to submit Edit Orders v3.0 as a NEW mod.

The other gentlemen did post two releases based on the Edit Orders v1.53 codebase (v1.54, 1.55). Coincidentally both of these releases were withdrawn from the Free Downloads after v3.0.x was released. According to the other developer's forum posts, he apparently will develop this on his own and release the final codebase at a later date.

Hope this all makes sense now.. In any case you should speak to the admins about how the Advance Filter on the Free Downloads works if you have concerns. I will always post the latest status for new/updated Super Orders releases here in this support thread..

dw08gm:

I wonder if it would work by renaming Super Orders to SuperOrders3. Just a thought.

DivaVocals:

I will always post the latest status for new/updated Super Orders releases here in this support thread..
Let me add one more thing.. There are no plans to submit Super Orders as a NEW module under a NEW name when it is in fact NOT a new module at all.. It is in fact an UPDATE to Super Orders, and the VERSION number was advanced because the changes in v3.0 ARE significant changes and they warranted a new version number.

We've got no plans to rename it simply so that it shows up in a "newly submitted" module search. That would be akin to MS renaming MS Word because they've made significant changes to the product. MS doesn't do this, and we don't have plans to rename Super Orders for similar reasons.

It seems that what you need is to see new modules as well as UDATES to modules show up in your Free Downloads advanced searches. Therefore, you might consider asking the admins if they have plans to add a last modified date option to the Advanced Seach criteria in the Free Downloads section. That would get you the solution to what you are looking for. Like I posted earlier.. This really isn't a Super Orders issue.. Suggest speaking to the admins regarding the Free Downloads search functions..

HTH..:smile:

Hi,

I may have missed it in the readme, but will SO 3.0 install fine into a 3.8 Zen store?

Or will I need to install the 2.0 version.

Thanks in advance,
Will

fungizmos:

Hi,

I may have missed it in the readme, but will SO 3.0 install fine into a 3.8 Zen store?

Or will I need to install the 2.0 version.

Thanks in advance,
Will
We did not test Super Orders on a v1.3.8 install.. I cannot say for sure whether it will or WILL NOT work on a v1.3.8 store.. It's possible that it will work, but again, we did not test the new version on v1.3.8 stores.. As posted earlier in this thread Super Orders v3.0 will NOT run in PHP4 environments (must have PHP5)

Hoping someone can please help.....

I upgraded to Zen Cart 1.3.9h and Super Orders (v??) stopped working so I downloaded Super Orders 3.0.

I followed the installation directions to the letter and, at first, it seemed that everything was back to normal.

But, now I notice that, when I print the order detail, I get the following error message near the bottom, near where the Order Status History table should appear:

ORDER STATUS HISTORY & COMMENTS 1054 Unknown column 'track_id1' in 'field list'
in:
[select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments from orders_status_history where orders_id = '3402' order by date_added]
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 found some threads that referred to what appears to be a similar error, but quite honestly don't understand what is being said. I think I am pretty good with Zen Cart, but I'm certainly not a professional web designer, so please make your responses on the "idiot" side and help me find and fix the error.

Also, I have reinstalled Super Orders twice just in case I had a corrupt file, but that also didn't help.

Thanks in advance!!

If you are referring to these two posts:
http://www.zen-cart.com/forum/showpost.php?p=974123&postcount=14
http://www.zen-cart.com/forum/showpost.php?p=974128&postcount=15

The error means that you have not followed all of the install or upgrade instructions..

DivaVocals:

Your DB is missing a required column.. Did you run the upgrade script?????

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:

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

SafetySam:

Hoping someone can please help.....

I upgraded to Zen Cart 1.3.9h and Super Orders (v??) stopped working so I downloaded Super Orders 3.0.

I followed the installation directions to the letter and, at first, it seemed that everything was back to normal.

But, now I notice that, when I print the order detail, I get the following error message near the bottom, near where the Order Status History table should appear:

ORDER STATUS HISTORY & COMMENTS 1054 Unknown column 'track_id1' in 'field list'
in:
[select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments from orders_status_history where orders_id = '3402' order by date_added]
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 found some threads that referred to what appears to be a similar error, but quite honestly don't understand what is being said. I think I am pretty good with Zen Cart, but I'm certainly not a professional web designer, so please make your responses on the "idiot" side and help me find and fix the error.

Also, I have reinstalled Super Orders twice just in case I had a corrupt file, but that also didn't help.

Thanks in advance!!

Hello I have a question about the customer files. If Iunderstand correctly does super_customers replace the default customer files?

I've been trying to add the referral mod but it just won't take. I'm going crazy and just looking for some guidance. Does Super Orders affect the way accounts are created at all? Thank you.

super_customers.php has NEVER done anything and was in fact removed from the v3.0 fileset.. (this is elaborated on earlier in this support thread..)

Super Orders doesn't do anything more except provide an enhanced version of the default orders.php.

joyjoy:

Hello I have a question about the customer files. If Iunderstand correctly does super_customers replace the default customer files?

I've been trying to add the referral mod but it just won't take. I'm going crazy and just looking for some guidance. Does Super Orders affect the way accounts are created at all? Thank you.

OH I must've missed that! Okay, that might help...but I'm still stuck. Thank you.

In the Super Orders mod is there a place that reflects "removed" files from previous versions that can be deleted? Like the super_customers file?

And just to verify, since super_customers does nothing, does that mean I can delete it?

joyjoy:

OH I must've missed that! Okay, that might help...but I'm still stuck. Thank you.

In the Super Orders mod is there a place that reflects "removed" files from previous versions that can be deleted? Like the super_customers file?

And just to verify, since super_customers does nothing, does that mean I can delete it?All your questions are answered on page 2 of this thread:
http://www.zen-cart.com/forum/showthread.php?t=170525&highlight=super_customers&page=2

Great! Thank you again. Wonderful work!

I've upgraded SU to the new version but one thing looks strange. It appears a language definition is missing. I've looked and don't see anything missing. In the attached image, aren't -TEXT_EMAIL -TEXT_NOEMAIL -TEXT_HIDE undefined text or images?