MestraMestra
All posts

CRM for Online Stores and Retail: Products, Variants, Orders, Returns and Profit

Reviews6 min read

CRM for an online store: variants with SKUs, purchase price and margin, product marking, stock by warehouse, orders and returns, Ozon, WB and Yandex Market.

M
Mestra Team
Mestra CRM for an online store: a product with variants, cost price and margin

A CRM for an online store is a system where every product has variants with an SKU, a barcode and stock at each warehouse, a purchase price and a margin, and every client has a history of orders, returns and warranty claims. The owner sees not only how much was sold, but how much was earned on each product and channel.

Orders come from the website, Ozon, Wildberries, Avito and direct messages, stock is kept in a spreadsheet, and the owner finds out the profit from the accountant at the end of the quarter. This article covers the product fields, orders, warehouses and marketplaces a seller should check when choosing a system.

One-minute check

  1. Does the product have a purchase price and an automatically calculated margin?
  2. Are size × colour variants created with separate SKUs and stock?
  3. Is stock visible for each warehouse?
  4. Does the system warn about selling below cost?
  5. Do orders and messages from marketplaces arrive in one system?

The product: price, cost and margin

In this industry, the Products section is called "Goods", with an "Add product" button. On the Prices tab:

Field Example
Selling price 2,500 ₽
Purchase price 1,400 ₽
Delivery to the warehouse, packaging, customs 100 ₽
Cost price 1,500 ₽ — calculated automatically
Markup and margin +1,000 ₽, 40% of the price — calculated automatically
VAT rate No VAT, 5%, 7%, 22%

If the margin is negative or below 10%, it's highlighted in red. When a manager gives a 30% discount on this product, the system warns: "selling below cost". In each order in the client history you can see: revenue 2,500 ₽, cost 1,500 ₽, profit 1,000 ₽. The "Most profitable products" report shows what makes money, not just what sells. More in our article profit by product.

Variants and product marking

On the Variants tab, sizes and colours become a table: each combination gets its own SKU, barcode, stock and price. Weight and dimensions are entered as numbers in kilograms and centimetres — for calculating delivery.

The product card has Barcode and Marking fields for the Chestny Znak system: mandatory marking applies to clothing, footwear, perfume, tyres and a number of other categories. Warranty is set in months.

Warehouses and suppliers

Stock is tracked for each warehouse, and a minimum stock level is set for the product. When stock falls below it, the responsible person gets an "Order from supplier" task, and the product appears in the "Below minimum" list. The supplier is a link to a card in the base. Transfers between warehouses are recorded in the movement log. More in our article multi-warehouse inventory.

The client and order history

Client type — retail, wholesale or corporate; for wholesale and companies, the tax ID is stored. The Purchases tab holds the client's sizes and purchase channel (website, shop, Ozon, WB, Avito, Instagram*). The last purchase, total purchases, average bill and status are calculated automatically.

Record What it captures
Order Items, delivery, amount; new → paid → packed → shipped → delivered / returned
Return Product, reason, amount
Request Warranty claim or complaint

Marketplaces: publishing and orders

From the Standard plan, products are published to Ozon, Wildberries and Yandex Market straight from the product card in Mestra, and orders flow back into the system. Buyers' messages from the platforms land in the shared feed next to MAX, Telegram and VKontakte.

Real profit on a marketplace is the selling price minus the platform's commission, logistics and cost. A 2,500 ₽ product with a 22% commission and 180 ₽ logistics earns not 1,000 ₽ but 270 ₽. In Mestra, commission and logistics are added as costs of the sale, and profit is calculated separately for each channel.

Process templates

  • Order: new → payment → packing → handed to delivery → delivered → review.
  • Return: request → received → inspection → refund → back to the warehouse.

Rules like "ask for a review 7 days after delivery" or "if the cart is abandoned, send a reminder the next day" are set up without a developer. Mailings go only to clients who have given consent.

Example: a bestseller that doesn't make money

A store sells 600 blankets a month at 1,900 ₽ — its bestseller. But a cost of 1,300 ₽, a 25% platform commission (475 ₽) and 120 ₽ of logistics leave 5 ₽ of profit per blanket. Without the purchase price in the CRM, this product would look like the best in the range.

How it works in Mestra

At sign-up, choose the "Retail and online stores" industry — Goods with variants, prices and margins, warehouses, order history and templates appear straight away. The Economy plan costs 390 ₽ per user per month incl. VAT. Ozon, Wildberries and Yandex Market are connected from the Standard plan; 1C and YooKassa on the Pro plan.

Related reading: markup and margin, inventory tracking.

CRM for an online store: questions from Wildberries, Ozon and messengers in Mestra

FAQ

Is the CRM suitable for a physical shop?

Yes. Products, variants, warehouses and clients work for a corner shop and for a retail chain alike — each location is managed as a branch.

Can you sell in instalments?

Yes. A payment schedule is set on the invoice, the client gets reminders, and the remaining debt is visible on the Debts tab.

How do you avoid selling something that's out of stock?

Stock is tracked by warehouse and variant and written off automatically on sale.

Bottom line

An online store grows when it knows the profit of every product and channel, not just turnover. A CRM with cost, variants, warehouses and marketplaces in one window gives you that picture every day. Upload your products to Mestra and calculate your margins today: 15 days free, no card required.

Instagram is owned by Meta, which is recognised as extremist and banned in Russia.

Keep reading

Sign up for a demo and see it in action

Niche analysis with ready scenarios and fields

Sign up for a demonstration

Leave your contacts and we will schedule a short demo.