Labels Module: Database Records Fields

Each record in the database defines 1 product -by name, by unit, and by business.

  • The data defines what text and barcode values are going to be used on labels.
  • The data defines how many labels of each sort are going to be printed in a batch.
  • The data defines what sort of label format is going to be used when printing a specific label record.

The process does the above by using the data in the database fields in different ways. Labels records have the following fields:

Label ID: Automated ID field. Ignore this.

Plant Name: The name of the product which could be a plant name or name of a dry goods product e.g. 40 lit. Pot and Tub Mix.

Label Quantity: The number of labels of the product/plant name to be printed in this batch.

Retail Price: If required, the retail price to appear on the labels.

Special Price: If required, a special price to appear on the labels. The labels can have both a normal retail price, and a special price if required.

Barcode: If required a barcode can be included on the labels. The barcode field holds the value of the barcode e.g. for the EAN_13 barcode system the value needs to be 13 digits long. The PFP labels can use any of 23 different barcode systems.

Label Reference: Not all want to use a barcode. Some business prefer to use a number or text to define a product. If required this field provides this requirement.

Label Type: There are 3 label types that be used with PFP labels, tie on, push in or self adhesive. When preparing a labels batch the label type field will prevent a label record being printed by anything other than the required label type. However if the 'All" option is used, then a label record can be printed by all label types.

Unit: This is the unit of measurement of the product. For plants it is normally the container size or unit. For dry goods it may be the volume, weight, or some other measurement unit.

Business: There are 2 options with this field, My Business or General. Use the My Business value for label records that relate to your business. Use the General value for labels to be produced for a customer or some other business. This means the labels records holds 2 subsets, 1 for your business and 1 for everyone else, and prevents messing up your own records.

Note that labels can be produced from inside the Customer Orders Module, and from inside the Invoices Module. In both these cases the process uses only the General label records.  If a General record for a specific product is not available the process will create a new General record based on values in a compatible My Business record via automation.

Label Description: For plant labels this would be a normal description of the plant. For dry goods it may be a few comments about the product.