Announcement

Collapse
No announcement yet.

How to Easily Calculate Shipping Charges

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to Easily Calculate Shipping Charges

    It goes without saying that it's very time consuming to have to consult a chart or add to cart to get shipping costs. If you know how to use a spreadsheet though, you can have all that information right in front of you.

    * This method assumes that you have access to an inventory report. You'll need to contact SLC to see about getting it if you don't. I don't know if it's available to all members or not.
    ** This also adds in the 50ยข fuel surcharge.
    *** Although not 100% accurate since other factors come into play ie. large or heavy items, quantity, etc., it's good for most individual products.


    5 Easy Steps:
    1) Enable editing (if acquired from SLC, file is safe and no need to remain in protected view)
    2) Remove the top blank row of the spreadsheet. This will put the column headings in the top row.
    3) Create 8 new columns - one for each shipping zone and one for rush. Name them accordingly in the column headings.
    4) Enter these formulas as indicated in cell 2 of each column.
    For Zone 2
    =IF(G2>38.23,SUM(0.5,PRODUCT(G2,0.17)),7)

    For Zone 3
    =IF(G2>34.21,SUM(0.5,PRODUCT(G2,0.19)),7)

    For Zone 4
    =IF(G2>30.95,SUM(0.5,PRODUCT(G2,0.21)),7)

    For Zone 5
    =IF(G2>28.26,SUM(0.5,PRODUCT(G2,0.23)),7)

    For Zone 6
    =IF(G2>26,SUM(0.5,PRODUCT(G2,0.25)),7)

    For Zone 7
    =IF(G2>24.07,SUM(0.5,PRODUCT(G2,0.27)),7)

    For Zone 8
    =IF(G2>22.41,SUM(0.5,PRODUCT(G2,0.29)),7)

    Rush for all zones
    =IF(G2>30.77,SUM(0.5,PRODUCT(G2,0.65)),20)

    5) Double-click the little square on the bottom-right of the cell to copy the formula down the column.

    Last edited by Store-n-Decor; 08-24-2014, 07:45 PM.

  • #2
    thanks for this colossal edifying website, living up the skilled work check out this online casino offers

    Comment


    • #3
      check doused this casino online where you can win legal funds with the usurp of this guidebookPlaying baccarat online , buy sex toys

      Comment


      • #4
        We're web-based resources, You can find directory real estate Spain, in which represented all detailed information about the whole available real estate country. websites real estate in spain. We present the pages the decent and affordable housing, buy it will everyone. Townhouses and small apartment and villas, other housing in our directory presented in rich range. We offer budget the property and housing VIP class. cheap property in spain for permanent residence. For each of catalog items affixed detailed description the property quality photos.

        Comment


        • #5
          block to this casino where you can collect real notes with the serve of this guidePlaying blackjack online , buy sex toys

          Comment


          • #6
            thanks towards this significant illuminating website, living up the momentous position check out this online casino offers , buy sex toys

            Comment


            • #7
              block out this online casino where you can collect legal kale with the usurp of this lightPlaying free casino bonus , check this casino

              Comment


              • #8
                thanks towards this countless informative website, keep up the massive position check out this online casino offers

                Comment

                Working...
                X