Why does Magento Admin show 39,000 records (database only has 5000 products)
-
Can anyone please help me understand why my Magento admin shows over 39,000 records but i only have 5,000 products on my site?
I am really struggling with trying to figure out how this happened.
thanks
-
We don't have too many Magento people in here, and I myself don't have any experience with it. However, a couple of things to look at. First, can you do a spot check of those records and see if they are all product records, or if some of them are transaction records? Are some of them maybe expired products? Or options on products such as color or size?
Got a burning SEO question?
Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.
Browse Questions
Explore more categories
-
Moz Tools
Chat with the community about the Moz tools.
-
SEO Tactics
Discuss the SEO process with fellow marketers
-
Community
Discuss industry events, jobs, and news!
-
Digital Marketing
Chat about tactics outside of SEO
-
Research & Trends
Dive into research and trends in the search industry.
-
Support
Connect on product support and feature requests.
Related Questions
-
How best to handle on-site blogs for multiple site views in Magento?
Hi, I'm working with a site on Magento with views for UK, US and FR websites. Currently they have a French WordPress Blog that is pulled into the French site view and an English one that appears on both the US and UK views. Of course the problem here is that the US and UK views are duplicating content so these needs sorting super-fast. The plan is to disconnect the US view from the current English blog and create a dedicated US onsite blog. However, should we continue to use WordPress or instead use an alternative blog module or plugin for Magento? Cost is an issue and running three separate blogs and the cost of plugging these into each site view. However, getting these right for SEO is the most important factor here. I'm also concerned about the mess of multiple plugins causing page speed issues etc... My instinct is to go with WordPress, but I'm keen to hear what others think or have experience of.
Content Development | | ExtraDigital0 -
Multiple listings for the same product - how to avoid duplication?
Hi everyone, We are working on an e-commerce site that has three different physical stores that each hold different products in stock. A listing is created on the website for each product in each location but if the same product is in all three stores the images and description are duplicate content We can't have one product page and tag locations to it as this would then require keeping two different stock systems updated, but is there a way to avoid the three pages being duplicates of each other? Many thanks for the advice!
Content Development | | A_Q0 -
Loads of Blog Search Results showing up in SERPs - What's the best way to remove?
Our client has a good number of results showing up in SERPs that are search results pages produced by Blog posts. Unfortunately all these results have exactly the same Title tag and it has nothing to do with the blog content which means they are unlikely to help us much. We can’t create a 301 redirect because there is no page to redirect. There is no blog page we can re=canonical to either. The content on these pages is a short list of blog posts by each author. They are not true “Author” pages that would have a URL structure like this: your company.com/author/joeblow Our plan is to use GWMT's URL removal tool to request remove of these pages. (and then try to stop new results from being created) We are doing this to get low-value content out of the SERP. Is there a better way to remove these search results? Any drawback in removing them in GWMTs? Thanks.
Content Development | | RosemaryB1 -
Where to outsource product pages contents?
We have been told to write good unique content for every products but we just don't have the skill nor the time. (english is not my first-language) Can anyone suggest where to find a good product content writer?
Content Development | | ringochan0 -
Authorship showing in SERPs for non-blog pages
Hi, A few months ago we set up authorship for on our blog articles for multiple authors, which has helped driving extra traffic to our blog posts. Today, I did a search for one of most important search terms and one of our non-blog pages is showing in the first page of the results with one of our authors headshot next to it. Technically we have not not set it up to do this, the page is on a different CMS to our blog (which is wordpress). I'm not complaining because I think this is a positive outcome, but does anyone have an idea why it has done this? I was under the impression that only blog article pages could have authorship set up. Thanks, Stu
Content Development | | Stuart260 -
Simular product pages
I have 27000 products on my website, showed one by one on a separated webpage. Google index them almost all (+- 25000). But the SEOmoz report shows them as duplicated content. Indeed, most of the page is identical, only changing description and price of the product which is indeed not more than 2% of the total content of the page. On the bottom of the product page are shown the alternatives for this product, mainly other colors. So, within the same family of products that can have 50 products, the site creates 50 webpages showing the product and it's family. That's why nearly everything on the page is identical within this family of products. My guess is, as Google indexed them all, I should not worry about duplicated content. Is my guess correct? Thanks for a soon answer. Rik
Content Development | | noordhout0 -
How do I get the correct picture to show up in the SERPs?
When I search for "Popular Baby Names" using Google UK, I get the image below that is clearly displaying the wrong picture. I believe they are coming from a module on the page in the left rail. I know I can use Robots.txt to have Google not show the image at all, but I don't want to impact my click through. What is the best way to have the search engine either not display an image that is not part of the resulting article or better yet, pick the right image. | | Popular baby names in the UK14 Feb 2012 ... We list the most popular names for babies born in the UK in recent years, taken from official national statistics.www.babycentre.co.uk/pregnancy/naming/popularbabynames |
Content Development | | network_operations0 -
Where in my wordpress admin panel do I add the .
Having read Rand's post about the canonical tag I very much wish to use it to advise Google that the duplicates created during archiving (due to the fact that the posts have multiple categories) are just copies. I understand the theory, but can't transfer it into practice! Could someone give me an idiots guide as to how to add the tag and to where. My site produces approx 10 - 20 blog posts per week. Each has at least 2-4 categories applied to it. They are archived each month, at which point I have a big jump in duplicates in my campaign panel. Help! C:\Users\Catherine\Desktop\me_small.gif
Content Development | | catherine-2793881