Feature

A ready-made shoe list for your shoe shop, to price and add

A ready-made Excel list of 309 shoe styles with sizes and colours, for the shop to price and add. No brands, no prices and no pictures.

Short answer The ready-made shoe list in Excel is one workbook of 309 shoe styles and 6,967 size and colour variants, with no brands and every price at 0. Products > Import reads it, and its rows wait in the Catalogue library until the shop adds the styles it stocks. It needs Basic or Professional.

In Basic, Professional

A shoe shop does not have to type every style into the till by hand. The ready-made shoe list in Excel is one workbook of 309 shoe styles, each with its sizes and colours already set out in a grid.

The list holds no brands, no prices and no pictures. Every price in it is 0, so each style has to be priced before it is sold.

What is in the ready-made shoe list in Excel?

The list holds 309 products and 6,967 variants. They sit under 49 categories in seven groups. Women’s shoes hold 67 products, men’s shoes 53, sandals and slippers 47, kids’ shoes 43, socks and shoe care 39, formal shoes 36 and sports shoes 24.

The kinds are the ones a Pakistani shoe shop sells, written generically, such as chappals, khussa and jutti, school shoes, bridal shoes, Hajj and umrah slippers and PT canvas shoes. The list was built from a survey of six footwear retailers’ public sites, with every brand and model name dropped.

How is one style built in the list?

One product is one style and its upper material, for example “a men’s cap-toe oxford, leather”. Its name, receipt name, category and search words are filled in, and the description holds the upper material and the sole.

Sizes sit under the Shoe Size (EU) option and colours under the colour option. Each size and colour of a style is a variant with its own SKU. The sizes and colours page shows the grid of size against colour, with the stock of each.

The unit is the pair for 290 of the products. The other 19 are sold by the piece (15), as a pack (3) or by the dozen (1). A Shoes shop starts with all four units, and an import never creates a unit.

Which sizes and colours are in the list?

The sizes and colours are the ones retailers list. They are not a standard, so check each one against your own supplier’s chart. The list holds no size conversion table. It uses the Shoe Size (EU) option, and the Shoes type also starts a British and an American size option for a shop that sells in those sizes.

Some sizes and colours are not in the starting set for a shoe shop. They include EU sizes 17 to 34 and colours such as tan, camel, coffee, golden, silver and burgundy. They are made when you add a style from the library, not typed in for each style. Two-tone shoes are not split into colour combinations.

How does the list reach my shop?

Products > Import reads the workbook. The file has no opening stock, so its rows wait in the Catalogue library instead of becoming products. The library sits on the main computer only.

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

What does the shop do first?

  1. Open Products > Import and choose the file. Match its columns, check the rows and import them.
  2. Open Products > Catalogue library and tick the styles 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.
  3. In Bulk edit, set each selling price, cost and opening stock. Each style’s variants are edited under it.

Can I sell a style from the list straight away?

No. A style from the list has no selling price until the shop sets one, and the counter will not add a product with no price. Library items are never sold, so a style must first become one of your products.

How do I get the ready-made shoe list?

A shop gets the file 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. Lite has no variants and no import, so compare the editions and amounts before you ask.

What does the list leave out?

  • Brands, companies and model names.
  • Prices. Every price is 0, and the shop sets each one.
  • Pictures.
  • Barcodes, cost, opening stock, tax group and brand. These are left empty for the shop.
  • Belts, wallets and bags, and safety footwear other than boots.
  • A size conversion table.

For example

For example, the owner imports the file, ticks only the sandals and school shoes the shop sells, and sets their prices in Bulk edit before the first sale.

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 shoe shop POS software and edit many products at once. Then download SellyPOS and compare the editions and prices.

Questions people ask

Is there a ready-made shoe list I can import?

The ready-made shoe list is written generically, with no brands, and is in Basic and Professional. It holds 309 products and 6,967 variants in 49 categories in seven groups, with no pictures. Its sizes and colours are what retailers list, not a standard. Its rows wait in the Catalogue library until you add them. A shop gets the file by contacting Selly Systems after buying a licence.

Does the ready-made shoe list come with prices?

The ready-made shoe list has no prices: every product in it is priced 0, so each product needs a price before the shop sells it. The counter does not add a product when no price can be found. The list also leaves out cost, opening stock, barcodes and tax groups, which the shop enters itself. Set each price in Bulk edit, or on the product's Pricing tab, before the first sale.

Does SellyPOS work for a shoe shop?

A shoe shop starts with four attributes and 80 values when Shoes is chosen at setup. A style can be one product with a variant per size and colour, each with its own barcode, price and stock. At the counter you pick the variant, and leftover stock on the main product can go to its variants. Basic and Professional have all of this. See shoe shop POS software.

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.

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.