Creating an extended site store for the Recipes tool customization

In this lesson, you create an extended site store with a custom catalog for use in the Recipes tool tutorials. This extended sites store is used in other tutorials in the Recipes tool series of tutorials. This store must be created before you proceed to perform any of the five tutorials in the series.

About this task

In the Recipes series of tutorial, you test your customization by inserting recipe data into the database. These recipes are associated with the created store through its storeent_id value, which is contained in the STOREENT table of the database.


  1. Publish a custom .sar file on the default extended sites catalog.

    The examples in the Recipes tool scenario use products in the Kitchenware category of the Madisons starter store catalog. This catalog is not available when you are creating an extended sites store. Therefore, you must publish the Housewares.sar file in the extended sites store after created the store.

    1. Download HousewaresCatalog.sar into a temporary directory.
    2. Go to WCDE_installdir\conf\sar. If the directories conf and sar do not exist, create the directories.
    3. Add HousewaresCatalog.sar into the WCDE_installdir\conf\sar directory.
    4. If the WebSphere Commerce Test Server is not running, start the server and log on to the Administration Console.
    5. Select Site > Store Archives > Publish.
    6. If ExtendedSites.sar is published, proceed to step 1 h. If the store archive is not published, check the box next to ExtendedSites.sar and click Next.

      This step enables the Extended Sites Asset Store as a parameter in later steps.

      For more information, see Viewing publish status.

    7. On the parameters page, select Automotive under Sample data and ATP under Inventory model. Click Next > Finish to publish the store.
    8. Select Site > Store Archives > Publish; check the box next to HousewaresCatalog.sar and click Next.
    9. On the Parameters page, select Extended Sites Catalog Asset Store; click Next > Finish. Confirm that the catalog was successfully published.
  2. Create the store:
    1. Log on to WebSphere Commerce Accelerator, select Extended Sites Hub; click Ok.
    2. From the Extended Sites menu, select New Store.
    3. On the General page, complete the store information fields and select Extended Sites Organization under Store organization; click Next.

      New Store wizard in Accelerator
      The general information for a new extended sites store must be completed. For this tutorial, type Sample Store (Recipe tutorial) into the Store unique identifier field and the Store display name field. The third field is a description of the store; type in the text "This store implements the Recipe customization tutorial." The fourth field requires the email address of the person to notify when the store is created. The fifth and final field before you specify the type of Store organization, requires you to select the default currency of the store; select "US Dollar".
    4. On the Store Type page, select MadisonsStorefrontAssetStore and click Next.
    5. On the Catalog page, select the store master catalog that has the description Visit the largest online retail store of apparel. Shop the wide selection in activewears, jeans, pants, shorts, and accessories for men and women. Be sure to select this catalog, as there can be two Store master catalogs. Click Next.
    6. On the Payments page, select any desirable options. The options do not affect the tutorial. Click Next > Finish to create the store.
    7. On the Store Creation Confirmation page, click Bookmark Store to save the URL for the store home page to your browser. Use this bookmark to view your store home page by selecting the bookmark in your Internet browser.
    8. Log out of the WebSphere Commerce Accelerator.
    9. Log on to the WebSphere Commerce Accelerator.
    10. From the Store menu select Sample store (Recipe Tutorial)
    11. Select Store > Open/Close > Launch. The store is now viewable and contains the default extended sites car parts catalog, and the Madisons starter store catalog.

      The default home page for your store
  3. Filter out unused product categories that are inherited from the asset store by your extended site store.
    You need to use only the Kitchenware category of the catalog.
    Introduced in Feature Pack 2Note: If your store has catalog filter and pricing is enabled, use the Catalog Filter and Pricing tool in the Management Center to filter unused categories. For more information, see Catalog Filter and Pricing tool.
    1. In WebSphere Commerce Accelerator, select Sample store (Recipe Tutorial) from the Store menu.
    2. Select Merchandise > Catalog Filter.
    3. Right-click the Kitchenware category; click Include, then Save.
      A green check mark appears on the Kitchenware folder, then the category is published.
      Kitchenware included in the catalog.
    4. Optional: If there are green check marks on categories other than Kitchenware, right-click the categories and click Exclude, then Save.
    The store is now created and is ready to be customized to implement a recipes section. The home page can look like the following screen capture:
    The store home page

    To change the default extended sites automotive E-Marketing spots to the Madisons housewares E-Marketing spots, you must customize the store JSP files and image files. For more information about E-Marketing spots, see Working with e-Marketing Spots.

  4. Optional: If you do not remember the storeent_id of the created store, find the storeent_id by following these instructions.

    The storeent_id is needed when you are inserting recipe test data in other lessons. Therefore, you require the storeent_id of this store to associate recipes with it.

    1. Access the WebSphere Commerce database through the following link: http://localhost/webapp/wcs/admin/servlet/db.jsp
    2. Submit the SQL query: select * from storeent;
    3. Find the row that represents the created store. The store name is in the identifier column. The created store's storeent_id is the number in the storeent_id column of that row.