Import orders from a file
Use this import when the order already comes ready in a file, with the header and the items. It is not for adding items to an order you are typing.
Where to import
Section titled “Where to import”In Demander Web, open Standard layout import.
The file must be .txt, up to 5 MB. Drag the file onto the screen area or click to select it.
The order uses the standard layout:
- Header: Table 16 - Orders
- Items: Table 17 - Order item
Header lines (table 16) come before item lines (table 17), in the same file. In table 17, position 3 is the product code.
Who enables it
Section titled “Who enables it”The company must have Import orders sent by the ERP (Do not enable without homologation) checked, in Company settings, Integration tab.
Without that option, lines from tables 16 and 17 are not accepted. The import warns that the company is not set up to import orders and asks you to contact Demander support.
The help for that option asks you to check it only after homologation, because the number range of existing orders can be duplicated.
Common errors
Section titled “Common errors”- The item unit amount without discount is required. If it comes empty, the import stops and warns that the field is required.
- The order must have the items in the file. Without them, the import warns that it did not find the items.
- The same product code cannot repeat in the same order.
- The item quantity cannot be zero.
- With Validate amounts when the order returns from the ERP checked (it comes checked), the order total must match the sum of the items, IPI, ICMS ST, the fee, freight and the highlighted discount.
Difference from the Excel import
Section titled “Difference from the Excel import”The Excel item import adds products to an order that is already open on the order screen.
The file import brings the whole order, header and items, in the layout of tables 16 and 17.