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