Fields Mapping

The following tables provide information about the mapping of fields between Shopify and AccountEdge Pro.

Items

Shopify AccountEdge Pro
Title Item Name
Description (Body-HTML) Web Store Item Description
Variant SKU Item Number
Price Web Store Price
Tags Tags
Title/Page Title Item Name
Description/Meta Description Web Store/Item Description
Variant Grams Weight (lbs converted to grams)
Published I sell this item on my web store
Variant Taxable I collect sales tax when I sell this item
Images Up to 3

Customers

  Shopify AccountEdge Pro
AED Company Card Type Company Co./Last Name
First Name/Last Name Addr 1 - Contact Name
AED Individual Card Type First Name First Name
Last Name Last Name/Company
Email Email Addr 1 - Email
Billing Address First Name First Name+Last Name/Company or Addr 1 - Contact Name
Last Name
Company Co./Last Name
Address1 Addr 1 - Line 1
Address2 Addr 1 - Line 2
City Addr 1 - City
Province/ST
Province Code Addr 1 - State
Country Addr 1 - Country
Country Code
Zip Addr 1 - ZIP Code
Phone Addr 1 - Phone # 1
Shipping Address First Name Addr 2 - Contact Name
Last Name
Company Addr 2 - Line 1
Shipping Address 1 Addr 2 - Line 2
Shipping Address 2 Addr 2 - Line 3
Shipping City Addr 2 - City
Shipping Province/ST
Shipping Province Code Addr 2 - State
Shipping Country Addr 2 - Country
Shipping Country Code
Shipping Zip Addr 2 - ZIP Code
Shipping Phone Addr 2 - Phone # 1

Orders

Shopify AccountEdge Pro
Name Part of Journal Member + Web Order #
Email
Financial Status
Paid at
Fulfillment Status
Fulfilled at
Accepts Marketing
Currency
Subtotal Note 1
Shipping Freight Amount
Taxes Tax Amount
Total
Discount Code
Discount Amount Note 2
Shipping Method Ship Via
Created at
Lineitem quantity Quantity
Lineitem name Description
Lineitem price Price
Lineitem compare at price
Lineitem sku Item Number
Lineitem requires shipping
Lineitem taxable
Lineitem fulfillment status
Billing Name Contact
Billing Street Addr1 - Line 1
Billing Address1 Addr1 - Line 1
Billing Address2 Addr1 - Line 2
Billing Company Customer
Billing City Addr 1 - City
Billing Zip
Billing Province
Billing Country
Billing Phone
Shipping Name Address 2 - Ship to - Contact
Shipping Street Addr2 - Line 2
Shipping Address1 Addr2 - Line 2
Shipping Address2 Addr2 - Line 3
Shipping Company Co./Last Name
Shipping City Addr2 - Line 4
Shipping Zip Addr2 - Line 4
Shipping Province Addr2 - Line 4
Shipping Country Addr2 - Line 4
Shipping Phone
Notes
Note Attributes
NJ State Tax
Cancelled at
Payment Method
Payment Reference
Refunded Amount
Vendor
Id
Tags

Notes

  1. AccountEdge brings in individual lines of an order and calculates the Subtotal, Tax and Total for the transaction.
  2. AccountEdge takes the total DiscountAmount and converts it a % and applies to the last line item.