Fields mapping
Items export – fields mapping
If in Business central user have settings for export Items from system to Shopify, system will use following mapping of fields:
| Business central, table Item (or Variant) | Shopify |
| Description | title |
| Description | body-html |
| No. | handle |
| Name of Vendor | vendor |
| Item Category Code | tags |
| Unit Price | price |
| No. + ”_” + Variant Code | sku |
| Net Weight * 1000 | grams |
| Net Weight | weight |
| ’kg’ | weight-unit |
| ’continue’ | inventory-policy |
| Item Cross Reference - Cross-Reference No. | barcode |
| ’manual’ | fulfillment-service |
| ’shopify’ | inventory-management |
| Inventory | inventory-quantity |
Customer export – fields mapping
If in Business central user have settings for export customers from system to Shopify, system will use following mapping of fields:
| Business central, table Customer | Shopify |
| Name (first part before Space) | first_name |
| Name (last part before Space) | last_name |
| Phone No. | phone |
| default_address | |
| Address | address1 |
| Address 2 | address2 |
| City | city |
| County | province |
| Country -> Name | country-name |
| Country/Region Code | country-code |
| Post Code | zip |
Orders import – fields mapping
When Business Central is importing orders from Shopify, system will use following mapping of fields:
| Business central, table Sales Header and Sales Line | Shopify |
| Sales Header | |
| Order Date | created-at |
| billing-address | |
| Bill-to Name | name |
| Bill-to Address | address1 + address2 |
| Bill-to City | city |
| Bill-to Post Code | zip |
| Bill-to Country/Region Code | country-code |
| shipping-address | |
| Sell-to Customer Name | name |
| Sell-to Address | address1 + address2 |
| Sell-to City | city |
| Sell-to Post Code | zip |
| Ship-to County | province |
| Sell-to Country/Region Code | country-code |
| Ship-to Name | first-name + last-name + company |
| Ship-to County | province |
| Sales Line | |
| Type = Item | |
| No. | --search for Item No. with logic below |
| Quantity | quantity |
| Unit Price | price |
| Line Discount Amount | total-discount |
Note – when system is importing orders, it checks whether this Order already exists in system by filtering existing Sales Oredrs (and Posted Sales Invoices) with value ” Your Reference” = Shopify order ID.
Seach for Item in Shopify order – when system is importing order from Shopify, it searches form item with following logis
-
system takes value from ’sku’ field and try to find Item with equivalent No. If not foudn then...
-
system seach for product information in Shopify, takes field ’handle’ try to find Item with equivalent No. If not found then...
-
system searches value from ’sku’ field in Item Cross Reference table.