Order Provider

The Order Provider is used to export and import Orders and Order lines.

When used as a source provider the following settings are available to you (Figure 2.1).

Figure 2.1 When used as a source provider, these are the settings available to you

You can:

  • Limit the export to orders which have not yet been exported (column OrderIsExported from table EcomOrders)
  • Limit the export to orders without an externalID (column in EcomOrders) from e.g. an ERP system
  • Limit the export to completed order (and not abandoned carts, which are technically also orders)
  • Bulk-set the orders exported to an order state

When used as a destination provider no further settings are available to you (Figure 3.1).

Figure 3.1 When importing order and order lines, no further options are available to you

The Order Provider uses only two tables; EcomOrders and EcomOrderLines.

For EcomOrders:

  • OrderID must be included, and should contain the ID of the order. If the OrderID already exists in Dynamicweb, the order will be updated (rather than created).
  • OrderStateID functions as a Foreign Key field to EcomOrderStates. If left blank, the order does not have a state.

For EcomOrderLines:

  • OrderLineID must be included, and should contain the ID of the order line. If the OrderLineID already exists in Dynamicweb, the order line will be updated (rather than created).
  • OrderLineOrderID must be included, and should contain the ID of the order you are creating relations from.
  • OrderLineParentID is optional, and can be used to create a relation between order lines by supplying a pared OrderLineID.