Manage Products

Organization (Webform) (Required)

1. Description:
The Organization (Of Depot/Sun/Crossdock types) which directly manages the inventory of the Product being created
2. Input rules:
Click on this field. Input the Organization Name/Organization Code of the appropriate Depot/Sun/Crossdock into the search bar then select it from the drop-down menu
Note:
The Organization Name/Organization Code can be found under the columns of the same name in the "Organizations > Organizations" tab
This field is not present in the Excel import file. When you use the Excel import file to create the Products, you will have to perform additional steps which will be covered below

Product Category (Webform); Product Category Code (Excel import file)
(Required)

1. Description:
The product category in which the product being created belongs
2. Input rules:
Web form:
Click on this field and choose the suitable 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
(Webform + Excel import file)
(Required)

1. Description:
The management code assigned to the Product being created
2. Input rules:
Format: Can contain letters, numbers, special characters. Must not contain spaces
For example: "Product 01" is not acceptable; "Product_01" is acceptable

Parent Product Code
(Excel import file)
(Required)

1. Description:
The Product Code of the upper-level Product (If any) of the Product being created
One Product can have only one upper-level Product
2. Input rules:
If the Product being created has an existing upper-level Product, copy the Product Code of the upper-level Product on the Web app then paste it into this cell
If the Product being created doesn't have an upper-level Product, copy the value in that Product's Product Code then paste it into this cell, do not leave this cell blank otherwise you would not be able to import the Excel file onto the system

Product Name
(Webform + Excel import file)
(Required)

1. Description:
Product name of the product being created
2. Input rules:
Format: Free-form

Items Per Case
(Webform + Excel import file)
(Required)

1. Description:
Number of single items in a whole case, if the product being created is normally stored in a case
2. Input rules:
Format: Integer number only. The value must be larger than or at least equal to 1
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
Notes when using Web form:
If you accidentally leave this cell blank or input the value "0", the system will automatically fill the value "1"

Case Price
(Webform + Excel import file)
(Required)

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 to be two hundred dollars per case. Input the following value into the field/cell: 200

Item Price
(Webform + Excel import file)
(Required)

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 to be forty dollars per item. Input the following value into the field/cell: 40

Product Discount
(Web form)
(Optional)

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 the quantity of whole case/single items being 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

Weight (kg)
(Webform + Excel import file)
(Required)

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)
(Webform + Excel import file)
(Required)

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 or a comma, based on the setting of your computer
For example: The volume of a case is zero point eight m3. Input the following value into the field/cell: 0.8

Length (m)
(Webform + Excel import file)
(Optional)

1. Description:
Length of a whole case of the product being created
Unit: Meter (m)
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 or a comma, based on the setting of your computer
For example: The length of a case is zero point eight meter. Input the following value into the field/cell: 0.8
If you do not have data of this field, just leave the field/cell blank
Note:
If the configuration "Oversized Goods Restriction" of the Manufacturer is enabled, this field/cell will become required, and the value input must be larger than 0

Width (m)
(Webform + Excel import file)
(Optional)

1. Description:
Width of a whole case of the product being created
Unit: Meter (m)
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 or a comma, based on the setting of your computer
For example: The width of a case is zero point eight meter. Input the following value into the field/cell: 0.8
If you do not have data of this field, just leave the field/cell blank
Note:
If the configuration "Oversized Goods Restriction" of the Manufacturer is enabled, this field/cell will become required, and the value input must be larger than 0

Height (m)
(Webform + Excel import file)
(Optional)

1. Description:
Height of a whole case of the product being created
Unit: Meter (m)
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 or a comma, based on the setting of your computer
For example: The height of a case is zero point eight meter. Input the following value into the field/cell: 0.8
If you do not have data of this field, just leave the field/cell blank
Note:
If the configuration "Oversized Goods Restriction" of the Manufacturer is enabled, this field/cell will become required, and the value input must be larger than 0

On-hand Quantity
(Webform + Excel import file)
(Required)

1. Description:
Quantity of whole cases of 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

Unit (Webform); Unit (Excel import file)
(Required)

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
(Webform + Excel import file)
(Optional)

This information field is only used for VRP - Transporters to Create Routes Model
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
(Webform + Excel import file)
(Required)

1. Description:
The date on which the Product being created is officially started being produced
2. Input rules:
Format: mm/dd/yyyy (Month/Date/Year)
Webform:
Input directly into this field or click on the calendar icon and select the appropriate date on the drop-down calendar
Excel template:
Input the appropriate date into this cell following the Month/Date/Year mm/dd/yyyy format, similar to the Webform

End Date
(Webform + Excel import file)
(Required)

1. Description:
The date on which the Product being created is officially stopped being produced
2. Input rules:
Same as the Start Date field
Important Note:
If the current date on your computer is a later date compared to the End Date, the Product will be hidden on the "Products > Inventory" tab. Therefore, when you create the Products, make sure to input a distant future date into this field/cell to avoid the Products become invisible undesirably

Product Temperature (Webform); Temperature (Excel import file)
(Required)

1. Description:
The temperature level of the Product being created
There are three default Product temperature levels: Ambient; Chilled; Frozen
Read more about this configuration in the following article: Cold Chain
2. Input rules:
Web form:
Tick the respective radio box of the appropriate temperature level
Excel import file:
Input only one of the following values into this cell: F, A, C
The above three letters represent the following temperature levels, respectively: Frozen, Ambient, Chilled

Properties (Webform); Variant Property (Excel import file)
(Optional)

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 import file)
(Optional)

1. Description:
The serial number of the product being created
2. Input rules:
Format: Free-form

Tracking By
(Webform + Excel import file)
(Optional)

1. Description:
This information field is only used for VRP - Outsourcing fleet Model
2. Input rules:
Web form:
Always click on the following radio box: No Tracking
Excel template:
Just leave this cell blank

Number Of Layers
(Webform + Excel import file)
(Optional)

1. Description:
Specify the maximum number of product cases (layers) of the product being created that can be stacked on top of one another inside the vehicle's container
2. Input Rules:
Format: Number
For example: A maximum of one hundred cases of the product can be stacked on top of one another inside the vehicle's container. Input the following value into the field/cell: 100
Notes:
The number of layers can not exceed the following value: 1000

Facets
(Webform + Excel import file)
(Optional)

1. Description:
Specify the facets (sides) of the product case that can be arranged to face the vehicle's container floor when loaded
2. Input Rules:
Web form:
Click on the corresponding checkbox of the sides you want
You can select multiple or all checkboxes
Excel template:
Input only one of the following seven values into this cell: 1; 2; 3; 12; 13; 23; 123
In which:
The value '1' means the Front and Back sides of the product case can face the vehicle container floor
The value '2' means the Left and Right sides of the product case can face the vehicle container floor
The value '3' means the Top and Bottom sides of the product case can face the vehicle container floor