Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2012
    Posts
    29

    Unanswered: Linking freight cost

    How can i link my freight cost to my order date?
    thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if freight rates (and presumably prices can change then I's store the prices applicable to the order at that time

    historically I've alwaya added freight, post & packing or whatever as a separate line item
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    Have a table that holds freight codes and break points (weight/distance/whatever). Have another table that holds freight codes, effectivity dates and the price that applies to each one. Use the order's date and freight code to pick up the cost.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  4. #4
    Join Date
    Aug 2012
    Posts
    29
    Thank u I will add it as a seperate item. It will make it easier

    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •