Listing Products with the “Display on Web Flag”

Yesterday we mentioned that we will be helping Office Brands members prepare their products for an initial upload to WebSphere. Part of this process involved checking the “Display on Web” flag on the relevant store products in Readysell.

We have received a number of queries regarding how to check what products already have this flag enabled. To do this, please create a new report by following these steps:

1. Log into Readysell and enter the “Report Wizard”
2. Go to Type “Products”
3. Highlight the “Product List” report and click “Run Highlighted Report”
4. “Select a Query” for PRODSITE will appear, click on “New” to create a new query
5. Click on the “Manual” button and paste in the following query:
   PRODSITE:DisplayOnWebSiteFl = 1 and (Prodsite:CatalogueProductFL is null or Prodsite:CatalogueProductFL = 0)
6. Click on “Finish”
7. Click “Yes” for “Save Query”
8. Enter “WebSphere Store Products Only” as the report name
9. Click OK

Your new report will the display on the screen. As usual, you can send it to the printer or Excel by using the “Send To” button. For more information about using the Report Wizard, please consult the documentation available at our Support Downloads site.