ViewCSV
Turn an eBay MIP pending-orders CSV into a SKU summary without adding the same order total for every line. Review accepted quantities and line-item amounts separately for each payment status and currency.
Supported eBay export
This tool reads the Merchant Integration Platform pending-orders response. Seller Hub Orders, Earnings and Managed Payments exports use other contracts and are not supported here. A pending-orders export is a snapshot, not a complete sales history.
From CSV to a usable report
- Choose the MIP orders or active-inventory tool that matches your export.
- Open the CSV, paste its contents, or inspect the linked official example.
- Review the Issues tab before using the summary. Open Source rows to compare the original records.
- Download the selected table, or send the summary to Excel, charts or video.
How the numbers are calculated
The summary adds quantity and lineItemSumTotal once per accepted orderID + lineItemID pair. It groups by SKU, optional channelID, orderPaymentStatus and lineItemSumTotalCurrency. Distinct order counts belong to each group and must not be added across SKUs. Decimal sums are exact. All occurrences of a repeated orderID + lineItemID are excluded for review; the tool does not choose a winner.
unitPrice is an EU unit-pricing disclosure, not a safe substitute for the purchased-item price. orderSumTotal, paymentTotal, fees and collected tax are not added to line-item amounts. The result is neither bank reconciliation nor profit.
Fields read from your file
orderID lineItemID SKU quantity lineItemSumTotal lineItemSumTotalCurrency orderPaymentStatus
Limits and review rules
Processing stays in your browser. Interactive limits are 25 MiB, 100,000 rows, 250 columns and 2 million cells. Decimal amounts accept a period and up to 8 fractional digits; quantities accept up to 24 integer digits. Unsupported numbers are listed for review rather than converted. Malformed CSV or missing required headers blocks the report.
Continue with the result
Use Filter CSV for a narrower source selection. Result buttons transfer the computed summary to CSV to Excel, CSV chart maker or CSV to video. Video uses a single export snapshot; no historical trend is invented.
Official eBay example
Selected columns from eBay’s unmodified official sample. Masked identifiers are supplied by eBay. The output below is calculated by ViewCSV.
orderID,lineItemID,SKU,channelID,quantity,lineItemSumTotal,lineItemSumTotalCurrency,orderPaymentStatus 1*1-0***3-4***3,1*********13-1**********03,PERF-SKU_123,EBAY_US,1,14.3,USD,PAID
SKU,channelID,orderPaymentStatus,currency,accepted_lines,distinct_orders,quantity,line_item_total PERF-SKU_123,EBAY_US,PAID,USD,1,1,1,14.3
Questions and answers
Use this page only for MIP pending-orders CSV with the required headers. A similarly named Seller Hub report is a different file format.