Order Object Reference

Overview

Property Value
API Name Order
Label Order
Plural Label Orders
Type Standard Object

Fields

Field Label API Name Type Required Description
Abandoned s_c__Abandoned__c Checkbox No The Abandoned__c field is set to true by StoreConnect if the order has a Checkout_Step__c of 'customer', 'shipping', 'terms_and_conditions', 'payment', 'failed' and 10 hours have passed since it was set.
Order Assisted by User s_c__Assisted_By_User_Id__c Lookup (User) No If the shopper selects a user from the "Were you assisted to make this purchase?" drop down during the last stage of checkout, then this field will be populated by the related User ID
Browser s_c__Browser__c Text(255) No Shows the browser used by the customer.
Cart Reference s_c__Cart_Reference__c TextArea No Used to link a web store Checkout session to its resulting Order.
Checkout Email s_c__Checkout_Email__c Email No Email added by the user at the point of checkout. In order transactional emails, this email is used. If empty, contact email is used
Checkout Phone s_c__Checkout_Phone__c Phone No Phone added by the user at the point of checkout
Checkout Shipping Email s_c__Checkout_Shipping_Email__c Email No Shipping Email (of recipient) added by user at the point of checkout. Sometimes this is different from ShipToContact's email.
Checkout Shipping Phone s_c__Checkout_Shipping_Phone__c Phone No Phone number (of recipient) added by user at the point of checkout. Sometimes this is different from ShipToContact's phone.
Checkout Step s_c__Checkout_Step__c Text(255) No The Checkout_Step__c field shows the step at which the checkout is up to. Valid values for this field are 'open', 'customer', 'shipping', 'terms_and_conditions', 'payment', 'complete', 'quotation_requested' and 'failed'. Each stage represents the step the order is up to, so a order in state 'payment' means the customer is at (but not complete) on the payment step of the checkout process.
Collection Point s_c__Collection_Point_Id__c Lookup (s_c__Collection_Point__c) No If the shopper picks up this order from a collection point, then that collection point will be referenced here.
Requested Collection Time s_c__Collection_Time__c DateTime No The time the customer requested to pickup the item during checkout
Contact Email s_c__Contact_Email__c Formula (Text) No This is a forumula field mirroring the BillToContact.Email field to be used in the Order Layout.
Contact s_c__Contact_Id__c Lookup (Contact) No The standard Contact object that this order belongs to.
Contact Mobile Phone s_c__Contact_Mobile_Phone__c Formula (Text) No This is a forumula field mirroring the BillToContact.MobilePhone field to be used in the Order Layout.
Contact Phone s_c__Contact_Phone__c Formula (Text) No This is a forumula field mirroring the BillToContact.Phone field to be used in the Order Layout.
Country s_c__Country__c Text(255) No Shows country of the customer.
Customer Notes s_c__Customer_Notes_Long__c LongTextArea(10000) No Holds any notes supplied by the customer during checkout on the payment page of the checkout process.
Device Type s_c__Device_Type__c Text(255) No Shows the device type used by the customer, eg Desktop/Mobile/Tablet.
Ip Address s_c__Ip_Address__c Text(255) No Shows the IP Address of the customer.
Language s_c__Language__c Text(255) No Shows the system language of the customer.
Location s_c__Location__c Location No Shows the latitude and longitude of the customer.
POS Order Type s_c__POS_Order_Type__c Text(255) No The type of this Order, for example Layby.
Payment Link s_c__Payment_Link__c Formula (Text) No Formula field providing a full link to the payment page for this Order.
Platform s_c__Platform__c Text(255) No Shows the computer platform of the customer, eg Mac/Windows.
Register Shift s_c__Register_Shift_Id__c Lookup (s_c__Register_Shift__c) No The Register Shift that created this order (if applicable).
Screen Resolution s_c__Screen_Resolution__c Text(255) No Shows the screen resolution of the computer used by the customer.
Send Confirmation Emails s_c__Send_Confirmation__c Checkbox No If true, send emails to the contact about this order as defined in the Store__c.Transactional_Emails association.
Send POS Receipt Email s_c__Send_POS_Email__c Checkbox No If true, send a POS receipt email to the checkout email address as defined in the Store__c.Transactional_Emails association.
Shipping Method Selected at Checkout s_c__Shipping_Method__c Text(255) No The shipping method selected by the customer during checkout.
Shipping Notes s_c__Shipping_Notes__c LongTextArea(10000) No Holds any shipping notes supplied by the customer during checkout.
Store s_c__Store_Id__c Lookup (s_c__Store__c) No This represents the Store__c that this order was placed on. This also defines which set of Transactional Emails are sent to this order based on the Store__c.Transactional_Emails relationship.
Submitted Date s_c__Submitted_Date__c DateTime No Contains the date when the order is created. Defaults to date/time now. Can be updated in case it needs to be altered.
Original Subscription Order s_c__Subscription_Order_Id__c Lookup (Order) No The original Order that is the source of this Order. When a subscription is renewed, it creates a new order object, which is then related back to the original subscription via this field.
Test Order s_c__Test_Order__c Checkbox No A true value indicates that this order was placed as a Test Order. An order is a test order if the email address used during the order matches one of the test email address set via the test_checkout_email_addresses Store Variable. There should be a limited number of these.
Timezone s_c__Timezone__c Text(255) No Shows the timezone of the customer.
Total Earn Points Amount s_c__Total_Earn_Points_Amount__c Number(18,0) No The total number of points earned with this Order.
Total Points Amount s_c__Total_Points_Amount__c Number(18,0) No The total number of points used for purchasing this Order.
Total Taxes s_c__Total_Tax_Amount__c Currency(18,2) No The total taxes billed as part of this order, kept up to date as the order is changed.
User Agent s_c__User_Agent__c Text(255) No Shows the customer's browser user agent string.
StoreConnect External ID s_c__sC_Id__c Text(36) No StoreConnect External ID, do not modify in Salesforce

Relationships

Field Type Related Object Relationship Name
s_c__Assisted_By_User_Id__c Lookup User Assisted_Orders
s_c__Collection_Point_Id__c Lookup s_c__Collection_Point__c Collected_Orders
s_c__Contact_Id__c Lookup Contact Orders
s_c__Register_Shift_Id__c Lookup s_c__Register_Shift__c Orders
s_c__Store_Id__c Lookup s_c__Store__c Orders
s_c__Subscription_Order_Id__c Lookup Order Generated_Subscription_Orders