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

[danilyn22]

I am experiencing the same issues as the post above. I am new to Zen Cart but have had ecommernce sites since 1999. My 2 other sites are hosted ecommerce packages with very robust order pages. When I first saw the stock order page in ZC I knew I needed something more so I loaded Super Orders.

When an order comes in, if I manage it in Super Orders it does not update the Order page that comes installed with Zen Cart so I get confused to where to update orders. If I complete an order in Super Orders it still shows as a new order in Orders.

Can anyone explain how they process their orders.

Also, I prefer to "Authorize only" charges until I ship the order. Is there a way to complete the charge from the admin panel? I do not see this in Super Orders or Orders nor have I found a Mod.
THanks

[cjeb456]

Hi all

Under localization -> Payment Types, I am trying to remove some of the types that I will never use. On the whole this was very straight forward but now I have a problem.

Whilst testing out the features of Super Orders 2.0, I created a few test orders, made test payments and test refunds etc against these orders.

I then went in once I had finished testing them and deleted all these orders.

The problem is, some of the payment types I am trying to delete were used in the payments or refunds on the test orders

It will not let me delete these payments type saying...

Delete Prohibited
This payment type currently has 1 payments and/or refunds attached to it. Those records must first be deleted or moved to another payment type before you can delete this one.

I connot delete the payment, or move it to another payment type because I have deleted the orders that those payments/refunds were against.

How can I make it forget about those payments so I can delete the payment types?

Many thanks in advance

[Resqjock]

Is there a compatibility issue using "Super Orders" with "Edit Orders"????

Thanks
Stan

[Resqjock]

I just installed this mod, but I am not able to edit orders, like the instructions claim.

I click on the "edit proucts" link and I get a new page, but there is nothing I can do on this page. it just displays the product.

The instructions state to remove the "orders" link in admin/customer/orders, but if I do tis I will not be able to edit any thing, since I have "edit orders" installed.

Is there something I am missing or doing something wrong, since I can not edit orders in "super orders" ?

Thanks

Stan

[tuncay]

hi this super orders isn't allowing to edit the products you can divide the order into 2 and for example
a customer order 3 products and you have in stock one of them you can sperate 2 not in stock orders in to new order but you can't add or delete directly from the original order. the edit order addon do that you can add or delete or change anything in the order such as name adress email, product, shipping and tax info. what i write that may be somebody wiser then us combine super orders+edit orders and make it complete. philips clarke is email me that he did that before in one of his test store.

[gezuvor]

Hi All,

Great mod, really love it. However, having some issues with our 1.38 installation and the info at a glance feature.

I did a search for this, but didn't see any suggestions to fix it. The bubble is there, but clicking it does nothing...

Screen capture from my admin attached, in case I'm missing something...

Thanks in advance, ~Rich

[smatric]

Hi all,

I started to cooperate with HiPCTech. We use for our webstore Zen Cart with Super Orders module. We had a problem with "Balance Due". If someone paid through PayPal, Super Orders still showed "Balance Due" to be paid. I've found a solution to this problem and I'd like to post it here so that maybe someone can also find it useful.

Whole changes are made in "zcmanager/includes/classes/super_order.php". I modified "start()" function and added one new ("check_paypal_payments()"). What it does is it basically selects PayPal payments from "TABLE_PAYPAL" where order_id equals "$this->oID" and adds "mc_gross" value to "amount_applied". It takes only payments from "paypalwpp" or "paypal 1.3.8a" or "paypal (ipn-handler)" modules. There might be a better way to do it. Maybe just to select all except for "paypaldp". But for security I wrote it like that.

Here is the code:

  function start() {
    global $db;

    // scrape some useful info from the record in the orders table
    $order_query = $db->Execute("select * from " . TABLE_ORDERS . " where orders_id = '" . $this->oID . "'");
    $this->cID = $order_query->fields['customers_id'];
    $this->order_total = $order_query->fields['order_total'];

    if (zen_not_null($order_query->fields['date_cancelled']) ) {
      $this->status_date = $order_query->fields['date_cancelled'];
      $this->status = "cancelled";
    }
    elseif (zen_not_null($order_query->fields['date_completed']) ) {
      $this->status_date = $order_query->fields['date_completed'];
      $this->status = "completed";
    }
    else {
      $this->status_date = false;
      $this->status = false;
    }

    // build an array to translate the payment_type codes stored in so_payments
    $payment_key_query = $db->Execute("select * from " . TABLE_SO_PAYMENT_TYPES . "
                                       where language_id = '" . $_SESSION['languages_id'] . "'
                                       order by payment_type_full asc");
    while(!$payment_key_query->EOF) {
      // this array is used by the full_type() function
      $this->payment_key_array[$payment_key_query->fields['payment_type_code']] = $payment_key_query->fields['payment_type_full'];

      // and this one can be used to build dropdown menus
      $this->payment_key[] = array('id' => $payment_key_query->fields['payment_type_code'],
                                   'text' => $payment_key_query->fields['payment_type_full']);
      $payment_key_query->MoveNext();
    }

    // get all payments not tied to a purchase order
    $payments_query = $db->Execute("select * from " . TABLE_SO_PAYMENTS . "
                                    where orders_id = '" . $this->oID . "'
                                    and purchase_order_id = 0
                                    order by date_posted asc");

    if (zen_not_null($payments_query->fields['orders_id'])) {
      while (!$payments_query->EOF) {
        $this->payment[] = array('index' => $payments_query->fields['payment_id'],
                                 'number' => $payments_query->fields['payment_number'],
                                 'name' => $payments_query->fields['payment_name'],
                                 'amount' => $payments_query->fields['payment_amount'],
                                 'type' => $payments_query->fields['payment_type'],
                                 'posted' => $payments_query->fields['date_posted'],
                                 'modified' => $payments_query->fields['last_modified']);
        $payments_query->MoveNext();
      }
    }
    else {
      unset($this->payment);
      $this->payment = false;
    }

    // get all the purchase orders for this order
    $purchase_order_query = $db->Execute("select * from " . TABLE_SO_PURCHASE_ORDERS . "
                                          where orders_id = '" . $this->oID . "'
                                          order by date_posted asc");

    if (zen_not_null($purchase_order_query->fields['orders_id'])) {
      while (!$purchase_order_query->EOF) {
        $this->purchase_order[] = array('index' => $purchase_order_query->fields['purchase_order_id'],
                                        'number' => $purchase_order_query->fields['po_number'],
                                        'posted' => $purchase_order_query->fields['date_posted'],
                                        'modified' => $purchase_order_query->fields['last_modified']);

        $purchase_order_query->MoveNext();
      }
    }
    else {
      unset($this->purchase_order);
      $this->purchase_order = false;
    }

    // get any payments that are tied to a purchase order
    if($this->purchase_order) {    // need a po before you can have po payments
      for($i = 0; $i < sizeof($this->purchase_order); $i++) {
        $this_po_id = $this->purchase_order[$i]['index'];

        $po_payments_query = $db->Execute("select * from " . TABLE_SO_PAYMENTS . "
                                          where purchase_order_id = '" . $this_po_id . "'
                                          order by date_posted asc");

        if (zen_not_null($po_payments_query->fields['orders_id'])) {
          while (!$po_payments_query->EOF) {
            $this->po_payment[] = array('index' => $po_payments_query->fields['payment_id'],
                                        'assigned_po' => $this_po_id,
                                        'number' => $po_payments_query->fields['payment_number'],
                                        'name' => $po_payments_query->fields['payment_name'],
                                        'amount' => $po_payments_query->fields['payment_amount'],
                                        'type' => $po_payments_query->fields['payment_type'],
                                        'posted' => $po_payments_query->fields['date_posted'],
                                        'modified' => $po_payments_query->fields['last_modified']);
            $po_payments_query->MoveNext();
          }
        }
      }

      if (sizeof($this->po_payment) < 1) {
        unset($this->po_payment);
        $this->po_payment = false;
      }

    }

    // get any refunds
    if($this->payment || $this->po_payment) {   // gotta have payments in order to refund them
      $refunds_query = $db->Execute("select * from " . TABLE_SO_REFUNDS . "
                                     where orders_id = '" . $this->oID . "'
                                     order by date_posted asc");

      if (zen_not_null($refunds_query->fields['orders_id'])) {
        while (!$refunds_query->EOF) {
          $this->refund[] = array('index' => $refunds_query->fields['refund_id'],
                                  'payment' => $refunds_query->fields['payment_id'],
                                  'number' => $refunds_query->fields['refund_number'],
                                  'name' => $refunds_query->fields['refund_name'],
                                  'amount' => $refunds_query->fields['refund_amount'],
                                  'type' => $refunds_query->fields['refund_type'],
                                  'posted' => $refunds_query->fields['date_posted'],
                                  'modified' => $refunds_query->fields['last_modified']);
          $refunds_query->MoveNext();
        }
      }
      else {
        unset($this->refund);
        $this->refund = false;
      }
    }

    // calculate and store the order total, amount applied, & balance due for the order

    // add individual payments if they exists
    if($this->payment) {
      for($i = 0; $i < sizeof($this->payment); $i++) {
        $this->amount_applied += $this->payment[$i]['amount'];
      }
    }

    // next add the po payments if they exist
    if ($this->po_payment) {
      for($i = 0; $i < sizeof($this->po_payment); $i++) {
        $this->amount_applied += $this->po_payment[$i]['amount'];
      }
    }

    // now check PayPal payments and add if they exist
	$this->check_paypal_payments();
    $this->amount_applied += $this->paypal_total_payments;

    // now subtract out any refunds if they exist
    if($this->refund) {
      for($i = 0; $i < sizeof($this->refund); $i++) {
        $this->amount_applied -= $this->refund[$i]['amount'];
      }
    }

    // subtract from the order total to get the balance due
    $this->balance_due = $this->order_total - $this->amount_applied;

    // compare this balance to the one stored in the orders table, update if necessary
    if ($this->balance_due != $order_query->fields['balance_due']) $this->new_balance();

  }   // END function start

  function check_paypal_payments() {
  	global $db;

  	$this->paypal_total_payments = 0;

  	$paypal_payments_query = $db->Execute("select * from " . TABLE_PAYPAL . "
  											where `order_id` = '" . $this->oID . "'
  											and `payment_status` = 'Completed'
  											and (`module_name` = 'paypalwpp'
  											  or `module_name` = 'paypal 1.3.8a'
  											  or `module_name` = 'paypal (ipn-handler)')");

  	if (zen_not_null($paypal_payments_query->fields['order_id'])) {
		while (!$paypal_payments_query->EOF) {
			$this->paypal_total_payments += $paypal_payments_query->fields['mc_gross'];
			$paypal_payments_query->MoveNext();
        }
  	}
  }

[cjeb456]

Hi all

Under localization -> Payment Types, I am trying to remove some of the types that I will never use. On the whole this was very straight forward but now I have a problem.

Whilst testing out the features of Super Orders 2.0, I created a few test orders, made test payments and test refunds etc against these orders.

I then went in once I had finished testing them and deleted all these orders.

The problem is, some of the payment types I am trying to delete were used in the payments or refunds on the test orders

It will not let me delete these payments type saying...

Delete Prohibited
This payment type currently has 1 payments and/or refunds attached to it. Those records must first be deleted or moved to another payment type before you can delete this one.

I connot delete the payment, or move it to another payment type because I have deleted the orders that those payments/refunds were against.

How can I make it forget about those payments so I can delete the payment types?

Many thanks in advance

Does anyone have advise on this please?

Thanks

[carlvt88]

I don't use this feature of sales orders, so this may not be too precise, but I looked at the code and it looks like it's checking in the TABLE_SO_PAYMENTS and TABLE_SO_REFUNDS to see if those payment types are used.

My guess is that when you deleted the order, you may have done this through the stock Customers->Orders instead of Customers->SuperOrders. If this is the case, the order was removed from TABLE_ORDERS, but still exists in those other tables.

I'd probably manually remove the one record from the TABLE_SO_PAYMENTS table using PhpMyAdmin - assuming that this record is associated with a non-existant order ID anyway.

[voltage]

what i write that may be somebody wiser then us combine super orders+edit orders and make it complete. philips clarke is email me that he did that before in one of his test store.

I just combined the two. I am no programmer but the following worked for me.

Install both mods: edit order and super orders. Make the option filenames update for super orders.

open up filenames.php at includes/filenames.php and add this line:

define('FILENAME_EDIT_ORDERS', 'edit_orders');

Open up admin/super_orders.php and find this line:

echo '<a href="' . zen_href_link(FILENAME_SUPER_DATA_SHEET, 'oID=' . $oID) . '" target="_blank">' . zen_image_button('btn_print.gif', ICON_ORDER_PRINT) . '</a>&nbsp;&nbsp;';

Add this line right above it:
echo '<a href="' . zen_href_link(FILENAME_EDIT_ORDERS, 'oID=' . $oID) . '">' . zen_image_button('button_edit.gif', ICON_ORDER_EDIT) . '</a>&nbsp;&nbsp;';