How Items Work in coreSTORE

Items are the most important entity in Corestore, as this is what you are selling in your store. In this document we will describe how items work.

Item Lookup

There are 6 ways our database looks up Items.

These are:

• Item Name
• UPC/EAN/ISBN
• Product ID
• Item ID
• Additional Item Numbers

Changing Lookup Order

The order which an item is looked up can be changed in the store configuration.

Simply search for an item by name from the sales interface and it is added.

• By UPC/EAN/ISBN

This field is unique per item and can be used to add an item to a sale.

This is often used if a barcode for a product already exists.

Enter a UPC/EAN/ISBN:

Find Using UPC/EAN/ISBN:

• By Product ID

The product id field is generally used as a company wide naming scheme to look up products.

Enter a Product ID:

Find using Product ID

• By Additional Item Numbers

You can also attach many arbitrary item numbers that relate it an item if they don't meet the criteria above.

• By Item Variation Number

You can also attach an item number for a variation.

• Setting the Selling Price and Cost Price

The cost and selling price are two important pieces of information for an item.

The difference between the cost price and selling price determines profit. Make sure you set both of these values when adding an item.

Other Important Fields:

Checking this box for an item has 2 effects: the first being that a serial number field will appear when adding an item and second, when adding the item to a sale it will NOT be grouped with the same item.

• Allow Alternate Description

This allows for a different description for an item to be typed when adding an item.

• Reorder and Replenish Levels

The reorder level is the level which an items inventory when it reaches will trigger email inventor alerts and will be used when auto generating POs.

The Replenish level is the quantity to reorder when generating a PO.

• Max Discount Percent

You can define a max discount amount per item on Items and Item kits.

Bulk Edit

You can edit items in bulk by making a search and then selecting the items you wish you edit. When you have selected the items you wish to edit click bulk edit:

You can then edit the fields by all at once:

Deleting Items

You can delete Items from the Items module by selecting the items you wish to delete. A delete button will appear at the top of the items table.

 Clean Up Old Items

The "Clean up old Items" makes the Item Name, Product ID and UPC/EAN/ISBN fields available for reuse since these are the only fields that are generally assigned by a user. The Item ID is an auto incriminating id number create by the database engine.