How do I charge shipping based on price ranges

JulienDJulienD Posts: 9Member, Moderator, Lightspeed Staff moderator
edited October 2018 in Tips, Tricks & How-To's
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.

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 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 in order 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
Sign In or Register to comment.