Shipping costs means the amount you, the store owner, pay to ship an order to your customer. Applying shipping costs into Triple Whale will be used in the Expenses section on the Summary Page and the Net Profit calculation.
You can add shipping costs in the following ways from the cost settings page:
A direct integration with two different Shipping Tools, ShipStation or ShipBob. By doing this, shipping costs will be automatically imported into Triple Whale.
Set shipping costs equal to Shipping Charged (what your customers pay for shipping in Shopify).
Manually upload a CSV file based on specific Order IDs to match shipping costs from Shopify data.
Set shipping profiles (estimates) based on country, order weight, & shipping method.
Here's a quick summary of how Triple Whale makes a final determination on shipping costs when one or more settings are applied:
Priority 1: Integrations with Shopify Shipping, ShipStation, or ShipBob
Priority 1a: Set shipping costs equal to Shipping Charged (what your customers pay for shipping). This setting appears in the Triple Whale expenses section on Summary, and if enabled, will ignore any other input aside from integrations.
Priority 2: Imports from CSV files
Priority 3: Shipping profiles
Shipping Integrations
If you integrate with one of the shipping integrations, then we will use that data to calculate your shipping costs per order. If orders are missing from the integration, we will rely on the above list of priorities to calculate the costs.
If you are using an integration, but want to also have ‘shipping estimates’ on your Summary page, then we recommend adding product specific costs, weight based costs or country specific costs in order to create estimations.
ShipStation
If you are using ShipStation to manage your shipping costs, you can connect Triple Whale and ShipStation to allow you to get an accurate net profit on Triple Whale, and watch your most important shipping metrics. Please refer to this article from our Knowledge Base, Integrating ShipStation with Triple Whale.
ShipBob
If you are using ShipBob to manage your shipping costs, you can connect Triple Whale and ShipBob, which will allow you to get an accurate net profit on Triple Whale. ShipBob is a global omnifulfillment solution trusted by thousands of brands to ship orders from everywhere their customers shop. Please refer to this article from our Knowledge Base, Integrating ShipBob with Triple Whale
Use Shopify Shipping Charges for Shipping Costs
Enable this setting (see below) if the shipping costs are equal to what your customers have been charged for shipping within Shopify.
Shipping Costs by Order ID (CSV upload)
Click 'Import Shipping by Order ID CSV' from the dropdown menu. Your CSV upload must have only two columns, 'order_id' and 'shipping cost.'
The Order ID data is related to the Shopify Order Number or the Shopify Order ID. See below for the difference of the two numbers, and please note the CSV import is approved for either option.
Shipping Profiles
Shipping profiles represent your brand’s shipping rates. Use this option if you want the shipping value in Triple Whale to display how much you pay to ship orders to your customers. You can create shipping profiles based on country/region, weight and shipping method.
Steps to creating a shipping profile:
Select the countries / states/ regions you want to apply each rate to
2. Select from two different options to display these rates:
Fixed rate: One single rate for every order that is shipped to the selected region. Please note that you can add different rates per time period. So if your shipping rate to USA was $5 in January, and $6 in February, you can add both of those prices by clicking on the clock icon within the field to change the historical data.
Order weight-based tiered rates: One rate for every weight range per order shipped to your selected region.
3. Add additional costs for fulfillment methods: If you have different rates for different shipping methods (e.g. overnight vs 5-7 days), then you can add an additional cost for the different shipping methods to your selected region/s.
