Overview
The Paid Order report in Lister is great for product category analysis and financial analysis at the order level. This report is great at comparing your actual shipping costs vs. what your buyers pay, tracking the average number of items per order and average order value.
One unique field on the Paid Orders report and this Paid Order Items report gives you the ability to filter by Paid, Refunded & Partially Refunded, or All orders. This report will default to paid orders which will exclude any orders that have been refunded or partially refunded.
This help article outlines how to access, download, and understand all of the data available in the Paid Order Items report.
đĄOperational Tip: Whereas the Paid Order Items report gives a breakdown at the item level (including what items sold from each supplier), the Paid Order report is an overview of details at the the order level.
Table of Contents
How to Access the Paid Order Items Report
Click the reports icon in the top right corner of Lister to navigate to the Reports page
Click âPaid Ordersâ in the left column
How to Download the Paid Orders Report
The Paid Orders report will populate data based on your selected criteria below.
Between: Select a date range for when the orders were imported to Lister
Timezone: Select your desired timezone for the report.
Note: For a closer match to Shopgoodwillâs reports, select America/Los Angeles timezone
Channel: Select between all or a single connected marketplace
Payment Status: Select between Paid, Refunded & Partially Refunded, or All orders.
Click âGenerate reportâ and optionally enter your email address to send a copy once itâs been created
Depending on how much data will be included in the report, this may take several moments to complete
Download and open the report from the Past Reports section of the reports page or from your email account (if entered in the popup in box 5, above)
Definitions of Report Columns
Once opened in a spreadsheet, the following data is available to view and manipulate as needed:
Column A - Upright Order Id: The ID associated with the order in Upright Lister
Column B - Channel: The channel on which the item sold (i.e. Shopgoodwill, eBay, etc.)
Column C - Channel Order Id: The ID associated with the order in the marketplace
Column D - Secondary Channel Order Id: Some marketplaces (eBay, for example) provide a secondary order ID. This column is included to help find specific orders if you need to search a marketplace by the secondary ID
Column E - Channel Buyer Id: This an identifier for the customer who purchased the order
Column F - Order Items Count: Sum of total purchased items within the order
Column G - Payment Id: The ID associated with the order (eBay Only)
Column H - Payment Type: How the payment was processed (typically Stripe or Paypal)
Column I - Total: Total amount that the customer paid. Sum of Subtotal, Shipping Total, Handling Total, Tax Total, and Donation Total
Column J - Subtotal: Total amount the customer paid for the items in the order
Column K - Shipping Total: How much the customer paid for shipping
Column L - Shipping Label Total: How much you paid to ship the order via EasyPost in Lister
Column M - Handling Total: Total handling fee the customer paid for the order (Shopgoodwill only)
Column N - Tax Total: How much tax was paid by the buyer
Column O - Donation Total: Roundup total on the order (Shopgoodwill only)
Column P - Currency Code: The currency that the order price values appear in. This is typically USD, but can also be other values, such as CAD for Canadian Dollars
Column Q - Final Value Fee: Fees charged by the channel (eBay only)
Column R - Payment Processing Fee: Matches up with the credit card fee from Shopgoodwill
Note: Unfortunately, we cannot capture all fees from Shopgoodwill due to technical constraints with the Shopgoodwill API
Column S - Shipping Contact: Name of the customer entered for the shipping address
Column T - Shipping Company: Company on the address line, if applicable
Column U - Shipping Address 1: First line of the shipping address
Column V - Shipping Address 2: Second line of the shipping address, if applicable (i.e. Apartment 2)
Column W - Shipping Address 3: Third line of the shipping address, if applicable (i.e. Attn: XX)
Column X - Shipping Country: Destination country
Column Y - Shipping Region: Destination region/state
Column Z - Shipping City: Destination city
Column AA - Shipping Postal Code: Zip code or postal code of destination address
Column AB - Shipping Phone Number: Phone number entered by the customer for shipping
Column AC - Shipping Method: Carrier used for the shipment (e.g. FedEx, USPS)
Note: If the order was a pickup order, this column will indicate "Pickup"
Column AD - Shipping Tracking Number: Tracking number for the shipment
Column AE - Fulfillment Status: This will either be "Fulfilled" or "Unfulfilled" and is reflective of whether tracking information has been shared with the channel or Lister (if shipped outside of Lister)
Column AF - Ordered At: Date and time the order was placed (not paid for). This may be the date and time the auction was won
Column AG - Shipped At: Date and time the order was shipped (even if it was not shipped via Lister)
Column AH - Paid At: Date and time the order was paid
Column AI - Packing Slip Printed At: Date and time the last packing slip for the order was printed
Column AJ - Order Cancelled At: Date and time the order was canceled, if applicable
Column AK - Channel Fee Or Credit Amount: Any fee or credit amount associated with the listing, or checkout process of an item. This is most often seen on eBay orders
Note: This is different from the Final Value Fee (column Z). A typical use-case for this column is comparing transaction fees for eBay orders
Column AL - Pick And Pack Status: Current status of the order if using Digital Picking and Pack Mode
đĄOperational Tip: Sum columns M (Handling total) and K (Shipping Total) and compare that value to the sum of column L (Shipping Label Total) to determine if you are breaking even on what youâre charging buyers for shipping vs the actual shipping cost of your packages.
Related Guides
Have questions? Reach out to us at support@uprightlabs.com or via chat anytime between 9am-6pm ET, Monday to Friday