Store
Magpie reports what your Store sold and earned. It keeps a record of what each customer has bought.
Reports show a Store's sales, Stripe fees, margins, stock, buyers and visits for any dates. Each table downloads as a CSV file. The customer list shows everyone who has paid for an order, with their orders and spending. Product feeds list your products in Google Merchant Center and Meta catalogs.
Create account
Sales and Stripe fees
You choose a range such as Last 30 days or This year, or your own dates. An order counts on the day it was paid, and a refund on the day it was made. Days start at midnight in the team owner's time zone.
You can let other members see reports, costs and margins with the See reports permission.
- Net and total sales
- Net sales is gross sales less discounts and refunds. Total sales adds shipping and tax.
- Orders and units
- Reports count paid orders, their average value before shipping and tax, and units sold.
- Stripe fees and payouts
- Stripe fees are what Stripe took from these payments. Paid out from Store sales is the part of Stripe payouts that reached your bank. Magpie takes 4% of each Store order.
- In Accounting
- When you keep your books in Accounting, each paid order is added to them. It is split between Sales, Shipping income and Sales tax payable, and the items' cost moves to Cost of goods sold.
Products, margins and stock
The Products table lists each product or variant sold, with units, sales after discounts, page views, cost of goods and margin.
- Cost of goods
- Cost of goods uses the variant's average cost per item when each unit sold. A product sold without a cost shows its margin as Unknown, not as if the cost were zero.
- Stock value
- Stock value is the units on hand now times each variant's average cost.
- Sell-through
- Sell-through is units sold in the range as a share of those units plus the units on hand now.
Buyers, visits and where sales came from
- New and returning buyers
- Buyers are told apart by email address. A buyer is new when their first paid order is in the range, and returning when they had paid before.
- Visits and conversion
- Visits are views of the Store's home, product and collection pages. Conversion is orders as a percentage of those views. No cookie is set and nothing about a visitor is stored.
- Sales by source
- Sales by source groups orders by the campaign tags on the link a buyer followed, such as utm_source. Otherwise it uses the website that linked to the Store.
CSV exports and the weekly summary email
Export CSV on each table downloads it for the chosen dates, including buyers with their email addresses.
With the weekly summary on, you will get an email each Monday after 07:00. It compares the past week's net sales, orders, refunds, views and conversion with the week before, and lists the best sellers. The assistant on the Dashboard can also summarise Store sales for any dates.
Customers and segments
The customer list has everyone who has paid for an order, one row per email address. Members you give Manage customers can open it too.
- A customer's page
- A customer's page shows their orders, what they have spent after refunds, saved addresses, gift cards and store credit. It shows whether they agreed to marketing email. Name, phone, tags and notes edit in place, and only your team sees them.
- Add to Contacts
- You can make a contact from the customer's name, email and phone, linked to the customer. A customer is never linked to a contact automatically.
- Segments
- You can filter by amount spent, number of orders, a product bought, days since the last order, a tag or marketing consent. Saved filters are a segment, and a discount can be limited to one.
- Export CSV
- Export CSV downloads the customers shown, or a segment's, with their contact details, orders, spending, tags and marketing consent.
Export or erase a customer's data
For a data request, Export personal data downloads everything the Store holds about one customer. That is their details, saved addresses, orders and gift cards, without the cards' codes.
Erase personal data replaces the customer's name, email, phone, tax IDs and addresses on their orders. It deletes their saved addresses, notes, tags and wholesale terms. Amounts, items, discounts and tax are kept, so orders and Accounting still add up. Erasing cannot be undone, and it does not change your Stripe records.
Product feeds for Google and Meta
Your Store has two feed addresses: one for Google Merchant Center, and one for a Meta catalog for Facebook and Instagram shopping. Each fetch reads the current prices, stock and links.
- What is listed
- A feed lists each variant for sale on a live product with an image, with its price, availability, images and link.
See your Store's sales.
Create a Magpie account and give your Store a name. Each order will appear in Reports once it is paid.