I'm working on a retail database. I noticed that a lot of retailers
are now charging freight based on an order total, e.g. if your order
total is between x and y, you are charged z for freight.
I can see keeping the shipping and handling charge at the order level,
but what becomes complicated is when you start allocating the order
detail line items. If you have an order with two items, one is in
stock and the other is backordered, what do you charge and, better
yet, how do you calculate freight if you wish to allocate and ship the
in stock item prior to the backordered item arriving in your
warehouse? Do you keep a freight field on the order detail level as
well and perform some calculation to figure what portion of the
freight applies to each line item? What is that calculation?
Received on Tue Jan 21 2003 - 18:20:51 CST
