Specific shipping cost per item.

[lee246]

Hi all,

I have been trying to find a contribution that will allow me to set a specific shipping cost for each item. This is because I am selling items using the dropship method so each individual item has its own shipping cost and none of the standard oscommerce shipping modules are suitable for this.

I haven't been able to find a contribution that can do this, does anyone have any ideas or pointers?

Thanks.

[OceanRanch]

http://www.oscommerce.com/community/contributions,1333

 

HTH

Tom

[lee246]

Thanks a lot Tom, I shall check this out.

Thanks, Lee.

[lee246]

I'm already stuck on instaling this contribution, the instructions don't seem to clear.

Can anyone make any sense of this for me please?

 

****************

MYSQL table products_shipping

 

DROP TABLE IF EXISTS `products_shipping`;

CREATE TABLE `products_shipping` (

`products_id` int(11) NOT NULL default '0',

`products_ship_methods_id` int(11) default NULL,

`products_ship_zip` varchar(32) default NULL,

`products_ship_price` varchar(10) default NULL,

`products_ship_price_two` varchar(10) default NULL

) TYPE=MyISAM;

 

Add in includes/databaes_tables.php define('TABLE_PRODUCTS_SHIPPING', 'products_shipping'); //eof

 

*******************************

Files to change

1- Add in includes/databaes_tables.php

define('TABLE_PRODUCTS_SHIPPING', 'products_shipping');

+++++++++++++++++++++++++++

++++++++++++++++++++++++++

2-includes application_top.php

at the end before the ?> add

require(DIR_WS_CLASSES . 'shipping.php');

$shipping_modules = new shipping;

[lee246]

anyone?

[OceanRanch]

1. You'll need access to phpmyadmin to run the following SQL statement to create the new table.

 

In the SQL tab, copy/paste the following code and run it.

 

DROP TABLE IF EXISTS `products_shipping`;
CREATE TABLE `products_shipping` (
`products_id` int(11) NOT NULL default '0',
`products_ship_methods_id` int(11) default NULL,
`products_ship_zip` varchar(32) default NULL,
`products_ship_price` varchar(10) default NULL,
`products_ship_price_two` varchar(10) default NULL
) TYPE=MyISAM;

 

2. Using your local editor (you may need to ftp the file down to your PC to edit) (do not use the osc File Manger editor - it's buggy).

 

edit catalog/includes/database_tables.php

 

add the following line in with the other defines.

 

define('TABLE_PRODUCTS_SHIPPING', 'products_shipping'); //eof

 

3. edit catalog/includes/application_top.php

 

Just before the last statement

 

?>

 

add the following code

 

require(DIR_WS_CLASSES . 'shipping.php');
$shipping_modules = new shipping;

 

HTH

Tom

[lee246]

brilliant thanks.