Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

individual product shipping prices


rmsigns

Recommended Posts

hello fellow osc'ers

someone pointed me to this contribution 'individual product shipping prices' but i need a little help with it. the contrib states that one needs to alter 2 of the sql tables but i am unsure of how to go about doing it. if anyone could possibly help me with this i'd be ever so grateful. here is what it states:

 

You will need to add 1 table: use the following SQL command

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;

You will need to modify 1 table: use the following SQL command

INSERT INTO configuration VALUES ('', 'Indiv Ship Home Country', 'INDIVIDUAL_SHIP_HOME_COUNTRY', '223', 'Individual ship home country ID (other countries will have extra freight)', 7, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);

INSERT INTO configuration VALUES ('', 'Indiv Ship Outside Home Increase', 'INDIVIDUAL_SHIP_INCREASE', '3', 'Individual ship x increase for shipping outside home country. For example: If you set your item ship price to $50 and this value to 3 and ship outside your home country they will pay $150, and if this value was 2, they would pay $100.', 7, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);

 

i know where the sql is for my site but not sure how to go about doing it, think i need the instructions to be a little more specific....

please and thank you

maureen

Link to comment
Share on other sites

hello fellow osc'ers

someone pointed me to this contribution 'individual product shipping prices' but i need a little help with it. the contrib states that one needs to alter 2 of the sql tables but i am unsure of how to go about doing it. if anyone could possibly help me with this i'd be ever so grateful. here is what it states:

 

You will need to add 1 table: use the following SQL command

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;

You will need to modify 1 table: use the following SQL command

INSERT INTO configuration VALUES ('', 'Indiv Ship Home Country', 'INDIVIDUAL_SHIP_HOME_COUNTRY', '223', 'Individual ship home country ID (other countries will have extra freight)', 7, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);

INSERT INTO configuration VALUES ('', 'Indiv Ship Outside Home Increase', 'INDIVIDUAL_SHIP_INCREASE', '3', 'Individual ship x increase for shipping outside home country. For example: If you set your item ship price to $50 and this value to 3 and ship outside your home country they will pay $150, and if this value was 2, they would pay $100.', 7, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, NULL);

 

i know where the sql is for my site but not sure how to go about doing it, think i need the instructions to be a little more specific....

please and thank you

maureen

 

club osc has a tutorial on sql: http://www.clubosc.com/how-to-use-phpmyadm...o-load-sql.html

I am a Jedi, like my father before me!

Link to comment
Share on other sites

Good evening,

I have been trying to download this contrib but it won't download.

Could I be cheeky and ask if you could mail it to me?

 

Thanks

Tony

did you try the little box on the right of the contrib? it should tell you where it's going to download to and you can change that to a desktop file so it's easy to find

Link to comment
Share on other sites

  • 3 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...