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
-
What is the best tactic to fix thousands of product descriptions on an eCommerce site?
I've asked this to dozens of people already, but I still haven't found a satisfactory answer... perhaps someone here can help me: I keep hearing how important it is to update product descriptions to avoid duplicate content, decrease thin content and improve conversion rates - but for any new eCommerce sites like ours, with thousands of listings going up at once, this is nearly impossible to control. Outsourcing is clearly a bad idea from an SEO standpoint as well as a UX standpoint... But are there any other options? Should I let go of my other responsibilities and focuses as an in-house SEO manager and virtually stop, drop and roll out unique product descriptions? That would be a project that would take me at least a year to complete. Do I just give up? Do two descriptions a day and hope for the best? What do you guys think? What have you recommended for others? I can't imagine our company is alone in this dilemma. Thanks in advance! Hanna
Content Development | | whiteonlySEO0 -
Product descriptions, when do they become classed as duplicate content, how different do they have to be?
I look after 3 sites which have a lot of crossover on products. We have 1000s of products and I've made it a requirement that we give each it's on description on each of the sites. This sounds like the right thing to but it's very hard for our content writers to write three different versions descriptions, especially when we have variations on the products so potentially writing unique product descriptions for 4-5 very similar products on three separate sites. We've worked very hard to create unique content deep through the site on all categories, subcategories and tag combinations and along with the other SEO work we've done over the last couple of years is producing great results. My question is now far do we have to go? I'm busy writing some product descriptions for a 3rd party site for some of our products, the easy thing to do is just copy and paste but I want Google to see the descriptions as unique. Whilst all SEO advice will say 'write unique descriptions' from a practical point of view this isn't especially useful as there doesn't really seem to be much guidance on how different they need to be. I gather we can't just move around the paragraphs or jumble up sentences a bit but it is easier to work from a description and change it than it is to start from a blank slate (our products range form being very interesting and unique, to quite everyday so sometimes tough to create varied unique content for). Does anyone know of any guidance or evidence of just how clever the Google algorithm is and how close content has to be before it becomes classed as the same or similar? Thanks Pete
Content Development | | PeterLeatherland0 -
Need suggestion to place longer content on products category page
Hi All, I wanted to place longer content on products category page, Currenty I am showing product listing first and then small description at the end of listing.I don't want to add longer content either bottom or top. I want to make two tabs at the top of each category pages like Products | Informtion In Product section (after clicking on it) I want to display all products listing & in Information tab (after clicking on it) 2-3 paragraphs of webpage content but I'm afraid If I will place the content in this way Google won't index content and my purpose of adding webpage content to target long tail keywords won't fulfill. Please suggest me if you have any better idea & let me know what I am going to do would be good or not in SEO perspective. Thanks
Content Development | | Alick3000 -
Whats the best way to creat a sitemap for a wordpress sitw with more than 1.000 posts
I tried to use yoast and google xml plugins but I´ve notice there are several important posts to me are not there... I´ve already checked if there was any post with noindex, and everything looks good Now I´m creating the sitemap file with screaming frog but it is not so convenient as a plugin... any suggestions or tips?
Content Development | | SeoMartin10 -
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 -
Multiply pages of similair subject not showing up in serps?
Hi, I have a website with a lot of similair subjects. Its a website with around 1000s pages.
Content Development | | vulonl
For example this website is about "cars" so I wrote a pages about: Green classy cars
Green cars for the summer
Green car show 2013 What happens is that on the query of "Green car show". The page green classy cars shows up. I have the feeling that google takes one page about a similair subject and only put on in the serps. I checked this on multiply pages and this seems the case. If I search on exact "Green car show 2013" + MY URL, still then its shows indexed but only position 4. Places 1,2,3 shows again other pages of my website with similair subject. Now my feeling says the other pages have more authority and thats why they show up higher. But then...again now all the content Im adding it isnt showing up.. The last months I added around 300 pages and I did not got one visitor more daily and I have the feeling it is because it are all similair pages and google does not want to show them. My question is: Is their something I can still make them show up? Because they do have all 100% unique content and 100% unique images they only have similair subjects. or Is their some way I can tell Google that his are really different pages, so this would maybe help?0 -
What's the best way to list products with multiple size options?
For some of my suppliers, there may be a Model A, Model B, and Model C. Within each model, the height and the width may be the same, but there might be 10 variants of length. Is is better to just list the 3 models on 3 separate product pages and have the various lengths as an option in a drop-down menu on each page, or should I actually create 30 different product pages? Just listing 3 would seem to be better from a usability perspective, but having 30 might lead to more pages being indexed. I believe that I'll have 30 different entries in my Google/Bing Product Search feeds, but what is the recommended practice for actual sites? Thanks
Content Development | | nks20120 -
Our blog is indexed by "google web" but does not show up in "google blogs". Why not and how can I fix this?
We have a pretty simple blog http://www.aviawest.com/blog I've noticed our articles arn't showing up in Google blogs on "web", we've submitted to http://blogsearch.google.com/ping a month ago. Anyone have some insight here?
Content Development | | Aviawest0