Fields

Description

Item Name

This is the name of your product. Your product name can include letters, numbers and symbols. This is a mandatory field.

tem Short Name

This is the short name of your product.

Item Desc.

This is a description of your product. This field is used by Uprow Retail when searching. A good description is vital to searching items by keywords.

UPC/EAN

Standard barcode number found on many products. You can fill in this field by scanning the product's barcode. The UPC and EAN fields are numeric fields.

Barcode

This is the barcode number of your product. If left blank, Uprow will automatically generate one for you. If the barcode consists of only numerical values, Excel will convert it into scientific notation. To convert it to a whole number, check out our FAQ section.

Product Type

The type of an item determines if there are any other special characteristics you would like to track for the item.

Standard: An item with no attribute.

Matrix: An item with multiple attributes like brand, color etc.

Please write S for standard product and write M for Matrix product.

Item Group

An item group is a collection of products which share similar attributes like color, features or usage. Item groups can also be formed based on the markets in which they’re sold or if they’re similar in price. For example, if an iPhone is an item group, then items in that group would be iPhone 5, iPhone 6 and iPhone 6s.

Brand Name

The brand name of your Product – i.e. Nike, Gucci etc.

Basic Rate

Cost that you usually receive the item at. It is the amount which includes purely the purchase price of the items without including other amounts such as discount, tax, freight charges etc.

MRP

A maximum retail price (MRP) is a manufacturer calculated price that is the highest price that can be charged for a product sold in India. However, retailers may choose to sell products for less than the MRP.

Qty On Hand

Add how much inventory you have in store for the product

GST

HSN

HSN (Harmonized System of Nomenclature) contains six digit uniform code that classifies products. HSN code can be recorded for the item for GST compliance. These set of defined rules is used for taxation purposes in identifying the rate of tax applicable to a product in a country. 

As of Date

 As of date is the date upon which quantity on hand is considered to be counted. 

Tax Slab

Tax class the item falls under. Usually leave this to default but in some circumstances you may charge a different tax amount on items and you'll need to set a tax slab for them.

Tax Inclusive

Please write Y if the prices are inclusive of all taxes else write N

Base UOM

UOM (Unit of Measurement) is used to quantify items and to track inventory of the items e.g Pack

UOM Conversion Value

To map UOM to items you must have base UOM, Sub UOM and Conversion factor values

Sub UOM

 Sub UOM will be sub units like pieces in Pack e.g 10 pieces = 1 Pack

Batch Confirmation

Please write R if batch confirmation is required for this product else write N

Batch No.

Batch Number allows you to group and monitor a set of stock that share similar properties.

With Batch Number you can:

        ·         Track the expiration of items.

        ·         Trace defective items back to the batch that it belonged.

In Uprow, you will be able to record the items you receive as batches along with its manufactured date and expiry date. And later when you are looking to make a sale, you can safely pick items from those batches that are well within its usage period

Reorder Level

The reorder Level is the quantity at which this product will be auto-filled the next time you create a stock order containing the product.

Reorder Qty

The reorder amount is the default amount that you will order when your product hits its reorder point or level.

Check Negative Stock

Write Y if you want this product to be sold even when it appears as out of stock on Uprow, Write N if you don’t.

Disc Rs

 Discount in Rupees

Disc %

 Discount in percentage

Special Disc %

 Any type of special discount in percentage given over the basic discounts.

MFG Confirmation

Manufacturing confirmation is just to ask if you want to manage MFG date. If Manufacturing date is required please write 'R' and if not required write 'N'

MFG Date

 Please write manufacturing date in DD/MM/YYYY format

Expiry Confirmation

Expiry confirmation is just to ask if you want to manage expiry date. If expiry date is required please write 'R' and if not required write 'N'

Expiry Date

Expiry date is the date, as the name suggests, on which a particular product expires. Please write expiry date in DD/MM/YYYY format

Sale Rate

 Sale rate is the rate you want to sell your product at.

Item Subgroup

 In case there are a lot of items in business, companies usually group these by item groups. In some cases when there are thousands of items, these are further divided into subgroups