Skip to content
Light
English

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.

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 lines (table 16) come before item lines (table 17), in the same file. In table 17, position 3 is the product code.

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.

  • 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.

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.