Each Shopify order line will generate one Total Sales record. If an order contains multiple lines, multiple Total Sales records will be created accordingly.
A GF Job Log entry is automatically generated as soon as an order is created in Shopify.
An Apex class, GF_OrderCreatedEvent, is exposed as a REST resource at the following URL:https://{instance}.salesforce.com/services/apexrest/OrderCreatedEvent
The Total Sales record is automatically created when the Shopify order is pushed to the GF Job Log table.
Once the Total Sales record is created, the Processed field in the job log will be checked.
You can also trigger the Create Total Sales routine manually by selecting the job log(s) you want to process and clicking the Create Total Sales button.
If a job log has already been processed, you will need to manually uncheck the Processed field in order to reprocess the log.
Shopify integration raw data is stored in the Job Log table with the Job Type set to "Shopify Order Import."
The Name field for these records follows this format:"Shopify - {store domain} - {store order number}"
You can configure the Shopify store and Salesforce account mapping under Custom Settings > Shopify Settings.
Name: Store Name
Customer Name: The corresponding Salesforce account name that the store is mapped to. The integration routine uses this field to search for the Salesforce account.
Store URL: The domain of the Shopify store.
Examples: http://doomlings.com
Example2: shop.facilitator.cards
Custom Setting - Shopify Setting
Total Sales Fields | Shopify Fields |
|---|---|
Account | Each of the Source should point to an Account in SF, using Custom Setting to setup |
Account Name | New text field. Save Customer Name to it |
Transaction Date | created_at |
Order Number | order_number |
Invoice Num | Shopify doc no |
Item | line_items.name |
Price | line_items.price |
Qty | line_items.quantity |
SKU | line_items.sku |
Source | order_status_url, to get the website's name? |
Taxes | total_tax |
First Name | customer.first_name |
Last Name | customer.last_name |
Phone Number | customer.phone |
Address 1 | shipping_address.address1 |
Address 2 | shipping_address.address2 |
City | shipping_address.City |
State/Provence | shipping_address.province |
Postal Code | shipping_address.zip |
Country Code | shipping_address.country_code |
Country | shipping_address.country |
customer.email | |
Total Sales | current_total_price |
Shipping Cost | total_shipping_price_set.shop_money.amount |
Shipping Service | shipping_lines.title |