How do I charge shipping based on price ranges

JulienDJulienD Member, Moderator, Lightspeed Staff Posts: 25 moderator
Even though Lightspeed eCommerce does not offer a shipping option based on the cart total, you can easily use a workaround to offer flat rate shipping based on price ranges.

The main idea is to use the weight field of a product in grams as if it was another place to define the item's price. 

Set up a shipping method

  1. Log in your eCom back office, go to Settings > Shipping Methods and click on

  2. Give it a title and select the ‘default delivery’ type:

    Note: Title will be visible to customers at checkout as a shipping option:

  3. Once you hit Save, the settings for this shipping method are made available

  4. Scroll down to the bottom of this page to the section named Countries and select the country for which this shipping method will apply:

  5. Scroll-up to the section Delivery Costs and click on

  6. Create your first shipping level:

    Here we are setting up so that for a $0 to $50 cart subtotal, the shipping cost will be $35.

  7. Create your second shipping level:

    Here we are setting it up so that for a $50 to $200 cart subtotal, the shipping cost will be $15

  8. In this example, shipping will be free over $200. Therefore, we create another weight level between 200 and 10 000 grams for $0.

  9. Hit the Save button and the setup of the shipping method is done.

WARNING: We recommend the use of grams as a weight unit in this workaround. We cannot guarantee that it will be fully functional if you use pounds or ounces.

Export your eCom products

  1. Log in your eCom back office, go to Tools > Exports and click on 

  2. Choose to export Products and click on Export:

  3. Once the export has finished, you can click on Download to save the csv file on your desktop.

Editing the csv file

  1. Clean-up the file by deleting all the unnecessary columns and keep only the following columns:
    - Internal_ID
    - Internal_Variant_ID
    - Price
    - Weight

  2. Copy the values from the column Price and paste it into the column Weight:

  3. Delete the price column and save your file.

Note: The most recent products uploaded to your eCom will be located at the bottom of your product export!

Import your file

  1. Log in your eCom back office, go to Tools > Imports and click on

  2. Click on the Browse Computer button to select and submit your CSV file.

  3. Once the file is submitted, you will be prompted to select the category of import you want to do. Select to import Products:

  4. Automatically, the Additional Settings section will be displayed. Set the field Behavior to Only update existing products and the field Find by to Product/Variant ID:

  5. Check the last section named Set Field Types, make sure that your import file was automatically mapped as seen below:

  6. Click on the Continue button and then Start the Import:

Test it!

Order < $50

Order > $50 and < $200

Order > $200

Post edited by JulienD on

eCom Support

Lightspeed HQ


  • SamaroosCarnivalCitySamaroosCarnivalCity Member Posts: 1

    This would be if I only wanted to ship by price. Is there a way to ship by a choice of weight or price?

  • JoeyJoey Administrator, Moderator, Lightspeed Staff Posts: 277 moderator
    edited March 2020

    @SamaroosCarnivalCity You can create multiple shipping methods, so one for ship by weight and one for ship by price.

    My apologies for the above, not sure why I said it would be possible because of course it is being overwritten. You can not use both methods in the same shop.

    Post edited by Joey on
    eCom Support Team
    Lightspeed HQ
  • VintageWineGuyVintageWineGuy Member Posts: 132 

    But how would that work with this method? The ship by price method you are describing has us overriding the Weight data with price data.

    In my case, I have bottles of wine that cost $10 and ones that cost $1000, but they all weigh about 48oz. I can't overwrite my weight data with price data to be able to do this?

  • JoeyJoey Administrator, Moderator, Lightspeed Staff Posts: 277 moderator

    @VintageWineGuy The two methods can not be used at the same time, that was a mistake on my end.

    eCom Support Team
    Lightspeed HQ
  • bharrisbharris Member Posts: 1

    This is exactly what I was looking for!

    1. For all items in my inventory, would I need dimensions and weights for everything? This might be a silly question, but I only ask because I have over 8,000 items in inventory and am hoping for some way to bypass that as I slowly add products from my retail to e-comm.
    2. Would I have to import all my products at once? Or is this something I could keep up with as I move things from retail to e-comm? With that said, how would I know which products have been done/which ones need their weights changed to accommodate this on my excel spreadsheet?
Sign In or Register to comment.