1. Multiple Warehouse Free Shipping

Scenario

When I have multiple products from different warehouses in the cart and the value is above $100 I would like to show UPS Ground as free delivery. Currently I can only see a price and not the free UPS Ground delivery option. How can I achieve this through using DropShip and Shipping override?

Solution

The solution to the scenario is to apply 2 configuration options within DropShip and Shipping Override.

The first configuration option which will need to be changed is under the DropShip extension. The configuration option is called’ Use cart Price in Calculations’ this option will need to be set to Yes. When this is set to No, each warehouse will produce a rate based on the warehouse weight, price or quantity, which are then added together at the cart for the customer to view.

When this is set to Yes the rate shown at the cart is based off the total weight, price or quantity from all warehouses present. The screenshot below shows this option in the configuration panel for the DropShip extension:

The second option that needs to be changed is under the Shipping override extension. This option is called ‘Filter On Subtotal Price and Weight’ and needs to be set to True by highlighting the option. With this set to True the rule stated in the CSV file for Shipping Override will be based on everything present in the cart, instead of based on each product. The screenshot below shows this option within the Shipping override configuration panel:

The following screenshot shows how to configure the free shipping over $100 rule in the Shipping Override CSV file:

The following screenshot show the result when the 2 options above are not set to True or Yes:

This screenshot shows the result when the 2 options re correct configured:

The example CSV file can be downloaded in the link below:

Multi-warehouse Free Shipping CSV

 

2. Filtering based on Warehouse

This CSV example uses the warehouse ID of the Dropship warehouse to filter its rates.

To enable this functionality, select “Use with Dropship warehouse” in “Advanced Options” in the Shipping Override configuration section then click “Save Config” before uploading the CSV file.

This option requires an additional column to be present in the CSV file, as illustrated above.

The warehouse ID is located in Shipping Mgr > Manage Warehouses in the ID column: