Articles in this section

See more

Inbounds - Shipping Plan Reconciliation Report

Report Purpose

The purpose of this report is to

  1. enable the seller and Deliverr to reconcile shipments, and
  2. serve as a source of truth on all shipment data for the seller at the time at which it's generated.

Report Description

A seller creates shipping plans in Seller Portal to send inventory to Deliverr. Every shipping plan contains one or more shipments, every shipment contains one or more boxes, and every box contains one or more SKUs. This report provides information about shipments broken down by the SKUs that comprise them. It enables the seller to understand the status of their shipments and where their constituent units are until they are received by a fulfillment center.

For the seller's convenience, the first five columns of this report contain information about the shipping plan to which each shipment belongs. These rows are not used to compute subsequent rows. This report can be aggregated by shipping plan, shipment, or SKU (or any combination thereof) if desired. This is a snapshot report; that is, it contains information only about the time at which it's generated in Seller Portal at https://sellerportal.deliverr.com/reports.

Column Descriptions

Column Description
Shipping Plan Name

Shipping plan name entered by the seller in Seller Portal. The shipment is part of this shipping plan.

Note: If the seller updates the shipping plan name in Seller portal, this value will update.
Shipping Plan ID Unique identifier of the shipping plan
Shipping Plan Creation Time (ET) Time in ET at which the shipping plan was created by the seller in Seller Portal
Shipping Plan Type

This column will have one of the following values:

  1. DIRECT: A direct plan is comprised of up to 4 shipments sent by the seller directly to up to 4 fulfillment centers.
  2. FORWARDING: A forwarding plan is comprised of a single shipment to a cross dock. Deliverr forwards this shipment to one or more fulfillment centers.
 Inbound Type

 This column will have one of the following values:

  1. ECOM_INBOUND: A normal inbound whose units once received will be available for sale. These units would be received at ecom FCs. 
  2. SELLER_TO_STORAGE_INBOUND: An inbound whose units would be received at Deliverr's storage warehouses. These units would not be available for sale.
  3. STORAGE_TO_ECOM_TRANSFER: Transfer of units from Deliverr's storage warehouse to an ecom FC. Post completion of this transfer, units would be available for sale.
Is Plan Archived?

This column will have one of the following values:

1. YES: The shipping plan has been archived by the seller in Seller Portal.

2. NO: The shipping plan has not been archived by the seller.

Shipment ID

 Unique identifier of the shipment

PO Number

 For forwarding plans, this is the PO/ASN of shipment from seller to crossdock. For Direct plans, this is the PO/ASN of shipment from seller to fulfillment center.
Earliest Cross Dock Scan Date

(Forwarding plans only) Date on which the first box in the shipment was scanned at a cross dock
Receiving Began at Date

Date on which the firs box in the shipment was received at the fulfillment center. 
Fulfillment Center Location For forwarding plans, this is the location of the crossdock. For direct plans, this is the location of the fulfillment center.
Shipment Status Current status of the shipment. See Understanding Inbound Shipment Status for the values this column can have.
DSKU Deliverr's unique identifier for the SKU in the shipment
MSKU The seller's unique identifier for the SKU in the shipment
Expected

Units of the SKU that the seller input in the shipping plan. This is the quantity of the SKU that Deliverr expects in the shipment.

Note: If the seller updates expected units in Seller Portal, this value will update.
Received

Units that have been received at a fulfillment center. These units cannot be damaged at the time of receiving, non-compliant, in transit, or shortshipped.

Note: Occasionally, units may be received without an associated shipment recorded due to seller or fulfillment center error. Due of the lack of an associated shipment, such units will not appear in this report.
Damaged Units recorded as damaged by a fulfillment center. These units have arrived at a fulfillment center but are not sellable and will not leave this column until removed by the seller or disposed by a fulfillment center.
Noncompliant Units recorded as non-compliant by a fulfillment center. These units have arrived at a fulfillment center but are not sellable and will not leave this column until removed by the seller or disposed by a fulfillment center.
In Transit Within Deliverr Under 60 Days

(Forwarding plans only) Units belonging to boxes that were scanned at a cross dock within the past 60 days and are in transit to a fulfillment center.

Note: This value doesn't exist for direct plans because direct plan shipments are not sent to a cross dock. This value is based on time elapsed since box scan time, which may be later than Earliest Cross Dock Scan Date.
Shortshipped In Box

(Forwarding plans only) Units missing from their boxes when they were received at a fulfillment center. This occurs when the seller ships fewer units in a box than indicated on the shipping plan.

Note: This value doesn't exist for direct plans because box-level content information from fulfillment centers is currently only available for forwarding plans.
In Transit Within Deliverr Over 60 Days

(Forwarding plans only) Units belonging to boxes that were scanned at a cross dock over 60 days ago but have not been received at a fulfillment center.

Note: This value doesn't exist for direct plans because direct plan shipments are not sent to a cross dock. This value is based on time elapsed since box scan time, which may be later than Earliest Cross Dock Scan Date.
In Transit To Deliverr

1. Direct plans: Units that have not been received at a fulfillment center. These units are either on their way from the seller to the FC or have not been shipped by the seller yet.

2. Forwarding plans: Units belonging to boxes that have not been scanned at a cross dock. These units are either on their way from the seller to a cross dock or have not been shipped by the seller yet.

Note: For time in transit, compare report generation time to Shipping Plan Creation Time (ET).
Excess Received

Units received over Expected, accounting for units in all prior columns. This occurs when the seller ships more units to Deliverr than indicated on the shipping plan.

Note: If the seller updates the inbounded quantity on a shipping plan in Seller Portal, Excess Received here will update.
Support Confirmed Lost

Units investigated and confirmed by Deliverr as lost. Deliverr will reimburse the seller for these units.
Support Confirmed Shortshipped

Units investigated and confirmed by Deliverr as shortshipped by the seller
Discrepant

A positive value represents units requiring further investigation. A negative value represents units received, found, and/or reimbursed over Expected.

1. Direct plans: For complete direct plans, Discrepant = In Transit To Deliverr - Excess Received - Support Confirmed Lost - Support Confirmed Shortshipped. For incomplete direct plans, Discrepant = 0 until the plan is complete.

2. Forwarding plans: Discrepant = In Transit Within Deliverr Over 60 Days - Excess Received - Support Confirmed Lost - Support Confirmed Shortshipped
Shipment Details

Link to shipment's page in Seller Portal

 

Column Relationships

  1. There is exactly one MSKU per DSKU, and vice versa.
  2. Expected = Received + Damaged + Noncompliant + In Transit Within Deliverr Under 60 Days + Shortshipped In Box + In Transit Within Deliverr Over 60 Days + In Transit To Deliverr - Excess Received.
  3. Received, Damaged, Noncompliant, In Transit Within Deliverr Under 60 Days, Shortshipped In Box, In Transit Within Deliverr Over 60 Days, and In Transit To Deliverr are mutually exclusive; that is, a given unit can appear in only one of these columns.
  4. Shortshipped In Box supersedes Support Confirmed Shortshipped. Otherwise put, Support Confirmed Shortshipped is subordinate to Shortshipped In Box. As units are recorded by Deliverr as shortshipped against a forwarding plan shipment at a fulfillment center, Support Confirmed Shortshipped is decremented until it is 0 to keep these columns mutually exclusive.
  5. Excess Received is a subset of Received. See (2) for how it is computed.
  6. In Transit Within Deliverr Over 60 Days and Excess Received are never both nonzero. This is because as units are received against a forwarding plan shipment, In Transit Within Deliverr Over 60 Days is decremented until it is 0, after which In Transit Within Deliverr Under 60 Days is decremented until it is 0, after which Excess Received starts being incremented.

Row Relationships

  1. Unique Identification: Each row represents units of a single SKU within a single shipment. Otherwise put, each row is uniquely identified by a shipment-SKU pair. As a result, no two rows share both Shipment ID and MSKU.
  2. Grouping and Ordering: Rows are grouped by MSKU. Separate shipments sharing MSKU appear in reverse chronological order of Shipping Plan Creation Time (ET). Separate MSKUs appear in alphabetical order.

Related articles