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

Look under: Localization / Order Status

thank you very much... hmm somethings are just easier then you think.

mauryg:

milobloom,
I haven't tried to go from SO to TYTracker except via the menu but if you want to go from Ty to SO look at

http://www.zen-cart.com/forum/showpost.php?p=540691&postcount=210

I used plan B and it worked fine.

Which file did you edit???

This looks like a very useful contribution, but there is another thread in the forum that states that Super Orders does not work with PHP 5. Is this true? I find that a bit hard to believe.

I've read through the last 10 pages of posts in this thread and I didn't see the PHP 5 issue raised.

I have my first Zen Cart site almost completed. Are there any known issues that may prevent this contribution from working well with the following?

Zen Cart 1.38a
PHP 5
MySQL 5

I have a number of carts running php5 and Mysql5 with superorders and have had no problems

Thanks barco57.

PHP5 is pretty compatible with most legacy code, so the statement that it wasn't compatible did not make sense for something that looks like it is using current coding standards.

I'll install it. Super Orders looks to be very useful.

toholio:

I've been setting up Super Orders and have run into a problem with order totals editing. From this thread I can see that the problem is quite common.

In Australia, and other countries, prices need to always be shown including tax. This means that invoices include the total of all item prices (inc. tax) in addition to a tax field.

So an invoice might have the following:
Order subtotal: $45
Included Tax: $4.09
Total: $45

If one edits the order totals using Super Orders then the new total will have the tax summary incorrectly added to the tax inclusive subtotal. Using the above totals as an example, if one opens the edit totals window and clicks submit without actually changing anything then the totals would be changed to:
Order subtotal: $45
Included Tax: $4.09
Total: $49.09

The quick and dirty fix I'm using for this problem is to comment out line 491 in super_edit.php which will remove tax from the running total calculated there.

Obviously a better solution would be required for people who do sometimes need tax added. The addition of tax in the total could be made conditional but I'm unsure of what to test...

Hope this helps.Ah. Those Americans. Never before has the world seen a nation with the ability to create such complex sales taxes. I have a client whose state levies sales taxes at the state, county and city levels creating literally thousands of possible rates. If they'd known, maybe they would have been more sympathetic to the British tea tax! Happily (and amazingly) Zen Cart copes.

However, over here in the UK, as in many other countries, consumer products are priced inclusive of sales tax and if the tax is mentioned at all, it's simply as a memo item on a receipt. For most of my clients therefore I swap the tax and total fields around to read
Unit price inc VAT: £22.50
Quantity: 2
Order subtotal: £45.00
Shipping: £5.00
Total: £50.00
Included VAT: £8.75

As Toholio has observed, Super Orders really doesn't like this, and I'm surprised that there's not been more discussion on this. Maybe because it only becomes obvious when you split or edit an order?

However, persuading it to work our way isn't so difficult. Here's the approach that I've just implemented for a client ...

Find the admin\includes\functions\extra_functions\super_orders_functions.php file and within it the recalc_total() function.

Find this block near the topphp // not everyone charges tax, so we check to see if it exists first if ($products->fields['products_tax'] > 0) { $this_tax = $this_subtotal * ($products->fields['products_tax'] / 100); $ot_tax += $this_tax; } and replace it with ```php
// not everyone charges tax, so we check to see if it exists first
if ($products->fields['products_tax'] > 0) {
$this_tax = $this_subtotal * ($products->fields['products_tax'] / 100);
$ot_tax += $this_tax;
$ot_subtotal += $this_tax; // add tax for products quoted inclusive of tax
}

Find this block```php
    if ($all_totals->fields['class'] != 'ot_total') {
      if ($all_totals->fields['class'] == 'ot_gv' || $all_totals->fields['class'] == 'ot_group_pricing') {
        $ot_total -= $all_totals->fields['value'];
      }
      else {
        $ot_total += $all_totals->fields['value'];
      }
    }
```and replace it with```php
    if ($all_totals->fields['class'] != 'ot_total' && $all_totals->fields['class'] != 'ot_tax') {
      if ($all_totals->fields['class'] == 'ot_gv' || $all_totals->fields['class'] == 'ot_group_pricing') {
        $ot_total -= $all_totals->fields['value'];
      }
      else {
        $ot_total += $all_totals->fields['value'];
      }
    }
```This prevents the tax from being adding into the overall total (which would be a double count).

This probably won't work for everybody, but will hopefully show how easy it is to tweak Super Orders to cope with different tax regimes and customs.

I have now gone live with this mod and am VERY impressed.

One more query though. I intend to print a copy of the the admin side summary (where you can edit orders - it's also is the page that shows if the customer has been notified etc) for my records. To comply with UK tax rules my paperwork must not make any reference to tax (because I'm not registered).

I've removed the headings, ie Tax, Total(inc) and so on, but I'm blowed if I can work out where to edit out the actual data!. This is especially frustrating as I managed to remove same from invoices and delivery notes.

Can anyone point me in the right direction please.

Many thanks

Philip

Anyone?

grace83:

I'm having some trouble installing. I've uploaded all the files, but am having issues with the SQL file. I tried uploading hte file through ZC's "install SQL Patches", but got an error. When I tried uploading the file again, this is what I got:

"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."

How do I fix this? I'm not all that familiar with SQL, I could really use some help!

grace83:

Anyone?

This is a common SQL error when you create a table then try to create the same table once more. Error shows due to a attempt to create a table or key with the same name. The tables may already exist. I would use phpmyadmin to check the table out or see if Super Orders is working before trying the fix below. More then likely the tables are good and you don't need to fix anything.

You have some options here...
1, Fix the table in phpmyadmin by dropping or adding the data that is missing, or drop the table and start over again.
2, Replace the database with your backup and try it again.
3, rewrite the sql file to do the drop and replace for you.

I like # 3 myself. You should have this added to your tables when you do a backup anyway, make life much easer.

open the sql file in note pad or any simple text editor. At the top of each table you will see 'CREATE TABLE' with a table name like this.. CREATE TABLE so_payment_types (

you need to change this line and add a line ..
DROP TABLE IF EXISTS so_payment_types;
CREATE TABLE IF NOT EXISTS so_payment_types (

What the two commands do! the first DROP TABLE IF EXIST table name, this deletes the table if it finds it, which is needed in order to replace it. Next line, CREATE TABLE IF NOT EXISTS table name, this one builds the table after deleting it, or creates it if it's not there.

**This deletes the table and rebuilds it... basically anything that was in it will be GONE! ** Back up your table... As said thought out this site.... BACK it UP..

Once you made your edits for each table name, and back up your database... you can copy and paste into Admin>>Tools>>Install SQL Patches and run it. This will rebuild the tables for this mod.

@grace83

As davewest says, the error message that you have posted is to be expected when you re-run the script. Clearly it has at least partially succeeded. His suggestions to clear down that file and re-load it are accurate, and I'd probably do that myself. However, I doubt that it will solve your problem.

The reason for this is that that error upon re-run is showing us that the so_payments_types table got created and populated. So that's not actually where your underlying problem is.

To know what and where that problem occurred we would need to know what your original error was - the one that caused you to re-run the script.

You've probably forgotten it. If so, then to investigate you need to do the following.

1. Use phpMyAdmin (or similar) to check if the extra fields (at the top of the SQL file) have been added to the orders table and if they have delete these insertions.
2. Add drop table if exists statements for all five new tables as explained by davewest.
3. Check your Admin to see if the new Super Orders settings fields are showing up in your Configuration menu (or you could check the configuration table in phpMyAdmin) and if they are there delete these statements from the SQL file.If the orders or configure tables didn't have the extra fields, then that's probably where your problem lies. Otherwise re-run the SQl file are directed by davewest, and if any errors occur, make a note of them and post them exactly as they appear back here.

Thank you very muc for the contribution. but the installation is reallly confused to me:blink::blink::blink:

Thank you very muc for the contribution. but the installation is reallly confused to me. hope can get a easier installation way next vertion.

Hi All,

A quick question I have been using super orders now for around 4 weeks and its a great timesaver and thanks to the contributer who created and maintains it.

My problem is that when you select an orders details and then tick the notify customer option it always comes up with a cross and never a tick no matter what I do. Below is a screenshot of an order however I ensure that I selected the tick box to notify the customer.

The emails seem to be getting through however It would be great to get this working also.

Cheers

Brett
http://www.eastcoasthobbies.com.au

Ok I think I found the answer to the above here
http://www.zen-cart.com/forum/showpost.php?p=537572&postcount=971

Can someone please verify that this is the correct change.

Thanks :+)

Brett

Never mind I tested it on the test site first and it worked.

Cheers

Brett

When I go into the batch status update and pull up the order I want to change the status of, the comments box is really small...like one character wide and 5 characters tall. So I can't even see anything I type into it. How do I change that? I looked at the batch_status_update.php file was unsure as to what values to change. Any ideas?

Hi All,

Todays small cosmetic problem of mine.. :smile:

I have a module installed for Australia Post which adds two images for the shipping type. The first is the Australia post image which shows up fine however the second is the type of shipping i.e parcel post, airmail etc.

The first image is showing up fine on the main "Super Orders" page and in all the other places where you see shipping however the second image is not showing up at all.

I have figured out that it is coming from the following code in for example the super_packingslip.php

<td class="main"><strong><?php echo ENTRY_SHIPPING_METHOD; ?></strong></td>
<td class="main"><?php echo $shipping_method; ?></td>

However am unsure where to go from here.

Any help would be great.

Cheers

Brett

Frank, and others who might be interested...

Just ran into a wierd "bug" with SO 2.0. Store owner received an order with multiple items. Had to backorder 2 items. Did order split (edit products), edit totals, modified payment and shipped the first part. Created Fedex label and entered tracking number into TyTracker, changed status on shipped order to "shipped" and notified customer. Backordered items were "pending". Then owner accidentally changed status on shipped items to "pending" and the first order disappeared from SO page. Second (split) order still visible. Both parts visible in customer account in store and in products purchased, etc.

Problem corrected by deleting last status change to "pending" in edit status history. Just thought you'd like to know.

BTW Don't think the owner actually clicked on one of the buttons, but what exactly do the "Order Completed" and "Order Cancelled" buttons do? There is nothing in the readme file.

We just got our first order from a customer using PayPal for payment. I have only PayPal Express Checkout enabled, IPN is set up in PayPal and the transaction is set to "authorization only" so that I can change the amount before capture in case we have a back order. I have removed the PayPal button from the shopping cart page so the customer has to go through the normal shipping and payment pages.

On the SO details page all of the PayPal information appears in the middle of the page. The order appears with a "Payment Status " = "pending" and a "Pending Reason" = "authorization". There is no payment listed and the order totals shows "Amount Applied" = 0 and "Balance Due" equal to the full amount of the order. If I go to PayPal and "authorize" the payment then the details page shows the "Payment Status" = "Completed" but the Amount Applied and Balance Due do NOT change. I have to click on the "Payment" button and manually add the PayPal payment in order to get the order totals to be correct. Also the only "Payment Type" I can use is "Adjustment" because PayPal does not appear in the list.
Even stranger, if I look at the PayPal IPN page in the Customers menu, the transaction is still pending.

Anyone have any ideas how I can fix this? :cry: