Community Forums 

Main Content

shipping prices in units

    Mar 31 2012 21:36:43

    #1

    cassie75

    Join date : 2008-09-18      Posts : 273

    I really hate to do this as I know I should be able to work it out, but have been going round in circles for last 3 hours and got nowhere. Brain now fried :-(

    Most of the things we sell has a shipping unit of 1 with postage of 3.25 on option 7

    Some have a postage of 1.25 up to 10 items then postage is 2.50 up to 25 items when postage goes up to standard 3.25

    Some have postage of 2.50 up to 5 items when the postage then goes up to standard 3.25

    Therefore to summarise

    A - up to 10 = 1.25
    A - 11 to 25 = 2.50
    A - 26+ = 3.25
    B - up to 5 = 2.50
    B - 5+ = 3.25
    C - all 3.25 - unit 1

    Don't want to change the main unit for C to anything other than 1 if can help it as that would be a big job. A and B are both smaller jobs.

    I have A as unit 0.04 and B as unit 0.19 but can't work out what to put in the Option 7 bands.

    Any help would really, really be appreciated

    Life is too short to work 8 hours a day - thats why I work 16 :-)




    Apr 01 2012 06:27:16

    #2

    Alan

    Join date : 2008-09-18      Posts : 2951

    Can't see a solution but wondered how you wish to charge for a mixed order? Or for, say, 3 Cs.

    For orders of only A, B, or C products your units values look as good as any but I don't see a way to charge 1 or 2 Bs at other than 1.25.

    UNITS COST
    0.40 __ 1.25
    0.56 __ 1.25
    rest __ 0.75

    Alan
    Some shipping help documents are available at www.stoner.org.uk/mals/




    Apr 01 2012 14:58:01

    #3

    cassie75

    Join date : 2008-09-18      Posts : 273

    We could adjust the numbers slightly so that they are as follows if that helps
    A - up to 10 = 1.25
    A - 11 to 20 = 2.50
    A - 21+ = 3.25
    B - up to 5 = 2.50
    B - 5+ = 3.25
    C - all 3.25 - unit 1

    So if someone buys some A's as soon as they buy a B it would go up to 2.50. Guess I am saying that 4 A's are worth a B.

    Perhaps some context may help. We sell knitting yarn (C) which obviously does not go through the 25mm Royal Mail 'slot' so we have to charge as a packet (3.25). But books (B) go through a slot - well up to 6 then they get too thick so are then a packet (C). 'A' are pattern leaflets which are much thinner so also go through the slot but we use them a bit like a loss leader - people like to see the pattern before they order the wool so we want to keep the pp price as low as possible.

    Would a 1.25 set price with some adjustment via the bands help ? Or a set price of 2.50 with minus numbers in the bands.... maths was never my strong point .... :-(

    Life is too short to work 8 hours a day - thats why I work 16 :-)




    Apr 01 2012 16:37:31

    #4

    Alan

    Join date : 2008-09-18      Posts : 2951

    Is 3.25 the maximum charge? What do you charge for 3 Cs?

    Alan
    Some shipping help documents are available at www.stoner.org.uk/mals/




    Apr 03 2012 13:24:32

    #5

    cassie75

    Join date : 2008-09-18      Posts : 273

    3.25 is the maximum however much you order.

    At the moment it is 2.50 for any B and/or C's but we don't think customers will accept the Book p+p price going up by so much when they will fit through the Large Letter Slot. It is the Packet prices that are rising so much due to the weight bands up to 750g being merged.

    Life is too short to work 8 hours a day - thats why I work 16 :-)




    Apr 03 2012 20:03:54

    #6

    Alan

    Join date : 2008-09-18      Posts : 2951

    I don't see using a base charge helping, with or without minus COST values.

    Using 0.04 and 0.19 you might subsidise postage on a single book. Depends how often it happens I suppose.

    UNITS COST
    0.37 __ 1.25 ____ 1-9 As, 1 B
    0.58 __ 1.25 ____ 10-23 As, 2-5 Bs
    rest __ 0.75 ____ 24 As, 6 Bs, 1 C

    Alan
    Some shipping help documents are available at www.stoner.org.uk/mals/




    Apr 06 2012 19:00:13

    #7

    cassie75

    Join date : 2008-09-18      Posts : 273

    Unfortunately it happens quite often so couldn't do that.

    As a compromise we may have to do the following instead. Not too many people have more than 15 patterns anyway. They could always put in a second order for another 10 which will be cheaper for them and easier for us to explain :-)

    A - up to 15 = 1.25
    A - 16+ = 3.25
    B - up to 5 = 2.50
    B - 5+ = 3.25
    C - all 3.25 - unit 1

    Does this make it easier?

    Life is too short to work 8 hours a day - thats why I work 16 :-)




    Apr 06 2012 22:07:01

    #8

    Alan

    Join date : 2008-09-18      Posts : 2951

    Don't think it helps.

    Alan
    Some shipping help documents are available at www.stoner.org.uk/mals/




    Apr 07 2012 17:06:23

    #9

    cassie75

    Join date : 2008-09-18      Posts : 273

    OK - had to change our mind a bit on what prices and bands to charge but figured it out. Daughter home from Uni (doing maths degree) so helped me out a bit. Thought would post in case it helps someone else

    A unit - 0.0359
    B unit - 0.181
    C unit - 1.0

    A - 1 to 5 - 1.25
    A - 6 to 25 - 2.50
    A - 26+ - 3.25

    B - 1 to 5 - 2.50
    B - 6+ - 3.25

    C - 3.25

    Up to 0.18 = 1.25
    next 0.01 = 1.25
    next 0.72 = 0
    next 0.01 = 0.75

    Now have to sort out my other cart which has 3 different sections - for UK, Europe and ROW. That increases by weight. Will have to see daughter next time she is home :-( Or may post again when brain recovered from this one.

    Life is too short to work 8 hours a day - thats why I work 16 :-)