Import your catalogue from a spreadsheet
Four different ways to bulk load products, the exact column order the classic import needs, and what happens to a bad row.
6 min read
Every field on the product form, which eight are required, and what Initial Stock actually does.
6 min readUpdated
Product, then Product list, then Add product. Fill in the eight required fields, press Save product. Everything else on the form is optional.
The eight are Product Type, Product Name, Product Code, Barcode Symbology, Category, Product Unit, Product Cost and Product Price.
Product Type decides which of the later fields apply. The options are Standard, Combo, Digital and Service. A Digital or a Service product does not show the cost and price block in the same way, because it does not sit on a shelf.
Product Cost, Profit Margin and Product Price move together. Change any one and the other two follow, so you can price from a margin or work the margin out from a price.
If you type a price below the cost the form stops you and says that every sale would lose money. That is a real block, not a warning.
The last checkbox is Initial Stock, and it is the one people misread. Opening stock is recorded as a purchase, so it appears in your purchase list and in your accounts. That is deliberate: stock you own has to have come from somewhere, or your figures will never balance.
If you are moving from another system, decide once whether opening stock goes in through Initial Stock or through a single purchase per supplier, and stick to it. Doing both leaves you with double the stock.
Deleting a product removes it from your catalogue and from every list, and its images are deleted from the server and cannot be recovered. Its sales and purchases stay on record.
Four different ways to bulk load products, the exact column order the classic import needs, and what happens to a bad row.
6 min read
Queue up products, choose a paper size and print. Plus the one thing that clears your list without warning.
3 min read
The stock count sheet, how a difference becomes an adjustment, and when to use a damage record instead.
7 min read