Skip to content

Otto Orders

List of the orders imported from Otto, newest first. Every Otto order is a marketplace order of merchantCENTRAL; the list shows the Otto marketplace orders with the columns only Otto has – Otto order status, delivery city and payment method. It is read-only; choosing an order opens it on the Marketplace Order card with its positions and the actions for them.

Opening the Page

  • Via search: Otto Orders
  • Via the Otto Dashboard → Orders
  • Via the Otto Dashboard → Orders with errors tile: opens the list with the orders that have no sales order yet – status Error or On Hold.

The same orders are also in the Marketplace Orders of merchantCENTRAL, there without the Otto columns.

From Otto Order to Sales Order

  1. Import. The job queue task Otto - Order Sync (every 15 minutes), the Import Orders action on this list or on the dashboard reads the orders whose positions Otto lists as Processable or Announced. Each order is stored as a merchantCENTRAL marketplace order, each position as an order line of its own. An order that is still waiting for its sales order and no longer appears in either of the two lists has since been cancelled or sent at Otto: it is read again individually and gets its new status before the sales orders are created.
  2. Waiting while a position is announced. An order only gets a sales order once Otto no longer lists any of its positions as Announced – otherwise the announced position would be missing from the sales order for good. As long as Positions Not Released on the card is greater than 0, the order waits. If Otto cancels all positions before the order has a sales order, it gets the status Cancelled. If all positions are sent or returned without there being a sales order, it gets the status Shipped and stops waiting.
  3. Sales order. If Auto Create Sales Order is enabled in the Otto Setup, merchantCENTRAL creates, after the import, the sales orders of the orders that have at least one position with Processable and none with Announced any more, as for all marketplaces. Each position with Processable becomes a sales line; positions cancelled from Business Central or reported as sent since the last import stay out. Prices go into the sales order excl. VAT, each position converted with its own VAT rate, and the delivery fee as shipping costs. Each order is created in a transaction of its own. If one fails, it gets the status Error, and Error Message gives the reason; the other orders are not held up. The next run tries again, Create Sales Orders at once. Releasing and posting the new sales orders is done by the Order Automation of the marketplace card through the job queue, as for every marketplace.
  4. Item. merchantCENTRAL finds the item of a position in this order: the item linked to the SKU on the Otto product, the item whose number is the SKU, or the item whose GTIN is the EAN. The search runs at import and once more right before the sales order is created; a link you created after the import therefore counts. With Find BC Item in the order lines you see beforehand which item a position gets.

Item Unknown

If none of the three ways leads to an item, merchantCENTRAL decides:

  • If a Default Item No. is set in the Otto Setup, the position gets this item – intended for test orders with made-up SKUs.
  • If Hold Order on Unknown Item is enabled on the merchantCENTRAL marketplace card, merchantCENTRAL holds the order: it gets the status On Hold, and Error Message names the unknown item. Link the SKU on the Otto product to the item and choose Import Again on the Marketplace Order card or in the Marketplace Orders of merchantCENTRAL. On the card, Import Without Unknown Items instead creates the sales order without the unknown positions.
  • Otherwise no sales order is created: the order gets the status Error, and Error Message names the SKU. Link it to the item on the Otto product or enter the EAN as the item's GTIN; the next run creates the sales order, Create Sales Orders does so at once.

Fields

Field Description
External Order No. The number Otto gives the order. The sales order keeps it as Marketplace Order No.
Otto Order Status Status of the order at Otto (coloured), derived from its positions: Announced (Otto has not released a position yet) and Processable amber, Sent green, Returned, Cancelled by Partner and Cancelled by Marketplace grey. See Otto Section.
Status Where the order stands in Business Central (coloured as on all merchantCENTRAL order pages): New – waiting for its sales order –, On Hold because of an unknown item, Error, Imported – sales order created –, Partially Shipped, Shipped, Invoiced or Cancelled. The colours are explained in the help for the Marketplace Order card.
Order Date When the order was placed at Otto.
Customer Name Name of the buyer, from the invoice address of the Otto order.
Delivery City City of the delivery address in full length, as Otto reports it.
Total Amount Total amount of the positions that are not cancelled plus the delivery fee, incl. VAT.
Currency Code Currency of the order; Otto sells in euros.
Sales Order No. Sales order in Business Central. Choosing it opens it. Empty as long as none has been created; Error Message then gives the reason.
Error Message Why the sales order of the order was not created, for example: no item for the SKU, a position still announced, held by merchantCENTRAL. The message disappears as soon as the sales order is created.
Payment Method How the buyer paid at Otto.
Import Date/Time When the order was imported from Otto. Hidden; can be shown via Personalize.

Actions

Action Description
Show Sales Order Opens the sales order of the selected order. Only enabled if there is one.
Import Orders Imports the new and changed orders from Otto and then creates the sales orders of the released ones, as described above. If a position is cancelled at Otto only after the sales order was created, the import reports the cancellation to merchantCENTRAL, see Cancellation and Sales Order. The summary names the imported orders and the created, held and failed sales orders.
Create Sales Orders Creates the sales orders of the selected orders now instead of in the next run – after the reason in Error Message has been fixed. The action skips orders with a sales order, orders on hold and anonymized orders. An order with a position that Otto has not released yet gets no sales order; Error Message names the position, and the order waits until Otto releases it. With several orders selected, it asks first. At the end there is a summary. You create an order on hold with Import Again on the Marketplace Order card.
Refresh Order Reads the selected order again from Otto: the status of its positions as well as shipments and cancellations at Otto. The action does not create a sales order; the next run or Create Sales Orders does that.

Workflow

  1. Orders come in through the job queue or Import Orders.
  2. Check orders with status Error or On Hold: Error Message gives the reason.
  3. Fix the reason, then Create Sales Orders (for Error) or Import Again on the card (for On Hold).
  4. Continue processing the sales order in Business Central (shipping, invoicing); the shipment confirmation goes to Otto, see Shipment Confirmations.