Login  Register

Re: Users - Shipping, packaging, rate calculation...

Posted by Daniel Kunkel on Mar 17, 2006; 2:16pm
URL: http://ofbiz.116.s1.nabble.com/Users-Shipping-packaging-rate-calculation-tp137949p137950.html

Hi Ben

Welcome!

I sent out a proposal  a while back...  repeated here for an improvement
to the shipping scheme that sounds like an exact fit. There is an open
issue in Jira where you can add your thoughts on how the scheme might be
improved.

http://jira.undersunconsulting.com/browse/OFBIZ-669 

Unfortunately, its beyond my time and resources to implement, however
with your help that might change.

---

I've got an idea for an improved shipping scheme I wanted to run by
other OFBiz users and see what everyone thought...

Although we have the USPS rate estimator working, I'm discovering that
it's very difficult to charge competitive shipping rates because the
packing material weights vary so much...

The idea I have is to add a new table of box sizes, recording both the
overall size, and the usable inner size. Then OFBiz will simply figure
out the box that's large enough for the largest item(s) and that has
enough shipping volume to handle the combined products.

The weight of this box can then be used when calculating the postage
weight for the order.

----

Can anyone help fund the development of this feature?  I've created a
jira issue for this with a few more details of the proposed algorithm,
which would be a good place to add your thoughts.

Thanks

Daniel


On Thu, 2006-03-16 at 23:29 -0800, Benjamin Cox wrote:

> First off, let me say that I'm highly impressed with ofbiz.  I  
> discovered it about ten days ago, and immediately felt very much at  
> home with the architecture;  I know just how productive this can be!  
> Also, I could see that you were _years_ ahead, and that you've  
> already tackled several of the thorny business issues that my  
> customers are facing these days.  So, I'm testing the waters, hoping  
> to be baptized as a convert!  So far, my hat is off to the ofbiz  
> community :-)
>
> One thing that I need to figure out in order to serve a current  
> client is how the shipping estimate is obtained...   in the five-year-
> old system we're porting to Ofbiz, we had built a packaging  
> calculator and a place for our client to add package dimensions and  
> weight capacities.  We then applied a relatively trivial optimization  
> process by trying to fit all items in an order into one box, and  
> moved up a box size if it didn't fit.  We kept this up until we had  
> to start a new box.
>
> Pretty basic, but it obviously allowed the end user to be quoted  
> significantly less expensive prices from UPS than would have been  
> possible just shipping one "item" per box, etc.  By the way - items  
> are units of measure of a wholesale cloth.  One tricky element,  
> therefore, is that the product can be rolled up, so 20 square feet  
> comes in one 4 foot piece rolled up, rather than 20 stacked 1x1  
> pieces or a 4x5 sheet.
>
> I've found the portion of the admin section where a shipment can be  
> made for the order, and packages created and filled by an employee,  
> but this is all long after the rate estimate and payment processing.  
> How does the rate estimate correlate to the packaging process?  Is it  
> already performing any kind of packaging calculation when obtaining  
> shipping quotes?  If so, where is the code for this located?  
> Otherwise, where exactly does the hand-off from products to what I've  
> been calling "shipment items" take place?  Would it make sense to  
> inject something to convert products to packages at that point?
>
> I appreciate any guidance you can offer,
>
>    Ben
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
--
Daniel

*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Have a GREAT Day!

Daniel Kunkel           [hidden email]
BioWaves, LLC           http://www.BioWaves.com
14150 NE 20th St. Suite F1
Bellevue, WA 98007
800-734-3588    425-895-0050
http://www.Apartment-Pets.com  http://www.Focus-Illusion.com
http://www.Brain-Fun.com       http://www.ColorGlasses.com
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users