Shopify to Total Sales Routine

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

Total Sales Fields	Shopify Fields

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
Email	customer.email
Total Sales	current_total_price
Shipping Cost	total_shipping_price_set.shop_money.amount
Shipping Service	shipping_lines.title

Ad Magic