Welcome to the Q&A Forum

Hi Everyone, We are currently caught between a rock and a hard place with Magento and are wondering if anyone else had similar problems and could share their advice. Our Core_URL_Rewrite now containt 1.3 million records for an account that has 12000 products on 4 different store views. This has ballooned past the point that we are no longer able to reindex our URL Management. The option that is being suggested to us is to truncate the table and start over, though this will essentially kill our SEO for those pages.(Which as there are duplicates, I can only imagine how much they are going to be penalized by it) Would anyone have any advice other than truncating and starting over? Any advice would be greatly appreciated. Thanks!

Hi Moz, Sorry if this comes across as a "Do My Job For Me" type of post but we are an E-Commerce store that have been live since January but have not seen any increase in performance on our site and over the past month, have even seen our rankings decrease. We have 1300 products on site and about 1500 pages in total. 1. As for on-site optimization, we have got 2 reviews and follow up reviews with a highly reputable reviewer from People Per Hour and solved any issues she has found. 2. Updated the Meta Data for products and Alt Descriptions for images focusing on the keywords we wish to rank for. We post weekly blogposts linking back to our products. 3. Social Media Campaigns with regular campaigns on FaceBook, Pinterest, Google+ and Twitter. 4. Attempted to build FOLLOW backlinks to articles relating to products on our site. We have also considered purchasing backlinks to improve our situation as we have yet to see any of these pages be crawled by Google over a month later. I have read a guides on Moz and other sites on how to improve our authority and improve rankings but none have offered much by way of practical solution. My question being, is this just a matter of patience or should I be worried/improving anything given we have 0 Domain Authority and Page Authority on all pages? Thanking you in advance, SEO Novice.