Magento associated products will not show up

Magento associated products will not show up

July 14, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento associated products will not show up

Associated Products Not Showing Up in Magento: A Comprehensive Guide

Are you facing issues with your associated products not showing up in your Magento store? Don’t worry; you’re not alone. This is a common challenge that many Magento users encounter while setting up their configurable and simple products.

Understanding the Problem

The primary issue lies in the configuration of your product settings, database tables, and relationships between your parent (configurable) and child (simple) products.

Check Your Product Settings

Firstly, ensure that you have correctly configured your associated products under the “Associated Products” tab of your configurable product. You should see a list of simple products linked to the main product here.

Associated Products Tab

Inspect Your Database Tables

Next, verify that the relationships have been correctly established in the database tables, specifically shop_catalog_product_relation and shop_catalog_product_super_link. These tables should contain entries linking your configurable product to its simple children.

Common Misconfigurations

Several reasons could be causing this issue:

Missing Save Button Click

When adding associated products, ensure you click the main “Save” button at the top of the page after configuring them. Failing to do so might cause the changes not to be saved in the database.

Incorrect Stock Management

Check if your configurable product’s “Manage Stock” setting is enabled. If it’s disabled, Magento may not recognize the associated products because the stock management system won’t link them properly.

Database Relationships

Verify that you have manually inserted the correct relationships into the shop_catalog_product_relation table if necessary. The data should match your product configurations accurately.

Quantity and Enabled Status

Ensure all child (simple) products are enabled and have non-zero quantities available in stock. Even one disabled or out-of-stock item can prevent the entire association from working correctly.

Diagnosing the Issue

To troubleshoot this problem, follow these steps:

  1. Check the Database: Use SQL queries to verify if your associated products exist in the shop_catalog_product_relation and shop_catalog_product_super_link tables.

  2. Inspect Product Configurations: Double-check all settings related to your configurable and simple products under their respective tabs in Magento’s admin panel.

  3. Review System Logs: Search for any error messages in the exception logs to identify potential issues with your product configurations or database setup.

  4. Test Different Scenarios: Change various settings like “Manage Stock” and quantity values, then observe if the associated products appear or disappear accordingly.

  5. Compare with Other Products: If you have correctly configured similar products elsewhere, compare their settings with the problematic ones to identify any discrepancies.

Solutions and Best Practices

Update Magento Version

Ensure your Magento installation is up-to-date. Newer versions often include fixes for product relationship issues that were present in earlier releases.

Follow Proper Configuration Steps

Make sure you follow these best practices:

  1. Create all simple products first, ensuring they are enabled and have appropriate quantities.
  2. Set the “Manage Stock” option to either “Yes” or “No” based on your requirements.
  3. Add the associated products to the configurable product under the “Associated Products” tab.
  4. Save changes meticulously by clicking the main “Save” button at the top of the page.

Manually Insert Relationships

If necessary, you can manually insert the relationships into the shop_catalog_product_relation table using SQL queries:

INSERT INTO shop_catalog_product_relation (parent_id, child_id) VALUES (<configurable_product_id>, <simple_product_id>);

Remember to replace <configurable_product_id> and <simple_product_id> with your actual product IDs.

Conclusion

Associated products not showing up is a common issue in Magento that can be resolved by carefully inspecting your product configurations, database relationships, and following the best practices outlined above. Always ensure you’ve clicked the main “Save” button after making changes and verify that all related settings are configured correctly across both the parent (configurable) and child (simple) products.

If you’re still facing issues, consider seeking professional help or contacting Magento support for further assistance with your specific configuration requirements.

Catalog Database Configuration Errors

Our network