What can we help with?

💻 You can view Online Reports in the eTailPet system to see data on orders that came from your e-commerce platform.

Here is every Online Report you can view and use:

• Sales Tax Report
• Sales By Item
• Promo Code Report
• Emails
• Price Slash

Please Note: This article covers the second part of the Online Reports series. To learn about other Online Reports, click here for part 1 or here for part 3 of the series.

Part 1 covers these reports:

• Stripe Transactions
• Refunds
• Refunds (Legacy)
• Basic Transactions
• Sales Line Transactions

Part 3 covers these reports:

• Auto Order
• Auto-Order Detail
• End of Day
• Customer Pet Birthday Report

Accessing Online Reports

Here is how to open any of your online reports:

1. Click on Reports in the eTailPet main menu.
2. Scroll down to the bottom of the page for the Online Reports section.
3. Click on the report you want to view.

Sales Tax Report

The Sales Tax Report from online reports shows sales tax data for individual stores. 

Here is everything you can use and view in this report:

1. Start Date — By default, the report will show all-time data. If you want to view a specific time period, you can change the Start Date by clicking in the first date field.
2. End Date — To specify the time period for the data, you can click into the second date field to mark an end date.
3. Submit Button — After entering any filter, click on Submit to find matching data.
4. Show Number of Entries — You can view a certain number of entries per page in this report by selecting a number in this drop-list.
5. Clear Selection — If you have data entries selected, click on Clear Selection to unselect all of them.
6. Export — You can export your report as a CSV file by clicking on the Export button.
7. Select All — You can select all data entries in the table by clicking on the checkbox in the column header.
8. Select Individual — You can select an individual data entry in the table by clicking on the checkbox on the left of an entry.
9. Data Table — You can view the report's data in this table. This is every column you can view in this report:
   • Store — This column shows the store associated with the data.
   • Total Collected — This column shows the total amount the store collected in sales, including tax.
   • Taxable Sales — This column shows the total amount the store had in sales that were taxable.
   • Taxable Sales Adjustment — This column shows the dollar amount of tax adjustment applied to the sale.
   • Tax Collected on Sales — This column shows the dollar amount in tax collected from the store's sales.
   • Tax Collected on Refunds — This column shows the dollar amount in tax collected from refunds at the store.
   • Total Tax Collected — This column shows the total dollar amount the store collected in tax.
   • Total Sales Tax Collected — This column shows the total dollar amount the store collected in sales tax.
   • Total Local Tax Collected — This column shows the total dollar amount the store collected in local tax.
10. View Exports — The View Exports button in the upper right allows you to view a report showing past exported report files. Click here for more information about the Export Report, or read the Export Report section on the bottom of this article.

Sales By Item

The Sales By Item online report shows the sales data performance of individual products from your e-commerce platform. You can use this report to see what items are popular online and how they've been performing.

Here is everything you can use and view in this report:

1. Search Field — Enter a product's name, UPC, or internal identification number in this field to find matching results.
2. Start Date — By default, the report will show all-time data. If you want to view a specific time period, you can change the Start Date by clicking in the first date field.
3. End Date — To specify the time period for the data, you can click into the second date field to mark an end date.
4. Store Filter — You can filter the report's data to a specific store.
5. Private / Public — You can filter the report's data to just private products or public products in your catalog.
6. Submit — After entering any filter, click on Submit to find matching data.
7. Show Number of Entries — You can view a certain number of entries per page in this report by selecting a number in this drop-list.
8. Clear Selection — If you have data entries selected, click on Clear Selection to unselect all of them.
9. Export — You can export your report as a CSV file by clicking on the Export button.
10. Select All — You can select all data entries in the table by clicking on the checkbox in the column header.
11. Select Individual — You can select an individual data entry in the table by clicking on the checkbox on the left of an entry.
12. Data Table — You can view the report's data in this table. This is every column you can view in this report:
    • UPC — This column shows the product's UPC number.
    • Internal Item Number — If you have another internal identification system for products, the product's number will appear in this column.
    • Product — This column shows the product's name / description.
    • Quantity (QTY) — This column shows how many units of the product have been sold.
    • Subtotal — This column shows the total dollar amount of the product's sales before discounts.
    • Discounts — This column shows the total dollar amount that has been discounted across all transactions of the product.
    • Net Sales — This column shows the total dollar amount of the product's sales after discounts.
13. Navigate — If your report spans multiple pages, you can navigate between pages by clicking on the Page Number to skip to that page, or by clicking either Next or Previous.
14. View Exports — The View Exports button in the upper right allows you to view a report showing past exported report files. Click here for more information about the Export Report, or read the Export Report section on the bottom of this article.

Promo Code Report

The Promo Code report in Online Reports shows all promo code activity on your e-commerce platform. You can see how many times each code has been redeemed, how many unique customers each have had, the total dollar amount of sales, and more.

Here is everything you can use and view in this report:

1. Search Field — Enter a promo code in this field to find matching results.
2. Start Date — By default, the report will show all-time data. If you want to view a specific time period, you can change the Start Date by clicking in the first date field.
3. End Date — To specify the time period for the data, you can click into the second date field to mark an end date.
4. Store Filter — You can filter the report's data to a specific store.
5. Submit — After entering any filter, click on Submit to find matching data.
6. Show Number of Entries — You can view a certain number of entries per page in this report by selecting a number in this drop-list.
7. Clear Selection — If you have data entries selected, click on Clear Selection to unselect all of them.
8. Export — You can export your report as a CSV file by clicking on the Export button.
9. Select All — You can select all data entries in the table by clicking on the checkbox in the column header.
10. Select Individual — You can select an individual data entry in the table by clicking on the checkbox on the left of an entry.
11. Data Table — You can view the report's data in this table. This is every column you can view in this report:
    • Promo Code — This column shows the promo code for the corresponding data.
    • Number of Times Redeemed — This column shows the number of times the promo code has been redeemed on your e-commerce platform.
    • Unique Users — This column shows the number of unique customer users of the promo code. If one person used the same promo code twice, that would count as one unique user.
    • Total Gross Sales — This column shows the combined amount of sales from transactions that used the promo code.
    • Total Discount — This column shows the total dollar amount discounted from transactions due to the promo code.
    • Average Transaction Size — This column shows the average dollar amount of subtotals in transactions that used the promo code.

12. Navigate — If your report spans multiple pages, you can navigate between pages by clicking on the Page Number to skip to that page, or by clicking either Next or Previous.

13. View Exports — The View Exports button in the upper right allows you to view a report showing past exported report files. Click here for more information about the Export Report, or read the Export Report section on the bottom of this article.

Emails

The Emails online report shows data and activity of emails sent out to customers. You can use this report to track how your marketing or reminder emails are performing.

Here is everything you can use and view in this report:

1. Status Filter — You can filter the report's data to emails with a certain status:
   • Processing — The email is currently being processed to get sent to the recipient.
   • Delivered — The email has been successfully delivered to the recipient.
   • Not Delivered — The email was not delivered to the recipient. Check that the recipient email address is correct.
2. Recipient Email Field — You can filter the report's data to just ones that were sent to a certain recipient. Enter the receiving email address here.
3. Subject Contains Field — You can filter the report's data to just ones with keywords in the email subject. Enter the keywords here.
4. Submit — After entering any filter, click on Submit to find matching data.
5. Show Number of Entries — You can view a certain number of entries per page in this report by selecting a number in this drop-list.
6. Data Table — You can view the report's data in this table. This is every column you can view in this report:
   • Recipient — This column shows the email address that received the email.
   • Subject — This column shows the subject line of the email.
   • Status — This column shows the status of the email: Processing, Delivered, or Not Delivered.
   • Open Count — This column shows how many times the email was opened by recipients.
   • Clicks Count — This column shows how many times the email's contents were clicked on by recipients.
   • Last Event Time — This column shows the last date and time the email had a recipient interaction.
7. Navigate — If your report spans multiple pages, you can navigate between pages by clicking on the Page Number to skip to that page, or by clicking either Next or Previous.

Price Slash

The Price Slash online report shows all price slashes that have been applied to transactions during the specified time period. 

Here is everything you can use and view in this report:

1. Search Field — Enter the name of a price slash in this field to find matching results.
2. Start Date — By default, the report will show data for the current day. If you want to view a specific time period, you can change the Start Date by clicking in the first date field. Please Note: The Price Slash report cannot show data for a time period that is over 90 days.
3. End Date — To specify the time period for the data, you can click into the second date field to mark an end date. Please Note: The Price Slash report cannot show data for a time period that is over 90 days.
4. Store Filter — You can filter the report's data to a specific store.
5. Submit — After entering any filter, click on Submit to find matching data.
6. Show Number of Entries — You can view a certain number of entries per page in this report by selecting a number in this drop-list.
7. Clear Selection — If you have data entries selected in the table, click on Clear Selection to unselect all of them.
8. Export — You can export your report as a CSV file by clicking on the Export button.
9. Select All — You can select all data entries in the table by clicking on the checkbox in the column header.
10. Select Individual — You can select an individual data entry in the table by clicking on the checkbox on the left of an entry.
11. Data Table — You can view the report's data in this table. This is every column you can view in this report:
    • Price Slash — This column shows the name of the price slash.
    • Number of Times Redeemed — This column shows the number of times the price slash was redeemed on your e-commerce platform.
    • Unique Users — This column shows the number of unique users of the price slash. If one person used the same price slash twice, that would count as one unique user.
    • Total Gross Sales — This column shows the combined amount of sales from transactions that used the price slash.
    • Total Discount — This column shows the total dollar amount discounted from transactions due to the price slash.
    • Average Transaction Size — This column shows the average dollar amount of subtotals in transactions that used the price slash.
12. View Exports — The View Exports button in the upper right allows you to view a report showing past exported report files. Click here for more information about the Export Report, or read the Export Report section on the bottom of this article.

Export Report

If you click on the View Exports button in some online reports, you'll be redirected to the Export Report. This will show which reports have been exported as CSV files. Note that this report will only show data from the past 3 months.

1. Start Date — By default, the report will show data from the past 30 days. If you want to view a specific time period, you can change the Start Date by clicking in the first date field.
2. End Date — To specify the time period for the data, you can click into the second date field to mark an end date.
3. Status Filter — You can select from this drop-list to filter the data to reports of a certain status:
   
   • IN_QUEUE — The report is in queue for export and is not ready yet.
   • STARTED — The eTailPet system has started to export the requested report.
   • FINISHED — The file was exported and ready for download.
   • FAILED — The report failed to export.
4. Select Report — You can select from this drop-list to filter the data to just one report type.
5. Search Button — After entering any filter, click on Search to find matching data.
6. Show Number of Entries — You can view a certain number of entries per page in this report by selecting a number in this drop-list.
7. Sort by Column — You can sort the report's data according to a column by clicking on the Arrows icon to the right of each column name. Click once to sort in ascending order, or click again to reverse the sort.
8. Details — You can view the full details of each report by clicking on the Details button. This page will allow you to download a copy of the exported file and view the filters of the export.
9. Navigate — If your report spans multiple pages, you can navigate between pages by clicking on the Page Number to skip to that page, or by clicking either Next or Previous.
10. Data Table — You can view the report's data in this table. This is every column you can view in this report:
    • ID — This column shows the ID of the report.
    • Report Type — This column shows what type of report was exported. For example, SALES_LINES indicates the file was for a Sales Line Transactions Report.
    • Created At — This column shows the date and time the export was created.
    • Start Time — This column shows the date and time the export process started.
    • End Time — This column shows the date and time the export process finished.
    • Status — This column shows the status of the file export.

Related Topics

Online Reports 1

Online Reports 3

Sales and Refund Reports 1

Sales and Refund Reports 2

Sales and Refund Reports 3

Reports Overview

Frequently Asked Questions

Q: Does the online Sales Tax Report include tax from my in-store sales?

A: No. Online Reports only cover orders that came through your e-commerce platform. For in-store tax data, use the Sales and Refund reports instead.

Q: What's the difference between Subtotal and Net Sales in the Sales By Item report?

A: Subtotal is the total of the product's sales before discounts are applied. Net Sales is the total after discounts. The Discounts column between them shows the amount taken off across all of that product's transactions.

Q: A customer used the same promo code on three separate orders. How does that count?

A: It counts as three under Number of Times Redeemed but only one under Unique Users. The same logic applies to the Price Slash report.

Q: An email shows as Not Delivered. What should I do?

A: Start by checking that the recipient's email address is correct in their customer record. Processing means the email is still being sent, and Delivered means it reached the recipient successfully.

Q: Why can't I pull a full year of Price Slash data?

A: The Price Slash report can't display a time period longer than 90 days. To review a longer stretch, run the report in separate date ranges of 90 days or less and export each one.

Q: I exported a report but never got the file. Where can I check on it?

A: Click View Exports in the upper right of the report to open the Export Report, which lists your exports from the past 3 months. In Queue or Started means it's still processing, Finished means it's ready to download from the Details page, and Failed means you'll need to run the export again.

Q: I have a question, but I can't find my answer here. How do I get more assistance?

A: You can ask any question at the number listed here. Contact our support team at (323) 370-0738 for the U.S. and (888) 370-2363 for Canada.