Hello.
I like to reduce number of rows in 2 tables:
cataloginventory_stock_status
cataloginventory_stock_status_idx
We have Magento v1.9 with 26 websites which use only 1 warehouse.
Both tables has around 800.000 rows - 25x are duplicated because Magento create for each website own row.
Question:
How I can modification and where Magento (core) to read and update Catalog Inventory only for website on id #1.
In other words I like to remove stock status for all website except the main store (with ID 1). Set Magento to manipulate (read/write/edit) only stock status for main store.
At the end number of rows will match with number of products example 35.000 which will speed up entire store.
Any idea? Thank you.
