How do I charge shipping based on price ranges

JulienD

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

SamaroosCarnivalCity

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

Joey

@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.

VintageWineGuy

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?

Joey

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

bharris

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?