DataConnector | ComponentOne
In This Topic
    GuestCarts
    In This Topic
    ColumnName DataType Description
    Id Int32 Cart/quote ID
    Created_at String Cart Creation Date And Time. Otherwise, Null
    Updated_at String Cart Last Update Date And Time. Otherwise, Null
    Converted_at String Cart Conversion Date And Time. Otherwise, Null
    Is_active Boolean Active Status Flag Value. Otherwise, Null
    Is_virtual Boolean Virtual Flag Value. Otherwise, Null
    Items String Array Of Items. Otherwise, Null
    Items_qty Double Total Quantity Of All Cart Items. Otherwise, Null
    Is_salable String Information About Product Saleability (In Stock)
    Customer_id Int32 Customer Info
    Customer_group_id Int32 Customer Info
    Customer_default_billing String Customer Info
    Customer_default_shipping String Customer Info
    Customer_confirmation String Customer Info
    Customer_created_at String Customer Info
    Customer_updated_at String Customer Info
    Customer_created_in String Customer Info
    Customer_dob String Customer Info
    Customer_email String Customer Info
    Customer_firstname String Customer Info
    Customer_lastname String Customer Info
    Customer_middlename String Customer Info
    Customer_fix String Customer Info
    StCustomer_suffixring String Customer Info
    Customer_gender String Customer Info
    Customer_store_id String Customer Info
    Customer_website_id Int32 Customer Info
    Customer_addresses String Customer Info
    Customer_disable_auto_group_change Int32 Customer Info
    Customer_custom_attributes String Customer Info
    Billing_address String Billing Address Info
    Billing_address_id Int32 Billing Address Info
    Billing_address_region String Billing Address Info
    Billing_address_region_id Int32 Billing Address Info
    Billing_address_region_code String Billing Address Info
    Billing_address_country_id String Billing Address Info
    Billing_address_street String Billing Address Info
    Billing_address_company String Billing Address Info
    Billing_address_telephone String Billing Address Info
    Billing_address_fax String Billing Address Info
    Billing_address_postcode String Billing Address Info
    Billing_address_city String Billing Address Info
    Billing_address_firstname String Billing Address Info
    Billing_address_lastname String Billing Address Info
    Billing_address_middlename String Billing Address Info
    Billing_address_prefix String Billing Address Info
    Billing_address_suffix String Billing Address Info
    Billing_address_vat_id String Billing Address Info
    Billing_address_customer_id Int32 Billing Address Info
    Billing_address_email String Billing Address Info
    Billing_address_same_as_billing Int32 Billing Address Info
    Billing_address_customer_address_id Int32 Billing Address Info
    Billing_address_save_in_address_book Int32 Billing Address Info
    Billing_address_custom_attributes String Billing Address Info
    Reserved_order_id String Reserved Order ID. Otherwise, Null
    Orig_order_id Int32 Reserved Order ID. Otherwise, Null
    Currency_global_currency_code String Currency Info
    Currency_base_currency_code String Currency Info
    Currency_store_currency_code String Currency Info
    Currency_quote_currency_code String Currency Info
    Currency_store_to_base_rate Double Currency Info
    Currency_store_to_quote_rate Double Currency Info
    Currency_base_to_global_rate Double Currency Info
    Currency_base_to_quote_rate Double Currency Info
    Customer_is_guest Boolean For Guest Customers, False For Logged In Customers
    Customer_note String Notice Text
    Customer_note_notify Boolean Customer Notification Flag
    Customer_tax_class_id Int32 Customer Tax Class ID
    Store_id Int32 Store Identifier
    Extension_attributes String Extension Attributes
    CartId String Cart Id