Search the Community

I am using OSCommerce Frozen and have the shipping's 'allow free shipping' option set to true(within order totals). I need to make the free shipping option be based off the subtotal amount rather than the total amount within the shopping cart. Is this possible? I need to have free shipping activated when the subtotal is over £118. At the moment free shipping is showing when the overall total ( including subtotal and tax) is over £99. In simple terms i want free shipping to trigger when the sub total order value is £99.

I'm just wondering which is the best method for all products to offer "free shipping", can any of the default modules just be set to $0.00 (and it will work)?

Dear, I'm running this contribution on a test site (xamp) and at localhost/catalog/checkout_shipping.php I receive the below error message: Warning: mysql_fetch_assoc() expects parameter 1 to be resource, object given in C:\xampp\htdocs\*****\catalog\includes\modules\shipping\zones.php on line 185 below is a piece of code in checkout_shipping.php were the error originates (marked in red). Apparently this is some old type of PHP coding and replaced by a new type. BUT I lack the knowledge of PHP to be able to update this piece of coding. Would there be any-one who could help me? Many thanks! Kind regards Gerry // Santosh - Added to select default country if not in listing if ($dest_zone == 0) { $dest_zone = $this->num_zones; // the zone is the lastest zone avalaible } // Santosh - Added to select default country if not in listing if ($dest_zone == 0) { $error = true; // this can no more achieve since by default the value is set to the max number of zones } else { $shipping = -1; $zones_cost = constant('MODULE_SHIPPING_ZONES_COST_' . $dest_zone); $zones_table = preg_split("/[:,]/" , $zones_cost); $size = sizeof($zones_table); $free_shipping_query = tep_db_query("select configuration_value from " . TABLE_CONFIGURATION . " where configuration_key = 'MODULE_SHIPPING_ZONES_FREESHIP_" . $dest_zone . "'"); $free_ship = mysql_fetch_assoc($free_shipping_query); $shipping_price = $free_ship['configuration_value']; if((tep_db_num_rows($free_shipping_query) != 0 ) && ($shipping_price <= $order->info['total']) && !empty($free_ship['configuration_value'])) { $shipping_method = MODULE_SHIPPING_ZONES_FREESHIP_TEXT_WAY . ' ' . $order->delivery['country']['title'] . ': '; if ($shipping_num_boxes > 1) { $shipping_method .= $shipping_num_boxes . 'x '; } $shipping_price = 0; $shipping_method .= $shipping_price . ' ' . MODULE_SHIPPING_ZONES_FREESHIP_TEXT_UNITS; $shipping_cost = 0; } else { for ($i=0; $i<$size; $i+=2) { if ($shipping_weight <= $zones_table[$i]) { $shipping = $zones_table[$i+1]; $shipping_method = MODULE_SHIPPING_ZONES_TEXT_WAY . ' ' . $order->delivery['country']['title'] . ': '; if ($shipping_num_boxes > 1) { $shipping_method .= $shipping_num_boxes . 'x '; } $shipping_method .= $shipping_weight . ' ' . MODULE_SHIPPING_ZONES_TEXT_UNITS; break; } }

Hello shipping support, currently using UPS shipping and freeamount shipping module on 2.3.4 BS. we have my free amount shipping set for free shipping over 500 dollars. we have a new category that we can not offer free shipping for that category only. Can someone suggest an addon for this, TY, Craig

Our site, www.labelsupplyhut.com is supposed to allow free shipping if a customer orders 5 boxes or above, plus any configuration after that rule. For example, 5 boxes of one style and one box of another style. We have a simple free FedEx shipping module that programs this based on a field in the product details, "Minimum Order Quantity for Free Shipping." Not being familar with php code, can someone look at the code for this function and tell me if there is something off that is causing this not to work? (For reference, we are using osCommerce Online Merchant v2.2 RC2a, PHP Version 5.3.23 and this should be independent of the free module, but FedEx Web Services version 9. function quote($method = '') { global $shipping_weight, $shipping_num_boxes, $cart, $order, $total_weight, $total_free_shipping_weight; $products = $cart->get_products(); $free_shipping = array(); foreach ($products as $product) { $free_shipping[$product['products_free_shipping_qty']] += $product['quantity']; } foreach ($free_shipping as $threshold => $quantity) { if ($quantity >= $threshold && $threshold > 0) { $total_free_shipping_weight = 0; break; } } if (isset($total_free_shipping_weight) && $total_free_shipping_weight < $total_weight) { if ($total_free_shipping_weight == 0) { function quote($method = '') { global $shipping_weight, $shipping_num_boxes, $cart, $order, $total_weight, $total_free_shipping_weight; $products = $cart->get_products(); $free_shipping = array(); foreach ($products as $product) { $free_shipping[$product['products_free_shipping_qty']] += $product['quantity']; } foreach ($free_shipping as $threshold => $quantity) { if ($quantity >= $threshold && $threshold > 0) { $total_free_shipping_weight = 0; break; } } if (isset($total_free_shipping_weight) && $total_free_shipping_weight < $total_weight) { if ($total_free_shipping_weight == 0) {

My store uses the flat rate shipping module to charge $10 per order. Orders are processed through PayPal standard (or express). We're now offering gift certificates which of course shouldn't be charged shipping. I installed the Free Shipping Per Product module (http://addons.oscommerce.com/info/8409). It allows my flag products that should have free shipping. It works well and the checkout shows "free shipping" BUT when the order is passed to PayPal the $10 shipping charge is still there. Somehow the add-on has not changed what PayPal sees. Any ideas?

I need to have the cart display the Free shipping option as well as USPS for priority shipping choices. When I have Free Shipping enabled in the order total module, USPS will not display in the cart. I can disable the free shipping and USPS works fine. I'm sure I've missed something but don't know what. Thanks in advance for any help.