Shipping Table Rate

[TracyJane]

Hello

 

I need some help setting the shipping table rate up, and am very unclear as to how this should be done. We would like the system to calculate out the cost of shipping per item.

 

Item 1 weighs 15g and shipping is ?0.00.

Item 2 weighs 100g and shipping is ?0.75.

Item 3 weighs 500g and shipping is ?2.00.

 

How do I set this up. When I did it as was shown in the example (15:0.00,100:0.75,500:2.00) I ended up with a shipping rate of ?60.50! <_<

 

Any clues? Thank you.

[geenygreat]

If you want to set shipping based on weight, the you have configured it correctly. But if you want to set shipping rate per product, then this module will help.

[Steve2004]

Hi,

 

I wondered if you have the table rate by weight working correctly yet? I am in the UK as well and I'm having problems. I think I really must be misunderstanding something with this module!

 

I have download items that have 0.00 weight/shipping and then items that weight the same, i.e CDs that all have the same weight.

 

So to test the module I set each download item to a weight of 0.00 and each CD a weight of 1.00. I then set the following rates 0:0.00,1:1.00,2:1.50,3:2.00 etc which I understood to mean to any item weighing 'zero' would be 'zero' shipping, it did'nt work it just ignored it, counting zero weight as '1'. Then I tried setting 1:0.00, 2:1.00,3:1.50,4:2.00 which worked for items weighing 0 but also seemed to see the items with weight as being zero.

 

Now I have the strangest of fixes I set 4:1.00,5:1.50,6:2.00 etc and it works! each download which a weight of 0.00 is charged 0.00 shipping, i item with a weight of 1.00 is charged 1.00, 2 tems with a weight of 2.00 is charged 1.50 etc etc.............I'm at a loss.

 

Any ideas

 

Steve

[TerryK]

Check out the package tare weight setting in the Admin-> Configuration -> Shipping/Packaging area. It's set at 3 by default, so you probably want to change it to 0 (or, if you want to factor in the weight of your shipping boxes, to whatever that weight might be).

 

HTH,

 

Terry

[TerryK]

One more thing: check to see what the maximum package weight is listed at in the Shipping & Packaging area, too. I believe the default is 50, so that may be why you got the initial high price on shipping.

 

I am also using grams as the weight for my orders. I've set my maximum package weight to 50000, with tare weight of 100 and percentage increase of 10 on larger packages.

 

HTH,

 

Terry

[Steve2004]

Thanks for posting Terry, the package tare weight setting solved my problem. I remembered seeing it when I first started setting up osCommerce but forgot all about it.

 

Many thanks

 

Steve

[Guest]

hi i get errors in my file anyone got any ideas

 

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

 

select p.products_ship_price, p.products_ship_price_two, pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from products p, products_description pd where p.products_id = '32' and p.products_id = pd.products_id and pd.language_id = '1'

[joelm]

Check out the package tare weight setting in the Admin-> Configuration -> Shipping/Packaging area. It's set at 3 by default, so you probably want to change it to 0 (or, if you want to factor in the weight of your shipping boxes, to whatever that weight might be).

 

HTH,

 

Terry

 

Thank you too terry. This has solved my problem here too. Where was my head? :P

[Guest]

I hope this topic is still being monitored. The Table Rate shipping mod should be perfect for what I need but like others I can not get it to work for me.

 

I need the free shipping amount to be at the lower end. I want to write the table so that anything that has a weight of less than a LB will ship for free and 1 to 1.5 LBS for ??? and 1.5 (or 2) fror??? and so forth.

 

I attempted to change the default (25:8.50,50:5.50,10000:0.00) to 1.5:0.00,1:8.50,2:12.50 and it did not work.

 

Any ideas?

[cryosi]

hi im having trouble with this as well i have these values set

 

500:1.70,750:220,1000:4.00,2000:6.00,4000:8.50,10000:10.50

 

Package Tare weight. 100

Larger packages - percentage increase. 10

 

Products Weight: 0.25 ( wanted this to be 0.258) but it wont go.

 

have changed the LBS to Kgs in the revelant php page that was mentioned on diff page.

 

Anyone help.???

 

thanks

barry

 

Im using grams as most products weigh in at grams or (170ml or 250ml) etc so grams is easier.

[aprildain]

Hi,

 

I have a question.

 

If I use this shipping method, will it only apply to my country (USA)?

 

Or if an international customer orders, will it still charge them the rate too.

 

Thanks.

[mrbill]

Check out the package tare weight setting in the Admin-> Configuration -> Shipping/Packaging area. It's set at 3 by default, so you probably want to change it to 0 (or, if you want to factor in the weight of your shipping boxes, to whatever that weight might be).

 

HTH,

 

Terry

 

Thanks Terry, this was driving me crazy.

[thehighlandsgroup]

I have a shopping cart we've setup for a client that wants to charge $0 shipping for 0 weight products. Other products with weights would have USPS and UPS shipping options. Table Rate of $0 now shows for all products over 1 lb. Is there a way to hide Table Rate of 0 for orders with weight over 1lb.

 

Cheers,

 

Gene Fourney

[♥rocket468]

I have a shopping cart we've setup for a client that wants to charge $0 shipping for 0 weight products. Other products with weights would have USPS and UPS shipping options. Table Rate of $0 now shows for all products over 1 lb. Is there a way to hide Table Rate of 0 for orders with weight over 1lb.

 

Cheers,

 

Gene Fourney

 

 

 

I have the same issue. I just put in 10000:1000 so it give a high shipping rate for this. But would like it to just hide the modual when over 1lb in weight. Anyone have idea how to do this?

[telefonica600]

Ok, so I have been looking on and off for hours and this seems like the best place to ask.... hahahaha

 

I want to use the table rates sorted by price.

My setup is as follows:

 

Table Rate

Enable Table Method

True

Shipping Table

10:1,20:2,30:3,40:4,50:5,60:6,70:7,80:8,90:9,100:10,110:11,120:12,130:13,140:14,

150:15,160:16,170:17,180:18,190:19,200:0

Table Method

weight

Handling Fee

0

Tax Class

Taxable Goods

Shipping Zone

--none--

Sort Order

1

 

The problem that I have is when I go to checkout, it gives me this:

 

Shipping Method

 

This is currently the only shipping method available to use on this order.

Table Rate

Best Way

 

 

 

I have all of the other shipping methods disabled. How do I remove the bestway option and make the table start working?

 

Best regards,

 

Steve

[telefonica600]

Any help?

 

Thanks everybody.