Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 11 Next »

  • The Shopify order line will create one total sales record. Multiple total sales records will be created if an order has multiple order lines.

  • GF Job Log will be automatically created once the order is created on Shopify.

    • An Apex class GF_OrderCreatedEvent is exposed as a REST resource, and maps to the URLhttps://{instance}.salesforce.com/services/apexrest//OrderCreatedEvent

  • The Total Sales record will be automatically created when the Shopify order is pushed to the GF Job Log table.

  • Once the Total Sales record is created for the job log, the Processed field will be checked.

  • The Create Total Sales routine can also be triggered by selecting the job log(s) you want to process and then clicking the Create Total Sales button.

  • If a job log is already processed, you need to manually uncheck the Processed field, in order to re-process the log.

  • Shopify integration raw data will be stored in the Job Log table with the Job Type Shopify Order Import

  • Name field format: "Shopify - {store domain} - {store order number}"

  • Shopify store and SF account mapping setup, under Custom Setting - Shopify Setting

    • Name - Store Name

    • Customer Name → SF account name that the store is mapped to. The integration routine will use this name field to search for an SF account.

    • Store URL → domain of the Shopify store

Example2: shop.facilitator.cards

Custom Setting - Shopify Setting

Shopify / Total Sales Fields Mapping

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

  • No labels