Shopify 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
- AccountEdge brings in individual lines of an order and calculates the Subtotal, Tax and Total for the transaction.
- AccountEdge takes the total DiscountAmount and converts it a % and applies to the last line item.