How to add products from a ready-made catalogue
Import a ready-made product workbook in Products, Import, then add only the items you stock from the Catalogue library. Basic and Professional.
Short answer To add products from a ready-made catalogue, import its workbook in Products, then Import. A ready-made catalogue has no opening stock, so its rows wait in the Catalogue library. Add the items you stock from there, then type your own price, cost and stock in Bulk edit. Import and the library are in Basic and Professional.
This guide shows how a ready-made catalogue comes into SellyPOS and how you add only the items you stock. Import and the Catalogue library are in Basic and Professional. For what each file holds, see the grocery catalogue or the supermarket catalogue.
What you need
- Basic or Professional. See the editions.
- A login with the permission to import products and to add products from the Catalogue library.
- The main computer. The Catalogue library is kept on the main computer only, not on client tills.
- The workbook. A shop gets it by contacting Selly Systems on WhatsApp, and only after a licence is bought. See contact Selly Systems.
Import the workbook
-
Open Import. Go to Products, then Import.
-
Choose the file. Choose the workbook. If it has more than one product sheet, the sheets are read together as one list.
-
Match the columns. Each column of the file is matched to a product field. Check the matches, then go on.
-
Choose products. Choose the categories and brands to import. Anything you leave out is not written.
-
Match names. A category or brand your shop lacks can be matched to one of yours, and a suggestion is used only when you choose it. When every row of the catalogue goes to the library, this step says there is nothing to match, because its category, brand and options are made when you add an item.
-
Check the rows, then import. Before anything is written, the Check step counts the ready rows and the problems, and names the cell behind each problem. Press Import to finish.
Where the rows go
A ready-made catalogue has no opening stock, so its rows go to the Catalogue library, and the result says how many went there. A file of your own is different: its rows go to your products.
Add the items you stock
-
Open the Catalogue library. Go to Products, then Catalogue library.
-
Find the items you stock. Search, filter or scan a barcode to find each one.
-
Tick each item you stock. Tick it in the results.
-
Press Add N to my products. N is the number you ticked. Each product is made with no selling price, no stock and no cost, and it is marked Incomplete. A product without a selling price cannot be sold until it has one.
-
Set the price, cost and stock in Bulk edit. Bulk edit opens on the new products for a login that may edit products. Type each selling price, cost and opening stock, then press Review and save.
Can I buy a library item before it is my product?
Yes. Quick purchase, Goods received, Purchase orders and Stock adjustments offer library items below your own products, and saving the document makes the product. Library items are never sold.
Are the prices in the file my prices?
No. They are a starting list of shelf prices on 5 November 2026, tax included, and they are not copied to the products you add from the library. Check each one, and type your own in Bulk edit.
If something is not as you expect
- An import does not update a product already in the shop. A matching name, SKU or main barcode is skipped.
- The library is on the main computer only, not on client tills.
- The Check step names the cell behind each problem. Correct it in your file, then import again.
Next
For each step of the import screen, read how to import your products from an Excel file. To set prices, cost or stock on many products at once, read how to edit many products at once. For the medicine workbook, see how to add a ready-made medicine list.
Download SellyPOS to try it.
Questions people ask
Can I import my product list from Excel?
Yes, in Basic and Professional. Products > Import reads a spreadsheet workbook or a CSV file in steps: choose the file, match its columns, check the rows, then import. The workbook template is built from the shop's own units, categories, brands and tax groups. An import only adds products, and it skips any already in the shop by name, SKU or main barcode. See import products from Excel.
How do I import my products from an Excel file?
The import shows each column of your file on its own row, with up to three examples from its first rows. Choose the product field each column imports as, or Don't import. Recognised columns are already matched. If the workbook has product details on several sheets, they are joined by their column names and read as one list. A row whose name, SKU or main barcode matches a product already in the shop is skipped, and so is a variant of a main product already in the shop. See import products from Excel.
Can I see what an import will do before it saves anything?
Yes, in Basic and Professional the Check step of an import runs before anything is written. It counts the rows that are ready, the rows that will be fixed, the rows that cannot import and the rows already in the shop. It lists the categories, brands and values it will create, and it names the cell behind each problem.
What happens to a product in my file that the shop already has?
A product in your file that the shop already has is skipped, in Basic and Professional. A row whose name, SKU or main barcode matches a product already in the shop is skipped, and so is a variant of a main product already there. The existing product is not updated from the file, because updating on a match is not built yet.