Tutorials > Sales Center > Add a new search option in the IBM Sales Center

< Previous | Next >

Test the new search option changes

This section refers to testing the new search option changes.

To ensure you can search for a product using the manufacturer's part number:

Procedure

1. Ensure that a product in the database has manufacturer part number information:

   1. Open http://localhost/webapp/wcs/admin/servlet/db.jsp.

   2. Select a valid product catalog entry:

      1. Type the following SQL query and press Submit Query:

         select * from ORGENTITY where ORGENTITYNAME='
         B2C Organization';
         

      2. Type the following SQL query and press Submit Query:

         select * from CATENTRY where MEMBER_ID=
         orgentity_id;
         

         Where orgentity_id is the ORGENTITY_ID value from the preceding step.

      3. In the result of the query, take note of the CATENTRY_ID value of the last record.

   3. Ensure the product catalog entry you have selected has data in its manufacturer part number column:

      1. Type the following SQL query and press Submit Query:

         select MFPARTNUMBER from CATENTRY where CATENTRY_ID=
         catentry_id;
         

         Where catentry_id is the CATENTRY_ID value from the preceding step.

      2. If the product catalog entry already has a manufacturer part number, use that part number in the next step. If the product catalog entry's manufacturer part number is NULL, add data into the MFPARTNUMBER column by entering the following SQL statement and pressing Submit Query:

         update CATENTRY set MFPARTNUMBER='mymfpartnumber' where
         CATENTRY_ID=
         catentry_id;
         

         Where catentry_id is the CATENTRY_ID value from the preceding step.

2. Use the IBM Sales Center to search for a product with the part number information you entered:

   1. Open the IBM Sales Center.

   2. Click Open > Sales Center - Order Management.

   3. Click File > Logon. Enter the userid and password and click Logon.

   4. Click Store > Select. In the Store name field, enter the store name. For example, if you use the default consumer direct store, the store name is ConsumerDirect. Click Find.

   5. Select the store name from the search results and click OK.

   6. Click Product > Find.

   7. In the Select option list, select Manufacturer Part Number.

   8. In the Manufacturer Part Number field, enter the part number you inserted into the mfpartnumber column.

   9. Click Find. The catalog entry you updated with the mfpartnumber displays in the Search result table, as in the following screen capture:

      

< Previous | Next >

+

Search Tips   |   Advanced Search