EOD Manifest
Overview
The End of Day (EOD) manifest includes information on items and parcels shipped by Merchants on a given day. This form allows the timely and correct processing of parcels in the Global-e hub or Merchant’s warehouse.
An EOD manifest is required for Merchants that send multi-parcel orders or to issue reorders (backordered items).
Global-e uses the EOD manifest to:
Create relevant Airway bills (AWB) and export documentation for all parcels.
Automatically amend out-of-stock items.
Notify Merchants shipping via Global-e of the number of parcels on the way and their unique identifier codes so they can be scanned and processed upon arrival.
Preparing the Report
The following guidelines detail how to prepare a report for the EOD manifest. Follow these instructions precisely to ensure that the order and parcel information is processed correctly.
Naming the report
The report name should include the merchant's name as configured in Global-e's merchant settings, the date, and the time.
Format: {MerchantName}Manifest_ddmmyyyyhhmm
Example: MyToysStoreManifest_100220151738
Formatting the report
The report should be in CSV format and include commas as separators.
Tabulations, semi-columns, or any other separators are not supported.
Report Structure and data
In your CSV file, make sure to name the columns headers A through I, as shown below:
Field Descriptions and Requirements
Header | Required | Description | Notes |
Global-e Order ID | No | If the Merchant does not have a Global-e Order ID, this column should remain empty. | |
Merchant Order ID | No | If there is no order ID, then this column should remain empty. | |
Parcel Code | Mandatory for in-stock items. Optional for backordered, pre-ordered, and out-of-stock items. | The code is assigned to each parcel in the Merchant’s warehouse. | This code should also be barcoded on the label of each parcel that arrives at a Global-e hub (or shipped directly by the Merchant), along with the Order ID barcode (either Global-e Order ID or Merchant Order ID, as included in the manifest data). |
Product SKU | Yes | The SKU of each product in the parcel. | |
Quantity | Yes | The quantity of each product in the parcel. | |
Is Backorder flag | No | Relevant for items that are known as backordered. | Accepted values:
Important:
|
Backorder Expected Fulfilment Date | No | If provided by the Merchant, Global-e includes this information in the notification on backordered items sent to customers. | Accepted values:
|
Is Order Completed flag | Yes | Updated by the merchant to indicate if the order is completed or not. | Accepted values:
Note: The same order in the manifest cannot contain both Is Backorder = 1 and Is Completed = 1. If there are any backorder items, always send Is Completed = 0, until all the order items are supplied. |
Delivery Reference Number | No | For Merchants adding additional unique order identifier. It should be associated with each line item in the manifest. | |
Weight | No | The weight of the parcel in grams. | If there are several items in the parcel, the total weight will be divided equally between all items. If the weight is not specified, it will be taken from the catalogue . |
Country of Origin | No | The country where the item is manufactured. | If the country of origin is not specified, it will be taken from the catalogue . |
Important
Global-e makes efforts to consolidate multi-parcel orders into one shipment (for supported carriers) to save shipment costs to merchants and provide a better customer experience for shoppers.
Multi-parcel orders flagged as not completed are treated as split orders that will be fulfilled within 1 – 2 days, and consolidated in the Global-e hub.
It is important not to delay the fulfilment of split multi-parcel orders beyond this timeframe, as this could bear additional holding costs.
An exception to consolidating orders are orders that are flagged as containing backordered items. In this case, each parcel arriving at a Global-e hub is dispatched immediately and is not placed into the holding area to await additional parcels, so that the customer's delivery promise is not compromised.
EOD Examples
Example 1: Single parcel order, all items are in stock
A customer has purchased the following products:
SKU 1 – quantity 1
SKU 2 – quantity 1
SKU 3 – quantity 1
The shipment scenario:
All the items are sent in one parcel, P1.
The order is marked as completed and is dispatched to the customer on arrival at the Global-e hub.
Example 2: Multi-parcel order, all the items are in stock
A customer has purchased the following products:
SKU 1 – quantity 1
SKU 2 – quantity 1
SKU 3 – quantity 1
The shipment scenario:
The items are sent in two parcels, P1 and P2.
The order is marked as completed and is dispatched to the customer on arrival at the Global-e hub.
Example 3: Split multi-parcel order, all the items are in stock
A customer has purchased the following products:
SKU 1 – quantity 1
SKU 2 – quantity 3
SKU 3 – quantity 1
SKU 4 – quantity 2
The shipment scenario:
Two parcels, P1 and P2, arrive on the first day and the order is marked as incomplete.
The Global-e hub processes the parcels and puts them in Holding Area 2 .
The following day, parcel P3 arrives. The parcel is processed, the hub operator is notified and collects the on-hold parcels.
All three parcels are dispatched to the customer.
Example 4: Multi-parcel order, some of the items are out of stock
A customer has purchased the following products:
SKU 1 – quantity 1
SKU 2 – quantity 3
The shipment scenario:
Two parcels arrive, P1 and P2, and the order is flagged as completed.
Product SKU2 shows that only 2 out of 3 items were shipped. However, since the order is flagged as completed, the manifest processor treats the third item of SKU2 as SNA:
The customer is notified and refunded.
The export documentation is amended.
The parcels are dispatched to the customer on the same day.
Example 5: Split multi-parcel order, some of the items are out of stock
A customer has purchased the following products:
SKU 1 – quantity 1
SKU 2 – quantity 3
The shipment scenario:
Two parcels arrive, P1 and P2, and the order is flagged as incomplete.
Product SKU2 shows that only 1 item out of the ordered 3 are shipped.
The Global-e hub processes the parcels and puts them in Holding Area 3.
The following day parcel P3 arrives, and the order is flagged as completed, however, product SKU2 only shows 1 additional item. This parcel is processed and:
The customer is notified and refunded for one item of SKU2 which is out of stock.
The export documentation is amended accordingly.
The hub operator is notified of additional parcels in the holding area and collects the on-hold parcels. All three parcels are dispatched to the customer.
Example 6: Split multi-parcel order, some of the items are out of stock with exception (the last item is SNA indefinitely)
A customer has purchased the following products:
SKU 1 – quantity 1
SKU 2 – quantity 3
The shipment scenario:
Two parcels arrive, P1 and P2, and the order is flagged as incomplete. Product SKU2 shows that only 2 out of 3 items were shipped.
The Global-e hub processes the parcels and puts them in the holding area.
The following day, the Merchant realizes that the third item of SKU2 is not being put back in stock and will never be fulfilled.
The Merchant notifies Global-e via the manifest by sending the missing item with quantity 0, triggering the following actions:
The customer is notified and refunded for one item of SKU2 which is out of stock.
The export documentation is amended accordingly.
A notification is sent to the hub operators to collect the parcels in the holding area and dispatch them to customers.
Note
It is important to immediately notify Global-e if an item cannot be fulfilled to avoid longer waiting periods for parcels in the holding area and compromising customer delivery promises.
Example 7: SNA exception – all of the order items are SNA and will never be fulfilled
In a situation where all of the order items are out of stock and will not be fulfilled, a notification is sent to Global-e through the manifest so that the customer can be updated and refunded.
A customer has purchased the following products:
SKU 1 – quantity 1
SKU 2 – quantity 1
The shipment scenario:
Both products are out of stock so the Merchant sends Global-e a notification with Is Completed flag set to 1 (order is completed).
The parcel codes are missing (since nothing is actually being shipped) and quantities show 0.
Note
In this situation, Merchants do not need to notify Global-e through the EOD manifest if they send an Order Status Update notification via API.
Contact your Account Manager or Technical Support if you are unsure if the Order Status Update API is implemented for your store.
Example 8: Order with backordered items
A customer has purchased the following products:
SKU 1 – quantity 5
The shipment scenario:
While fulfilling the order, 3 items are available while 2 are out of stock but can be fulfilled within a few weeks.
One parcel arrives at the hub. The manifest shows the order is incomplete and additional items will be fulfilled later on. The parcel is dispatched to the customer on the same day. Once the additional items arrive, the order is marked as complete.
In X days, when one of the backordered items is available in stock, the Merchant sends an updated line.
Note: When an item is no longer backordered – the flag is changed accordingly (Is Backorder = 0) and the date is removed.
In additional X days the order is fully completed, Is Order completed flag = 1:
Example 9: Split multi-parcel order with backordered items and out of stock items
A customer has purchased the following products:
SKU 1 – quantity 2
SKU 2 – quantity 1
SKU 3 – quantity 3
The shipment scenario:
One parcel, P1, is received at the hub with SKU 1. The order is marked as incomplete and some of the items are marked as backordered.
The P1 parcel is processed and dispatched to the customer. The customer is notified of the backordered items.
The following day, the P2 parcel arrives at the hub with SKU 2 item. The order is still incomplete.
In x days, the backordered items arrive at the hub in parcel P3. The order is marked as completed. The manifest processor:
Recognizes that one of the items (SKU3) is missing.
Refunds the customer and amends export documents for parcel P3.
Dispatches the parcel to the customer.
Example 10: Backorder Exception - all items order items are backordered
A customer has purchased the following products:
SKU 1 – quantity 1
SKU 2 – quantity 2
The shipment scenario:
While fulfilling the order the Merchant realizes that all of the items are backordered. Though no items are being shipped physically to the hub, the Merchant notifies Global-e of the backordered items via the manifest, so that the customer can be updated.
Report Schedule
The report should be sent once the pick and pack in the Merchant warehouse is completed for the day and before the orders arrive at the Global-e hub or before the orders are prepared for international shipping by Merchants fulfilling from their own warehouse.
Uploading the Report
The report can be uploaded in the following ways:
On the Global-e sFTP
On the Merchant’s sFTP
Note
In order to pull the report from a Merchant's sFTP server, the Merchant needs to provide Global-e with write permissions to the folder where the manifests are located. This folder should also contain an archive sub-folder.