Table Abandoned Checkouts

Id: Integer
Name: String
Note: String
Email: String
Phone: String
Token: String
Source: String
Gateway: String
User_id: Integer
Currency: String
Customer: Object
Closed_at: Date-time
Device_id: Integer
Tax_lines: Array
Total_tax: Singer.decimal
Cart_token: String
Created_at: Date-time
Line_items: Array
Source_url: String
Updated_at: Date-time
Location_id: Integer
Source_name: String
Total_price: Singer.decimal
_sdc_shop_id: Integer
Completed_at: Date-time
Landing_site: String
Total_duties: Singer.decimal
Total_weight: Integer
_sdc_shop_name: String
Discount_codes: Array
Referring_site: String
Shipping_lines: Array
Subtotal_price: Singer.decimal
Taxes_included: Boolean
Billing_address: Object
Customer_locale: String
Note_attributes: Array
Total_discounts: Singer.decimal
Shipping_address: Object
Source_identifier: String
Sms_marketing_phone: String
Presentment_currency: String
Abandoned_checkout_url: String
Total_line_items_price: Singer.decimal
Buyer_accepts_marketing: Boolean
_sdc_shop_myshopify_domain: String
Buyer_accepts_sms_marketing: Boolean

Table Collects

Id: Integer
Position: Integer
Created_at: Date-time
Product_id: Integer
Sort_value: String
Updated_at: Date-time
_sdc_shop_id: Integer
Collection_id: Integer
_sdc_shop_name: String
_sdc_shop_myshopify_domain: String

Table Custom Collections

Id: Integer
Image: Object
Title: String
Handle: String
Body_html: String
Sort_order: String
Updated_at: String
_sdc_shop_id: Integer
Published_at: String
_sdc_shop_name: String
Published_scope: String
Template_suffix: String
Admin_graphql_api_id: String
_sdc_shop_myshopify_domain: String

Table Inventory Items

Id: Integer
Sku: String
Cost: Singer.decimal
Tracked: Boolean
Created_at: Date-time
Updated_at: Date-time
_sdc_shop_id: Integer
_sdc_shop_name: String
Requires_shipping: Boolean
Admin_graphql_api_id: String
Country_code_of_origin: String
Harmonized_system_code: Integer
Province_code_of_origin: String
_sdc_shop_myshopify_domain: String
Country_harmonized_system_codes: Array

Table Inventory Levels

Available: Integer
Updated_at: Date-time
Location_id: Integer
_sdc_shop_id: Integer
_sdc_shop_name: String
Inventory_item_id: Integer
Admin_graphql_api_id: String
_sdc_shop_myshopify_domain: String

Table Locations

Id: Integer
Zip: String
City: String
Name: String
Phone: String
Active: Boolean
Legacy: Boolean
Country: String
Address1: String
Address2: String
Province: String
Created_at: Date-time
Updated_at: Date-time
_sdc_shop_id: Integer
Country_code: String
Country_name: String
Province_code: String
_sdc_shop_name: String
Admin_graphql_api_id: String
Localized_country_name: String
Localized_province_name: String
_sdc_shop_myshopify_domain: String

Table Metafields

Id: Integer
Key: String
Type: String
Value: Integer
Owner_id: Integer
Namespace: String
Created_at: Date-time
Updated_at: Date-time
Value_type: String
Description: String
_sdc_shop_id: Integer
_sdc_shop_name: String
Owner_resource: String
Admin_graphql_api_id: String
_sdc_shop_myshopify_domain: String

Table Products

Id: Integer
Tags: String
Image: Object
Title: String
Handle: String
Images: Array
Status: String
Vendor: String
Options: Array
Variants: Array
Body_html: String
Created_at: Date-time
Updated_at: Date-time
_sdc_shop_id: Integer
Product_type: String
Published_at: Date-time
_sdc_shop_name: String
Published_scope: String
Template_suffix: String
Admin_graphql_api_id: String
_sdc_shop_myshopify_domain: String

Table Transactions

Id: Integer
Kind: String
Test: Boolean
Amount: Singer.decimal
Status: String
Gateway: String
Message: String
Receipt: Object
User_id: Integer
Currency: String
Order_id: Integer
Device_id: Integer
Parent_id: Integer
Created_at: String
Error_code: String
Location_id: Integer
Source_name: String
_sdc_shop_id: Integer
Processed_at: String
Authorization: String
_sdc_shop_name: String
Payment_details: Object
Admin_graphql_api_id: String
_sdc_shop_myshopify_domain: String
Payments_refund_attributes: Object