Substitute Product Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Substitute Product Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Base Product Code

40

Character

Yes

Enter a valid product code of the product for which you are defining a substitute product. For information on setting up products, see Product Maintenance.

B

2

Substitute Product Code

40

Character

Yes

Enter a valid product code of the substitute product. For information on setting up products, see Product Maintenance.

C

3

Create Reverse Substitute Product

3

Yes/No

No

Enter Yes to create the reverse of the substitute product. This is the same as importing a second record with the Base Product Code and Substitute Product Code fields switched.

Prerequisites

Before using this import, the following must be set up: