Feature

A ready-made product list for your grocery or kiryana shop, ready to import

A ready-made Excel list of 21,044 packaged grocery products, with barcodes and shelf prices, for the shop to check and add.

Short answer The grocery product list in Excel is a workbook of 21,044 packaged, barcoded products for a grocery store, with 1,095 brands and 76 categories. Products > Import reads it, and its rows wait in the Catalogue library until the shop adds the ones it stocks, with its own cost and stock. It needs Basic or Professional.

In Basic, Professional

A grocery store does not have to type every packaged product into the till by hand. The grocery product list in Excel is one workbook of 21,044 packaged, barcoded products, and the shop adds the ones it stocks.

What is in the grocery product list in Excel?

The grocery product list in Excel is a workbook of 21,044 packaged, barcoded products in 76 categories, grouped under 18 headings, with 1,095 brands. Every product has a barcode, a category, a brand and a shelf price filled in as a starting point for the shop to check.

Personal care is the largest group, with 6,620 products, so a general store gets soap and shampoo too. Next come snacks, biscuits and sweets (3,907), household and cleaning (2,514), spices and condiments (1,406), baby care (1,371) and beverages (1,036).

The file also holds 135 pack levels: 128 cartons and 7 boxes.

How does one row look?

The row below is invented.

Column Invented example
Name Example biscuits, 500 g
Receipt name Example biscuits 500 g (40 characters or fewer)
Category Biscuits and cookies
Brand One of the 1,095 brands in the file
Barcode The pack’s barcode, with extra barcodes on some products
Price Filled in, tax included, as a shelf price to check
Pack level A carton of the same biscuits, with its own barcode and price
Cost, opening stock and tax group Empty, for the shop to set

Does the file hold loose rice, flour and pulses?

No. The list holds packaged goods only. Loose and unbranded staples such as rice, flour and pulses sold by weight have no barcode, so they are left out on purpose. The file has 17 products under rice, flour and grains and 35 under pulses and beans, and all of them are packaged.

The shop adds its loose goods itself. Mark a product as loose and sell it in a unit that allows decimals, and the counter asks how much is being sold in a small How much? window. A typed weight or a typed money amount fills in the other. Reading the weight from a connected scale is not built.

How does the file reach my shop?

The file reaches your shop through Products > Import, which reads the workbook. Because the file carries no opening stock, every row goes to Products > Catalogue library, so the rows do not crowd every search and list. The library sits on the main computer only, and nothing is sold from it.

An import only adds products. A row whose name, SKU or main barcode matches a product already in the shop is skipped, not updated.

What does the shop do first?

  1. Open Products > Import and choose the file. Match its columns, check the rows and import them. The rows wait in the Catalogue library.
  2. Open Products > Catalogue library and tick the products you stock. Search, filter or scan to find them, then press Add N to my products. They join your products with no selling price, stock or cost, and Bulk edit opens on them.
  3. In Bulk edit, type each selling price, cost and opening stock.
  4. Check each price against your own shelf. Change any price that differs before you sell.

Can I sell a product from the list straight away?

No. A product from the list cannot be sold until the shop sets its selling price, because the list’s prices are only a starting point. The shop sets it in Bulk edit. The counter does not add a product when no price can be found for it.

What does Lite leave out?

Lite has no import and no Catalogue library, so it cannot take this list. It is meant for up to 20 products.

How do I get the grocery product list?

A shop gets the grocery product list by contacting Selly Systems on WhatsApp, and only after it has bought a licence. Reach Selly Systems through the contact page. The file imports on Basic or Professional, so compare the editions and prices before you ask.

For a supermarket or mart

A supermarket or mart needs the bigger file, the supermarket product list in Excel. It holds 60,073 products across 22 groups, and not all of them are food.

For example

For example, the owner imports the file on a quiet evening, ticks only the biscuits and soap the shop sells, and types each price in Bulk edit.

Next

Read how to add products from a ready-made catalogue and how to import products from an Excel file. For the whole counter, see grocery store POS software and edit many products at once. Then download SellyPOS and compare the editions and prices.

Questions people ask

How many products are in the grocery catalogue?

The grocery catalogue holds 21,044 products in 76 categories within 18 groups, from 1,095 brands, and every product has a barcode, a category and a brand. It is packaged goods only, so loose rice, flour and pulses are not in it. Basic and Professional read the file, which the shop gets from Selly Systems on WhatsApp after buying a licence. See the grocery catalogue.

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.

What does a grocery store need from its POS software?

A grocery store needs a counter that adds scanned items at once, and lets the cashier sell loose goods by typing the weight. It needs expiry dates on food and other goods, credit for named customers, and bills and payments for its suppliers. Basic is for one counter. Professional adds several counters on one shop network. See grocery store POS software.

How much does grocery store software cost?

SellyPOS Lite is free for ever, with no trial and no licence. It holds up to 20 products, and a grocery store usually has more than that. Basic and Professional each start with a 7-day free trial, then a one-time payment for the licence. Basic is for one counter, and Professional adds several counters. The amounts are on the pricing page.

Start selling with SellyPOS today

An installed Windows app with a modern interface, made to sell from the keyboard. It keeps selling with no internet.

Windows 10 (version 1809 or later) or Windows 11, 64-bit.