Skip to main content

Customizing Reports with the Column Chooser

Pick which columns show on your Profit & Loss report.

You can choose which columns show in a report, so you only see what matters to you.

How to add or remove a column

  1. Click Run Report.

  2. Click Columns at the top right of the table.

  3. Tick a column to show it. Untick it to hide it.

  4. To move a column, drag its header.

Columns you can add

Product details

SKU, FNSKU, Item ID, Title, Store, Category and Sub Category, Fulfillment Channel, Season, Buyer and Order Type. Shopify stores get Gateway.

Item Category, Brand, Manufacturer and Vendor show when you pick ConnectStock customers or files, or display items by ConnectStock item name.

Sales and units

  • Net Sales: Sales minus refunds, plus or minus adjustments.

  • Total Units: units that actually moved in or out of your stock.

  • Order Count: number of orders (not units).

Ads

  • Ad Sales (same day), Ad Sales 7 Days and Ad Sales Same SKU.

  • TACOS: Ad Spend ÷ Sales.

  • POAS: Profit ÷ Ad Spend.

  • Organic Sales: Sales minus ad sales from the same day.

Amazon traffic

  • Page Views: how many times your listing was viewed.

  • Real Conversion Rate: orders ÷ sessions. (Conversion Rate, shown by default, counts units.)

Each fee on its own

Every fee your store has, such as the FBA fulfillment fee or the referral fee, can be its own column. The same goes for each type of sale, quantity, ad and cost. This list depends on what's in your store.

Frequently asked questions

I don't see a column listed here.

Some columns only show for certain stores. Fee columns only show for fees your store actually had.

Can I save my column setup?

Yes. Save it as a report template. See "Save and Update Report Templates".

What do the default columns mean?

Did this answer your question?