Editing the product cross reference data in Excel

A Product Warehouse Product Setup record is required for each product that you add to the tab-delimited file.

  1. Open Excel.
  2. Select File > Open.
  3. Select the tab-delimited file, and then click Open.
  4. Verify that Delimited is selected, and then click Next.
  5. Verify that Tab is selected, and then click Next.
  6. Select all columns in the Data Preview section, and then select Text.

    To select all columns:

    1. Verify that the first column is highlighted.
    2. Scroll to the last column.
    3. Press Shift, and then click the last column.
  7. Click Finish.
  8. Edit the file.

    This table shows the columns that require a value to create a product cross reference record. The table also shows the corresponding field in Product Extended Product Cross Reference Setup, if applicable, and the value to specify for new records.

    Note: Do not specify a ship to. Ship to values are not associated with products in Storeroom.
    Column Field Value for new records
    extractseqno NA 0
    rectype NA c
    prod Customer Product Name of the customer product
    keyno NA 1
    altprod Our Product Lookup name from the Product Setup record
    custno Customer Customer number that is associated with the customer product
    orderqty Quantity Quantity of the product that the customer typically orders
    unitsell Unit Standard unit for the customer and product
    rowpointer NA Leave the field blank.

    Depending on your setup, other columns may require a value. If existing records contain a 0 in a column, specify 0 in the same column for the new record.

    You can delete, hide, or ignore the columns that do not contain values.

    See the Infor Distribution SX.e Mass Maintenance User Guide for rules about editing a tab-delimited file.

  9. Click Save.
  10. Click Yes.