NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Product Unit of Measure Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Unit of Measure Type |
1 |
Character |
Yes |
Enter the type of unit of measure import record. Enter P for product, C for product category, or L for product/location. |
B |
2 |
Product Code |
40 |
Character |
Yes, only if P or L is entered for the Unit of Measure Type field |
If you are importing unit of measure information for a product or product/location, enter a valid product code. For information on setting up product codes, see Product Maintenance. This field is not used if C is entered for the Unit of Measure Type field. |
C |
3 |
Location Prefix |
3
|
Character |
Yes, only if L is entered for the Unit of Measure Type field |
If you are importing unit of measure information for a product/location, enter a valid location prefix. For information on setting up location prefixes, see Location Maintenance. This field is not used if P or C is entered for the Unit of Measure Type field. |
D |
4 |
Product Category |
12 |
Character |
Yes, only if C is entered for the Unit of Measure Type field |
If you are importing unit of measure information for a product category, enter a valid product category. For information on setting up product categories, see Product Category Maintenance. This field is not used if P or L is entered for the Unit of Measure Type field. |
E
|
5 |
Unit of Measure |
8 |
Character |
Yes |
Enter a valid unit of measure. For information on setting up units of measure, see Unit of Measure Maintenance. |
F |
6 |
Picking Unit of Measure |
3 |
Yes/No |
Yes, only if the Purchasing Unit of Measure and Selling Unit of Measure fields are blank |
Enter Yes if the imported unit of measure can be used for pick demands. You must enter Yes for one of the Picking Unit of Measure, Purchasing Unit of Measure, or Selling Unit of Measure fields or the record will not be imported. |
G |
7 |
Purchasing Unit of Measure |
3 |
Yes/No |
Yes, only if the Picking Unit of Measure and Selling Unit of Measure fields are blank |
Enter Yes if the imported unit of measure can be used for purchase orders. You must enter Yes for one of the Picking Unit of Measure, Purchasing Unit of Measure, or Selling Unit of Measure fields or the record will not be imported. |
H |
8 |
Selling Unit of Measure |
3 |
Yes/No |
Yes, only if the Picking Unit of Measure and Purchasing Unit of Measure fields are blank |
Enter Yes if the imported unit of measure can be used for sales orders. You must enter Yes for one of the Picking Unit of Measure, Purchasing Unit of Measure, or Selling Unit of Measure fields or the record will not be imported. |
I |
9 |
Default Display Unit of Measure |
3 |
Yes/No |
No |
Enter Yes if the unit of measure is the default display unit of measure. If you are importing multiple units of measure for the same product, the last one imported with Yes entered for this field will be the default. You cannot enter No for the current default display unit of measure. If you want to change the current default display unit of measure, you can import a different unit of measure and enter Yes for this field. |
J |
10 |
Default Purchase Unit of Measure |
3 |
Yes/No |
No |
Enter Yes if the unit of measure is the default purchase unit of measure. If you are importing multiple units of measure for the same product, the last one imported with Yes entered for this field will be the default. You cannot enter No for the current default purchase unit of measure. If you want to change the current default purchase unit of measure, you can import a different unit of measure and enter Yes for this field. |
K |
11 |
Default Selling Unit of Measure |
3 |
Yes/No |
No |
Enter Yes if the unit of measure is the default selling unit of measure. If you are importing multiple units of measure for the same product, the last one imported with Yes entered for this field will be the default. You cannot enter No for the current default selling unit of measure. If you want to change the current default selling unit of measure, you can import a different unit of measure and enter Yes for this field. |
L |
12 |
Default Receipt Unit of Measure |
3 |
Yes/No |
No |
Enter Yes if the unit of measure is the default receipt unit of measure. If you are importing multiple units of measure for the same product, the last one imported with Yes entered for this field will be the default. You cannot enter No for the current default receipt unit of measure. If you want to change the current default receipt unit of measure, you can import a different unit of measure and enter Yes for this field. |
M |
13 |
Height |
10 |
>>>>>>9.99 |
No |
Enter the height of the product in the unit of measure. |
N |
14 |
Length |
10 |
>>>>>>9.99 |
No |
Enter the length of the product in the unit of measure. |
O |
15 |
Width |
10 |
>>>>>>9.99 |
No |
Enter the width of the product in the unit of measure. |
P |
16 |
Gross Packaged Weight |
10 |
>>>>>>9.99 |
No |
Enter the gross packaged weight of the product in the unit of measure. |
Q |
17 |
Net Weight |
10 |
>>>>>>9.99 |
Yes, only if the unit of measure is for a catch-weight product |
Enter the net weight of the product in the unit of measure. |
R |
18 |
Weight Unit of Measure |
8 |
Character |
No |
Enter a valid unit of measure for the weights entered for the Gross Packaged Weight and Net Weight fields. For information on setting up units of measure, see Unit of Measure Maintenance. If this is blank, it defaults to the default weight unit of measure entered in Warehouse Management Control Maintenance. |
S |
19 |
Putaway Group Name |
30 |
Character |
No |
Enter a valid putaway group name for the product unit of measure. This field is used for automatic putaway processing. For information on setting up putaway groups, see Putaway Group Maintenance. |
T |
20 |
Primary Pick Bin |
20 |
Character |
No |
Enter the primary pick bin for shipping. This field is only used if L is entered for the Unit of Measure Type field. This field cannot be used if you are using a primary pick zone. |
U |
21 |
Primary Pick Zone |
20 |
Character |
No |
Enter the primary pick zone for shipping. This field is only used if L is entered for the Unit of Measure Type field. This field cannot be used if you are using a primary pick bin. |
V |
22 |
Replenish Minimum |
10 |
>>>>>>>>>9 |
No |
Enter the bin or zone minimum replenishment. This field is only used if L is entered for the Unit of Measure Type field. When the bin or zone falls below this number, a replenishment notice is created. |
W |
23 |
Replenishment Maximum |
10 |
>>>>>>>>>9 |
No |
Enter the bin maximum replenishment. This field is only used if L is entered for the Unit of Measure Type field. When the bin or zone replenishment is recommended, this is the maximum quantity that is recommended. |
X |
24 |
UPC |
25 |
Character |
No |
Enter the Universal Product Code (UPC) for the unit of measure. |
Y |
25 |
Break to Unit of Measure |
8 |
Character |
No |
If this unit of measure can be broken down into a smaller unit of measure, enter the unit of measure. If this field is blank, the unit of measure cannot be broken down in the picking or replenishment process. Example A pallet/100 unit of measure is broken down into the case/10 unit of measure, which is broken down to the each unit of measure. If a promotional 2-pack unit of measure bundled in special packaging was sold for this product, it would not be broken down to the each unit of measure. |
Z |
26 |
GTIN |
14 |
Character |
No |
Enter the Global Trade Item Number (GTIN). This number is used for RFID purposes. |
AA |
27 |
Label Format |
40 |
Character |
No |
Enter the receiving label format for the unit of measure. |
AB |
28 |
Can Be Packaged |
3 |
Yes/No |
No |
Enter Yes if a product in the unit of measure can be packaged into other larger packages for picking cartonization. If this field is blank or No, the unit of measure is considered a package and cannot be put into a larger package. |
AC |
29 |
Web |
3 |
Yes/No |
No |
Enter Yes if you want to make the unit of measure available for customer portal sites. This field is only used if if P is entered for the Unit of Measure Type field (position 1). |
AD |
30 |
Dimensional Unit of Measure |
8 |
Character |
Yes, only if a value is entered for the Height, Length, and/or Width field |
Enter a valid unit of measure for the height, length, and width entered for the Height, Length, and Width fields. For information on setting up units of measure, see Unit of Measure Maintenance. |
AE |
31 |
Cube (Volume) |
11 |
>>>>>9.9999 |
No |
Enter the volume for the unit of measure. |
AF |
32 |
Cube (Volume) Unit of Measure |
8 |
Character |
No |
Enter a valid unit of measure for the volume entered for the Cube (Volume) field. For information on setting up units of measure, see Unit of Measure Maintenance. If this is blank, it defaults to the default cube unit of measure entered in Warehouse Management Control Maintenance. |
AG |
33 |
Velocity Code |
12 |
Character |
No |
Enter the velocity code associated with the frequency of picking activity for the unit of measure. For information on setting up velocity codes, see Velocity Maintenance. |
AH |
34 |
Pick Sequence Group |
12 |
Character |
No |
Enter the pick sequence group for the unit of measure. For information on setting up pick sequence groups, see Pick Sequence Group Maintenance. |
AI |
35 |
Default Web Unit of Measure |
3 |
Yes/No |
No |
Enter Yes if the unit of measure is the default unit of measure for customer portal sites. If you are importing multiple units of measure for the same product, the last one imported with Yes entered for this field will be the default. NOTE If you enter Yes for this field, the unit of measure must be a Web unit of measure. |
AJ |
36 |
eCommerce Unit of Measure |
3 |
Yes/No |
No |
Enter Yes if the unit of measure is the default unit of measure for Aptean eCommerce B2C sites. |
AK |
37 |
eCommerce Price |
12 |
>>>>>>>>9.99 |
No |
Enter the price to be used for Aptean eCommerce B2C sites. |
Before using this import, the following must be set up:
products, locations, or product categories
units of measure
The values entered for the Product Code, Location, Category, Unit of Measure, Putaway Group Name, Primary Pick Bin, and Primary Pick Zone fields must be valid (if entered).
To acquire a thorough understanding of the fields and buttons required for creating a product/unit of measure record, see Product Maintenance or Product Location Maintenance. The two windows are equivalent with the exception of location-specific fields and buttons defined in Product Location Maintenance.
There must be a record of blank space(s) at the end of an import file.
This import updates product units of measure in the order that they are found in the import file without considering future lines. If you set units of measure as a default unit of measure in multiple lines, the unit of measure in the last line is used as the default.