Access my detailed sales information

Updated -

Not sure how much business your business is doing? Download all the details you need to track your sales and profit by going to Account Settings > Business > Selling > Sales History > Manage.

There are two different CSV files you can download: "Detailed" and "Summary."  If you specify a certain date range or Paid/Unpaid status on your Sales History, the Filtered CSVs will reflect that.

Need some help interpreting the spreadsheets? Check out the detailed guides below!

Detailed CSV

This sheet details every order item you've sold. It contains line-by-line breakdowns of all your orders, but it doesn't give information that's common to every item. See the summary sheet for that info.

Column Name Meaning and Notes
OrderID The order's unique identifier.
Date When the order was placed.
Quantity How many of this item were ordered.
Base Price What does each instance of this item cost.
Price Charged What did you charge for each instance of this item.
Profit What is your estimated profit for this row (already multiplied by quantity).
Charges How much we will charge your credit card for this item.
Sales Tax How much tax we collected and will pass along to you. See our help page on sales tax collection.
Type What type of item is this. Possible values include Sale and various adjustments, coupons, and value-add features. See chart below for details.
Name The name of the item being described by this row.
Payment Status The status of paying the profit for this order.
One of: Paid, Paying, or NotPaid.
Paying means we are in the process of sending you payment for this item; usually that indicates that you are being paid for this item this month.
Can also be Pending, Ready, Charged, Credited or Voided for charges. Pending means the charge has been created, but is not ready to be captured, this is the case before a print order ships for example. Ready means the associated item has shipped, and the charge will be rolled up in the next batch of charges.
Payment Date If the profit for this order has been paid, when was it paid. Or if this is for a charge, when it was captured.
Note that this date may be a couple weeks after the direct deposit payment was initiated, or it might be a couple days before the check went out in the mail.
Payment Info If the profit for this order has been paid, this will indicate what batch or check it was paid under.
If this looks like a date, then it's most likely a direct deposit batch. If it looks like a number, then it's most likely a check number.
There may also be notes here in some rare cases.
Link link to the image.
Filename filename of the image.
ImageID of the image.
AlbumID of the album the image is in.
Gallery Title of the album the image is in.
Category Hierarchy of the album the image is in. Includes Category and Subcategory (if set) separated by /
Type Meaning
Sale This row type represents a single sale.
various coupons When your customer uses a coupon, it will be shown here. The name will contain the code used, and the title the coupon had at the time it was used.
various adjustments Anything that would adjust your profit is listed as a separate adjustment. This could include coupons, branding charges or administrative adjustments. The name will often indicate what the adjustment is related to.
various feature use fees Some features, such as Branding and Coupons, can cause an order to cost you money. While those fees are taken first from the order's earned profit, if there is not enough, the overage will be charged to your credit card directly. These overage amounts are collected and billed periodically and this record reflects those costs. In these cases, the name may indicate the name of what the charge relates to, such as a coupon. The last three columns, the payment information, will represent when these charges are billed against your credit card on file.

Many items will result in several rows to present different views of the same event. Coupons for example can present both a coupon usage and an adjustment as seen here:

  A B C D E F G H I J
  OrderID Date Quantity Base Price Price Profit Charges Sales Tax Type Name
13 1955 May 24... 1 99.51 150.00 42.92     Sale 16 x 24 Float Mounted MetalPrint - High Gloss
14 1955 May 24... 1 301.50 400.00 83.73     Sale 30 x 40 Float Mounted MetalPrint - High Gloss
15 1955 May 24... 1 140.50 200.00 50.58     Sale 24 x 36 Print (Giclée Watercolor)
16 1955 May 24... 1 3.23 75.00 61.00     Sale 8 x 10 Print (Lustre)
17 1955 May 24... 1   -280.26       At Cost Coupon cabATCost: Cabbey's prints AT COST
18 1955 May 24... 1     -238.23     Coupon Adjustment cabATCost: Cabbey's prints AT COST

In this sample section my customer bought several prints, but used an at cost coupon. We see the sales in rows 13-16. The coupon usage in row 17, and the effect that coupon had on my order profit on row 18. Had they used a different type of coupon, such as a print credit that was good for more than my profit, you may also then have seen a charge:

  A B C D E F G H I J
  OrderID Date Quantity Base Price Price Profit Charges Sales Tax Type Name
58 2134 Apr 27... 3 107.45 150.00 108.50     Sale 24 x 30 Ready-to-Hang ThinWrap (Metallic/Satin)
59 2134 Apr 27... 1   -270.00       60% Off Coupon res54as83ds789: Big Break discount
60 2134 Apr 27... 1     -108.50     Coupon Adjustment res54as83ds789: Big Break discount
61 2134 Apr 27... 1       -142.35   Coupon res54as83ds789: Big Break discount
62 2134 Apr 27... 1       -1.00   Branding  
63 2134 Apr 27... 1         12.38 Sales Tax 6.875%

Here you can see the customer ordered 3 copies of a large canvas with a marked up price of $150. That would have landed me $108.50 profit, but they also used a large 60% off coupon. Row 59 shows that coupon saved them $270, row 60 shows that it ate away all $108.50 of my profit, row 61 shows that the remainder of the cost of the prints, 142.35, was charged to me, and finally row 62 shows that I also paid $1 to have the package branded with my studio logo. Additionally, my state sales tax was collected on the order at 6.875% of the post coupon value as row 63 shows.

Summary CSV

This sheet summarizes your orders. There's a line for each one, but it does not get into details about what was IN the order. See the details sheet for that info.

Column Name Meaning and notes
OrderID The order's unique identifier.
Date When the order was placed
Customer Email The customer's email address. 1
Billed Name Who paid for the order. 2
Billed Street1 Address information for the payment. 1
Billed Street2 ... 1
Billed City ... 1
Billed State ... 1
Billed Zip ... 1
Billed Country ...
Billed Phone ... 1
Shipped Name Who was the order shipped to. 2
Shipped Street1 Address the order was shipped to. 1
Shipped Street2 ... 1
Shipped City ... 1
Shipped State ... 1
Shipped Zip ... 1
Shipped Country ...
Shipped Phone ... 1
Quantity The count of items ordered.
Base Price The total cost of the prints and merchandise in the order.
Price Charged The total of what you charged the customer.
Est. Profit The estimation of your profit for the order, with adjustments.
Charges Sum of any charges to your credit card as a result of this order.
Total Sales Tax If any tax was collected for this order, the portion of it that belongs to your portion of the order (in the case of a multi-pro order), though it will display CA tax as well as tax for your state.  See footnote. 3
Shipping Method What shipping method was used. One of FC, PM, SD, ON.  For domestic orders, these roughly correspond to 6-10 business day, 3-5 business day, 2 business day, and 1 business day shipping, respectively.  See our shipping page for further information on methods.   For International orders, there are typically just two shipping options so FC or PM translates to "slower, untrackable" shipping and SD or ON translates to "faster, trackable" shipping.
Shipping Cost The portion of the order's shipping and handling that belongs to your portion of the order (in the case of a multi-pro order).
Profit Status See above section on Detailed CSV, plus one additional possibility: Mixed.
If you see Mixed, you will need to consult the Detailed CSV; usually this is the case when we have paid you for an order, and then there was an administrative adjustment after we had already paid you.
Profit Date See above, same field in Detailed CSV.
Profit Info See above, same field in Detailed CSV.
Order Link link to the order in your sales history.

Footnotes

  1. In the case of non-marked up sales, this information is not provided. The exception is if you are collecting sales tax, the state will be presented so you can tell if that sales tax should be reported to your tax authority, or if we included it in our report to the State of California.
  2. In the case of non-marked up sales, this information is slightly anonymized.
  3. The Summary sheet includes sales tax collected for your state (if enabled) and also any sales tax collected for California sales, though these are handled by SmugMug and not remitted to you.

Filenames

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

  Nickname static filename Filters (optional) Details (optional) extension
  nickname -SmugMug-sales -(paid status)-(time period) -detailed .csv
1 cabbey -SmugMug-sales -Paid-LastYear   .csv
2 schmootography -SmugMug-sales   -detailed .csv

Example 1 is what user cabbey would get if he set the filters at the top of the page to Paid and Last Year, then downloaded the filtered summary CSV.

Example 2 is what user schmootography would get if she downloaded the all time Detailed CSV.

Can't find what you're looking for?

Our Support Heroes are ready to help!

Contact Us