Item ID Category Item Name Description Manufacturer

This column will include “Item ID”. Do Categorize your items to This is the name of your The description of Specify the
not edit the values in the id column! organize them. product. Your product your product. you manufacturer or brand
Inventory items that are already in the Note: To create a product name can include letters, can have letters, of the item in your
system will have a unique value. from import, you can add numbers and symbols. numbers, and inventory. Adding the
⚠️Note: Kindly leave the field blank more than one category. symbols in this field. manufacturer
when you're creating new products. Always use a > separator to information helps in
specify parent & child organizing and
relationship. For Example: Dell categorizing items
> Inspiron 5th Gen based on their brand.

5925 Mobile Parts iPhone 11 OEM Screeen oem screeen Apple

Device SKU Supplier Multiple Supplier SKUs UPC
Specify the device or A stock-keeping unit Name of your This column allows you to enter This is your Universal
model associated with (SKU) is a scannable supplier. the multiple vendor SKUs for each Product code.
the item in your barcode to help item. To add multiple suppliers,
inventory. It helps in customers automatically separate them with semi colon so
organizing inventory track the movement of you can add SKU against that
items based on specific inventory. supplier e.g. mobile sentrix : sku1 |
makes or models, injured gadget : sku2. Note: If
streamlining inventory existing SKUs are removed from
management and making this column, the SKUs will be
it easier to locate items deleted.
when needed.

iPhone 11 59253
Manage Inventory level Valuation Method Manage Serials On Hand Qty New Stock Adjustment
This column indicates This column refers to You can mark yes if you Your products on You can place value here if
whether you want to the various valuation want to manage hand. If you want you want to update the stock
manage the inventory level methods used for inventory item with level with new on hand value.
for the item. If set to Yes, it calculating the item's serials. Please note that to update available If you have already on hand
enables inventory cost, such as Weighted valuation method will not qty, please use stock available, system will
management for the item, Average Cost (WAC), be applicable if you use New Stock replace the value with the
allowing you to track stock Last In First Out (LIFO), serialized inventory. If Adjustment adjustment. To decrease the
quantities, receive alerts for and First In First Out you have already stock column to update. stock, simply add a negative
low stock levels, and (FIFO). available, please make Any changes made sign before the quantity e.g. -
manage reordering. sure that stock value in this column will 5. Let’s say if you have 10
should be 0 for serialized items available and you
item not reflect in the reduce the stock by writing -2
system. in this column, your new
stock will be 8.
YES YES 11
 New Inventory Item
Cost Price Cost Retail Price Online Price Promotional Price Minimum Price
The cost of your The cost of your new Enter the retail price of Specifies the price at This column This column indicates the
available products (on stock. You can put value your product which the item will be indicates the minimum price at which
here if you update the listed and displayed discounted price the item can be sold by
hand). If you want to unit cost of your on on your online sales of the item offered your employees. It
update cost, please use hand stock. System will channels. during ensures that the product
New Unit Cost column do the revaluation based promotional is not undersold,
to update. Any changes on your new cost value campaigns or maintaining profitability
made in this column special offers. and pricing consistency
will not reflect in the across transactions.
system.

17.00 35.00 0.00 0.00 0.00

Tax Class Tax Inclusive Stock Warning Re-Order Level Condition Physical Location
Specifies the tax This column indicates The minimum quantity This column indicates the This column indicates This column
class applicable to whether tax is will alert when minimum quantity threshold the current condition indicates the
the item. This class included in the item's reordering stock. at which the system of the item in your specific physical
determines the tax price. If set to Yes, the prompts a reorder for the inventory. It allows location where the
rate applied to the tax inclusive trigger item. When the stock level you to categorize item is stored or
item's price during will be enabled, of the item falls below this items based on their placed within your
transactions. meaning that the threshold, the system sends condition, such as inventory.
displayed price the item in the low stock new, refurbished,
includes applicable report. used, or damaged.
taxes.

NO 0 New
 Commission
Warranty Warranty Time Frame IMEI Display On Point of Sale Percentage Commission Amount
Enter the warranty number Warranty will be Add IMEI of the If set to Yes, the item Specify your Specify your
for warranty time frame. applicable in Days, item in this column. will visible and can be commission commission amount in
Leave the column blank. If Months, Years and sold at the POS. If set to percentage in this this column.
there is no warranty, please lifetime only. No, the item will not be column. The system
leave the column blank. listed for sale on the will calculate the
Note: This field will accept POS. commission based on
numeric numbers only. the provided
percentage

90 Days YES 0.00 0.00