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
-
Best SEO Structure For E-Commerce With Products Using Multiple Categories
Hi all, I am in the process of re-structuring my e-commerce website for better SEO and user experience. I have done some keyword research and would like some advice on how best to structure my site around those keywords. For example, my site (All Things Nature) sells a brand of wooden sculptures (Woodsculp) and I would like to rank for keywords related to that brand, the brand by animal, the brand by collection and the brand by release date.
Content Development | | nb2e4fg
Examples of keywords could be: Brand by Animal: Woodsculp Dogs, Woodsculp Cats, Woodsculp Elephants
Brand by Collection: Woodsculp Pets, Woodsculp Safari
Brand by Release Date: Woodsculp Christmas 2023, Woodsculp Summer 2022 I would create each of these keywords as a category so that they can be found by a search engine and by users. I would then structure as follows: All Things Nature -> Woodsculp -> Woodsculp by Animal -> Woodsculp Dogs
All Things Nature -> Woodsculp -> Woodsculp by Animal -> Woodsculp Elephants
All Things Nature -> Woodsculp -> Woodsculp by Collection -> Woodsculp Pets
All Things Nature -> Woodsculp -> Woodsculp by Collection -> Woodsculp Safari
All Things Nature -> Woodsculp -> Woodsculp by Release Date -> Woodsculp Christmas 2023
All Things Nature -> Woodsculp -> Woodsculp by Release Date -> Woodsculp Summer 2022 The only problem with this structure is it would take more than 3 clicks (4) for the user to reach a product. How critical is this for good SEO and user experience? Would I be better off getting rid of the ‘Woodsculp by Animal’, ‘Woodsculp by Collection’ and ‘Woodsculp by Release Date’ categories? Structure would look as follows: All Things Nature -> Woodsculp -> Woodsculp Dogs
All Things Nature -> Woodsculp -> Woodsculp Elephants
All Things Nature -> Woodsculp -> Woodsculp Safari
All Things Nature -> Woodsculp -> Woodsculp Christmas 2023 The only thing with this is there would be a lot of categories under the brand name which might make it more difficult for search engines and users to logically follow. Would I be better off getting rid of the brand category and replace them with the keyword categories? Structure would look as follows: All Things Nature -> Woodsculp by Animal -> Woodsculp Dogs
All Things Nature -> Woodsculp by Animal -> Woodsculp Elephants
All Things Nature -> Woodsculp by Collection -> Woodsculp Safari
All Things Nature -> Woodsculp by Release Date -> Woodsculp Christmas 2023 This would organise things more logically but I would then lose the brand category (and the potential of the brand keyword ranking?) Would I be better off choosing one main keyword to use as a category and then use tags for the other categories? Categories: All Things Nature -> Woodsculp -> Woodsculp Dogs
All Things Nature -> Woodsculp -> Woodsculp Elephants Tags: Woodsculp Safari
Woodsculp Christmas 2023 The next issue I have is that I have products which could fall under several different categories. A product called Elijah Elephant, for example could fall under Woodsculp Elephants, Woodsculp Safari and Woodsculp Summer 2022. In previous e-commerce sites I have never assigned multiple categories to one product (I instead have used tags). Is it good practice to organise products under multiple categories for an e-commerce site? Thanks in advance for any help and advice.0 -
Duplicate product description on the same page
Hello, I've got a really simple a basic question : is it an issue to put an excerpt of a text at the begining of a page, with a "jump to full text" link at the end of the excerpt ? So the first part of the text will be duplicated. A solution would be to hide a part of the text and reveal it with a "read more" button, but we don't want to do that, we want users to be able to read the full text just by scrolling + we want to put an excerpt "above-the-fold" content It's a product page. A second question : we've got duplicate content between our brand category pages, and the related product page, because the presentation text of the brand is shown on the product page + on the brand category page (it's presentations of distilleries, so it's a valuable content for the customer, we want to show it directly on the product page). Do you think it's a big issue ? Or maybe we can think : "ok, there is plenty of other text on those pages, so it won't matter" ?
Content Development | | Colage1 -
Would my ranking be affected if i had a snipet of an article showing on another site
Hi, i am thinking of using rss feed to show a snippet of an article on two sites for people then to be able to visit the main site, but i want to know if this would damage my seo and rankings. Any help and advice on this would be great
Content Development | | ClaireH-1848860 -
In light of the Interflora advertorials debacle where do you think bloggers stand with regard to product reviews?
I realise the main blame fell on the newspapers for what was essentially cash for links, but a separate part of the PR push was sending flowers to bloggers who then blogged about it. I can see that this could be construed by Google to be a breach of their t&cs, but equally it could be a legitimate action by the blogger if they are giving an honest viewpoint. Is the Google Chrome "satchel" ad being unintentionally misleading? If it's all down to the intention that's a worryingly grey area to be stuck in, what do you think?
Content Development | | Tompt1 -
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 -
Magento Multi Stores and seo
Hello all, im not that clued on SEO and only know the basics so please bear with me! I've just had built 5 different furniture retail websites, all of which will be selling the same products, but all priced differently and all of the sites will have different content etc on each one (4 of the 5 websites are on a multi store system with one back end on magento). The only thing that the 5 sites will have in common is the names of the products in the titles but all the content in the text and prices etc will all be different on each site, including articles and blogs… How will this sit with google in terms of rankings on each site? I know a lot of other companies that do this already and they all have good rankings on each site for their chosen keywords, the only difference between my scenario and theirs is 4 of my sites on the same back end which is mainly the ones i am concerned about… Any thoughts? thanks anthony
Content Development | | anthonybriant0 -
New Magento store with lots of duplicate contect
Hi, I am fairly new to SEOmoz and would really appreciate some pointers. I have just received the results of my first crawl and I have over 1800 pages of duplicate content. this is an example Cream poplin slim fit mens business shirt from Jermyn Street Shirt Co. http://jsshirts.com.au/aylesbury-cream-poplin-slim-fit-shirt.html Heading other URL's indicates 10 My questions are what does this figure 10 represent? what do I need to do to remove this duplicate content. Thanks | | | | |
Content Development | | mullsey
| | | | |
| | | | |0 -
Content being copied from our product page hurting our site overall?
On our product pages, he have short descriptions and some bulleted lists. Resellers of our products, and many other sites who are not resellers are copying this content, often verbatim. While I'm not as concerned for the product pages themselves as we're hoping the category pages will rank, does this duplication of our content hurt our site overall? FWIW, our brand name is in our domain and often also shown on these sites that copy the content.
Content Development | | minutiae0