coreSTORE - Inventory: General Item Guidelines
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.
There are 6 ways our database looks up Items.
These are:
Item Name
UPC/EAN/ISBN
Product ID
Item ID
Additional Item Numbers
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.
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.
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:
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.
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.
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.
Updated on: 06/26/2024
Thank you!