Integrating Shipstation's order management and shipping software with Daasity gives merchants additional shipping and fulfillment analytics
Key Topics
Dashboard Description
ShipStation is an order management and shipping software company that is designed to help retailers become more efficient at processing, fulfilling and shipping their e-commerce orders. The Shipstation integration allows merchants to pull shipment cost into the Daasity order data models to calculate gross margin with shipment cost deducted. The integration also allows merchants to analyze pending orders aging to help with supply chain management. Finally, this integration provides merchants with a holistic view of existing shipping carriers distributions, and allows for comparison of shipping speed efficiency and shipping cost efficiency.
Proper analysis of the Shipstation dashboard can help answer the following questions:
- Are there any specific products or specific regions with a large number of outstanding shipments?
- How long after a customer places their order is that order shipping? Long times between order and ship dates can signal an issue with fulfillment.
- Are any shipping carriers showing longer than expected transit times? This information can help you optimize your delivery times by routing shipments to specific carriers.
WARNING:
The Shipstation integration / transform code will ONLY work if the order_key in Shipstation is set to the same value as the order_id from Shopify. If these two fields do not match then the transform code will not be able to join the orders from Shipstation with the orders from Shopify which will result in the Shipstation dashboard being blank.
The Shipstation Dashboard contains the following sections:
- Order Counts
- Product Shipping Details
- Zip Code Details
- Shipping Efficiency
- Shipping Carriers Comparison
Orders Counts: top level summary of shipments (Looks: Count of Orders Shipped; Count of Orders Outstanding).
Products Shipping Details: integrates Shipstation data with products data from the BSD that summarizes product shipments details (Looks: Top 10 Products Shipped; Top 10 Product Outstanding).
Zip Code Details: Helps merchants understand which areas receive the most shipments and if there are specific geographies that consistently have outstanding shipments (Looks: Top 10 Zip Codes Shipped to; Map of Outstanding Shipments).
Shipping Efficiency: Provides an overall understanding of pending orders aging info (Looks: Average Days Between Order Paid and Order Shipped; Top 10 Slowest Order to Shipment SKUs).
Shipping Carriers Comparison: allows merchants to compare and evaluate rationality of carrier distribution by looking at shipping speed and cost (Looks: Count of Shipments by Shipping Carriers; Average Days in Transit by Shipping Carriers).
Requirements
The Shipstation Dashboard requires that you have the Shipstation integration installed in Daasity. Also note that your order_key in Shipstation must be set to the same value as the order_id from Shopify. If it is not then the dashboard will be blank.
Reports
# of Orders Shipped
# of Orders Outstanding
Shipment: Top 10 Products
Outstanding Shipments: Top 10 Products
Top 10 Zip Codes Shipped To
Map of Outstanding Shipments
Avg Days Between Order Paid and Order Shipped
Top 10 Slowest Order to Shipment SKUs
Shipments by Shipping Carrier
Avg Days in Transit by Shipping Carriers