NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Supplier Product Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Supplier Code |
15 |
Character |
Yes |
Enter a valid supplier code for the product. For information on creating supplier codes, see Supplier Maintenance. |
B |
2 |
Product Code |
40 |
Character |
Yes |
Enter a valid product code for the product. For information on creating product codes, see Product Maintenance. |
C |
3 |
Supplier's Product Code |
20 |
Character |
No |
Enter the product code used by the supplier for the product. Example The product code for a product is 123 in Product Maintenance. Supplier ABC identifies the product as A314-B6. |
D |
4 |
Supplier's Product Name |
30 |
Character |
No |
Enter the name used by the supplier to identify the product. |
E |
5 |
Description |
60 |
Character |
No |
Enter the description used by the supplier for the product. |
F |
6 |
Purchase Increment |
16 |
>>>,>>>,>>9.99<< |
No |
Enter the purchase increment for the product that can be used on a purchase order. The increment is in the unit of measure entered for the Unit of Measure field. Example The product can only be ordered in increments of 10 cases from this supplier. Note If you enter a purchase increment, it is used in Purchase Order Maintenance. |
G |
7 |
Minimum Purchase Quantity |
16 |
>>>,>>>,>>9.99<< |
No |
Enter the minimum quantity that can be ordered on a purchase order. The minimum quantity is in the unit of measure entered for the Unit of Measure field. Example The product can only be ordered from this supplier if 25 cases or more are ordered. Note If you enter a minimum purchase quantity, it is used in Purchase Order Maintenance. |
H |
8 |
Quality Rating |
8 |
Character |
No |
Enter the quality rating for the supplier. This rating is only used for reporting. |
I |
9 |
Additional Duty Basis |
17
|
->>>,>>>,>>9.99<< |
No |
Enter an amount that is added to the purchasing cost of the product for duty calculations. |
J |
10 |
Delivery Rating |
8 |
Character |
No |
Enter the delivery rating for the supplier. This rating is only used for reporting. |
K |
11 |
Lead Time |
8 |
>>>>>>>9 |
No |
Enter the number of days between the purchase order date and the date the product is expected to be received (and available to be sold). |
L |
12 |
Tax Category |
8 |
Character |
No |
Leave this field blank. This field is not used. |
M |
13 |
Active |
3 |
Yes/No |
No |
Enter Yes if the supplier product is currently active or No if it is not. If this field is blank, it defaults to Yes. |
N |
14 |
Under Contract |
3 |
Yes/No |
No |
Enter Yes if your company has a contract with the supplier for the product. If this field is blank, it defaults to No. |
O |
15 |
Unit of Measure |
8 |
Character |
Yes |
Enter a valid purchasing unit of measure for the product. For information on creating units of measure, see Unit of Measure Maintenance. |
P |
16 |
Country of Origin |
10 |
Character |
No |
Enter a valid country code for the product's country of origin. For information on creating country codes, see Country Maintenance. |
Q |
17 |
Goal Seek Unit Code |
12 |
Character |
No |
Enter the goal seek unit code for the supplier product. For information on setting up goal seek unit codes, see Goal Seek Unit Maintenance. |
R |
18 |
Goal Seek Unit Count |
14 |
>>>>>>>>9.99<< |
No |
Enter the goal seek unit count for the supplier product. This value is used to convert the goal seek unit to the default purchasing unit of measure for the supplier product. If this field is blank, it defaults to 1. |
S |
19 |
In Transit Lead Time |
4 |
>>>9 |
No |
Enter the in-transit lead time for the product, which is the number of days between when the product is shipped and received. This is used by DRP to calculate purchase order and blanket release ship dates. Example If the in-transit lead time is 10 days, and the purchase order delivery date is 06/15/2020, the purchase order ship date is calculated as 06/05/2020. |
Before using this import, the following must be set up:
suppliers
products
units of measure
There must be a record of blank space(s) at the end of an import file.