Siebel Order Management Guide > Integrating Order Management with Oracle ATG Web Commerce >

Maintaining Product Data for Integration with Oracle ATG Web Commerce

This topic describes the methods that you must use to work with product-related data in the Siebel application to have the results reflected properly in Oracle ATG Web Commerce. These methods give the Siebel application and ATG Web Commerce access to identical versions of the product and their supporting objects in both applications, which is necessary to avoid incorrect cross-channel orders.

In most cases, you must use End Effective Date to make the object unavailable. However, you can delete nonversioned product data, such as collateral, literature, or recommended products.

Removing a Product from a Catalog and Category

To remove a product from a catalog and category in both the Siebel application and ATG Web Commerce, set the effective end date in the Category view for the product, and then create a Web content export job to export the change to ATG Web Commerce.

To remove a product from a catalog and category

1. Navigate to the Administration - Product screen, then the Products view.
2. Select the product that you want.
3. Click the Category tab.
4. In the categories list, for all categories that you want, enter a value in the Effective End Date field that is before the current date.
5. To verify your work:
   1. Navigate to the Administration - Catalog
   2. In the Catalogs list, click the Name field of the catalog that contains the category that you removed the product from.
   3. In the Categories list, select the category that you removed the product from.
   4. Click the Products tab, and confirm that the Product is no longer in this category.
6. Click Update Commerce App.

Removing a Catalog

To remove a catalog, including its categories and its categories' products, from both the Siebel application and ATG Web Commerce, set the effective end date of the catalog, and then create a Web content export job to export the change to ATG Web Commerce.

Physically deleting a Catalog record, Category record or Category Product record is also supported, but it is not recommended because it becomes impossible to trace which objects have been removed.

To remove a catalog

1. Navigate to the Administration - Catalog screen, then the Catalog view.
2. In the record for the catalog that you want, enter a value in the Effective End Date field that is before the current date.

   This field is in the Administration - Catalog applets:

   • Catalog Admin Catalog List Applet
   • Catalog Admin Catalog Detail Applet
3. Click Update Commerce App.

Removing a Price List

To remove a price list, including its line items, from both the Siebel application and ATG Web Commerce, set the effective end date of the price list, and then create a Web content export job to export the change to ATG Web Commerce.

Physically deleting a price list and price list line item record is also supported, but it is not recommended because it becomes impossible to trace which objects have been removed.

To remove a price list

1. Navigate to the Administration - Pricing screen, then the Price Lists view.
2. In the record for the price list that you want, enter a value in the Effective To field that is before the current date.

Deleting Product Collateral

Product records cannot be deleted. However, collateral, literature and recommended products that are attached to a product can be deleted.

To make collateral, literature and recommended products unavailable in Oracle ATG Web Commerce, you can delete the record in the Siebel application instead of using End Effective Date. If you delete this data, and the system preference for SiebelCommerceInteg is set to True, then a record of type Delete is inserted in the Export Job Details applet, and SCOA sends this record to Oracle ATG Web Commerce.