# ShipStation Data Connector User Guide

> **Note:** ShipStation is a powerful e-commerce shipping solution that helps businesses streamline their order fulfillment process. This guide will walk you through how to connect ShipStation to Power My Analytics, create reports, and leverage key metrics to gain insights into your shipping operations. By integrating ShipStation data, you can track important KPIs like order volume, shipping costs, and carrier performance to optimize your e-commerce logistics.

## Prerequisites

Before connecting ShipStation to Power My Analytics, ensure you have:

- API key and API secret for your ShipStation account
- Account owner status, or if not an account owner, your account must have either **Administration** or **Configuration** access (it is not necessary to have both)

To obtain your API key and API secret, follow the instructions in [How to Connect to ShipStation](https://knowledge.powermyanalytics.com/application/sources/how-to-connect-to-shipstation/).

## Adding ShipStation as a Data Source

1. Log in to your Power My Analytics hub.
2. Go to **Sources** in the main menu.
3. Click **\+ New Data Source**.
4. Select ShipStation from the list of available sources.
5. Enter your ShipStation API Key and API Secret.
6. Click **Connect** to authenticate.

## Creating a Data Studio Report

Follow these steps to create a Data Studio report using your ShipStation data:

1. In your Power My Analytics hub, go to **Reports > Data Studio**
2. Select ShipStation under Create Data Studio Report (this will open the official Data Studio application in a new window)
3. Google Data Studio Configuration:

    - Step 1:

        - Name your data source (e.g., "ShipStation - Your Company Name")
        - Choose your Power My Analytics hub from the dropdown
        - Optional: Leave "Use report template for new reports" checked to use PMA's demo template
        - Click **Next**

    - Step 2:

        - User Account: Select your ShipStation account for real data or "Sample Account" for demo data
        - Click **Next**

    - Step 3:

        - Choose "Optional - Order Status Filter" for your reports
        - Optional: Allow "Optional - Order Status Filter" modification in reports
        - Click **Connect** in the top right

    - Step 4:

        - Click **Create Report** in the top right

For a quick start, use our pre-built [ShipStation demo template](https://lookerstudio.google.com/reporting/0e1d4813-1205-43d4-b988-fd99428bb1e4/page/p_nny7g6zkxc).

## Key Reports and Fields

Here are some popular metrics you can use in your ShipStation reports:

- Key Performance Metrics: New Orders, Orders Shipped, Orders Unshipped
- Carrier Metrics: Items by Carrier Code
- Store Metrics: Revenue by Store Name
- Order Metrics: Percentage of open orders by Age of Order
- Shipping Metrics: Shipping Cost by Shipment ID, Order ID, Store Name, Order Number, Create Date, Ship Date, Ship City, Ship State, Ship Postal Code, Country, Carrier, Tracking Number
- Item Metrics: Order ID, Item ID, Product ID, Image, SKU, Store Name, Unit Price, Item Shipping, Item Tax

For a complete list of available ShipStation fields, refer to the [Schema Explorer](https://hub.powermyanalytics.com/resources/schema/shipstation).

## Limitations and Important Considerations

- **Cached Data Requests with Unique Metrics and Date Dimension:** When a unique metric is paired with the date dimension, this will result in a request for cached data instead of a request for live data. For more information, please see [Understanding Cached and Live Data Requests](https://knowledge.powermyanalytics.com/support/faq/understanding-cached-and-live-data-requests/#a-special-case-unique-metrics-paired-with-the-date-dimension).
- Backfilling: 24 months of historical data will be backfilled when you first connect your ShipStation account as a data source.

### Unavailable Data

- Realtime data
- Custom fields

## Troubleshooting

See our article [Basic Troubleshooting](https://knowledge.powermyanalytics.com/application/troubleshooting/basic-troubleshooting/) for information on issues that may affect the ShipStation connector.
