Your Product Database
Your Product Database should be regularly maintained with key information such
as cost and retail prices. The product database is divided into 3 areas; Groups,
Departments and PLUs (products).
A ‘Group’ is a reportable area e.g. Food. A ‘Department’ is a reportable area within
a ‘Group’ e.g. Starters.
To create a PLU you must have the Group and Department in place first e.g. if we
wanted to create ‘Soup’ we would need Food and Starters.
Before you start to set up your system it is a good idea to decide how you would
like your reports to look and devise a naming convention for your PLUs e.g. 01001,
01 may be the Department e.g. Food and 001 the first product e.g. Soup so the
product will have a PLU of 01001 and a description of Soup. If being used in the
Retail environment with scanner the PLU should be the barcode.
Other mandatory information for the product record is the supplier name; this can
be created from the product record.