The Settlement Product Summary by Item report display's settled items from each order for the date range and filter options selected.
Column Headings & Field Mappings
Column
|
Table
|
Data Field
|
Type
|
Description
|
Product SKU
|
SettlesOrdSKU
|
ProdSKU
|
Data
|
Product SKU
|
Product Name
|
Prods
|
ProdName
|
Data
|
Product Name
|
Settle ID
|
Settles
|
SettleID
|
Data
|
Settlement ID
|
Deposit
|
Settles
|
DepDate
|
Data
|
Deposit Date for the settlement
|
Date
|
SettlesOrdSKU
|
TransDate
|
Data
|
Transaction Date
|
Order ID
|
SettlesOrdSKU
|
OrderID
|
Data
|
Amazon Order ID
|
Item ID
|
SettlesOrdSKU
|
OrderItemID
|
Data
|
Amazon Order Item ID
|
Qty Sold
|
SettlesOrdSKU
|
QtySold
|
Data
|
Number of Units Sold
|
Sales
|
SettlesOrdSKU
|
SalesAmt
|
Data
|
Product Sales
|
Taxes
|
SettlesOrdSKU
|
SalesTax
|
Data
|
Sales Tax
|
Ship Fee
|
SettlesOrdSKU
|
SalesShip
|
Data
|
Shipping Fee collected from the Buyer
|
Other
|
SettlesOrdSKU
|
SalesOth
|
Data
|
Other Sales Revenue
|
Revenue
|
SettlesOrdSKU
|
SalesRev
|
Data
|
Total Sales Revenue
|
Sales Fees
|
SettlesOrdSKU
|
SalesFees
|
Data
|
Total Sales Fees
|
Promo Fees
|
SettlesOrdSKU
|
PromoFees
|
Data
|
Total Promotion Fees
|
Ship Fees
|
SettlesOrdSKU
|
ShipFees
|
Data
|
Total Ship Fees
|
Oth Fees
|
SettlesOrdSKU
|
OthFees
|
Data
|
Total Other Fees
|
Fees
|
|
Proprietary Algorithm
|
Calculated
|
Total of Fees
|
Fees %
|
|
Proprietary Algorithm
|
Calculated
|
Percentage of Fees Paid
|
Sales Net
|
SettlesOrdSKU
|
SalesNet
|
Data
|
Net Revenue after Fees are subtracted
|
GM
|
|
Proprietary Algorithm
|
Calculated
|
Total Gross Margin (GM)
|
GM %
|
|
Proprietary Algorithm
|
Calculated
|
Total Gross Margin Percent (GM %)
|
Fulfill
|
SettlesOrdSKU
|
FulfillType
|
Data
|
Fulfillment Channel
|
Description
|
|
Proprietary Algorithm
|
Calculated
|
Fulfillment Channel Description
|
Ship Service
|
Orders
|
ShipService
|
Data
|
Ship Service
|
State
|
Orders
|
ShipState
|
Data
|
Ship State
|
Country
|
Orders
|
ShipCtry
|
Data
|
Ship Country
|
Category
|
ProdsCat
|
CatName
|
Data
|
Category Name
|
Brand
|
ProdsBrnd
|
BrndName
|
Data
|
Brand Name
|
Supplier SKU
|
Prods
|
SuppSKU
|
Data
|
Supplier SKU
|
Supplier
|
Supps
|
SuppName
|
Data
|
Supplier Name
|
Market
|
|
Proprietary Algorithm
|
Calculated
|
Market Name
|
|