StoreTender Online  Version 8.  ©2015,  Aloha Data Systems, Inc.

Products (Main Menu / Data / Inventory / Products)

 

 

Overview

 

The products table serves as the central repository for all of the products in the store's inventory for resale.

 

Actions

 

Find - Selects and displays a product (see Find Dialog)

 

New - Adds a new product.

 

Edit - Edits the current product.

 

Delete - Permanently deletes the current pricing family.

 

Save - Saves changes to the current product.

 

Cancel - Cancels the current operation.

 

Close - Closes the Products form.

 

Keys - Displays the on-screen keyboard (see On-Screen Keyboard).

 

History, Activity - Display activity for the current product (see Product Activity).

 

History, Sales - Displays sales for the current product (see Product Sales).

 

Import - Opens the Import Data Dialog (see Import Data)

 

Export - Opens the Export Data Dialog (see Export Data)

 

Grid - Opens the Data Grid (see Data Grid)

 

List - Displays and optionally prints a list of products (see Product List).

 

Help - Displays the help menu (see Help Menu).

 

Tool Tips - Hover the mouse cursor over any field descriptor to display a brief description.

 

Fields

 

PLU / UPC Number - The PLU (Product Lookup) Number can contain letters and numbers and be up to 14 characters in length. The PLU Number is typically the UPC, EAN or GSA-1 bar code number assigned to the item by the manufacturer.

 

Examples of UPC/EAN/GSA-1 bar code numbers:

 

UPC-E   04128601            (8 digits)

UPC-A  644209411405     (12 digits)

EAN       7290002752349   (13 digits)

GSA-1    01234567890123 (14 digits)

 

Note: It is strongly recommended to always enter the complete number including the lead and check digits.

 

In the above UPC-A example, 6 is the lead digit and 5 is the check digit.

 

Entering Price Embedded Bar Codes produced by labeling scales

 

UPC-A Codes (12 digits) starting with 2 - The PLU number is a 5 digit number starting at positions 2

Example: 231407214718

 

The PLU number would be 31407

 

EAN Codes (13 digits) starting with 02 -  The PLU number is a 5 digit number starting at positions 3.

Example: 0231407214718

 

The PLU number would be 31407

 

Note: PLU # 00000 is reserved by the system.

 

Alias List - The Alias List allows adding additional lookups for the current PLU. Additional lookups can contain alpha and numeric characters and can be up to 14 characters in length. An Alias PLU number is typically a new UPC, EAN or GSA-1 bar code number assigned to the item by the manufacturer. In most cases Alias PLU numbers are used for packaging changes made by the manufacturer.

 

Examples of UPC/EAN/GSA-1 bar code numbers:

 

UPC-E   04128601            (8 digits)

UPC-A  644209411405     (12 digits)

EAN       7290002752349   (13 digits)

GSA-1    01234567890123 (14 digits)

 

Note: It is strongly recommended to always enter the complete number including the lead and check digits.

 

In the above UPC-A example, 6 is the lead digit and 5 is the check digit.

 

To add additional alternate lookups click the icon to the right of the field. (see Alternate Lookups )

 

Case - The Case PLU (Product Lookup) Number can contain letters and numbers and be up to 14 characters in length. It is used to store the UPC number assigned to the case. When the Case PLU is present and defined as a stand alone item in the database, automatic case breakouts are performed when individual on hand counts go below zero.

 

Example:

 

Marlboro Pack 002820036320, On Hand 2

Marlboro Carton 002820010023, On Hand 5

Pack Size 10

 

Sell 3 packs. This puts the on hand to -1. The system will automatically "break-open" a case, thereby lowering the case inventory by 1 and incrementing the pack inventory by 10. The result is the pack inventory will now have 9 and the carton or case inventory will drop to 4.

 

There is no limit to the number of parent/child relationships you can define.

 

Example:

 

Single - pack size 6

Six Pack - pack size 2

12 Pack - pack size 2

24 Pack

 

The Case PLU is typically a new UPC, EAN or GSA-1 bar code number assigned to the item by the manufacturer.

 

Examples of UPC/EAN/GSA-1 bar code numbers:

 

UPC-E   04128601            (8 digits)

UPC-A  644209411405     (12 digits)

EAN       7290002752349   (13 digits)

GSA-1    01234567890123 (14 digits)

 

Note: It is strongly recommended to always enter the complete number including the lead and check digits.

 

In the above UPC-A example, 6 is the lead digit and 5 is the check digit.

 

Full Description - The full product description field is alphanumeric and can be up to 80 characters in length.

 

Example:

Procter & Gamble Tide with Bleach Alternative Original Scent 78 Loads 150 oz.

 

POS Description - The POS item description field is alphanumeric and can be up to 20 characters in length.

 

Example:

Tide 150 oz

 

Department / Subdepartment - Select the yellow folder on the right to display a list of departments to choose from. (see Departments). Once a department is selected you will be presented with a list of subdepartments to choose from. (see Subdepartments). The use of subdepartments is optional.

 

Example:

Household / Laundry Soap

 

Brand - Select the yellow folder on the right to display a list of brands to choose from. (see Brands)

 

Example:

Tide

 

Family - Select the yellow folder on the right to display a list of pricing families to choose from. (see Families)

 

Scale - Select the folder on the right to display a list of scale options to choose from.

 

If the item label is being printed by the scale and the scale(s) are being controlled by E-Plum software, be sure to select the appropriate synchronization option.

 

Examples:

No

Yes

Yes, Tare 1

Yes, Tare 2

Yes, Tare 3

Synchronize with Label Printing Scale(s) BC (By Count)

Synchronize with Label Printing Scale(s) FP (Fixed Price)

Synchronize with Label Printing Scale(s) FW (Fixed Weight)

Synchronize with Label Printing Scale(s) KG (Kilogram)

Synchronize with Label Printing Scale(s) HG (100 Gram)

Synchronize with Label Printing Scale(s) LB (Pound)

Synchronize with Label Printing Scale(s) HB (Half Pound)

Synchronize with Label Printing Scale(s) QB (Quarter Pound)

Synchronize with Label Printing Scale(s) OK (Open Price, Kilogram)

Synchronize with Label Printing Scale(s) OG (Open Price, 100 Gram)

Synchronize with Label Printing Scale(s) OB (Open Price, By Count)

Synchronize with Label Printing Scale(s) OP (Open Price, Pound)

Synchronize with Label Printing Scale(s) OH (Open Price,Half Pound)

Synchronize with Label Printing Scale(s) OQ (Open Price, Quarter Pound)

 

Size - Used to store the size of the item.  This field is used in conjunction with the Unit of Measure.

 

Example: 

17.5 oz (where 17.5 is the size and oz is the unit of measure)

 

Unit of Measure - Used to store the unit of measure for the item.  This field is used in conjunction with the Size field.

 

Example:

17.5 oz (where 17.5 is the size and oz is the unit of measure)

 

Food Stamps - The Food Stamp check box will control whether or not this item can be paid for by food stamps. When items are paid for by food stamps, any applicable sales tax is forgiven.

 

Example:

If Corn Flakes sell for $4.00 and carry a 5% tax then the total would be $4.20 if paid by cash, but only $4.00 if paid by food stamps. The term Food Stamps actually refers to a time when paper vouchers were issued to qualified participants of this program. Today, most states issue plastic cards called EBT cards. These cards work like debit cards and customers can present them at the time of purchase. These cards actually carry two balances; EBT Food and EBT Cash. Either balance can be used to pay for purchases but only EBT Food will forgive the tax.

 

WIC - Used to indicate whether or not the item qualifies for the WIC program.

 

Check the box if the item qualifies and your store is set up to accept WIC payments.

 

WIC Fruits and Vegetables - Used to indicate whether or not the item qualifies for the WIC Fruits and Vegetables program.

 

Check the box if the item qualifies and your store is set up to accept WIC Payments.

 

Tax Zone - Tax Zones are assigned by HQ in multi-store environments. They provide a convenient method of managing taxes across the enterprise. This is a read only field.

 

Tax 1 -3  - Each item can have up to three different taxes assigned. Select the yellow folder on the right to display a list of taxes to choose from. (see Taxes)

 

Price Zone - Price Zones are assigned from HQ in multi-store environments. They provide a convenient method of managing prices across the enterprise. This is a read-only field.

 

Link PLU - A link PLU is a secondary PLU that will follow the primary PLU. A common use for a link PLU is when a bottle deposit is attached to the first or primary PLU. Select the folder on the right to display a list of products to choose from.

 

Example: 

PLU 123 is a bottle of soda that sells for $1.50. PLU 456 is a bottle deposit that charges $0.05. On PLU 123 you would select the PLU 456 as the link PLU. When the Soda sells the bottle deposit will automatically follow in the same quantity as the soda being sold. 

 

Price Formula - Select the yellow folder on the right to display a list of pricing formulas to choose from. (see Formulas)

 

Vendor - Select the yellow folder on the right to display a list of vendors to choose from. (see Vendors)

 

Example:

Best Foods

 

Select the vendor relationships icon on the right to display a list of vendors where this product can be purchased from.

(see Multiple Vendors)

 

Item Number - The Item Number can contain alpha and numeric characters and can be up to 14 characters in length. This is typically the number associated with this item when ordering from the vendor. Item Numbers are typically unique to the vendor.

 

Example:

123422

 

Pack Size / Case Cost - Used to store the pack size and the cost of the item. When either the Pack Size or Case Cost is edited the resulting profit margin and markup percentage will be calculated.

 

Examples:

12/$18.00 ( case cost is $18.00 with 12 items in a case )

24/$12.00 ( case cost is $12.00 with 24 items in a case )

 

Margin - Margin is the percentage of the final selling price that is profit. This field can be used to automatically calculate a selling price and the markup percentage based on the margin amount entered.

 

Example:

To achieve a 33% profit margin enter 33.

 

Note regarding open rings:

 

When the retail price is zero the margin can be used to record a cost to your history files even when the cost is left at zero on the file.

To record a cost of 0, set the margin at 100

To record a cost of 100% (as in the case of a hash department), set the margin at 0

To record any other cost set the margin accordingly

 

 

Markup Percentage - Markup is the percentage of the cost price you add on to get the selling price. This field can be used to automatically calculate a selling price and the profit margin based on the markup percentage entered.

 

Example:

To achieve a 50% markup enter 50.

 

Multiplier / Unit Price - Used to store the quantity multiplier and price of the item. When either the multiplier or unit price is edited the resulting profit margin and markup percentage will be calculated.

 

Examples:

1/$1.59 ( 1 for $1.59 )

3/$1.00 ( 3 for $1.00 )

 

Store Number - The Store Number is used by HQ in multi-store environments. It provides a unique identifier for pricing, ordering, setting up and managing items across the enterprise. This is a read only field.

 

Item Carried - Used to signify the item is carried and sold at this store. When unchecked the item cannot be rung up at the register.

 

Minimum Stock - The Minimum Stock, Maximum Stock, Pack Size, On Hand and On Order fields are used in a formula to determine when a reorder should occur.

 

Example:

Pack Size: 12 (12 items to a case)

Minimum Stock: 2 (2 cases)

Maximum Stock: 4 (4 cases)

On Hand: 22 (22 individual items)

 

When reordering the following formula will be used:

 

if ON HAND / PACKSIZE <= MIN STOCK + ON ORDER then REORDER = MAX STOCK - ON ORDER - ON HAND / PACK SIZE

 

In the above example a reorder for 2 cases is needed. The reorder quantity will never bring the  quantity on hand more than the maximum.

 

 

Maximum Stock - The Minimum Stock, Maximum Stock, Pack Size, On Hand and On Order fields are used in a formula to determine when a reorder should occur.

 

Example:

Pack Size: 12 (12 items to a case)

Minimum Stock: 2 (2 cases)

Maximum Stock: 4 (4 cases)

On Hand: 22 (22 individual items)

 

When reordering the following formula will be used:

 

if ON HAND / PACKSIZE <= MIN STOCK + ON ORDER then REORDER = MAX STOCK - ON ORDER - ON HAND / PACK SIZE

 

In the above example a reorder for 2 cases is needed. The reorder quantity will never bring the  quantity on hand more than the maximum.

 

On Order - The current quantity on order for this item. This field is automatically incremented when merchandise is ordered and decremented when merchandise is received. The Minimum Stock, Maximum Stock, Pack Size, On Hand and On Order fields are used in a formula to determine when a reorder should occur.

 

Example:

Pack Size: 12 (12 items to a case)

Minimum Stock: 2 (2 cases)

Maximum Stock: 4 (4 cases)

On Hand: 22 (22 individual items)

 

When reordering the following formula will be used:

 

if ON HAND / PACKSIZE <= MIN STOCK + ON ORDER then REORDER = MAX STOCK - ON ORDER - ON HAND / PACK SIZE

 

In the above example a reorder for 2 cases is needed. The reorder quantity will never bring the  quantity on hand more than the maximum.

 

On Hand - The current quantity on hand for this item. This field is automatically incremented when merchandise is received or returned and decremented when merchandise is sold. The Minimum Stock, Maximum Stock, Pack Size, On Hand and On Order fields are used in a formula to determine when a reorder should occur.

 

Example:

Pack Size: 12 (12 items to a case)

Minimum Stock: 2 (2 cases)

Maximum Stock: 4 (4 cases)

On Hand: 22 (22 individual items)

 

When reordering the following formula will be used:

 

if ON HAND / PACKSIZE <= MIN STOCK + ON ORDER then REORDER = MAX STOCK - ON ORDER - ON HAND / PACK SIZE

 

In the above example a reorder for 2 cases is needed. The reorder quantity will never bring the  quantity on hand more than the maximum.