QRY: Solr

Update 3/2/22 

ECommerce store navigation is dependent on Solr Search on Fusion 

Updates to Products in Aptify should take no more than two hours to update on the site.   

Credentials are in Secret Server.   

Job that updates the store is  

You can view this after logging in by clicking on the drop down, selecting Store-Prod, Then clicking the home button, and under tools you will see data sources: 

When viewing jdbc-store-prod2 you can manually run the update or view the history. 

Clicking on the arrows and then Dev Ops you will be able to see the schedule for the Job listed.   

This is the job scheduled to run that Data source every hour: 

The data source has the following query against chi-vm-rpts: 

SELECT id, 

       WebName,       Description,       ProductCode,       Category,       BackOfficeCategory,      RootCategory,       ProductTypeId,       ProductType,       DateUpdated,      ImageUrl,       WebProductPage,       DistributionType,       QuantityAvailable,      AllowBackorders,       PriceStandard,       PriceMember,       MeetingStartDate,      WebLongDescription,       ProductKitTypeID,       RequireInventory,  IsNewProduct        

FROM dbo.vwWebProductListings 

WHERE IsExcludeWebSearch = 0 

This data source is filled from Aptify products from a SQL Agent job that runs a ETL package : 

This job is called ZK-Product Run – Production and runs every two hours.