Manage Products

Organization (Web form) (Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
The Depot which manages the product being created
2. Input rules:
Click on this field. Input the Organization Name/Organization Code of the appropriate Depot into the search bar, then select from the drop down menu
Note:
The Organization Name/Organization Code can be found under "Organization Name" and "Organization Code" columns in "Organizations > Organization List" tab

Product Category (Web form); Product Category Code (Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
The product category in which the product being created belongs
2. Input rules:
Web form:
Click on this field and choose the appropriate value from the drop down menu
Excel template:
Copy the appropriate Product Category Code on Web app, then paste into this cell
The category code can be found under "Category Code" column in "Products > Product Categories" tab

Product Code
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
A management code assigned to the product being created
2. Input rules:
Format: Must not contain spaces
For example: "Product 01" is not acceptable; "Product_01" is acceptable
Important Note:
For products that you don't want to synchronize with the external resource planning system, input the prefix consists of the following two symbols: Hash and Underscore
For example: Products with product code "#_Product01" will not be synchronized with the external resource planning system

Parent Product Code
(Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Management code of the product that is on the upper level to the product being created
2. Input rules:
Copy the value in the Product Code cell then paste into this cell

Product Name
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Product name of the product being created
2. Input rules:
Format: Free-form

Number Per Case
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Number of single items in a whole case, if the product being created is normally stored in a case
2. Input rules:
Input the value in numbers. Do not input the unit
For example: A beer crate has twenty four single bottles. Input the following value into the field/cell: 24

Case Price
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Price of a whole case of the product being created
2. Input rules:
Input the value in numbers. Do not input the unit
For example: The product being created has the Case price of two hundred dollars. Input the following value into the field/cell: 200

Item Price
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Price of a single item of the product being created, if the sales orders include single items of that product, not just whole cases
2. Input rules:
Input the value in numbers. Do not input the unit
For example: The product being created has the Item price of forty dollars per item. Input the following value into the field/cell: 40

Product Discount
(Web form)
(Optional)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
The money value to be subtracted from the total value of any Sales order that includes the product being created
This value is fixed, regardless of how many whole cases/single items are loaded
2. Input rules:
Input the value in numbers. Do not input the unit
For example: You want to discount two dollars from the total value of any sales order that includes the product being created. Input the following value into the field/cell: 2
If there is no discount, input the following value into the field/cell: 0. Do not leave the field/cell blank

Weight (kg)
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Weight (In kilogram, or kg) of a Case of the product being created
2. Input rules:
Input the value in numbers. Do not input the unit
If the value is a decimal, separate the whole number part and the fractional part by a decimal point. Do not use comma
For example: The weight of a case is zero point eight kilogram. Input the following value into the field: 0.8

Volume (m3)
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Volume (In cubic meter, or m3) of a Case of the product being created
2. Input rules:
Input the value in numbers. Do not input the unit
If the value is a decimal, separate the whole number part and the fractional part by a decimal point. Do not use comma
For example: The volume of a case is zero point eight m3. Input the following value into the field/cell: 0.8

Quantity
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Quantity of the Cases for the product being created. Value in this field will show up under the "On-Hand" column in "Products > Inventory" tab
2. Input rules:
Input the value in numbers. Do not input the unit
For example: The product being created has two hundred cases in the warehouse. Input the following value into the field/cell: 200

Form/Unit (Web form); Unit (Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
The unit of measure for the product being created
2. Input rules:
Format: Text
For example: The product being created is beer crate. Input the following value into the field/cell: Crate

Conversion Unit
(Web form + Excel template)
(Optional)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Conversion ratio from the unit of measure of the product being created to a default unit of measure specified by the management organization
This field is used to calculate the price of Transport service by product
2. Input rules:
Input the value in numbers. Do not input the unit
For example: The default unit of measure specified by your organization is Pack. If the unit of measure of the product being created is Crate, around 2.5 times larger in volume (or other attributes, depends on how the management organization specifies) than Pack, input the following value into the field/cell: 2.5

Start Date
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
The date when the product being created is officially started being produced
2. Input rules:
Format: mm/dd/yyyy (Month/Date/Year)
Web form:
Choose the date on the drop down calendar by clicking on this icon:
Excel template:
Input in mm/dd/yyyy format, similar to Web form

End Date
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
The date when the product is officially deemed expired
After this date, the product will be hidden, not visible on the system
2. Input rules:
Same as Start Date field

Temperature (Web form); Temperature Level (Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Temperature level of the product being created
There are three temperature levels: Ambient; Chilled; Frozen
Read more about this configuration at this article: Optimize routes with Cold Chain
2. Input rules:
Web form:
Click on the appropriate radio box
Excel template:
Input only one of these values into the cell: F, A, C
The above letters represent these temperature levels respectively: Frozen, Ambient, Chilled

Properties (Web form); Variant Property (Excel template)
(Optional)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
Special attributes of the product being created, to better manage the product
Each property consists of three information fields:

• *Property Name**: A name assigned to that property
• *Property Type**: Data type of the property: A string of text, A specific date or A number
• *Property Value: Exact value of the property, only able to input after choosing Property Type
Note:
  Each product can have multiple properties
2. Input rules:**
  Web form:
  Click on this icon to add one property:
  Input value into the fields of the property sequentially from left to right
  Excel template:
  Input the property into the cell in the format below:
  Property Name : Property Type : Property Value
  (Notice there is a space on each side of the colon)
• *Property Name: Input name of the property, similar to Web form
Property Type: Input either of these numbers: *1, 2, 3
  These numbers represent these values in Web form respectively:Text, Date, Number***
• *Property Value: Input the value of the property, similar to Web form
Note:
  If there are multiple properties, two adjacent properties will be separated by a vertical line, with a space on each side of the vertical line
  For example:
  *Color : 1 : Red | Expiry : 2 : 12/20/2018
  Means there are two properties:
First property:***
• Property Name:* Color
• Property Type:* Text
• Property Value:* Red
  Second property:
• Property Name:* Expiry
• Property Type:* Date
• Property Value:* 12/20/2018

Product Serial
(Excel template)
(Optional)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
The serial number of the product being created
2. Input rules:
Format: Free-form

Tracking By
(Web form + Excel template)
(Required)

On Web form: Product Detail tab
On Excel template: Import_Product_Template
1. Description:
The tracking mode of the product being created
There are three mode options: Tracking by Serial; Tracking by Lot number; and No tracking
2. Input rules:
Web form:
Click on the appropriate radio box
Excel template:
If the product is tracked by Lot number, input the following value into this cell: 1 - Lot Number
If the product is tracked by Serial number, input the following value into this cell: 2 - Serial Number
If the product is not tracked, input the following value into this cell: 0 - No Tracking

Organization Code (Excel template) (Required)

On Excel template: Import_LotNumber_Template
1. Description:
The Depot which manages the product being created/updated
2. Input rules:
Copy the Organization Code of the appropriate Depot on Web app, then paste into this cell
Note:
The Organization Code can be found under "Organization Code" column in "Organizations > Organization List" tab

Product Code
(Excel template)
(Required)

On Excel template: Import_LotNumber_Template
1. Description:
The product code of the product you want to update
2. Input rules:
Copy the appropriate Product Code on Web app, then paste into this cell
Note:
The Product Code can be found under "Product Code" column in "Products > Inventory" tab

Lot Number
(Web form + Excel template)
(Required)

On Web form: Lot Number tab
On Excel template: Import_LotNumber_Template
1. Description:
The product lot number of the product being created/updated
2. Input rules:
Format: Free-form
Web form:

QC Number
(Web form + Excel template)
(Required)

On Web form: Lot Number tab
On Excel template: Import_LotNumber_Template
1. Description:
The quality checking number of the product being created/updated
2. Input rules:
Format: Free-form

On-hand Quantity
(Web form + Excel template)
(Required)

On Web form: Lot Number tab
On Excel template: Import_LotNumber_Template
1. Description:
The on-hand quantity of the product being created/updated
The value input into this field will replace the value currently displayed on Web app
2. Input rules:
Only input the value in numbers. Do not input the unit
For example: The product being updated is beer crate. You want to update the on-hand quantity of this product to two hundred thousand crates. Input the following value into this field/cell: 200000

On-hand

The total SKU quantity that are physically located in the warehouse at the current time

Picked

The SKU quantity in the Depart way of all on-going sales orders that have actually been picked up from the warehouse onto the delivery vehicles

On-SOrder

The total SKU quantity in the Depart way of all on-going Sales orders

Returning

The SKU quantity in the Return way of all on-going sales orders that have actually been picked up from the customers onto the delivery vehicles

On-ROrder

The total SKU quantity in the Return way of all on-going Sales orders

On-POrder

The total SKU quantity of all on-going Purchase orders

1

Product lots exist, quantity is larger than zero

Product lots don't exist yet

Create the product lots on Abivin vRoute, with the same quantity as on the data

2

Product lots exist, quantity is larger than zero

Product lots exist, quantity not the same as on the data

Update the quantity of the product lots on Abivin vRoute to be the same as on the data

3

Product lots don't exist

Product lots exist, quantity is larger than zero

Update the quantity of the product lots on Abivin vRoute to be zero