Starshipit

Total unshipped order items

SQL query for Starshipit

Get the total number of unshipped order items.

SELECT COUNT(*) FROM unshipped_orderitems

Starshipit data model

Starshipit
Table Unshipped Orders
Dtp: Boolean
Plt: Boolean
Type: String
Items: String
Status: String
Carrier: String
Archived: Boolean
Currency: String
Order_id: Integer
Packages: String
Platform: String
Metadatas: String
Reference: String
Order_date: Date-time
Carrier_name: String
Order_number: String
Add_insurance: Boolean
Create_return: Boolean
Declared_value: Number
Dangerous_goods: Boolean
Insurance_value: Number
Manifest_number: Integer
Destination_city: String
Destination_name: String
Destination_email: String
Destination_phone: String
Destination_state: String
Address_validation: String
Destination_street: String
Destination_suburb: String
Signature_required: Boolean
Destination_company: String
Destination_country: String
Carrier_service_code: String
Destination_building: String
Sender_details_email: String
Sender_details_phone: String
Destination_post_code: String
Sender_details_company: String
Sender_details_country: String
Destination_delivery_instructions: String

Starshipit
Table Unshipped Orderitems
Value: Number
Width: Number
Height: Number
Length: Number
Weight: Number
Item_id: Integer
Order_id: Integer
Quantity: Integer
Description: String
Tariff_code: String
Stock_on_hand: Integer
Quantity_to_ship: Integer
Country_of_origin: String

Starshipit
Table Unshipped Orderpackages
Name: String
Width: Number
Height: Number
Length: Number
Weight: Number
Order_id: Integer
Package_id: Integer
Packaging_type: String
Tracking_number: String

Starshipit
Table Shipped Orders

Starshipit
Table Shipped Orderitems

Starshipit
Table Shipped Orderpackages

Use SQL on all your SaaS data

Magical SQL for Starshipit with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool such as Microsoft Power BI, Tableau or Metabase.

Peliqan Ask AI willl write your SQL queries from plain English

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.