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

[BSHRC]

Thanks.. Had my head so close to the grindstone that it never ocurred to me to include one.. and MAN I could use a Starbuck Card refill.. I sure sucked down a LOT of iced coffees in this process.. I'm sure JTheed went through SEVERAL bottles of asprin..

I'll have to give a donate button some thought..

More than happy to send you a Holiday Strabucks refill for the both of you.

Thanks again for the contributions and continued support.

[DivaVocals]

Wanted to point out that the two queries you cited are coming from TWO DIFFERENT tables. (see highlighted sections below..

It'll help to determine if there is an issue and how to address it if you can tell me what the default orders.php page looks like for this SAME order.. Also screen prints of the default invoice.php and the super_invoice.php would also be imensely helpful.. Since Super Orders is based off of the default Zen Cart orders.php this is helpful information..

The SuperOrders Order Payment Data and Amount Applied seems to come from the orders table:

SELECT orders_id, order_total, order_tax
FROM `cart1_orders`
WHERE `orders_id` =1166

orders_id = 1166
order_total = 19.22
order_tax = 1.04

But invoice shows different, and authorize.net charge is $19.23

SELECT *
FROM `cart1_orders_total`
WHERE `orders_id` =1166

This shows:
|title | text| value
|CA state sales tax: | $1.05 | 1.0450
| Total: | $19.23 | 19.2250

[DivaVocals]

Doing little sleuthing in the forum I am confident that this reported issue is NOT a Super Orders issue at all.. If markcarranza had posted screen shots of the default order.php and invoice.php I'm fairly certain that the order totals displayed would be the same as the ones shown on super_orders.php and super_invoice.php.

The values stored in the orders and order_totals tables are NOT affected by Super Orders in ANY way. Super Orders makes USE of this information for orders paid via credit card so that it can auto-generate a corresponding payment record in the Super Orders payment tables. Super Orders DOES NOT alter these values during the checkout/ordering process.

A search of the forum confirms that the tax rounding error is indeed a ZEN CART issue that was addressed apparently in one of the releases subsequent to the 1.3.9g release that markcarranza is running..

Suggest following one of the threads which discusses how to fix it if you are un-prepared to upgrade to the latest 1.3.9 release and SEE if this doesn't resolve the issue.. (BTW the fix will likely not FIX any orders already received, but it should correct orders received after the fix is applied..)

Tax rounding problem in Superorders 2.0
Using v1.3.9g, couldn't find problem in Forum. Please see graphic.


The SuperOrders Order Payment Data and Amount Applied seems to come from the orders table:

SELECT orders_id, order_total, order_tax
FROM `cart1_orders`
WHERE `orders_id` =1166

orders_id = 1166
order_total = 19.22
order_tax = 1.04

But invoice shows different, and authorize.net charge is $19.23

SELECT *
FROM `cart1_orders_total`
WHERE `orders_id` =1166

This shows:
|title | text| value
|CA state sales tax: | $1.05 | 1.0450
| Total: | $19.23 | 19.2250

Is this fixed in SuperOrders 3.0? Suggestions? Thanks!

Short answer.. didn't know it was broken in the current version.. Didn't test for this EXPLICITLY in the v3.0 testing..

Question for you... What does the order total read in the default orders.php??

Wanted to point out that the two queries you cited are coming from TWO DIFFERENT tables. (see highlighted sections below..

It'll help to determine if there is an issue and how to address it if you can tell me what the default orders.php page looks like for this SAME order.. Also screen prints of the default invoice.php and the super_invoice.php would also be imensely helpful.. Since Super Orders is based off of the default Zen Cart orders.php this is helpful information..

[sanji]

I couldn't find this new release. Could you please provide a link to the download if it has been released? I stayed on a modified version of SO 1.0, because I absolutely wanted to have the possibility to add products to an order, so I am pretty excited to test this new release...

sanji

Super Orders 3.0 is READY for release.. I am just doing one last quality check, and I will have this all packaged up and submitted tomorrow night..

[DivaVocals]

I couldn't find this new release. Could you please provide a link to the download if it has been released?

All submissions must be approved by the Zen Cart admins before they are available to download.. When this happens as always I will update this thread.

I stayed on a modified version of SO 1.0, because I absolutely wanted to have the possibility to add products to an order, so I am pretty excited to test this new release...

sanji

The editing functions in older versions of Super Orders was based on an OLDER version of Edit Orders.. Using one of the newer versions Edit Orders would have allowed you this same functionality with newer/improved functionality.

The ability to edit orders directly in Super Orders has been deprecated in v3.0 in favor of providing an integration option with the Edit Orders mod (which you must download and install to take advantage of this feature). This will MORE than adequately provide those who desire order editing functionality with an improved means to do so.

In any case I hope you made note of the FULL change log I posted earlier.. In particular the following items..

• Order total and customer address edit features have been removed in their entirety. (use Edit Orders if you need order/customer address editing functionality)
• 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!!)

[DivaVocals]

I have a feeling I'm going to have to repeat this a few times, so let me post this now so I can copy and paste or refer to it later..




I have been asked a few questions about the Super Orders v3.0 integration options to support other Zen Cart add-ons/modules. So let me clarify a few things.

1. Question: Did I read that right?? Does Super Orders v3.0 now come with Edit Orders, Ty Package Tracker, USPS Click-N-Ship, and FedEx Automated Labels already bundled in???
   
   Answer: NO! But we've made it EASIER for Super Orders users who use (or want to use) these mods with Super Orders.
   
   We looked around and found that there were a number of modules which kindly provided Super Orders files edited to work with these modules. Over time however many of these add-ons did not always update these Super Orders files to match the latest versions of Super Orders. Also if shopowners were running more than one of these add-ons sometimes the job of merging all the changes was a little daunting was some..
   
   Initially we talked about bundling all of these modules into Super Orders, but thought better of it.. Not all shopowners need (or want) Ty Package Tracker for example. So instead we opted for making the required changes while still providing shopowners the flexibility to choose which mods they wanted to enable to use with Super Orders (versus forcing extra mods on them).
   
   For ANY of the new Super Orders v3.0 integration options to work you MUST have the required mod(s) installed first. Then you simply "turn on" the appropriate admin flag to enable that modules fields/buttons in Super Orders. If you do not have the required mod installed and turn on the admin flag you will get errors in your store..
   
   We are strongly suggesting that you get the other modules up and ruinning FIRST so that you do not mistakenly assume that install issues with the other mods are with issues with Super Orders. We have tested EACH and every one of these mods and find they all work if installed as their readme files direct. Once they are installed and working correctly "turning on" the appropriate admin flag takes care of making them work with Super Orders. (please note in the readme file which versions of these mods are currently supported)
   
   ---------
   
   ---------
   
   ---------
2. Question: Do I HAVE to install Edit Orders, Ty Package Tracker, USPS Click-N-Ship, or FedEx Automated Labels to use Super Orders v3.0?
   
   Answer: NO! You DO NOT have to use the integration options NOR are you required to installed any of the integrated modules in order to use Super Orders.. We simply wanted to make using these modules EASIER for Super Orders users..

I STRONGLY suggest to EVERYONE who plans to install or upgrade to please READ the Super Order v3.0 readme file..
There are LOTS of details in it which should answer most questions you may have.. More importantly it contains vital instruction son HOW to upgrade, and HOW to use the new integration options we have built in..

[sanji]

Thanks DivaVocals,

It was indeed clear that the newest Edit Orders version 3 has to be installed. I am waiting for SO 3 to be released, and intend to install both mods together to limit the handling.

Looking foward for the release by the Zen Cart team ;)

sanji

[DivaVocals]

Thanks DivaVocals,

It was indeed clear that the newest Edit Orders version 3 has to be installed. I am waiting for SO 3 to be released, and intend to install both mods together to limit the handling.

Looking foward for the release by the Zen Cart team ;)

sanji

No problem.. Will update the community when the new version is approved and available..

[dw08gm]

Another mod to consider is COWOA, although JTHeed seems to have already taken this into account.

While I keenly await the SO3 release, the only other mod I require to finish my store is Events Calendar, which is in dire need of improvement. Nudge nudge wink wink.

[DivaVocals]

Another mod to consider is COWOA, although JTHeed seems to have already taken this into account.

We already took a look at this and decided to NOT include any built-in integration for these two mods.. But COWOA and FEC users still get a special treat in the new Super Orders.. In the absence of the same integration flags we used for other mods, we have provided properly merged Super Orders files for users of FEC or COWOA in the Super Orders fileset.

In our analysis of the COWOA we discovered that it and FEC share FAR too much common code to make the current method we use to turn mods on/off in Super Orders feasible for these mods (COWOA and FEC) at the moment.. It would require a GREAT deal of work on our parts.. and we thought our efforts were better spent on the other things we wanted to implement in Super Orders -- hence why we are at LEAST providing the properly modded files needed for BOTH COWOA and FEC.

FYI, the Super Orders files you got from JTheed are VERY different than the ones which will be included in the upcoming release.. The ones on JTheeds site are from a MUCH earlier RC of Super Orders. You'll WANT to upgrade..

While I keenly await the SO3 release, the only other mod I require to finish my store is Events Calendar, which is in dire need of improvement. Nudge nudge wink wink.

Yeah.. well.. I have a site in development now where the Events Calendar mod might be needed.. Dunno if I'll pick up the torch on that one.. I'm happy to watch!!