Workflow · Stock and products · Opening soon

Shipping cost per order

Use your ShipStation shipment export to review shipping cost analysis by carrier, service, and destination zone. The workflow calculates the average shipping cost per order from your shipment rows.

Book a demo

Someone typed

“calculate average shipping cost per order by carrier, service and destination zone”

The agent read it as

Calculate average shipping cost per order by carrier, service and destination zone in ShipStation shipments.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

ShipStation shipments

CSV export · 20 rows

Step

Average cost by carrier and zone

Step 1

Result

Shipping Cost Averages

15 rows

Schedule

Runs when you say

Proposed

File
ShipStation shipments
CSV export · 20 rows
Step
Average cost by carrier and zone
Step 1
Result
Shipping Cost Averages
15 rows
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 15 rows came out.

Download ShipStation shipments sample (20 rows)ShipStation: Shipments > All Shipments > Export

What you get back

The result of that run, the rows to look at first.

Shipping Cost AveragesSample data15 rows

Carrier	Service	Destination zone	Average shipping cost	Orders
UPS	Ground	2	8.52	2
USPS	Priority Mail	4	9.20	1
UPS	Ground	5	11.80	1
FedEx	2nd Day Air	6	18.93	2
UPS	Ground	3	9.05	1
DHL	Express	8	43.50	2
FedEx	Ground	4	11.25	1
DHL	Express	7	26.40	1
FedEx	Ground	3	10.15	1
USPS	First Class	2	6.23	2
USPS	Priority Mail	5	10.10	1
FedEx	Ground	2	8.95	1

15 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you calculate average shipping cost per order by carrier, service, and destination zone?

Export your ShipStation shipments as a spreadsheet file, then upload it to Mammoth. The workflow groups the rows by carrier, service, and destination zone, then calculates the average shipping cost per order for each group. You get a table of average shipping cost by carrier, service, and zone.

How it works

How to use the Shipping Cost Averages workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Shipping Cost Averages: questions

Which export should you use?

Use an export of your shipment rows from ShipStation. The file should include the fields for carrier, service, destination zone, and shipping cost.

What happens to rows that do not match a group?

Rows that do not have the needed fields, or do not fit the grouping rules, are left out of the grouped result.

How do you change the rules?

You can change the grouping fields and the calculation in words. For example, you can ask to group by a different field, or to sum costs instead of averaging them.