Access my detailed sales information

Want to track your sales performance and profit? Access comprehensive sales data by navigating to the Selling Tools > Sales History > Manage, where you can download detailed reports.

• Detailed CSV Introduction
  • Detailed CSV Column Definitions
• Type Reference Chart
• Detailed CSV Examples Section
• Summary CSV Introduction
  • Summary CSV Column Definitions
• Footnotes
• File Naming

You can download two types of CSV files:

• Detailed CSV: Line-by-line breakdown of every order item
• Summary CSV: High-level overview of complete orders
   

Back to Top 

Detailed CSV Introduction.

The Detailed CSV provides a lin-by-line breakdown of every individual item sold across all your orders. Each row represents a single item, coupon, or adjustment from an order, including sales, adjustments, coupons, and fees. For order-level information like shipping addresses and totals, refer to the Summary CSV.

Detailed CSV Column Definitions.

Back to Top

Type Reference Chart.

Back to Top

Detailed CSV Examples Section.

Complex transactions may generate multiple rows to show different aspects of the same event. For example, when a customer uses a coupon, you'll see separate rows for the original sale, the coupon usage and the profit adjustment:

In this example, a customer purchased several prints and used an at-cost coupon. The data breaks down as follows:

• Rows 13-16: Each row represents the sale of a different print product, showing the base price, the price charged to the customer, and the profit earned from each item.
• Row 17: Displays the coupon usage. This reflects the value of the discount applied at checkout.
• Row 18: Shows how the coupon reduced your profit. The entire profit from the sale was offset by the coupon.

Because the total discount was equal to or less than the total profit, no additional charge row appears. This is key: when an at-cost coupon only eats into your profit, you're not charged out of pocket. However, if the discount exceeded your profit, you would see a separate charge row reflecting the remaining cost covered by you.

This example shows a more complex scenario: Row 58: A customer ordered 3 large canvas prints at $289.53 each (marked -up price), which would normally generate $120 in total profit. However, they used a 60% off coupon, creating the following breakdown:

• Row 59: Coupon discount of $521.15 applied to the customer
• Row 60: Your profit of $120 was eliminated entirely by the discount
• Row 61: the remaining $401.15 of the discount (beyond your profit) was charged to you.
• Row 62: A $1 branding fee was charged for custom branding.

This demonstrates how large coupon discounts can result in charges to your account when the discount exceeds your profit margin.

Back to Top

Summary CSV Introduction.

The Summary CSV provides one row per order with complete order totals and customer information. This gives you the big picture view of each transaction, while the Detailed CSV breaks down individual items within each order.

Summary CSV Column Definitions.

Back to Top

Footnotes.

1. Customer information is limited for non-markup sales to protect privacy. However, billing state is always shown when sales tax is collected so you can determine your tax reporting obligations.
2. Shipping information is anonymized for non-markup sales to protect customer privacy.
3. The Summary sheet shows sales tax for both your state (if enabled) and California. California tax is handled by SmugMug and not remitted to you.

File naming.

When you download these CSV files, the filenames are of the following pattern:

Example 1: User "cabbey" applies filters for "Paid" status and "Last Year" date range, then downloads the Summary CSV. The filename would be: cabbey-SmugMug-sales-Paid-LastYear.csv 

Example 2: User "cabbey" applies the same filters ("Paid" and "Last Year"), but downloads the Detailed CSV instead. The filename would be: cabbey-SmugMug-sales-Paid-LastYear-detailed.csv

Back to Top