How to Manage Orders, Inventory and Invoices in an Estonian Store
A step-by-step routine for a small online store: one stock record, a daily order flow, invoices created from order data and a monthly check that catches errors.
Updated , 4 min read, by the Cart editorial team
The short answer
- Keep one source of truth for stock and make every sale, return and delivery update it.
- Run orders through the same fixed steps every day: confirm payment, pick, pack, label, hand over, mark shipped.
- Create invoices from order data rather than typing them, and reconcile stock and payouts once a month.
To manage orders, inventory and invoices in a small online store, keep a single stock record, process orders through the same steps every day, and generate invoices from order data instead of typing them. The tools matter less than the routine. A store that follows a fixed routine with simple tools makes fewer mistakes than one with advanced software and no habits.
Step 1: Set up one source of truth for stock
Decide where the real stock number lives. It can be your store platform, a business app or, at the very beginning, a spreadsheet. It cannot be two of them.
For each product, record:
- a unique code (SKU) that never changes;
- the quantity on the shelf;
- where it is stored, if you have more than one shelf or room;
- a reorder point, meaning the quantity at which you order more.
Give variants their own codes. A shirt in three sizes is three stock items, not one.
Step 2: Make every stock movement update that record
Stock goes wrong when things move without being recorded. There are only a few kinds of movement, so name them and decide how each is logged.
| Movement | What happens | How to record it |
|---|---|---|
| Sale | Order is paid | Store reduces stock automatically |
| Delivery from supplier | Goods arrive | Count the goods, then add the counted quantity |
| Customer return | Item comes back | Inspect, then add back only if sellable |
| Damage or loss | Item cannot be sold | Write off with a short note |
| Sale in another channel | Sold at a market or on a marketplace | Reduce stock the same day |
The last row causes most overselling. If you sell from the same shelf in more than one place, either connect the channels so they share stock, or reserve separate quantities for each.
Step 3: Process orders the same way every day
Pick a fixed time for order handling and follow the same sequence.
- Confirm payment. Only pack orders that are paid, or that are on agreed invoice terms.
- Print a pick list. Group the day's orders so you walk the shelves once.
- Pick and check. Compare each item to the order line, including variant and quantity.
- Pack. Use the smallest packaging that protects the product, since parcel locker pricing depends on size class.
- Label. Generate the shipping label from the order so the locker and phone number are not retyped.
- Hand over. Drop parcels at a locker or hand them to the courier according to your contract.
- Mark as shipped. This triggers the buyer's notification and keeps your order list honest.
Publish a dispatch promise you can keep, such as orders placed before a certain hour ship the same working day, and then keep it. Predictable dispatch reduces "where is my order" messages more than anything else.
Step 4: Create invoices from order data
Every sale needs a document. Consumers usually receive an order confirmation and receipt. Business buyers expect an invoice with their company details, and your accountant needs a record of every sale either way.
Typing invoices by hand is slow and creates errors in the places that matter: amounts, VAT and numbering. Set up your store or business tool so that an invoice is created from the order automatically, with a number sequence that has no gaps.
A sales invoice normally shows:
- seller and buyer names and details;
- invoice number and date;
- description, quantity and price of the goods;
- the amount without VAT, the VAT amount and the total, where VAT applies;
- payment terms or a note that the invoice has been paid.
VAT-registered sellers have specific invoice requirements under the Value-Added Tax Act. Check the current list with your accountant or the Estonian Tax and Customs Board rather than relying on a template.
Step 5: Handle returns as a reverse order
A return is an order running backwards, and it needs the same discipline.
- Log the return request against the original order.
- When the parcel arrives, inspect the item.
- Return sellable items to stock. Write off the rest.
- Refund through the original payment method.
- Issue a credit invoice so the books match the refund.
Do the stock step and the refund step at the same time. A refund without a stock update, or the reverse, is a discrepancy you will spend an hour finding later.
Step 6: Reconcile once a month
Set aside an hour each month for three checks.
- Stock count. Count your best sellers and anything that looks wrong. Compare to the record and correct it with a note about the cause.
- Payout check. Compare the payouts from your payment provider with the orders they cover. Fees are deducted before payout, so the amounts differ from order totals in a predictable way.
- Open items. Look for orders paid but not shipped, returns received but not refunded, and invoices issued but not paid.
Small discrepancies caught monthly are easy to explain. The same errors found at year end are not.
When should you move beyond a spreadsheet?
Move when any of these becomes true:
- you oversell more than once in a while;
- you sell in more than one channel;
- more than one person packs orders;
- invoices or stock updates are regularly done late;
- you cannot tell, within a minute, how many units of a product you have.
The next step is either the inventory features of your store platform or a business tool that holds stock, invoices and customers together. Choose the one that removes the most retyping. If you are still deciding on the store itself, see how to choose an e-commerce platform.