2 different Shipping costs on Certin products

[mtechama]

I have 2 seperate stores and what I am trying to do is combine 2 store together.

 

Ok, one store is my computer store the shipping charge is 20% of total cost.

 

and my gift store is: $10.00 for up to $100.00 and 10% for over $100.00

 

is there a way that I can have a certin product on a certin shipping?

Edited March 31, 2006 by mtechama

[mtechama]

Anyone?

[mtechama]

Can anyone help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[mtechama]

After I install the Indavidal Shipping by products it get this error when adding to cart:

 

 

1146 - Table 'mgstest.TABLE_VENDORS' doesn't exist

 

select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id, v.vendors_id, v.vendors_name from products p, products_description pd, TABLE_VENDORS v where p.products_id = '1203' and pd.products_id = p.products_id and v.vendors_id = p.vendors_id and pd.language_id = '1'

 

[TEP STOP]

[mtechama]

after I installed the contribution: "Indvidual Product Shipping Prices - v1.0"

 

here is this contribution I found at:http://www.oscommerce.com/community/contributions,1333/category,2/search,prodrate

 

the admin works fine but when I click on catalog in Admin I got this error:

 

 

1054 - Unknown column 'p.products_ship_price' in 'field list'

 

select p.products_ship_price, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

 

[TEP STOP]

 

and when I add item to cart I also got this error:

 

Sub-Total: 1054 - Unknown column 'products_ship_price' in 'field list'

 

select products_id, products_price, products_ship_price, products_tax_class_id, products_weight from products where products_id = '18'

 

[TEP STOP]

Edited April 2, 2006 by mtechama

[mtechama]

ok now got it up and running now I run into a problem. my shipping cost won't working. for an example: if you add the printer $499.95 and I was going to add 20% to the shipping its still says $0.00 why?

[satish]

ok now got it up and running now I run into a problem. my shipping cost won't working. for an example: if you add the printer $499.95 and I was going to add 20% to the shipping its still says $0.00 why?

 

 

Check setting at Paypal profile.It might Be over writing the shipping amount you are sending.

 

DO not allow it to overwrite.

 

Also I suggest you to use Paypal IPN by oscommerce.It will take care of autoreturn.

 

 

Satish Mantri

[mtechama]

This is on my Test Site and I don't have paypal set up on it

[mtechama]

ok with this contribution: "Individual Product Shipping Prices - v1.0"

 

will it work like this all my computer parts shipping cost--------> 20% of total order

 

and my gifts items shipping------------> $10.00 up to $100.00 anything over $100.00 is 10% of total cost

 

 

is that currect?