A per-tab list of every column SyncRange can export, with a short description of what each one contains. Use this page when picking columns in the export builder, or when you need to know exactly what a value represents in BigQuery or Google Sheets.
Each tab below notes whether it uses the export date range or always exports a full current snapshot when that applies.
For configuration steps see Configuring ShipStation exports.
Shipments ready to label or already processed Date range: uses the selected export date range.
| Column | Description |
|---|---|
| Shipment ID | Shipment ID from the source platform. |
| External Shipment ID | External Shipment ID from the source platform. |
| Shipment Number | Shipment Number. |
| Shipment Status | Shipment Status. |
| Carrier ID | Carrier ID from the source platform. |
| Service Code | Service Code. |
| Requested Shipment Service | Requested Shipment Service. |
| Package Code | Package Code. |
| Confirmation | Confirmation. |
| Ship Date | Ship Date. |
| Created At | Created At. |
| Modified At | Modified At. |
| Warehouse ID | Warehouse ID from the source platform. |
| Is Return | Boolean: Is Return. |
| Store ID | Store ID from the source platform. |
| Order Source Code | Order Source Code. |
| Insurance Provider | Insurance Provider. |
| Tags | Tags. |
| Items | Items. |
| Packages | Packages. |
| Options | Options. |
| Advanced Options | Advanced Options. |
| Customs | Customs. |
| Tax Identifiers | Tax Identifiers. |
| Amount Paid | Amount Paid in the row currency unless noted otherwise. |
| Amount Paid Currency | Amount Paid Currency (ISO 4217 when applicable). |
| Amount Paid Amount | Amount Paid Amount in the row currency unless noted otherwise. |
| Amount Paid Currency Code | Amount Paid Currency Code (ISO 4217 when applicable). |
| Shipping Paid | Shipping Paid in the row currency unless noted otherwise. |
| Shipping Paid Currency | Shipping Paid Currency (ISO 4217 when applicable). |
| Tax Paid | Tax Paid in the row currency unless noted otherwise. |
| Tax Paid Currency | Tax Paid Currency (ISO 4217 when applicable). |
| Insurance Amount | Insurance Amount in the row currency unless noted otherwise. |
| Insurance Currency | Insurance Currency (ISO 4217 when applicable). |
| External Order ID | External Order ID from the source platform. |
| Ship By Date | Ship By Date. |
| Ship Datetime | Ship Datetime. |
| Hold Until Date | Hold Until Date. |
| Deliver By Date | Deliver By Date. |
| Zone | Zone. |
| Assigned User | Assigned User. |
| Is Gift | Boolean: Is Gift. |
| Notes From Buyer | Notes From Buyer. |
| Notes To Buyer | Notes To Buyer. |
| Notes For Gift | Notes For Gift. |
| Internal Notes | Internal Notes. |
| Ship To Name | Ship To Name. |
| Ship To Phone | Ship To Phone. |
| Ship To Email | Ship To Email. |
| Ship To Company | Ship To Company. |
| Ship To Address Line 1 | Ship To Address Line 1. |
| Ship To Address Line 2 | Ship To Address Line 2. |
| Ship To Address Line 3 | Ship To Address Line 3. |
| Ship To City | Ship To City. |
| Ship To State/Province | Ship To State/Province. |
| Ship To Postal Code | Ship To Postal Code. |
| Ship To Country Code | Ship To Country Code. |
| Ship To Residential Indicator | Ship To Residential Indicator. |
| Ship From Name | Ship From Name. |
| Ship From Phone | Ship From Phone. |
| Ship From Email | Ship From Email. |
| Ship From Company | Ship From Company. |
| Ship From Address Line 1 | Ship From Address Line 1. |
| Ship From Address Line 2 | Ship From Address Line 2. |
| Ship From Address Line 3 | Ship From Address Line 3. |
| Ship From City | Ship From City. |
| Ship From State/Province | Ship From State/Province. |
| Ship From Postal Code | Ship From Postal Code. |
| Ship From Country Code | Ship From Country Code. |
| Ship From Residential Indicator | Ship From Residential Indicator. |
| Return To Name | Return To Name. |
| Return To Phone | Return To Phone. |
| Return To Email | Return To Email. |
| Return To Company | Return To Company. |
| Return To Address Line 1 | Return To Address Line 1. |
| Return To Address Line 2 | Return To Address Line 2. |
| Return To Address Line 3 | Return To Address Line 3. |
| Return To City | Return To City. |
| Return To State/Province | Return To State/Province. |
| Return To Postal Code | Return To Postal Code. |
| Return To Country Code | Return To Country Code. |
| Return To Residential Indicator | Return To Residential Indicator. |
| Weight Value | Weight Value in the row currency unless noted otherwise. |
| Weight Unit | Weight Unit. |
| Total Weight Value | Total Weight Value in the row currency unless noted otherwise. |
| Total Weight Unit | Total Weight Unit in the row currency unless noted otherwise. |
| Dimensions Unit | Dimensions Unit. |
| Length | Length. |
| Width | Width. |
| Height | Height. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Shipping labels and tracking details Date range: uses the selected export date range.
| Column | Description |
|---|---|
| Label ID | Label ID from the source platform. |
| Status | Status. |
| Shipment ID | Shipment ID from the source platform. |
| External Shipment ID | External Shipment ID from the source platform. |
| Ship Date | Ship Date. |
| Created At | Created At. |
| Tracking Number | Tracking Number. |
| Tracking Status | Tracking Status. |
| Tracking URL | Tracking URL. |
| Is Return Label | Boolean: Is Return Label. |
| RMA Number | RMA Number. |
| Is International | Boolean: Is International. |
| Batch ID | Batch ID from the source platform. |
| Carrier ID | Carrier ID from the source platform. |
| Carrier Code | Carrier Code. |
| Service Code | Service Code. |
| Package Code | Package Code. |
| Charge Event | Charge Event. |
| Voided | Voided. |
| Voided At | Voided At. |
| Label Format | Label Format. |
| Label Layout | Label Layout. |
| Display Scheme | Display Scheme. |
| Trackable | Trackable. |
| Label Image ID | Label Image ID from the source platform. |
| Label Download URL | Label Download URL. |
| Label PDF URL | Label PDF URL. |
| Label PNG URL | Label PNG URL. |
| Label ZPL URL | Label ZPL URL. |
| Form Download URL | Form Download URL. |
| Packages | Packages. |
| Rate Details | Rate Details. |
| Alternative Identifiers | Alternative Identifiers. |
| Shipment Cost Amount | Shipment Cost Amount in the row currency unless noted otherwise. |
| Shipment Cost Currency | Shipment Cost Currency (ISO 4217 when applicable). |
| Insurance Cost Amount | Insurance Cost Amount in the row currency unless noted otherwise. |
| Insurance Cost Currency | Insurance Cost Currency (ISO 4217 when applicable). |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Marketplace fulfillment notifications Date range: uses the selected export date range.
| Column | Description |
|---|---|
| Fulfillment ID | Fulfillment ID from the source platform. |
| Shipment ID | Shipment ID from the source platform. |
| External Shipment ID | External Shipment ID from the source platform. |
| Tracking Number | Tracking Number. |
| Carrier Code | Carrier Code. |
| Ship Date | Ship Date. |
| Created At | Created At. |
| Fulfillment Status | Fulfillment Status. |
| Items | Items. |
| Ship To Name | Ship To Name. |
| Ship To Phone | Ship To Phone. |
| Ship To Email | Ship To Email. |
| Ship To Company | Ship To Company. |
| Ship To Address Line 1 | Ship To Address Line 1. |
| Ship To Address Line 2 | Ship To Address Line 2. |
| Ship To Address Line 3 | Ship To Address Line 3. |
| Ship To City | Ship To City. |
| Ship To State/Province | Ship To State/Province. |
| Ship To Postal Code | Ship To Postal Code. |
| Ship To Country Code | Ship To Country Code. |
| Ship To Residential Indicator | Ship To Residential Indicator. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Product catalog items Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Product ID | Product ID from the source platform. |
| SKU | SKU. |
| Name | Name. |
| Price | Price in the row currency unless noted otherwise. |
| Price Amount | Price Amount in the row currency unless noted otherwise. |
| Price Currency | Price Currency (ISO 4217 when applicable). |
| Active | Active. |
| Created At | Created At. |
| Modified At | Modified At. |
| UPC | UPC. |
| ISBN | ISBN. |
| ASIN | ASIN. |
| Brand | Brand. |
| Product Type | Product Type. |
| Product Category | Product Category. |
| Description | Description. |
| Fulfillment SKU | Fulfillment SKU. |
| Thumbnail URL | Thumbnail URL. |
| Warehouse Location | Warehouse Location. |
| Image URLs | Image URLs. |
| Customs | Customs. |
| Customs Description | Customs Description. |
| Customs Value | Customs Value in the row currency unless noted otherwise. |
| Customs Tariff No | Customs Tariff No. |
| Customs Country Code | Customs Country Code. |
| Weight Value | Weight Value in the row currency unless noted otherwise. |
| Weight Unit | Weight Unit. |
| Dimensions Unit | Dimensions Unit. |
| Length | Length. |
| Width | Width. |
| Height | Height. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
SKU inventory stock levels Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| SKU | SKU. |
| On Hand | On Hand. |
| Allocated | Allocated. |
| Available | Available. |
| Inventory Warehouse ID | Inventory Warehouse ID from the source platform. |
| Inventory Location ID | Inventory Location ID from the source platform. |
| Updated At | Updated At. |
| Stock Details | Stock Details. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Inventory warehouses used for stock tracking Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Inventory Warehouse ID | Inventory Warehouse ID from the source platform. |
| Name | Name. |
| Created At | Created At. |
| Updated At | Updated At. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Locations within inventory warehouses Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Inventory Location ID | Inventory Location ID from the source platform. |
| Inventory Warehouse ID | Inventory Warehouse ID from the source platform. |
| Name | Name. |
| Barcode | Barcode. |
| Created At | Created At. |
| Updated At | Updated At. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Shipping warehouses / ship-from locations Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Warehouse ID | Warehouse ID from the source platform. |
| Name | Name. |
| Created At | Created At. |
| Is Default | Boolean: Is Default. |
| Origin Name | Origin Name. |
| Origin Phone | Origin Phone. |
| Origin Email | Origin Email. |
| Origin Company | Origin Company. |
| Origin Address Line 1 | Origin Address Line 1. |
| Origin Address Line 2 | Origin Address Line 2. |
| Origin Address Line 3 | Origin Address Line 3. |
| Origin City | Origin City. |
| Origin State/Province | Origin State/Province. |
| Origin Postal Code | Origin Postal Code. |
| Origin Country Code | Origin Country Code. |
| Origin Residential Indicator | Origin Residential Indicator. |
| Return Name | Return Name. |
| Return Phone | Return Phone. |
| Return Email | Return Email. |
| Return Company | Return Company. |
| Return Address Line 1 | Return Address Line 1. |
| Return Address Line 2 | Return Address Line 2. |
| Return Address Line 3 | Return Address Line 3. |
| Return City | Return City. |
| Return State/Province | Return State/Province. |
| Return Postal Code | Return Postal Code. |
| Return Country Code | Return Country Code. |
| Return Residential Indicator | Return Residential Indicator. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Connected carrier accounts Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Carrier ID | Carrier ID from the source platform. |
| Carrier Code | Carrier Code. |
| Account Number | Account Number. |
| Name | Name. |
| Nickname | Nickname. |
| Friendly Name | Friendly Name. |
| Primary | Primary. |
| Supports Multi-Package | Supports Multi-Package. |
| Supports Label Messages | Supports Label Messages. |
| Supports User Managed Rates | Supports User Managed Rates. |
| Send Rates | Send Rates. |
| Services | Services. |
| Packages | Packages. |
| Options | Options. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Label batches Date range: uses the selected export date range.
| Column | Description |
|---|---|
| Batch ID | Batch ID from the source platform. |
| External Batch ID | External Batch ID from the source platform. |
| Status | Status. |
| Created At | Created At. |
| Processed At | Processed At. |
| Errors | Errors. |
| Warnings | Warnings. |
| Label Count | Label Count. |
| Completed | Completed. |
| Forms | Forms. |
| Batch Notes | Batch Notes. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
End-of-day manifests Date range: uses the selected export date range.
| Column | Description |
|---|---|
| Manifest ID | Manifest ID from the source platform. |
| Form ID | Form ID from the source platform. |
| Created At | Created At. |
| Ship Date | Ship Date. |
| Shipments | Shipments. |
| Label IDs | Label IDs. |
| Warehouse ID | Warehouse ID from the source platform. |
| Submission ID | Submission ID from the source platform. |
| Carrier ID | Carrier ID from the source platform. |
| Manifest Download URL | Manifest Download URL. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Scheduled carrier pickups Date range: uses the selected export date range.
| Column | Description |
|---|---|
| Pickup ID | Pickup ID from the source platform. |
| Label IDs | Label IDs. |
| Created At | Created At. |
| Cancelled At | Cancelled At. |
| Carrier ID | Carrier ID from the source platform. |
| Warehouse ID | Warehouse ID from the source platform. |
| Confirmation Number | Confirmation Number. |
| Contact Details | Contact Details. |
| Pickup Window | Pickup Window. |
| Pickup Address | Pickup Address. |
| Notes | Notes. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Custom package types Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Package ID | Package ID from the source platform. |
| Package Code | Package Code. |
| Name | Name. |
| Dimensions Unit | Dimensions Unit. |
| Length | Length. |
| Width | Width. |
| Height | Height. |
| Description | Description. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Purchase orders Date range: uses the selected export date range.
| Column | Description |
|---|---|
| Purchase Order ID | Purchase Order ID from the source platform. |
| PO Number | PO Number. |
| Status | Status. |
| Created At | Created At. |
| Modified At | Modified At. |
| Expected Date | Expected Date. |
| Supplier ID | Supplier ID from the source platform. |
| Warehouse ID | Warehouse ID from the source platform. |
| Items | Items. |
| Notes | Notes. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Suppliers for purchase orders Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Supplier ID | Supplier ID from the source platform. |
| Name | Name. |
| Email. | |
| Phone | Phone. |
| Created At | Created At. |
| Address | Address. |
| Notes | Notes. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Warehouse totes Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Tote ID | Tote ID from the source platform. |
| Name | Name. |
| Barcode | Barcode. |
| Status | Status. |
| Created At | Created At. |
| Updated At | Updated At. |
| Warehouse ID | Warehouse ID from the source platform. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
ShipStation account users Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| User ID | User ID from the source platform. |
| Name | Name. |
| Username | Username. |
| Email. | |
| Status | Status. |
| Role | Role. |
| Last Login At | Last Login At. |
| Created At | Created At. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Configured rate shoppers Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Rate Shopper ID | Rate Shopper ID from the source platform. |
| Name | Name. |
| Is Active | Boolean: Is Active. |
| Service Preference | Service Preference. |
| Services | Services. |
| Transit Time | Transit Time. |
| Created At | Created At. |
| Updated At | Updated At. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Configured environment webhooks Full export each run: current snapshot; the date range does not apply.
| Column | Description |
|---|---|
| Webhook ID | Webhook ID from the source platform. |
| URL | URL. |
| Event | Event. |
| Name | Name. |
| Active | Boolean: Active. |
| Store ID | Store ID from the source platform. |
| Headers | Headers. |
| Created At | Created At. |
| Date Exported | Timestamp this row was written by SyncRange (your account timezone). |
Something missing on this page? Email [email protected]
Install on Shopify