Overview
The Shopify Listings report is a downloadable .csv history of all your listings to your Shopify store within a given date range. The report includes auction names, listing dates, number of bids, starting and current price, listing status, and more.
Table of Contents
How to Access the Shopify Listings Report
Click the reports icon in the top right corner of Lister to navigate to the Reports page
Click “Shopify Listings” in the left column
How to Download the Shopify Listings Report
The Shopify Listings report will populate data based on your selected criteria below.
Between: Select a date range for when the listings were created in Lister.
Note: Listings will populate based on the date they were created in Lister, not the date they were published to the marketplace
Timezone: Select your desired timezone for the report
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 - Product SKU: Product SKU of listing
Column B - Title: Listing title as it appears on Shopify
Column C - State: Current state of the listing, as defined below:
Pending: Listing is awaiting approval to list via the Pending Listing Review feature
Listed: Listing is currently active on Shopify
Listing Failed: Listing is awaiting action the the “Attention Required” tab of the Shopify Listing Manager
Relisting Failed: Relisted item awaiting action in the “Attention Required” tab of the Shopify Listing Manager
Delisted: Listing was manually ended by a user, or an automated action by Lister
Expired: Listing ended without bids and is awaiting the next step of the Listing Strategy, or manual relist
Sold: Listing sold and purchased by the buyer
Unpaid: Listing sold and is awaiting payment from the buyer
Purged: Listing either went unpaid and was automatically relisted or reached the end of the Listing Strategy without a sale. These listings will appear in the Recycled tab of the Listing Manager. Important Note: This is NOT the same as a purged Product!
Column D - Inventory Location: Shows the current Lister inventory location for the associated Product
Column E - Price: Current price of the item, set at the point of listing, via a Listing Strategy, or via a Price Override
Column F - Compare at Price: Displays the current Compare at price, set chosen at the point of listing, or via a Price Override
Column G - Quantity: Shows the quantity level set at the point of listing
Column H - Barcode: Indicates if the manufacturer’s barcode was added to the listing
Column I - Product Type: Shows what Lister Category the item was listed to
Column J - Template Suffix: Indicates if a custom Shopify store template was used when listing the item
Column K - Fulfillment Service: A Fulfillment Service is a third-party warehouse that prepares and ships orders on behalf of the store owner
Note: If you fulfill your own orders, this column will display “Manual” for each of your listings
Column L - Inventory Management: Shows “Shopify” if the inventory is tracked by Shopify. Inventory can be tracked by store location(s) and/or third-party fulfillment service(s)
Column M - Inventory Policy: Indicates if the listing can be purchased once out of stock
CONTINUE: Customers can buy this product variant after it's out of stock
DENY: Customers can't buy this product variant after it's out of stock
Column N - Tax Code: Indicates what tax code (if any) is assigned to the Shopify product
Column O - Options: Indicates if any additional options were added to the listing
Column P - Shopify Tags: Provides a list of all tags assigned to the listing
Column Q - Relist Count: Indicates how many times the item has been relisted
Column R - Collections: Shows what Shopify collection the item was assigned to
Column S - Shopify Account: Shows the name of your Shopify store
Column T - Shopify Product ID: Shopify listing number
Column U - Shopify Variant ID: Alternative Product ID number (if available)
Column V - Start Time: Starting date and time of the listing
Column W - End Time: Ending date and time of the listing
Column Y - Poster: Teammate who created the listing
Column Z - Supplier: Origin store/supplier of the Product, unless manually changed at the point of listing
Column AA - Listing Strategy Step: Indicates what step of the Listing Strategy the listing is on, starting at zero for the first step, 1 for the second step, and so on. A blank entry indicates the listing was posted without a Listing Strategy
Column AB - Currency: Shows what currency the price and compare at price (columns E and F) are displayed in
Column AC - Shopify Product Status: Shows if the product is archived or active in Shopify
Related Guides
Have questions? Reach out to us at support@uprightlabs.com or via chat anytime between 9am-6pm ET, Monday to Friday