This blog promotes knowledge sharing through experience and collaboration. For more product information, visit our WebSphere Commerce CSE page. For easier navigation, utilize the Categories to find posts that match your interest.
Validating Watson Commerce Insights integration with WebSphere Commerce System
As part of integrating WebSphere Commerce (WCS) and Watson Commerce Insights (WCI), you setup and schedule jobs that feed Insights with catalog, pricing, inventory, analytics and other data from the WebSphere Commerce database and Analytics system. You would also make configuration changes in WebSphere Commerce system to enable store view, overlays and sequencing functionalities to work in Commerce Insights.
1. Catalog Upload
Watson Commerce Insights (WCI) requires catalog data from WebSphere Commerce System (WCS) to display it in WCI workspace. You can validate that catalog feed is configured correctly by logging into WCI as Tenant Administrator and use the System Health Page to monitor catalog upload job status, and ensure catalog upload job is completed successfully as shown in below screenshot. It also helps to validate how many row's of data got processed as part of each job run.
If you are not seeing a successful catalog job after setting up the integration, Please check the catalog extract configuration steps and ensure it's been configured as documented and your catalog extract process running successfully in WCS in order to upload data to WCI FTP server for processing. You can check Troubleshooting Catalog Uploads to Watson Commerce Insights blog post as a troubleshooting document for catalog upload issues.
2. Analytical Data
As we reviewed step 1, open System health page as a Tenant Administrator and check the analytics job status for the store and ensure it's been completed successfully.
If analytics job in failed status then open up Analytic Section configuration as tenant administrator and review the Analytics credential to ensure that it's been configured correctly. In cases, where you notice that Analytics job gets completed successfully but you still don't see any analytical data in WCI then it might have happened that your analytics system don't have correct data captured or don't have it at the product level (Currently WCI requires that metrics are provided at product level and not at SKU level). Please check your analytics system and ensure that it's capturing data from WebSphere Commerce storefront, If you don't see expected data then it might be possible that your WebSphere Commerce storefront is not sending data as expected and you need to review analytics tagging in your storefront.
In cases, where WCS storefront analytics tag sends customized format of catalog entry partnumber to analytics provider then you might notice an issue where WCI couldn't map analytics data to corresponding catalog entry based on details we get from analytics system. In this case, you need to provide additional mapping information to WCI as part of catalog upload as explained on knowledge center topic Customization scenarios for data under the section 'Product partnumber sent to analytic vendor'.
After validating and ensuring that catalog and analytics schedule job completed successfully, You should be able to create your workspace in WCI and add widgets to review catalog and analytics data as explained in KC topic Creating a web workspace. In cases, where you notice an issues with viewing product thumbnail images in WCI workspace then please refer Troubleshooting Images in Watson Commerce Insights blog post under section 'Images in the workspace' as troubleshooting document to review further.
4. Store View / Preview
Once your have setup your workspace, You can preview your store in store view by using one of the methods documented in KC under topic Previewing your store in Store view. If you are noticing an issue where WCI couldn't connect to WCS store then you need to review the E-Commerce platform configuration in WCI, refer step 9 on this knowledge center topic Configuring your account for details. After validating that all the configurations are correct, and if you still have an issues with loading your store from WCI, then you can try to load store preview in Commerce Management Center (CMC) and as long as you can load store preview in CMC, You should be able to load it from WCI as well. If you are having issues with CMC store preview itself then you can debug this problem outside of WCI. You can also validate that images are loading fine in store view, if you have any issues with viewing images in WCI store view then you can refer Troubleshooting Images in Watson Commerce Insights blog post under section 'Images under Preview' for further troubleshooting.
When business users preview your store in Store view, they can see metrics that are overlaid on your images, such as metrics from categories, products, and e-marketing spots. If you are noticing an issue while loading these overlay information in store view then ensure that you have enabled the recommended storefront related changes as explained in KC topic Configuring your store to display the version 2 overlay metrics in
6. Intelligence and Manual Sequencing
Once we ensure that store view is working as expected, You can validate the sequencing functionality, it gives you an option to edit the order of products without leaving Watson Commerce Insights. You can refer KC on topic Changing product sequence in Store view to understand how you can modify sequencing in WCI. If you are seeing an issue where you don't see an option to enable manual or intelligence sequence for a category then ensure that you made necessary configuration changes in WCS side as explained in KC under topic Configuring the product sequencing and featured image features in WebSphere Commerce to enable it.
Also in WCI sequence panel, if you notice an issue where images aren't displayed in sequence panel then refer Troubleshooting Images in Watson Commerce Insights blog post under section 'Images in the sequencing panel' for further troubleshooting. After changing sequencing in WCI, if you notice an issue where WCI sequence file is not transferred to WCS search server then refer Sequencing in Watson Commerce Insights blog post as overall sequencing troubleshooting page. Once WCI sequence file is downloaded to your staging search server then ensure that index is replicated to search server to see the results in live storefront.
Special thanks to Andres Voldman for his insights on these topics.