# Add a ready-made medicine list from Excel to your shop

> Import a ready-made medicine workbook in Products > Import, then add only the medicines you stock from the Catalogue library. Basic and Professional.

**Short answer:** To add medicines from a ready-made catalogue, import the workbook in Products, then Import. Rows with opening stock become your products, and the rest wait in the Catalogue library. Add the medicines you stock from there, then set their prices. Import and the library are in Basic and Professional.

Source: https://sellypos.com/help/products/add-medicines-from-the-ready-made-catalogue/
Updated: 2026-11-05

This guide shows how a ready-made medicine workbook comes into SellyPOS, and how you add only the medicines your shop stocks. The import and the Catalogue library are in Basic and Professional. Lite has no import.

## What you need

- Basic or Professional. See [the editions](/help/licensing/choose-an-edition/).
- A login with the permission to import products, and to create products for the Catalogue library.
- The main computer. The Catalogue library is kept on the main computer only, not on client tills, so add items there.
- The workbook. A shop gets the medicine workbook by contacting Selly Systems on WhatsApp, and only after a licence is bought. See [contact Selly Systems](/contact/).

## Import the workbook

1. **Open Import.** Go to Products, then Import.

2. **Choose the file.** Choose a file, and pick the workbook. If it has more than one product sheet, the sheets are read together as one list.

3. **Match the columns.** Each column of the workbook is matched to a product field. Check the matches, then go on.

4. **Choose the products.** Choose the categories and brands to import. Anything you leave out is not written.

5. **Match the names.** A unit, category, brand or option value that the shop does not have can be matched to one of your own. A suggestion is used only when you choose it.

6. **Check the rows, then import.** Before anything is written, the Check step counts the rows that are ready, that cannot import and that are already here. It names the cell behind each problem. Press Import to finish.

Rows with opening stock become your products. The rest go to the Catalogue library, and the result says how many went there and where to find them.

## Add the medicines you stock

1. **Open the Catalogue library.** Go to Products, then Catalogue library.

2. **Find the medicines.** Search, filter or scan a barcode to find each medicine you stock.

3. **Choose the ones you stock.** Tick a result, or click its row.

4. **Press Add N to my products.** N is the number you have chosen. The products are made with no selling price, no stock and no cost, and each is marked Incomplete. The MRP in the file is kept.

5. **Set the prices and stock in Bulk edit.** For a login that may edit products, Bulk edit opens on the new products. Type each selling price, cost and opening stock there.

## Check the prices against your own

The prices in the file are a retailer's shelf price from 5 November 2026, tax included. They are not copied to your products, so type each price in Bulk edit after checking it. A selling price above the MRP is refused.

## Are rows already in my shop imported again?

No. A row is skipped when its name, SKU or main barcode matches a product already in the shop, and so is a variant of a main product already there. The file does not update a product that is already in the shop, because update on match is not built.

## Can I find the products an import added?

Yes. Each import is saved as a record of the products it created. Import History shows those products, opens them in Bulk edit, or prints their labels, which is a Professional feature. The Alerts page also reminds you 30 days after a large import.

## Can I sell a medicine straight from the library?

No. Library items are never sold, and they do not sit in every search and list. Add the medicines you stock first, and then they sell like any other product.

## If something is not as you expect

- **A row is marked as a problem.** A SKU or barcode that appears again later in the file makes that later row invalid. Correct or remove the repeat.
- **A row without stock is not in the library.** A row without stock from your own file goes to your products. The library is only for a ready-made catalogue.

## Next

For each step of the import screen, read [import your products from an Excel file](/help/products/import-products-from-excel/). To set prices, stock or cost on many medicines at once, read [how to edit many products at once](/help/products/edit-many-products-at-once/). For the expiry dates of the medicines you receive, read [how to receive medicines with lot and expiry dates](/help/stock/receive-medicines-with-batch-and-expiry/).

[Download SellyPOS](/download/) to try it.
