Minimum FIRST TIME order fee

[aussiesapphire]

i think it will cause you more headaches than granny buying her cotton balls. from a pure business perspective, you want to put as few obstacles as possible in front of your customer base, especially whoelsale or B2B customers as their business is more lucrative via its frequency and it's volume.

losing a $200 order will prbably hurt more than shipping to granny (we're really getting on the granny bandwagon aren't we?), so i suspect a better solution would be to find another solution.

i don't have an answer, however can see custom code being the best solution as it would not take much to check the number of previous orders before applying a restriction.

andy

I entirely agree with you except the OP said his boss was insisting on this system which we all agree is a bad idea. For our new site, we've decided to go with a flat rate shipping fee which more than covers the real cost for very tiny orders but FREE shipping for modest to large orders. We're trying to attract larger buyers and dont want to fiddle around with very low value small orders so free shipping and a flat rate that easily covers the small orders should work (I hope - we're not up and running on this one yet). We can switch back to actual cost if we find it is necessary but trying to offer something really simple and attractive.

Simple is best of course - it is really nice to be able to explain our shipping policy in one short sentence. And I do think it would be best to try and change the boss' mind on this one.

cheers
Leah

[Ajeh]

Have you looked at the Minimum Order in the Free Software Add Ons ...
http://www.zen-cart.com/index.php?ma...roducts_id=599

You could probably adapt that to check if the customer has made an order or not and use this to prevent checkouts of less than $100.00 if the customer does not yet have their first order ...

[adam2020]

Have you looked at the Minimum Order in the Free Software Add Ons ...
http://www.zen-cart.com/index.php?ma...roducts_id=599

You could probably adapt that to check if the customer has made an order or not and use this to prevent checkouts of less than $100.00 if the customer does not yet have their first order ...

This would help with my current project.

It looks like this is the section of the addon to edit:

          if($_SESSION['cart']->show_total() < MIN_ORDER_AMOUNT) {
            $_SESSION['valid_to_checkout'] = false;
            $messageStack->add('shopping_cart', sprintf(TEXT_ORDER_UNDER_MIN_AMOUNT, $currencies->format(MIN_ORDER_AMOUNT)) . '<br />', 'caution');
          }

How would I amend statement to check if customer has ordered before?

Thanks for any help :)

[Ajeh]

// check for at least 1 existing order 
$sql = "SELECT orders_id from " . TABLE_ORDERS . " WHERE customers_id = '" . $_SESSION['customer_id'] . "' limit 1";
$chk_customers_orders = $db->Execute($sql);
if (!$chk_customers_orders->fields['orders_id'] > 0) {
  $charge_minimum = true;
} else {
  $charge_minimum = false;
}

          if($charge_minimum && $_SESSION['cart']->show_total() < MIN_ORDER_AMOUNT) {
            $_SESSION['valid_to_checkout'] = false;
            $messageStack->add('shopping_cart', sprintf(TEXT_ORDER_UNDER_MIN_AMOUNT, $currencies->format(MIN_ORDER_AMOUNT)) . '<br />', 'caution');
          }

[adam2020]

Thanks for your help.

I tried that and it doesn't work. Causes white screen.

I think I should have posted more of the code.

This is the whole class.minimum_order_amount.php file in includes/classes/observers

<?php
/**
 * class.minimum_order_amount.php
 *
 * @copyright Copyright 2005-2007 Andrew Berezin eCommerce-Service.com
 * @copyright Portions Copyright 2003-2006 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: config.minimum_order_amount.php 1.0.1 20.09.2007 0:06 AndrewBerezin $
 */

/**
 * Observer class used to check minimum order amount
 *
 */
class minimum_order_amount extends base {
  /**
   * constructor method
   *
   * Attaches our class to the ... and watches for 4 notifier events.
   */
  function minimum_order_amount() {
    global $zco_notifier;
//      $_SESSION['cart']->attach($this, array('NOTIFIER_CART_GET_PRODUCTS_START', 'NOTIFIER_CART_GET_PRODUCTS_END'));
    $zco_notifier->attach($this, array('NOTIFY_HEADER_END_SHOPPING_CART', 'NOTIFY_HEADER_START_CHECKOUT_SHIPPING', 'NOTIFY_HEADER_START_CHECKOUT_PAYMENT', 'NOTIFY_HEADER_START_CHECKOUT_CONFIRMATION'));
  }
  /**
   * Update Method
   *
   * Called by observed class when any of our notifiable events occur
   *
   * @param object $class
   * @param string $eventID
   */
  function update(&$class, $eventID) {
    global $messageStack;
    global $currencies;
    switch ($eventID) {
      case 'NOTIFIER_CART_GET_PRODUCTS_END':
      case 'NOTIFY_HEADER_END_SHOPPING_CART':
        if ($_SESSION['cart']->count_contents() > 0 && MIN_ORDER_AMOUNT > 0) {
		
		// check for at least 1 existing order 
			$sql = "SELECT orders_id from " . TABLE_ORDERS . " WHERE customers_id = '" . $_SESSION['customer_id'] . "' limit 1";
			$chk_customers_orders = $db->Execute($sql);
			if (!$chk_customers_orders->fields['orders_id'] > 0) {
				$charge_minimum = true;
			} else {
  $charge_minimum = false;
			}
          if($charge_minimum && $_SESSION['cart']->show_total() < MIN_ORDER_AMOUNT) {
            $_SESSION['valid_to_checkout'] = false;
            $messageStack->add('shopping_cart', sprintf(TEXT_ORDER_UNDER_MIN_AMOUNT, $currencies->format(MIN_ORDER_AMOUNT)) . '<br />', 'caution');
          }
        }
        break;
      case 'NOTIFY_HEADER_START_CHECKOUT_SHIPPING':
      case 'NOTIFY_HEADER_START_CHECKOUT_PAYMENT':
      case 'NOTIFY_HEADER_START_CHECKOUT_CONFIRMATION':
        if ($_SESSION['cart']->count_contents() > 0 && MIN_ORDER_AMOUNT > 0) {
          if($_SESSION['cart']->show_total() < MIN_ORDER_AMOUNT) {
            zen_redirect(zen_href_link(FILENAME_SHOPPING_CART));
          }
        }
        break;
      default:
        break;
    }
  }
}
?>

[Ajeh]

And if you add a
global $db;

above the line that starts:
$sql

what happens?

[adam2020]

It works like a charm. Thank you for your help Ajeh

If anyone is interested in Minimum Order for first order only, use the Minimum Order addon and substitute includes/classes/observers/class.minimum_order_amount.php with the code below:

<?php
/**
 * class.minimum_order_amount.php
 *
 * @copyright Copyright 2005-2007 Andrew Berezin eCommerce-Service.com
 * @copyright Portions Copyright 2003-2006 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: config.minimum_order_amount.php 1.0.1 20.09.2007 0:06 AndrewBerezin $
 */

/**
 * Observer class used to check minimum order amount
 *
 */
class minimum_order_amount extends base {
  /**
   * constructor method
   *
   * Attaches our class to the ... and watches for 4 notifier events.
   */
  function minimum_order_amount() {
    global $zco_notifier;
//      $_SESSION['cart']->attach($this, array('NOTIFIER_CART_GET_PRODUCTS_START', 'NOTIFIER_CART_GET_PRODUCTS_END'));
    $zco_notifier->attach($this, array('NOTIFY_HEADER_END_SHOPPING_CART', 'NOTIFY_HEADER_START_CHECKOUT_SHIPPING', 'NOTIFY_HEADER_START_CHECKOUT_PAYMENT', 'NOTIFY_HEADER_START_CHECKOUT_CONFIRMATION'));
  }
  /**
   * Update Method
   *
   * Called by observed class when any of our notifiable events occur
   *
   * @param object $class
   * @param string $eventID
   */
  function update(&$class, $eventID) {
    global $messageStack;
    global $currencies;
    switch ($eventID) {
      case 'NOTIFIER_CART_GET_PRODUCTS_END':
      case 'NOTIFY_HEADER_END_SHOPPING_CART':
        if ($_SESSION['cart']->count_contents() > 0 && MIN_ORDER_AMOUNT > 0) {
		
		// check for at least 1 existing order 
			global $db;
			$sql = "SELECT orders_id from " . TABLE_ORDERS . " WHERE customers_id = '" . $_SESSION['customer_id'] . "' limit 1";
			$chk_customers_orders = $db->Execute($sql);
			if (!$chk_customers_orders->fields['orders_id'] > 0) {
				$charge_minimum = true;
			} else {
  $charge_minimum = false;
			}
          if($charge_minimum && $_SESSION['cart']->show_total() < MIN_ORDER_AMOUNT) {
            $_SESSION['valid_to_checkout'] = false;
            $messageStack->add('shopping_cart', sprintf(TEXT_ORDER_UNDER_MIN_AMOUNT, $currencies->format(MIN_ORDER_AMOUNT)) . '<br />', 'caution');
          }
        }
        break;
      case 'NOTIFY_HEADER_START_CHECKOUT_SHIPPING':
      case 'NOTIFY_HEADER_START_CHECKOUT_PAYMENT':
      case 'NOTIFY_HEADER_START_CHECKOUT_CONFIRMATION':
        if ($_SESSION['cart']->count_contents() > 0 && MIN_ORDER_AMOUNT > 0) {
          if($_SESSION['cart']->show_total() < MIN_ORDER_AMOUNT) {
            zen_redirect(zen_href_link(FILENAME_SHOPPING_CART));
          }
        }
        break;
      default:
        break;
    }
  }
}
?>

Also edit the language files to something more suitable for First Order.

[Ajeh]

You are most welcome ...

Thanks for the update that this code is now working properly for you ...

[adam2020]

Sorry but I didn't test thoroughly enough.

If I try and order a 2nd time there are no messages or errors but attempting to go to checkout_shipping page just loads the Shopping Cart page.

[Ajeh]

Put the IF test above the case statement then add the results to both case statements that are checking the cart ...