Multiple stores

[claudioLB]

Dear

What is the name of the table in phpmyadmin that records the websites that the products should be displayed on

I have two websites but the second is not showing the product.

I've checked all the settings, all I have to do is check the data base.

Magento 1.9

[Vimal Kumar]

HI @claudioLB 

You can find your records in the "catalog_product_website" table for multi-website.

I hope it will help you!

[salvimkelv5ac9]

• In Magento 1.9, when using multiple websites or stores, each product must be assigned to the correct website in the database.

• If your product shows on one website but not on the second, the issue is usually with how the product is linked to that second website.

• The system uses a hidden database table to record which products belong to which websites—just like how each menu Mary Brown location might show slightly different items.

• You can’t see this assignment directly in the Magento admin unless you edit the product and look under the Websites tab.

• Make sure the checkbox for the second website is selected when editing the product in the admin panel.

• Also check if the product is enabled (active) for the second website and assigned to at least one visible category.

• Go to the Inventory section like menu and confirm the product is in stock and has quantity available for the second site.

• Magento sometimes saves different values per store view (like status, price, or description), so switch to the second website’s store view and double-check those values.

• Once all settings are correct, you may still need to refresh Magento’s index and clear the cache to make the changes show on the frontend.

• If the product is still not visible, it’s often because of missing connections behind the scenes, much like when a location forgets to update their menu Mary Brown—the items won’t appear for customers.

• Rechecking and saving the product with the correct website and category can fix the issue without touching any code or database.

• Think of each Magento website like a separate restaurant branch—if the product isn’t assigned properly, it won’t be on that store’s menu, just like how a meal might be missing from one menu Mary Brown location but not the other.