A clean product catalogue is the foundation for understandable billing, inventory, purchasing and reports. The objective is not to collect every possible field. It is to give the store one dependable record for each item and enough detail for staff to select, count and review it consistently.
Decide what counts as one product
Begin with the way the store buys, stocks and sells the item. Products that have different prices, identifiers, units or stock quantities may need separate records. Items that are genuinely identical should not be duplicated merely because they arrived in a different delivery.
For clothing, electronics or other specification-heavy products, decide which differences matter during billing and counting. Size, model, pack quantity or another attribute may be necessary; decorative wording that staff do not use may only make searching harder.
Use a consistent product-name pattern
Choose an order that helps staff distinguish similar items, such as brand, product, model or size where relevant. Apply the same pattern across the catalogue. Avoid vague names such as “new item,” supplier-only abbreviations that cashiers cannot recognize, or several spellings for the same brand.
Product-name questions
- Can a new staff member identify the physical item from this name?
- Does the name distinguish similar models, sizes or pack quantities?
- Will staff search for the same words used in the record?
- Is temporary promotional language being kept out of the permanent identity?
Create a stable SKU or identifier
A SKU is an internal stock-keeping identifier. Use a unique, stable value for each relevant product record and avoid reusing an old SKU for a different item. A supplier code or barcode may also be useful, but it serves a different source or scanning context and should not be assumed to replace the merchant’s own catalogue decisions.
Do not design an identifier so complicated that staff cannot maintain it. A simple consistent scheme is usually more dependable than encoding every possible product fact inside the SKU.
Choose categories that support daily work
Categories should make products easier to find and review. Begin with a manageable list connected to the store’s real assortment. Avoid creating separate categories that mean nearly the same thing, and do not use categories as a substitute for important product identifiers.
Review uncategorized products and categories containing only accidental duplicates. If the assortment changes, decide how inactive categories and historical records should remain understandable.
Define the selling and purchasing unit
Write down whether the product is counted and sold as a piece, pack, box, weight or another unit supported by the business. If the supplier delivers one case containing several sellable units, confirm how the merchant converts and records that relationship. Changing between case and piece without a defined process causes quantity differences even when every transaction was entered.
Separate cost from selling price
Keep the recorded cost basis and customer selling price in distinct fields. Confirm whether freight, tax-related amounts, discounts or other costs are included before using the numbers in margin or markup calculations. When supplier cost changes, review the proposed selling price instead of automatically assuming the previous percentage remains suitable.
The profit margin calculator and markup calculator can check arithmetic using the amounts entered. They do not value inventory, include omitted expenses or change product prices.
Check opening stock carefully
Count the physical quantity after duplicate products and units have been resolved. Keep damaged, reserved, returned or non-sellable goods separate according to the merchant’s process. An opening quantity entered against the wrong product can make every later sale and receipt appear incorrect.
Test the catalogue with real store tasks
- Search for a product the way a cashier would describe it.
- Record a sample supported sale using the intended unit and price.
- Match a supplier delivery to the same product record.
- Check whether a return or correction can be connected to the intended item.
- Review how the product appears in inventory and sales information.
- Export data where available and confirm important identifiers remain understandable.
Control changes after setup
Decide who may create a product, change its price, alter its unit, merge a duplicate or make it inactive. Before a structural change, consider open orders, stock history and earlier transactions. Keep a record inactive when appropriate instead of repurposing its identity for an unrelated item.
Connect the catalogue with SellingIt
Use Product Management for supported product records, Inventory Management for stock context, POS and Billing for sales, and Purchase and Supplier Management for received goods. The stock-count checklist helps verify the quantities attached to those records.
Advanced variants, bundles, unit conversion, barcode generation, weighing equipment, bulk import and specialist catalogue integrations should be confirmed in the current SellingIt configuration before relying on them.