3156
Dead stock is inventory that sits in your warehouse and does not sell, or sells so slowly that the stock on hand would last for years. You spot it ...
477
The inventory turnover ratio shows how many times a year your average stock sells: cost of goods sold divided by average inventory at cost. The reo...
581
A lot number (also called a batch number) is a code for a group of identical goods made or received together under the same conditions. It is print...
5523
FMCG stands for fast-moving consumer goods: everyday products that people buy often, use up quickly and pay little for — food, beverages, household...
9274
Gross margin is the share of the selling price you keep after paying for the goods: gross margin % = (selling price − cost of goods) ÷ selling pric...
6688
In winter, stores sell what people search for in the cold months: space heaters, heated blankets, hand warmers, snow shovels, Christmas decorations...
1265
To optimize product images, keep one sharp original of about 2000 px on the longest side, make smaller copies for each place the photo appears (pro...
2662
A pre-order is an order for a product that has not been released or has not arrived yet: the buyer orders now, often pays in advance, and gets the ...
1123
To extract a table from a PDF, first check whether you can select the text. If you can, pull the table out with Excel ("Data → Get Data → From File...
1722
ABC analysis splits your products into three groups by how much they contribute: group A is the items that together bring the first 80% of profit o...
1758
Dynamic pricing means a product's price changes automatically, by rules, when conditions change: the supplier's price, the exchange rate, competito...
1551
A merged supplier price list is one table where the products of all suppliers are matched by a shared key (a barcode or the manufacturer part numbe...