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

[wickedklown]

btw 1 other thing how can i add paypal to the drop down box when im applying a payment cause at the mo there cash cheque and various credit card types but no paypal

heres the box that i meen

in the admin console, under LOCALIZATION, youll find PAYMENT TYPES

you can add/delete payment types and refund types from there.

[modchipfitters.co.uk]

in the admin console, under LOCALIZATION, youll find PAYMENT TYPES

you can add/delete payment types and refund types from there.

ok great thanks for your help

[wickedklown]

No idea off hand as to what might cause it, but the nature of them leads me to believe it's in your mods and any customizations you've done. Here's a couple things to check...

1. Did you perform a full installation, particularly the required edits to the order classes in the admin and catalog sides?
2. Do you have any customizations to the account page in the catalog. It would be includes/modules/pages/account/header_php.php and/or includes/templates/[your_template]/templates/tpl_account_default.php
3. What version of Zen Cart are you running? This module shouldn't be used under v1.2.5.
4. I'm not totally familiar with all your mods, do any of them affect orders, order statuses, or the associated tables? If so, you may want to remove or disable them and see if the behavior continues.

well iv looked at all these files, and checked it all,

everything seems ok. Both the files you reqested i look at are identical to those that come with the zc install fileset. so they are unchanged.

is there anything else i can try?

its a drag having to del a comment and re-do it, just to make an edit..

thanks again. if you can think of anything, please let me know.

it works fine, as long as i dont try and edit it. thats when it gets all messed up.
---------------------------------------------
Extra NOTE:
I have a customized super_orders page now. It has the Info at a Glance contrib on it, as well as the USPS AUTOFILL contrib.
Search through the USPS Autofill contrib support thread and he has it posted right there for you to see. i also posted it in the info at a glace thread.
Just so you guys can take advantage of it too.

[tajul_ashyqin]

Extra NOTE:
...I have a customized super_orders page now. It has the Info at a Glance contrib on it...

hi,

can you share with us the customized super_orders page?!

[crazycucumber]

I am willing to let absolute look at my admin side , if its going to be any use for you , to help fix the batch e-mail thing. my cliemt really needs this to work , as he has 40+ orders a day . if it needs some money thrown at it let me know.

[wickedklown]

here is a link to the authors post.
http://www.zen-cart.com/forum/showpo...8&postcount=15

basicly, there are two files in there. both have the USPS click-n-ship autofill contrib, and the other overlib has the info at a glance.

NOTE: you must already have both these mods installed in order for this to work. all we are doing is adding them to super orders. for more info, contact the author

[BlindSide]

My settings are set to sendmail , I will try and get SMTP set up and working and test it that way.

Don't think it is spam , as the red cross is appearing in the update customer box etc . as if it never sent. Could it be a permissions thing ? I installed the easy Admin tool thing ( before super orders ) to create new users under admin , I have set myself and other user full perms to the super orders mod, but still no joy ! .

Bolded part has me curious. Are you using one of the admin levels modifications, which allow/deny access to various admin pages? That could very well be the issue. You need access to several files in order for the e-mail to go through. Here's a list...

• admin/includes/languages/english/super_orders.php
• admin/includes/functions/extra_functions/super_orders_functions.php
• admin/super_batch_status.php

I don't use any of those admin level mods, so I have no diea how SO will behave with them. Any way to disable it and then try again?

by offending dates - you mean find an order that has 2 payments, one with correct data and one with $0.00. and the dates should NOT match?

This is my most current order. This is the second payment created (YES in green payments bar) it now shows all 0's
$0.00 0000-00-00 00:00:00 0000-00-00 00:00:00

Unfortunitly, the manager told them to remove the other payment data that was not valid- so that is now the only one that i have showing 2 payments.

i told them to leave them be for now, becuase i need to look at them. so when the next order comes in, ill post what it says.
if this is a coding problem within my site, how will i track it down, and is there someone here that i can hire to fix it?
thanks again for your time BS- im sorry to be a pain..

It's creating the record, but not storing the proper values (the table defaults to all 0's when no value is added). Did you place the code from README step Edit the order.php class (catalog side) after the indicated line? it must go after

$insert_id = $db->Insert_ID();

The result you're seeing is possible otherwise.

btw 1 other thing how can i add paypal to the drop down box when im applying a payment cause at the mo there cash cheque and various credit card types but no paypal

Admin > Localization > Payment Types

Like wickedclown said, I have code to automate PayPal payments made at checkout for the next version. If you're feeling adventurous, here's the code for the modified function. Just replace the entire function as it exists in [catalog]/includes/class/super_order.php...

  function cc_line_item() {
    global $db;

    // first we look for credit card payments
    $cc_data = $db->Execute("select cc_type, cc_owner, cc_number, cc_expires, cc_cvv, date_purchased, order_total
                             from " . TABLE_ORDERS . " where orders_id = '" . $this->oID . "' limit 1");
    if ($cc_data->RecordCount() ) {
      // collect payment types from the DB
      $payment_data = $db->Execute("select * from " . TABLE_SO_PAYMENT_TYPES . "
                                    where language_id = " . $_SESSION['languages_id']);
      $cc_type_key = array();
      while (!$payment_data->EOF) {
        $cc_type_key[$payment_data->fields['payment_type_full']] = $payment_data->fields['payment_type_code'];
        $payment_data->MoveNext();
      }

      // convert CC name to match shorthand type in SO payment system
      // the name used at checkout must match name entered into Admin > Localization > Payment Types!
      $payment_type = $cc_type_key[$cc_data->fields['cc_type']];
      $new_cc_payment = array('orders_id' => $this->oID,
                              'payment_number' => $cc_data->fields['cc_number'],
                              'payment_name' => $cc_data->fields['cc_owner'],
                              'payment_amount' => $cc_data->fields['order_total'],
                              'payment_type' => $payment_type,
                              'date_posted' => 'now()',
                              'last_modified' => 'now()');

      zen_db_perform(TABLE_SO_PAYMENTS, $new_cc_payment);
    }

    // now look for PayPal data
    $pp_data = $db->Execute("select * from " . TABLE_PAYPAL . " where zen_order_id = " . $this->oID);
    if ($pp_data->RecordCount() ) {
      $new_pp_payment = array();
      while (!$pp_data->EOF)  {
        $name = $pp_data->fields['first_name'] . ' ' . $pp_data->fields['last_name'];
        $new_pp_payment[] = array('orders_id' => $this->oID,
                                  'payment_number' => $pp_data->fields['txn_id'],
                                  'payment_name' => $name,
                                  'payment_amount' => $pp_data->fields['mc_gross'],
                                  'payment_type' => 'PP',
                                  'date_posted' => 'now()',
                                  'last_modified' => 'now()');

        $pp_data->MoveNext();
      }

      foreach ($new_pp_payment as $key => $payment) {
        zen_db_perform(TABLE_SO_PAYMENTS, $payment);
      }
    }
  }

I'd also like to hear from those of you who use PayPal extensively (I don't at all). What other stuff can I do here to make this more useful?

[wickedklown]

Blindside,

can you please help me to find out the problem with my order status comments box.

I really need to find a fix for it

I have posted in the general forum hoping that maybe someone would have an idea, or maybe went through the same problem, and found a fix.

any help would be great at this point.
thanks man

a man in desperate need of help :)
benjamin

[wickedklown]

Yes BS,

I checked to make sure i had that SO code below the indecated line, and i do. i fallowed and double checked the edits before i came asking about the problem..

thanks man

[BlindSide]

(The following is from a PM)

I was trying to install Super Order 2.0 rev45 on Zen Cart Version 1.3.5 (Clean Installation/Not upgrade). After uploading all Admin & Includes files, tried to upload super_orders_sql.sql and encountered the following error messages:

1. When using "Install SQL Patch" in Zen Admin:

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.

2. When using "PHPmyAdmin" from my web server:

Error SQL query:
-- EDIT EXISTING TABLES
ALTER TABLE orders ADD date_completed datetime default NULL
MySQL said:
#1146 - Table 'wwwlin5_zc1.orders' doesn't exist

As you can see, two different error messages when using two different methods to install the super_orders_sql patches.

In addittion, I cannot find Admin>Configuration>Super Orders field after installation.

Can you please help?

The first issue sounds like you have run and rerun the SQL file over your DB. The so_payment_types is a new table that SO installs, so it would only find it if you had already run the script. UNless you know what the initial error was, your best bet is to restore from your DB backup and try again. I recommend that you use phpMyAdmin instead of the Zen SQL installer.

The second may or may not be related. Look at the table name: wwwlin5_zc1.orders. In the first error, you have a table prefix (zen_), and here you have none. Restore from your backup, go through the entire file to add your DB prefix (if you do, in fact, have one), and run the file again.