1, Search 'Order Import' in BC
2, Choose the platform has been registered in Step1: Ecommerce Integration Setup (Platform Code Setup)
3, Click 'Import Configuration'
4.
Table of Contents
1. Create Customer Master for the Ecommerce Customer
1.1 Create customer for the ecommerce perform. Please see How to create new customer for details
2. Add Platform for the Ecommerce Customer
2.1 Click on the search button then enter Ecom Integration Setup List and then click the link to open the page
2.2 Click action +New to add the new platform code
3. Configuration for Order Import
3.1 Go to Order Import page by use the search function
3.2 In Order Import page, click 
button in Platform field to add or select platform you want to setup for the order import
3.3 Select Import Configuration
3.4 Order Import Configuration
Fill up the information for the configuration that use for data import from excel template
| # | Field | Description |
|---|---|---|
| 1 | Import to Customer No | The customer number that system create SO for the import file |
| 2 | Order No. Prefix | The Sales Order number |
| series that system uses to create SO for the import file | ||
| 3 | SO Group By | Select how to create sales order by the import file. Two option is available (1) Group by Order Date / (2) Group by Shipment Date |
| 4 | First Row ID |
| To determine the first row of data to be grabbed | ||
| 5 | Use System Discount | When the option is selected, system will use the discount for the customer its setup in business central. No matter the discount field is mapped in Configure Excel Column, the discount column data in import file |
will be |
ignored. | ||
| 6 | Configure Excel Column | To determine the import file columns to be displayed in the sales orders generated |
| 7 | Calculation | Select either one option Calculate Unit Price - |
- when this option is selected, no matter the unit price field is mapped in Configure Excel Column, the data in import file to be ignore.
Calculate Sales Price
- select this option for always use the price setup in system to calculate sales price.
...
The sales orders with a unit price will be generated by dividing the Sales Price by quantity. -Users must map the "Sales Price" in the configuration first Calculate Sales Price -The sales orders with a sales price (total price) will be generated by calculating "Unit Price" * “Quantity" -Users must map the "Unit Price" in the configuration first |
| Case Setting | Outcome |
|---|---|
| "Use System Discount" + "Calculate Sales Price" | With setup of the "Unit Price", users will get the sales order (Quantity * Unit Price = Sales Price) Please be noted that with this setting, no discount will be applied |
| Only "Calculate Sales Price" | With setup of the "Unit Price", users will get the sales order (Quantity * Unit Price * Excel discount line = Sales Price) and get the sales price. |
| "Use System Discount" + "Calculate Unit Price" | With setup of the "Unit Price", users will get the sales order (Quantity * Unit Price * Line Discount = Sales Price) and get the unit price. |
| Only "Calculate Unit Price" | With setup of the "Unit Price", users will get the sales order (Quantity * Unit Price * Excel discount line = Sales Price) and get the unit price. |