I am trying to get a hold on our Core_URL_Rewrite table in our database. After truncating 3 months ago, we once again have 1.4million entries from 15000SKUs across 4 storeviews. The issue is so severe we are no longer able to reindex.
- Currently our URLs look like this: http://example.com/new-hi-vis-hat-12355 and change after every reindex, making it harder to get any kind of ranking on Google.
- We currently run on Magento 126.96.36.199 and have found that the EE SUPEE-389_EE_188.8.131.52_v1.patch is recommended for 1.7 and 1.8 but our developer doubts this will fix on our version.
We are willing to TRUNCATE and start again if we would be able to find a more permanent fix. Any advice at this stage would be greatly appreciated.