Skip to content

Product Missing on Store Checklist

Product Missing Diagnostic Guide

This guide outlines the step-by-step process to investigate and resolve issues when a product is not showing up in a store or category in the ecompaas platform.

Step 1: Product Exclusion Check
Run the following query to check if the product is excluded:

SELECT * FROM ecompaastest.product_group_results
WHERE product_id = '28651'
ORDER BY id DESC
LIMIT 0,1000;

Review the output and verify that the product is not excluded due to any of the following:

  • Group
  • Store
  • Product Filter
  • Store-level Filter
  • Category
  • Direct-to-Product
  • Feature Product List
  • Category Drop Down

Step 2: Parameter Verification
Confirm that search, reseller, and category processes have completed:

SELECT * FROM csc.parameter
WHERE parameter_id IN ('227', '228', '229'); 

Parameter ID
Description
227
Search Processed
228
Reseller Processed
229
Category Processed

Step 3: Category Rebuild Check

SELECT * FROM ecompaastest.ecompaas_custom_parameters WHERE param_name LIKE '%rebuild%' AND param_name = 'csc_rebuild_categories_status' ORDER BY id DESC LIMIT 0,1000;

Step 4: Product-Category Association Verify category quick links:

SELECT * FROM csc.category_quick_links WHERE category_id IN ('2600', '2586') AND vendor_id = '1011' LIMIT 0,1000;

Check product lookup table:

SELECT * FROM csc.product_lookup WHERE category_id IN ('2600', '2586') AND vendor_nr = '1011' AND product_id IN ('28651','28860') LIMIT 0,1000;

Step 5: Store Rebuild Verification

SELECT * FROM csc.reseller_processing WHERE reseller_id IN ('11', '3', '2340', '10059') ORDER BY reseller_id LIMIT 0,1000;

Step 6: Product Update Flag

SELECT * FROM csc.product_update WHERE update_flag = 1;

Step 7: Store-Category Mapping Check

Check if store has assigned the correct categories:

SELECT * FROM csc.reseller_categories WHERE category_id IN ('2600', '2586') AND reseller_id IN ('10059', '11', '2340', '3') LIMIT 0,1000;

Check cross-reference mapping:

SELECT * FROM csc.reseller_category_xref WHERE reseller_id IN ('10059', '11', '2340', '3') LIMIT 0,1000;

Checklist Summary: Checkpoint Description Status Product group results Ensure product is listed and not excluded UI Visibility Confirm product appears in search/dropdowns Processing Parameters Validate parameter 227, 228, 229

Category Rebuild Check rebuild trigger status Category Association Confirm category_quick_links and lookup Store Rebuild Check if processed in reseller_processing Product Update Ensure update_flag is set Store-Category Mapping Check reseller_categories and xref

Last Updated: 2025-05-13