product window field descriptions

See Also: Ordering Window

Product Field Descriptions

Section - This is the section that a product is found in on the order form. Sections can not be edited directly. Categories are automatically linked to Sections and changing the product’s category will automatically change the section if necessary.

Category - This is the category that the product is found under on the order form. Changing the product’s category will automatically set the product’s Section.

On Order - This is the number of items on order from the company. If you have multiple orders pending (posted but not received), this will be the total for this product of the outstanding orders.

Last Order - This will be the date of the last time you ordered this product.

Part # - This is the four digit part number found on the company order form or on the products you have on hand. This field is required to save a record. If you do not have a part number you can create your own. i.e.) SU96 for the black and vinyl direct support premium, I use SU for summer and 96 for the year, that way I’ll know when that item was a premium.

Description - This is how the products will be identified. This field may be edited to fit your needs. You will find that the cleansers will all have Cleanse as a description, if you do not want to locate them this way in the invoice by cleanse, you can change the description to say Creamy Cleanser #2. When we add products at Steinhoff and Associates we generally try to follow the same format as the company order form. This too is a required field.

Color - This field could be a color or a formula depending on how the description field is used. In the case of the cleansers being listed under Cleanse in description, we would then see that the Color field would hold the formula, i.e.) Creamy Cleanser etc.

Average Wholesale - This field is the average wholesale value of the product. When you receive an order the inventory is averaged with the discount rate of the new order. If you are manually adding or updating your inventory enter the wholesale value of the product.

On Special - This is a checkbox. This will identify a product as being on special. This feature let’s you put an individual product on special. With this option checked and a value in the Special Price field, the invoice will automatically discount the product to the special price when the product is entered into an invoice.

Special Price - This is the price you are charging for a product you have marked as special price.

Sold This Year - The number of items of this particular product that have been sold this year. This field is automatically updated as you sell product.

Sold Last Year - This is the total number of this particular product that was sold last year. This field is automatically updated as you sell product.

Par Level - This is the preferred shelf level of a particular product.

Formula - The Formula field refers to the Swap Formula feature. The Swap Formula feature will exchange a foundation for a different formula. Foundation products should be entered with a value of 1, 2 or 3 depending on the formula. All other products should have a 0 in this field.

On Hand - This is the quantity of your current inventory. When you order products and they are received into inventory they will be added into this figure and when you sell the product via the invoice, the inventory will be reduced.

Retail Price - This is the retail price of the product. This is now separate from the order price to accommodate situations where we may have some classic product which has a retail value greater than that of the current order price. A good example of this is Close-out Section 1 products where the price has been reduced. i.e.) the classic shapes in eye colors and cheek colors.

Order Price - This is the current order price of the product. In most instances it will be the same as the retail price. If you are adding a product to the database and it is NOT on the current order form it is not necessary to provide an order price. It is only necessary if the item is to be on the current order form.

Order Form - An x in this box will tag the product as an item that should appear on the order form. If the item does not appear on the current order form this box should be cleared.