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

[cjayosburn]

I have finally got Super Orders installed, but have no Super Orders in the Admin Configuration Menu, nor do I have the Store Phone and Store Fax defines under My Store. Any suggestions.

Thanks

Jay

All fixed now...
I copied and pasted only the parts of the SQL code that I needed and the Store Fax and Store Phone are on the My Store page and the Super Orders Config page is where it should be.

Thanks Again

For all of you who look at this forum and think that Super Orders is not worth the time or trouble, think again. This is a great mod.

Jay

[DivaVocals]

Does anyone know how to make the product image smaller on Super packing slip? At the moment, it looks too big and stretched. Thanks in advance.

So I've been through this whole thread.. Did I miss the answer to this.. I've got SO installed, and so far so good, but I'm still gonna take it through it's paces just to make sure before I sign off on this and breathe easy that it works.. The only glitch is the product image on the packing slip.. It is pulling in the full size image versus the thumbnail.. I'd be super grateful for an assist..

[DivaVocals]

Okay so I think I know WHAT needs to be changed.. I just need to know HOW to modify it so that it displays the thumbnail of the product images on the packing list:

In the admin/super_packingslip.php file, on or around line 201 in the I found:

          echo '        <td class="dataTableContent" align="left">' . zen_image(DIR_WS_CATALOG . DIR_WS_IMAGES . $products->fields['products_image'] , $order->products[$i]['name'], SMALL_IMAGE_HEIGHT, SMALL_IMAGE_WIDTH) . '</a>&nbsp;</td>';

I am hoping that someone ran into this same issue and knows the answer.. If not, I guess I'll start experimenting with how to remove the product image from the packing list altogether..

[DivaVocals]

Okay so I think I know WHAT needs to be changed.. I just need to know HOW to modify it so that it displays the thumbnail of the product images on the packing list:

In the admin/super_packingslip.php file, on or around line 201 in the I found:

          echo '        <td class="dataTableContent" align="left">' . zen_image(DIR_WS_CATALOG . DIR_WS_IMAGES . $products->fields['products_image'] , $order->products[$i]['name'], SMALL_IMAGE_HEIGHT, SMALL_IMAGE_WIDTH) . '</a>&nbsp;</td>';

I am hoping that someone ran into this same issue and knows the answer.. If not, I guess I'll start experimenting with how to remove the product image from the packing list altogether..

So for now I changed the code and added the relative path to a "generic" image to appear in place of the product image.. (In this case I used my "no_image" file because I replaced the default with a custom "no_image" file) I also changed the header row in the table to not call the header row constant for the product image column heading text. (it was faster doing it that way than changing the language file)

[carlvt88]

Partial progress - I now have paypal payments showing up on the order. In addition to the code that BlindSide provided for cc_line_item (quoted below), I needed to modify includes/classes/order.php to call the function:

      if (zen_not_null($this->info['cc_type']) || zen_not_null($this->info['cc_owner']) || zen_not_null($this->info['cc_number']) || $this->info['payment_module_code'] == 'paypalwpp') {

Works great - now when an order is placed with paypal, the amount from paypal[mc_gross] is applied as a payment.

However, while the so_payments[orders_id] and [payment_amount] are filled in, the [payment_name] and [payment_number] are not. Don't know why.....

Also, this is done at order creation. I think if this were done at report generation instead, you could pick up multiple paypal payments, paypal refunds, and maybe even current status of e-checks (haven't had much experience here).

Other than that- if any other hackers are making progress here, I'd love to know.

Frank - love the SO work you've done - it's really helped me out!

Thanks,
Carl

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?

[carlvt88]

Further update: I now get paypal express checkout payments and full and partial refunds to show up correctly as SO payments. Refunds are negative value payments and not refunds, but I'll live with this for now.

What I did was take Frank's code snippet (above) to modify cc_line_item in super_order.php. During the checkout process, this adds a so_payments record with info from the paypal transaction. I also modified order.php as indicated above so that this would get called during checkout.

Next I added a function to modules/payment/paypal/paypal_functions.php:

function ipn_create_so_payments_array($new_order_id, $txn_type) {
    $sql_data_array = array('orders_id' => $new_order_id,
                          'payment_number' => $_POST['txn_id'],
                          'payment_name' => $_POST['last_name'],
                          'payment_amount' => $_POST['mc_gross'],
                          'payment_type' => $txn_type,
                          'date_posted' => datetime_to_sql_format($_POST['payment_date']),
                         );
    return $sql_data_array;
  }

Then, in ipn_main_handler.php, I inserted this for txn_type parent. Starting line 279:

    if ($txn_type == 'parent') {
      $sql_data_array = ipn_create_order_array($ordersID, $txn_type);
      zen_db_perform(TABLE_PAYPAL, $sql_data_array);
      
      // put refund info into SO
      require(DIR_WS_CLASSES . 'super_order.php');
      $sql_data_array = ipn_create_so_payments_array($ordersID, $txn_type);
      zen_db_perform(TABLE_SO_PAYMENTS, $sql_data_array);     
    } else {

This probably still isn't complete, I've only tested a couple of transactions, but I've seen many asking for this feature and I hope it helps some. I'm sure I could have done this more completely or more consistently - feedback welcome!

[tslav]

After reviewing SO features, I must say that I am impressed. It seems like a great mod for my store. I just have couple of question regarding SO implementation in multi Language/ currency environment.

Is SO supports multiple Currencies/Languages (Invoice, Package slip, Shipping Label and etc)?


Tzachi

[yrakc]

I have installed Super Orders and don't see the PO Payment Module under Admin> Modules> Payment

Anyone know a reason I may have this issue?

I made sure all of the files got installed in their place and all of the sql patch executed.

Any help is much appreciated.

[tyroneneous]

Hi,

I have a question about closing the orders.

Can someone help me or tell me how I can have the "Close Order" function be batch processed? I know we can do it with the other statuses, but if I have a hundred orders that I want to close off how can I do it?

Also is it possible for it to do it automatically after the last status has been selected? e.g. when we change it to be dispatched it should close the order off?

Thank you

Tyrone.

[tslav]

After reviewing SO features, I must say that I am impressed. It seems like a great mod for my store. I just have couple of question regarding SO implementation in multi Language/ currency environment.

Is SO supports multiple Currencies/Languages (Invoice, Package slip, Shipping Label and etc)?


Tzachi

Any help? Are there things i need to know about before installing SO module?