Overview
The refunds report in Lister is the source of truth for all refunds processed within a given time period. Unlike the Paid Orders report, which pulls data based on the paid date, the Refunds report is generated based on the date a refund was processed and should be used when determining the number of refunds within a given timeframe.
Table of contents
How to Access the Refunds Report
Click the reports icon in the top right corner of Lister to navigate to the Reports page
Click “Refunds” in the left column
How to Download the Refunds Report
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
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 3, above)
Definitions of Report Columns
Column A - Upright Order Id: The ID associated with the order in Upright Lister
Column B - Channel: The channel on which the order sold (i.e. Shopgoodwill, eBay, etc.)
Column C - Channel Order Id: The ID associated with the order in the sales channel
Column D - Secondary Channel Order Id: This is eBay-specific and ties to the "Sales Record Number" on the order
Column E - Channel Item ID: The ID associated with the item in the channel (Shopgoodwill and Shopify only)
Note: eBay Reports refunds at the order level, and does not pass item information on the API with refunds. As a result, eBay refunds in this report do not show the item ID
Column F - Channel Order Item ID: Typically the same as the channel item ID, but certain channels like Shopify may provide a secondary ID for the item once it is associated with an order
Column G - Channel Buyer Id: This is an identifier for the customer who purchased the order
Column H - Order Payment Id: The payment ID associated with the order (eBay Only)
Column I - Order Payment Type: How the payment was processed (typically Stripe or Paypal)
Column J - Upright Refund ID: ID associated with the refund in Lister
Column K - Channel Refund ID: ID associated with the refund in the channel (not all channels have this)
Column L - Channel Refund Item ID: Some channels record refunds on an item level. In the event that one item was refunded in a multi-item order, the Channel Item ID may be displayed in this column
Note: Shopgoodwill and Shopify record refunds at the ITEM level, whereas eBay records refunds at the ORDER level. eBay refunds do not link back to the original item number
Column M - Refund Reason: Reason entered for processing the refund (Shopgoodwill and Shopify only)
Column N - Order Paid At: Date and time the order was placed (not paid for). This may be the date and time the auction was won.
Note: The timestamp will reflect the time zone selected when generating the report
Column O - Refund Date: Date and time the order/item was refunded.
Note: The timestamp will reflect the time zone selected when generating the report
Column P - Refund Item Amount: Amount refunded
Column Q - Full Refund: True or false. If all of the money paid for the order was refunded, it is considered a full refund and will read TRUE. If only part of the money or part of the items in the order were refunded, it is considered a partial refund, and this column will read FALSE
Column R: Currency Code: The currency that the refund price values appear in. This is typically USD, but can also be other values, such as CAD for Canadian Dollars
Column S Order Final Value Fee: Refunded Final Value fee from eBay, if present (eBay only)
Related Guides
Have questions? Reach out to us at support@uprightlabs.com or via chat anytime between 9am-6pm ET, Monday to Friday