NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for changing a record in Customer Product Change Import.
Customer Code |
Product Code |
Customer Product Code |
Field Value Name or Number (see table below) |
New Value |
Example You import from a text file that includes the following: 101^101^StdBottle^10100^NewBottle
This changes the customer product name for customer code 101 and product code 101 to NewBottle.
The following table lists fields that can be updated. You can indicate a field by either its value name or its number.
Value Name |
Number |
Maximum Length |
Format |
Description |
Apprise Field |
cust-product-name |
10100 |
30 |
Character |
Enter the customer’s product name for the product. |
Name field in Customer Product Maintenance |
cust-upc-code |
10200 |
25 |
Character |
Enter the customer’s UPC for the product. This field is typically used for custom invoice printing. |
Customer UPC Code field in Customer Product Maintenance |
cust-mfg-code |
10300 |
20 |
Character |
Enter the customer's manufacturing code for the product. This field is typically used for custom invoice printing. |
Customer Mfg Code field in Customer Product Maintenance |
retail-price |
10400 |
18 |
>>>,>>>,>>>,>>9.99 |
Enter the customer’s suggested retail price (informational only; no other standard functionality). This field is used for custom retail label printing. |
Retail Price field in Customer Product Maintenance |
retail-label-type |
10500 |
10 |
Character |
Enter the customer’s retail label type. This field is used for custom retail label printing. |
Retail Label Type field in Customer Product Maintenance |
user-1 |
10600 |
30 |
Character |
Enter appropriate data for this user-defined field. This field is typically used for custom invoice printing purposes. |
User Defined 1 field in Customer Product Maintenance |
user-2 |
10700 |
30 |
Character |
Enter appropriate data for this user-defined field. This field is typically used for custom invoice printing purposes. |
User Defined 2 field in Customer Product Maintenance |
default-selling-um |
10800 |
8 |
Character |
Enter a valid default selling unit of measure used in Order Entry when entering an order line item for the customer and product. This must be the same type of unit of measure as the product unit of measure for the product, and this must be a selling unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance. |
Default Selling U/M field in Customer Product Maintenance |
default-package-um |
10900 |
8 |
Character |
Enter a valid default package unit of measure used with cartonization for the customer and product. This must be the same type of unit of measure as the product unit of measure for the product. For information on setting up units of measure, see Unit of Measure Maintenance. |
Default Pkg U/M field in Customer Product Maintenance |
can-be-packaged |
11000 |
3 |
Yes/No |
Enter Yes if the customer/product combination can be used in cartonization. For more information, see Cartonization FAQ. Enter No if the customer/product combination cannot be used in cartonization. |
Can be Packaged check box in Customer Product Maintenance |
default-cust-product |
11100 |
3 |
Yes/No |
Enter Yes to make this the default customer’s product code associated with the customer and product code. Enter No if the customer product code is not the default customer product for the customer and product code. Note There can be many customer’s product codes linked to a product code, but there can only be one that is the current default. If you enter Yes and a default customer product code previously existed, the imported customer product is set as the new default. Example Customer ABC has its own product code A101 that supersedes its previous model product code B101. Both B101 and A101 are linked to your product code 1243434, but A101 is now selected as the default. |
Default Customer Product check box in Customer Product Maintenance |
master-carton-um |
11200 |
8 |
Character |
Enter a valid master carton unit of measure for the product. This must be the same type of unit of measure as the product unit of measure for the product, and this must be a selling unit of measure for the product. This must be larger than and a multiple of the unit of measure entered for the inner-pack-um field. |
Master Carton U/M field in Customer Product Maintenance |
inner-pack-um |
11300 |
8 |
Character |
Enter a valid inner pack unit of measure for the product. This must be the same type of unit of measure as the product unit of measure for the product, and this must be a selling unit of measure for the product. If a customer only has one case pack unit of measure, the inner pack unit of measure should be the base unit of measure for the product. This must be smaller than the unit of measure entered for the master-carton-um field. |
Inner Pack U/M field in Customer Product Maintenance |
cust-order-min |
11400 |
16 |
>>>,>>>,>>9.9999 |
Enter the minimum quantity in the selling default unit of measure when the customer orders the product. If a value is entered for the cust-order-multiple field, this must be a multiple of that value. For more information, see Unit of Measure Fields FAQ. |
Order Minimum field in Customer Product Maintenance |
cust-order-multiple |
11500 |
16 |
>>>,>>>,>>9.9999 |
Enter the order multiple quantity in the selling default unit of measure when the customer orders the product. For more information, see Unit of Measure Fields FAQ. |
Order Multiple field in Customer Product Maintenance |
order-alloc-min |
11600 |
16 |
>>>,>>>,>>9.9999 |
Enter the minimum quantity that can be allocated for the product in the selling default unit of measure. This overrides the allocation minimum value entered for the product in Product Maintenance and Product Location Maintenance. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance. This value cannot be greater than the value entered for the cust-order-min field. If a value is entered for the order-alloc-multiple field, this must be a multiple of that value. |
Allocation Minimum field in Customer Product Maintenance |
order-alloc-multiple |
11700 |
16 |
>>>,>>>,>>9.9999 |
Enter a value of which a multiple can be allocated for the product in the selling default unit of measure. This overrides the multiple allocation value entered for the product in Product Maintenance and Product Location Maintenance. This value functions in conjunction with the Allocation Qty Min/Mult Automatic and Allocation Qty Min/Mult Manual options in Customer Service Control Maintenance. |
Allocation Multiple field in Customer Product Maintenance |
discontinued |
11800 |
3 |
Yes/No |
Enter Yes if the customer product is discontinued. Enter No if the customer product is not discontinued. This is informational only and can be communicated to customers by EDI price/sales catalog. |
Discontinued check box in Customer Product Maintenance |
discontinued-date |
11900 |
10 |
99/99/9999 |
If the customer product is discontinued, enter the date the customer product was discontinued. This is informational only and can be communicated to customers by EDI price/sales catalog. |
Discontinued Date field in Customer Product Maintenance |
skip-832 |
12000 |
3 |
Yes/No |
Enter Yes to not include the product in the EDI price/sales catalog sent to the customer. Enter No to include the product in the EDI prices/sales catalog sent to the customer. For more information on exporting EDI price/sales catalogs, see EDI Price/Sales Catalog Export. |
Do Not Send EDI Price/Sales Catalog check box in Customer Product Maintenance |
edi-832-status |
12100 |
1 |
Character |
Enter a one-character EDI price/sales catalog status code for the customer product (A for added, D for deleted, or S for substituted/changed). |
EDI Price/Sales Catalog Status field in Customer Product Maintenance |
exclude-from-846 |
12200 |
3 |
Yes/No |
Enter Yes if you want to exclude the product from the EDI Inventory Inquiry/Advice files. For more information, see Customer Product Maintenance. If this field is blank, it defaults to No. |
Exclude from EDI Inventory Inquiry/Advice check box in Customer Product Maintenance |
send-846-zero-count |
12300 |
2 |
>9 |
Enter the number of times zero quantity of the product was sent before excluding it from EDI Inventory Inquiry/Advice files. (Only users with permission can update this field) |
EDI Inventory Inquiry/Advice Count field in Customer Product Maintenance |
Before using this import, the following must be set up:
customers
products
customer products