eBay Orders

List of the eBay orders of all eBay accounts, newest first. Every eBay order is a merchantCENTRAL marketplace order; the list shows the marketplace orders of eBay with the columns only eBay has – eBay order, fulfillment, payment, and cancellation status, the eBay buyer, and the deadline for shipping. It is read-only; clicking an order opens it on the Marketplace Order card with its lines and the refund and cancellation actions.

Opening the Page

Via search: eBay Orders
Via the eBay Dashboard → Orders
Via the figures of the eBay Dashboard: To be sent, Orders today and Orders with errors open the list with exactly the orders they counted.

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

From eBay Order to Sales Order

Import. The ORDER job queue entry (eBay: Import Orders, every 5 minutes by default) or the Import Orders action reads, once per eBay account – for all countries of the account – the open orders eBay has changed since the last import: new orders as well as payment, cancellation, and shipment of existing ones. On the first import of an account, these are all open orders. Every order is stored as a merchantCENTRAL marketplace order, every eBay line item as an order line of its own; an order merchantCENTRAL already has is updated by the import – also after its sales order has been created. An order still waiting for its sales order that was not among the changed ones is read again on its own.
Sales channel. The sales channel (country) of an order is determined by the eBay country of the listing it was bought through, together with the eBay account. If the account has not set up this country, the order gets the sales channel of the country the import runs for; the activity log says so. Shipment confirmation, refund, and cancellation later run in the eBay account of this sales channel.
Waiting for payment. An order gets its sales order only once eBay reports it as paid – eBay Payment Status Paid or Partially Refunded – and no cancellation is in progress (eBay Cancellation State None Requested). Until then it has the status New. An order with Pending, Failed, or Fully Refunded gets no sales order. If an order is cancelled at eBay before it has a sales order, it gets the status Cancelled; if eBay reports it as shipped (Fulfilled) before it has one, it was shipped outside Business Central and gets the status Shipped. In both cases, no sales order is created any more.
Sales order. After the import, merchantCENTRAL creates the sales orders of the paid orders, as for all marketplaces, each in a transaction of its own. If one fails, it gets the status Error, and Error Message gives the reason; this does not hold up the other orders. The next run tries again, Create Sales Orders at once. With a sales order, the order has the status Imported; after that it follows shipment and invoicing.
Item and variant. merchantCENTRAL finds them by the eBay SKU of the line item, see below.

The check for payment and cancellation applies to every way to the sales order – including Import Again on the Marketplace Order card. If an order fails it there, it gets the status Error, and Error Message gives the payment or cancellation status; once eBay reports it as paid, the next run creates the sales order.

If an order is cancelled after its sales order has been created, see Cancellation and Sales Order.

What the Import Writes to the Sales Order

In the sales order	From the eBay order
Marketplace Order No. / External Document No.	eBay order ID – the number under which merchantCENTRAL keeps the order and recognises duplicate imports. Clicking the Marketplace Order No. opens the order on the Marketplace Order card.
Your Reference	Sales record number from eBay Seller Hub; the eBay order ID when there is none.
Order Date	Order date on eBay.
Generated By	`EBAY`.
Latest Ship Date	Earliest ship-by date of the line items (ship deadlines).
Lines	One line per eBay line item with the unit price the buyer paid (after promotions). merchantCENTRAL finds item and variant by the eBay SKU (see below).
Shipping costs	The shipping costs paid, less shipping discounts. merchantCENTRAL creates the shipping cost line from the Shipping No. in the merchantCENTRAL setup; the Shipping Item No. in the eBay setup applies only when the Shipping No. is empty. Without shipping costs the order gets the Free Shipping Method Code.
Address	The second address line (e.g. Packstation customer number, c/o) is part of the street. eBay provides no billing address; the ship-to address is used for both.
Comments	The buyer's message from checkout.
VAT Registration No.	The VAT ID of a business buyer; if the country prefix is missing, the connector adds it (Greece: EL). merchantCENTRAL puts it on the customer and chooses the customer template by it. eBay provides it only for eBay Italy and eBay Spain and only when a single order is retrieved – that is, for orders read again on their own (Refresh Order, or an order still waiting for its sales order), not with the regular import. Tax numbers such as Codice Fiscale or NIF are not taken over.

The sales order no longer has the eBay Order ID and eBay Origin fields; the way to the order is the Marketplace Order No. and the merchantCENTRAL action Show Marketplace Order. The posted shipment no longer shows an eBay Order ID field of its own either; on it, as on the posted sales invoice, the Marketplace Order No. field and the merchantCENTRAL action Show Marketplace Order lead to the order.

Item and Variant by eBay SKU

Every line item names the eBay SKU of the item sold. merchantCENTRAL looks it up in the sales channel (country) of the order – first as a marketplace offer, then as the SKU of a marketplace item – and finds item and variant that way. Since every country has an SKU of its own (4711-DE, 4711-AT, see eBay SKU per country), the line lands on the right item even when it is listed in several countries. There is no matching by item number.

The order lines on the card show per line item the Item No. and Variant Code it was imported as.

Unknown SKU: If merchantCENTRAL finds no item for an SKU – for example for a listing not yet assigned to an item – the result depends on Hold Order on Unknown Item on the marketplace card of the hub marketplace EBAY:

Setting	Result
On	The order is held: it gets the status On Hold, and Error Message names the unknown item; no sales order is created yet. For a new setup the setup wizard switches the setting on; existing setups stay unchanged.
Off	The sales order is created without this line. The missing line is recorded in the activity log.

To resolve an order on hold:

Assign the SKU – for an existing eBay listing via the eBay Listings list (Assign Item...), otherwise by giving the marketplace item the matching eBay SKU.
Open the order on the Marketplace Order card or select it in the Marketplace Orders and choose Import Again. If the SKU is still unknown, the order stays on hold. On the card, Import Without Unknown Items creates the sales order without the unknown lines instead.

No duplicate orders arise: an order merchantCENTRAL already knows – held ones included – is only updated by the next import.

Fields

Field	Description
External Order No.	The eBay order ID – the ID eBay gives the order. The sales order carries it as Marketplace Order No.
Sales Record No.	The sales record number you see in eBay Seller Hub. Hidden; shown via Personalize.
Sales Channel	eBay account and country the order came in through.
Status	Where the order stands in Business Central (color-coded as on all merchantCENTRAL order pages): New – waiting for payment and sales order –, On Hold because of an unknown item, Error, Imported – sales order created –, Partially Shipped, Shipped, Invoiced, or Cancelled. The colors are explained in the help for the Marketplace Order card.
Order Date	When the buyer placed the order at eBay.
Customer Name	Name of the buyer. eBay gives the seller no billing address, so it is the name on the ship-to address.
Total Amount	What the buyer paid for the order, including shipping and tax.
Currency Code	Currency of the order.
Sales Order No.	Sales order in Business Central. Clicking it opens it. Empty while the order waits for payment, has a cancellation at eBay, or its sales order failed; in the last case Error Message gives the reason.
Error Message	Why the sales order of the order was not created. The message disappears once the sales order is created.
eBay Order Status	Status of the order at eBay: Active (yellow) while it still has to be shipped, Completed (green) once eBay reports it fulfilled, Cancelled (gray) once it is cancelled at eBay.
eBay Fulfillment Status	How far eBay considers the order shipped: Not Started (yellow), In Progress (partly shipped, blue), or Fulfilled (green).
eBay Payment Status	Payment status at eBay: Pending (yellow), Paid (green), Failed (red), Partially Refunded (blue), or Fully Refunded (green). The sales order is created for Paid and Partially Refunded.
eBay Cancellation State	None Requested, Cancellation Requested (red – a decision is pending), or Cancelled (gray). While a cancellation is requested, no sales order is created.
eBay Buyer	eBay user name of the buyer. Cleared when the order is anonymized.
Ship By	Date and time by which eBay expects the order to be shipped: the earliest ship-by date of its line items. The sales order gets it as Latest Ship Date.

eBay Collected Tax, Refund Status (colored as on the card), and Import Date/Time are hidden; you can show them via Personalize.

Actions

Action	Description
Show Sales Order	Opens the sales order of the selected order. Only active if there is one.
Import Orders	Imports the new and changed orders of all eBay accounts and then creates the sales orders of the paid ones, as described above. The summary gives the orders read, new, and updated, the sales orders created, held, and failed, and the orders still waiting for payment.
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. Orders with a sales order are left out; orders that are not paid or have a cancellation at eBay keep waiting. With several orders selected, it asks first. A summary follows at the end. You create an order on hold with Import Again on the Marketplace Order card.
Refresh Order	Reads the selected order again from eBay: payment, cancellation, and fulfillment status. If it is then paid and without a cancellation, the action creates its sales order.

Workflow

Orders come in through the job queue or Import Orders.
Orders with status New are waiting for payment – nothing to do.
Check orders with status Error or On Hold: Error Message gives the reason.
Fix the reason, then Create Sales Orders (for Error) or Import Again on the card (for On Hold).
Continue with the sales order in Business Central (shipment, invoicing); the shipment confirmation with the tracking number goes to eBay once the shipment is posted.