Community Add-Ons

Individual Product Shipping Prices - v1.0
for osCommerce Online Merchant v2.2

This shipping module will allow you to set an individual shipping price for each product. This module is kind of like the 'Shipping rate per product', or 'prodrate' shipping module designed by Joe Janos, except this module does not use the 'weight' field. Instead, this module adds a new field to your products table to hold the individual shipping price data. This means that you can use this module with any other module if you like. Intigration with the contribution 'multi-vendor shipping' is also explained.

Support forum thread at: http://forums.oscommerce.com/viewtopic.php?t=50221

Legend:

Download

Report

Expand All / Collapse All

Previous version did not download the complete product to xcel, only product that has indv price was set.

This is a complete updated instruction which will export all products including the one that does not have the shipping price set...

Through support thread, reported won't show all shipping option...

found the following block in catalog/includes/classes/shipping.php

// start indvship
//while (list(, $value) = each($this->modules)) {
// $class = substr($value, 0, strrpos($value, '.'));
// $include_modules[] = array('class' => $class, 'file' => $value);
//}
//}

if($indvcount==sizeof($products)){
if ((tep_get_configuration_key_value('MODULE_SHIPPING_INDVSHIP_STATUS')) && ((tep_not_null($shiptotal)) || $shiptotal == 0)) {
$include_modules[] = array('class'=> 'indvship', 'file' => 'indvship.php');
}
} else {
if(sizeof($products)>$indvcount){
while (list(, $value) = each($this->modules)) {
$class = substr($value, 0, strrpos($value, '.'));
if (($class !='freeshipper') && ($class != 'indvship')) { // comment to show all ship options
// if ($class !='freeshipper') { // uncomment to show all ship options
$include_modules[] = array('class' => $class, 'file' => $value);
}
}
}
}
}
// end indvship

where you can uncomment and comment the line:
if (($class !='freeshipper') && ($class != 'indvship')) { // comment to show all ship options
// if ($class !='freeshipper') { // uncomment to show all ship options

to show all shipping option, however, it doesn't work, so i remove that whole block seems like it doesn't needed to be there. and it shows all shipping option.

see below is the complete shipping.php for catalog/includes/classes/shipping.php

if anyone can find a better fix, please added to this...

you can compare for which part to modify!

<?php
/*
$Id: shipping.php,v 1.23 2003/06/29 11:22:05 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License
*/

class shipping {
var $modules;

// class constructor
function shipping($module = '') {

// start indvship
// global $language, $PHP_SELF;
global $language, $PHP_SELF, $cart;
// New to fix attributes bug
$cart_products = $cart->get_products();
if (tep_not_null($cart_products)) {
$real_ids = array();
foreach($cart_products as $prod){
$real_ids[] = tep_get_prid($prod['id']);
}
$sql = "SELECT products_ship_methods_id FROM ".TABLE_PRODUCTS_SHIPPING." WHERE products_id IN (".implode(',',$real_ids).") AND products_ship_methods_id IS NOT NULL AND products_ship_methods_id <> ''";
$query = mysql_query($sql);
// End new bug fix
$allow_mod_array = array();
while($rec = mysql_fetch_array($query)){
if(empty($allow_mod_array)) $startedempty = true;
$methods_array = array();
$methods_array = explode(';',$rec['products_ship_methods_id']);
if(!empty($methods_array)){
foreach($methods_array as $method){
$allow_mod_array[] = $method;
}
}
if($startedempty){
$startedempty = false;
}else{
$temp_array = array();
foreach($allow_mod_array as $val){
$temp_array[$val]++;
}
$allow_mod_array = array();
foreach($temp_array as $key => $val){
if($val > 1){
$allow_mod_array[] = $key;
}
}
}
}
}
// INDIV_SM END
if (defined('MODULE_SHIPPING_INSTALLED') && tep_not_null(MODULE_SHIPPING_INSTALLED)) {
$this->modules = explode(';', MODULE_SHIPPING_INSTALLED);
// INDIV_SM START
if (tep_not_null($cart_products)) {
$temp_array = $this->modules;
$this->modules = array();
foreach($temp_array as $val){
if(mysql_num_rows($query)==0 || in_array(str_replace('.php','',$val),$allow_mod_array)) {
$this->modules[] = $val;
}
}
}
// INDIV_SM END
$include_modules = array();

if ( (tep_not_null($module)) && (in_array(substr($module['id'], 0, strpos($module['id'], '_')) . '.' . substr($PHP_SELF, (strrpos($PHP_SELF, '.')+1)), $this->modules)) ) {
$include_modules[] = array('class' => substr($module['id'], 0, strpos($module['id'], '_')), 'file' => substr($module['id'], 0, strpos($module['id'], '_')) . '.' . substr($PHP_SELF, (strrpos($PHP_SELF, '.')+1)));
} else {
reset($this->modules);
//// original block >>>>
while (list(, $value) = each($this->modules)) {
$class = substr($value, 0, strrpos($value, '.'));
$include_modules[] = array('class' => $class, 'file' => $value);
}
}
//// end original block <<<<
/* >>>> below where it doesn't show all option, and doesn't seem nessecarily needed <<<<<<<<<<<
// start indvship
//while (list(, $value) = each($this->modules)) {
// $class = substr($value, 0, strrpos($value, '.'));
// $include_modules[] = array('class' => $class, 'file' => $value);
//}
//}

if($indvcount==sizeof($products)){
if ((tep_get_configuration_key_value('MODULE_SHIPPING_INDVSHIP_STATUS')) && ((tep_not_null($shiptotal)) || $shiptotal == 0)) {
$include_modules[] = array('class'=> 'indvship', 'file' => 'indvship.php');
}
} else {
if(sizeof($products)>$indvcount){
while (list(, $value) = each($this->modules)) {
$class = substr($value, 0, strrpos($value, '.'));
if (($class !='freeshipper') && ($class != 'indvship')) { // comment to show all ship options
// if ($class !='freeshipper') { // uncomment to show all ship options
$include_modules[] = array('class' => $class, 'file' => $value);
}
}
}
}
}
// end indvship
*/
for ($i=0, $n=sizeof($include_modules); $i<$n; $i++) {
include(DIR_WS_LANGUAGES . $language . '/modules/shipping/' . $include_modules[$i]['file']);
include(DIR_WS_MODULES . 'shipping/' . $include_modules[$i]['file']);

$GLOBALS[$include_modules[$i]['class']] = new $include_modules[$i]['class'];
}
}
}

function quote($method = '', $module = '') {
global $total_weight, $shipping_weight, $shipping_quoted, $shipping_num_boxes;

$quotes_array = array();

if (is_array($this->modules)) {
$shipping_quoted = '';
$shipping_num_boxes = 1;
$shipping_weight = $total_weight;

if (SHIPPING_BOX_WEIGHT >= $shipping_weight*SHIPPING_BOX_PADDING/100) {
$shipping_weight = $shipping_weight+SHIPPING_BOX_WEIGHT;
} else {
$shipping_weight = $shipping_weight + ($shipping_weight*SHIPPING_BOX_PADDING/100);
}

if ($shipping_weight > SHIPPING_MAX_WEIGHT) { // Split into many boxes
$shipping_num_boxes = ceil($shipping_weight/SHIPPING_MAX_WEIGHT);
$shipping_weight = $shipping_weight/$shipping_num_boxes;
}

$include_quotes = array();

reset($this->modules);
while (list(, $value) = each($this->modules)) {
$class = substr($value, 0, strrpos($value, '.'));
if (tep_not_null($module)) {
if ( ($module == $class) && ($GLOBALS[$class]->enabled) ) {
$include_quotes[] = $class;
}
} elseif ($GLOBALS[$class]->enabled) {
$include_quotes[] = $class;
}
}

$size = sizeof($include_quotes);
for ($i=0; $i<$size; $i++) {
$quotes = $GLOBALS[$include_quotes[$i]]->quote($method);
if (is_array($quotes)) $quotes_array[] = $quotes;
}
}

return $quotes_array;
}

//start indvship
function get_shiptotal() {
global $cart, $order;
$this->shiptotal = '';
$products = $cart->get_products();
for ($i=0, $n=sizeof($products); $i<$n; $i++) {
if (tep_not_null($products[$i]['products_ship_price'])) {
$products_ship_price = $products[$i]['products_ship_price'];
$products_ship_price_two = $products[$i]['products_ship_price_two'];
$products_ship_zip = $products[$i]['products_ship_zip'];
$qty = $products[$i]['quantity'];
if(tep_not_null($products_ship_price) ||tep_not_null($products_ship_price_two)){
$this->shiptotal += ($products_ship_price);
if ($qty > 1) {
if (tep_not_null($products_ship_price_two)) {
$this->shiptotal += ($products_ship_price_two * ($qty-1));
} else {
$this->shiptotal += ($products_ship_price * ($qty-1));
}
}/////////////NOT HERE <<------------
}
}
}// CHECK TO SEE IF SHIPPING TO HOME COUNTRY, IF NOT INCREASE SHIPPING COSTS BY AMOUNT SET IN ADMIN/////////////move back here <<------------
if (($order->delivery['country']['id']) != INDIVIDUAL_SHIP_HOME_COUNTRY) {
if(INDIVIDUAL_SHIP_INCREASE > '0' || $this->shiptotal > '0') {
$this->shiptotal *= INDIVIDUAL_SHIP_INCREASE;
} else {
$this->shiptotal += INDIVIDUAL_SHIP_INCREASE * $this->get_indvcount();
}
return $this->shiptotal;
// not sure why this is needed, but it now works correctly for home country - by Ed
} else {
$this->shiptotal *= 1;
return $this->shiptotal;
}
}

function get_indvcount() {
global $cart;
$this->indvcount = '';
$products = $cart->get_products();
for ($i=0, $n=sizeof($products); $i<$n; $i++) {
if (tep_not_null($products[$i]['products_ship_price'])) {
$products_ship_price = $products[$i]['products_ship_price'];//}
$products_ship_price_two = $products[$i]['products_ship_price_two'];
if(is_numeric($products_ship_price)){
$this->indvcount += '1';
}
}
}
return $this->indvcount;
}

// end indvship

function cheapest() {
if (is_array($this->modules)) {
$rates = array();

reset($this->modules);
while (list(, $value) = each($this->modules)) {
$class = substr($value, 0, strrpos($value, '.'));
if ($GLOBALS[$class]->enabled) {
$quotes = $GLOBALS[$class]->quotes;
for ($i=0, $n=sizeof($quotes['methods']); $i<$n; $i++) {
if (isset($quotes['methods'][$i]['cost']) && tep_not_null($quotes['methods'][$i]['cost'])) {
$rates[] = array('id' => $quotes['id'] . '_' . $quotes['methods'][$i]['id'],
'title' => $quotes['module'] . ' (' . $quotes['methods'][$i]['title'] . ')',
'cost' => $quotes['methods'][$i]['cost']);
}
}
}
}

$cheapest = false;
for ($i=0, $n=sizeof($rates); $i<$n; $i++) {
if (is_array($cheapest)) {
if ($rates[$i]['cost'] < $cheapest['cost']) {
$cheapest = $rates[$i];
}
} else {
$cheapest = $rates[$i];
}
}

return $cheapest;
}
}
}
?>

Important, this is not a complete package, only fix!

if no products exists in the shopping-box and if then the user like to pop-up the shipping-cost information - an sql-error are displayed.

I corrected the code so that the individual shipping methods (defined within the product) only displayed if the box is not empty.

=============================
backup backup backup backup backup
=============================

catalog/includes/classes/shipping.php
---------------------------------------
Find (around row 20-58):
// INDIV_SM BEGIN (this is messy i know)
global $cart;
// New to fix attributes bug
$cart_products = $cart->get_products();
$real_ids = array();
foreach($cart_products as $prod){
$real_ids[] = tep_get_prid($prod['id']);
}
$sql = "SELECT shipping_methods FROM ".TABLE_PRODUCTS." WHERE products_id IN (".implode(',',$real_ids).") AND shipping_methods IS NOT NULL AND shipping_methods <> ''";
$query = mysql_query($sql);
// End new bug fix
$allow_mod_array = array();
while($rec = mysql_fetch_array($query)){
if(empty($allow_mod_array)) $startedempty = true;
$methods_array = array();
$methods_array = explode(';',$rec['shipping_methods']);
if(!empty($methods_array)){
foreach($methods_array as $method){
$allow_mod_array[] = $method;
}
}
if($startedempty){
$startedempty = false;
}else{
$temp_array = array();
foreach($allow_mod_array as $val){
$temp_array[$val]++;
}
$allow_mod_array = array();
foreach($temp_array as $key => $val){
if($val > 1){
$allow_mod_array[] = $key;
}
}
}
}
// INDIV_SM END

and replaced it with:

// INDIV_SM BEGIN (this is messy i know)
global $cart;
// New to fix attributes bug
$cart_products = $cart->get_products();
if (tep_not_null($cart_products)) {
$real_ids = array();
foreach($cart_products as $prod){
$real_ids[] = tep_get_prid($prod['id']);
}
$sql = "SELECT shipping_methods FROM ".TABLE_PRODUCTS." WHERE products_id IN (".implode(',',$real_ids).") AND shipping_methods IS NOT NULL AND shipping_methods <> ''";
$query = mysql_query($sql);
// End new bug fix
$allow_mod_array = array();
while($rec = mysql_fetch_array($query)){
if(empty($allow_mod_array)) $startedempty = true;
$methods_array = array();
$methods_array = explode(';',$rec['shipping_methods']);
if(!empty($methods_array)){
foreach($methods_array as $method){
$allow_mod_array[] = $method;
}
}
if($startedempty){
$startedempty = false;
}else{
$temp_array = array();
foreach($allow_mod_array as $val){
$temp_array[$val]++;
}
$allow_mod_array = array();
foreach($temp_array as $key => $val){
if($val > 1){
$allow_mod_array[] = $key;
}
}
}
}
}
// INDIV_SM END

second change (around row 63-73):

Find:
// INDIV_SM START
$temp_array = $this->modules;
$this->modules = array();
foreach($temp_array as $val){
if(mysql_num_rows($query)==0 || in_array(str_replace('.php','',$val),$allow_mod_array)) {
$this->modules[] = $val;
}
}
// INDIV_SM END

and replace it with:

// INDIV_SM START
if (tep_not_null($cart_products)) {
$temp_array = $this->modules;
$this->modules = array();
foreach($temp_array as $val){
if(mysql_num_rows($query)==0 || in_array(str_replace('.php','',$val),$allow_mod_array)) {
$this->modules[] = $val;
}
}
}
// INDIV_SM END

Thats all. Hope this solve it for everyone, within my shop it works. ;-))

I've attached my shipping.php -- use winmerge or other tools to compare it with your own version! I've installed some other contribution that changed this file.

kind regards

peter

our success? individual commitment to a group effort

Community Add-Ons

Individual Product Shipping Prices - v1.0for osCommerce Online Merchant v2.2

Individual Product Shipping Prices - v1.0
for osCommerce Online Merchant v2.2