Overview
The downloadable Orders report is a complete history of all orders in Lister within a specified date range. Unlike the Paid Orders report, this report does not factor in the payment status of orders, and also includes the full billing address of the order. In addition, the Orders report includes orders from all your connected marketplaces.
This help article outlines how to access, download, and understand all of the data available in the Order report.
Table of Contents
How to Access the Orders Report
Click the reports icon in the top right corner of Lister to navigate to the Reports page
Click “Orders” in the left column
How to Download the Orders Report
The 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
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
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 - Total: Total amount that the customer paid. Sum of Subtotal, Shipping Total, Handling Total, Tax Total, and Donation Total
Column E - Shipping Contact: Name of the customer entered for the shipping address
Column F - Shipping Company: Company on the address line, if applicable
Column G - Shipping Address 1: First line of the shipping address
Column H - Shipping Address 2: Second line of the shipping address, if applicable (i.e. Apartment 2)
Column I - Shipping Address 3: Third line of the shipping address, if applicable (i.e. Attn: XX)
Column J - Shipping Country: Destination country
Column K - Shipping Region: Destination region/state
Column L - Shipping City: Destination city
Column M - Shipping Postal Code: Zip code or postal code of destination address
Column N - Shipping Phone Number: Phone number entered by the customer for shipping
Column O - Billing Contact: Name of the customer entered for the billing information
Column P - Billing Company: Company name on the billing address line, if applicable
Column Q - Billing Address 1: First line of the billing address
Column R - Billing Address 2: Second line of the billing address, if applicable (i.e. Apartment 2)
Column S - Billing Address 3: Third line of the billing address, if applicable (i.e. Attn: XX)
Column T - Billing Country: Country location of the billing address
Column U - Billing Region: Billing address region/state
Column V - Billing City: Billing address city
Column W - Billing Postal Code: Zip code or postal code of billing address
Column X - Billing Phone Number: Phone number entered by the customer for billing information
Column Y - Subtotal: Total amount the customer paid for the items in the order
Column Z - Shipping Total: How much the customer paid for shipping
Column AA - Shipping Label Total: How much you paid to ship the order via EasyPost in Lister
Column AB - Handling Total: Total handling fee the customer paid for the order (Shopgoodwill only)
Column AC - Tax Total: How much tax was paid by the buyer
Column AD - Buyer ID: This an identifier for the customer who purchased the order
Column AE - 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 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 - Cancelled At: Date and time the order was canceled, if applicable
Column AJ - 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 AK - Shipping Tracking Number: Tracking number for the shipment
Column AL - Order Items Count: Sum of total purchased items within the order
Column AM - Donation Total: Roundup total on the order (Shopgoodwill only)
Column AN - Packing Slip Printed At: Date and time the last packing slip for the order was printed
Column AO - Secondary 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 AP - Payment ID: The ID associated with the order (eBay Only)
Column AQ - Payment Type: How the payment was processed (typically Credit Card or Paypal)
Column AR - Final Value Fee: Fees charged by the channel (eBay only)
Column AS - 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 AT - Refund Amount: Total refund amount applied to the order
Column AU - 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 AR). A typical use-case for this column is comparing transaction fees for eBay orders
Related Guides
Have questions? Reach out to us at support@uprightlabs.com or via chat anytime between 9am-6pm ET, Monday to Friday