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
1Import to Customer NoThe customer number that system create SO for the import file
2Order No. PrefixThe Sales Order number prefix that system create SO for the import file
3SO 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

4First Row IDThe 1st row in import file with sales line data use for creating sales order
5Use 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 data in import file to be ignore.

6CalculationSelect either one option

Calculate Unit Price

- select this option for always use the sales price to calculate the 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.












  • No labels