Shipping rules making my hair fall out

[ksasaki]

Okay, I?ve been doing quite well for several days and have gone through these pages to help me with any questions. Still, there?s one that has been killing me for a couple days now. Perhaps it?s a simple solution, a contribution or more.

 

Anyways, I am trying to set up my rules for shipping and just haven?t gotten it so far.

 

To begin. I have set my ?tare weight? to 0 and the ?extra charge? also to zero, as suggested in other articles I have read through.

 

Next, I am trying to use the table rate and have the following settings:

Table Rate

 

Enable Table Method

True

 

Shipping Table

1:3.50, 2:5.00, 3: 7.00, 4:10.00, 25:5.00, 50:10.00, 75:15.00

26:8.50, 27:10, 28:12.00,51:13.00, 52:15.00, 53:17.00,100:18.00 and so on.

(1 for small items, 25 for mid, 75 for large and so on.

 

Table Method

weight

 

Handling Fee

0

 

Tax Class

--none--

 

Shipping Zone

--none--

 

Sort Order

0

I created my shipping table on the basis that people buy multiple items. When I have tested and ordered just one small item, the shipping cost of 3.50 came up like a champ. Same thing if I ordered just one mid sized item. It came up to 5.00 for shipping. The problem though, is that when I combine products, I never get a clear shipping rate. This is why I came up with the above table for possible purchase scenarios. Buy 3 small items and shipping is 7.00. Combine that with a large article and total shipping would be 22.00

 

Somewhere, this isn?t working..

 

Now I have read in several posts that people have used the following contribution:

http://www.oscommerce.com/community/contri...ions,367/page,3 is this something I should look into?? The only reason I ask is that it is kind of outdated and since I am not the smarted programming bear, I would rather install something that doesn?t have so many steps to take. I will if needed though. Is there something out there more efficient??

 

Maybe I?ve already confused everyone but, what I want to do is assign a shipping price to a certain product and so forth and so on. If people order five products in which each costs 15 euros to ship, then the total would be 60. If you added something that costs five euros to ship, then the total would be 65.. I haven?t been able to do this..

 

Sorry for such a long post and thank you very much in advance for your support.

Keith

[stevel]

The table has to be sorted for increasing "weights". Does that help?

[ksasaki]

The table has to be sorted for increasing "weights".  Does that help?

<{POST_SNAPBACK}>

 

 

Could you please elaborate on that?? Show me an example?? Sorry for asking what may seem such an lame question. I've tried several scenarios and haven't gotten any success as of yet.

 

Thanks again.

Keith

[stevel]

Perhaps I misunderstood what you wrote, but it looks as if you specified the table values out-of-order. The table module requires that the "weights" be in strictly ascending order in the list, where it looks as if you had an order 1,2,3,4,25,50,75,26,27,28... It would have to be instead 1,2,3,4,25,26,27,28,..,50,75, etc. Is that clearer? Perhaps this isn't your problem, as you didn't explain what values you get that were wrong, but it seems likely to me.

[ksasaki]

Perhaps I misunderstood what you wrote, but it looks as if you specified the table values out-of-order.  The table module requires that the "weights" be in strictly ascending order in the list, where it looks as if you had an order 1,2,3,4,25,50,75,26,27,28...  It would have to be instead 1,2,3,4,25,26,27,28,..,50,75, etc.  Is that clearer?  Perhaps this isn't your problem, as you didn't explain what values you get that were wrong, but it seems likely to me.

<{POST_SNAPBACK}>

 

 

Steve, wanted to say thank you for tying to help thus far. I've taken your suggestions and created my tables as follows:

 

1:3.50, 2:5.00, 3:7.00, 4:10.00, 25:5.00, 26:8.50, 27:10.00, 28:12.00, 51:13.00, 52:15.00, 53:17.00, 100:18.00, 500:15.00, 501:18:50, 502:20.00, 503:22.00, 525:20.00,

 

I have different categories: In category one, if I was selling socks, then I would assign a sock with weight of "1". Another category would be shoes. Those products are assigned "25". From there, the category of products are stereos which have been assigned "500".

 

So, logically (at least I think). If you ordered a stereo and pair of shoes, then shipping should come out to 20 euros according to my table. Well, it comes out "0".

 

This is where I'm freaking out. I thought that OsC automatically calculates the shipping charges according to the assigned "weight"??. If so, it isn't working.

 

As I mentioned before, if I was to order just one stereo, then the shipping of 15 euros would come up. But if I added a pair of socks in my basket, either I get a "0", 1000 euros or some other number...

 

Thanks again..

 

Keith

[stevel]

At this point, I would recommend inserting some debugging code in table.php's quote function to see what it is doing. A few judicious print_r() calls of variables it is looking at would be useful.

[Jeremy at oddly enough]

Keith, the way you are trying to get the shipping to work is not how it was conceived, and you are going to get some unexpected, but predictable results, even if you get it working as is. For example shipping for 4 socks will be 10.00, but any where from 5 to 24 would be 5.00. That can't be your intent, can it? The reason your shipping might be coming to 0 for a stereo and a pair of shoes could be that you missed one of the sneaky added weights, and you don't have a value high enough in your table as a result. Try adding an entry for 999 to see if it gives a result. You also ought to specify a sort order, as the 0 can create problems.

 

By the way, how are you going to describe your shipping policy to prospective customers? I'm just curious.

 

Jeremy

[ksasaki]

Keith, the way you are trying to get the shipping to work is not how it was conceived, and you are going to get some unexpected, but predictable results, even if you get it working as is.  For example shipping for 4 socks will be 10.00, but any where from 5 to 24 would be 5.00.  That can't be your intent, can it?  The reason your shipping might be coming to 0 for a stereo and a pair of shoes could be that you missed one of the sneaky added weights, and you don't have a value high enough in your table as a result.  Try adding an entry for 999 to see if it gives a result.  You also ought to specify a sort order, as the 0 can create problems.

 

By the way, how are you going to describe your shipping policy to prospective customers?  I'm just curious.

 

Jeremy

<{POST_SNAPBACK}>

 

 

Jeremy,

Thanks for your message. I did create a table for around 50 or so possible purchase scenarios, but the shipping tables module only accepted around 20, which basically scraped that idea... I'm still looking for a solution..

 

Shipping policy is quite simple.

Having only around five actual weight categories, group one would cost XX to ship, group 2-XX so forth and so on..

 

Actually, as I write this, I think I have a better idea now of how the shipping table module works.

 

If you could think of something, gatering the information in my past posts and of this one, help would be appreciated.

 

Thanks for your time.

Keith

[Jeremy at oddly enough]

If you want 5 shipping categories, then just pick the five numbers that will be the upper limit of your divisions. Shipping is charged at the prescribed rate for orders up to, and including the limit. Orders with weights that add up to, or below the first weight will be charged at that rate, everything that falls between the first and second weights will be charged at that rate, etc..

 

Jeremy