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
-
Over Optimised Magento Pages
We are working on a clients Magento site and we've added new copy which has a decent keyword density which is in line with best practice. When we run it through Moz we are getting a Key Word Stuffing alert saying the page has 27 keywords, where we can only see about 11. This is the page https://www.greatbeanbags.com/bean-bag-cushions The client is pushing back saying the page must have already been optimised before as our new copy has triggered the stuffing alert. But my guess is the page was already stuffed but buy some Magento code we can't see. Any ideas? #magento #Keyworddensity
Content Development | | Marketing_Optimist0 -
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 -
Two pages for, essentially, the same product.
My client currently has a page on their website that advertises one of their products. The product in question is manufactured by someone else but branded by my client. Recently, the manufacturer have released their own version with their own branding which is available to the public. My client has decided that they are going to stock both their own version and the manufacturers version of the product to avoid losing any sales. This have left us with trying to find the best way to add the new product to the site without it competing with my clients own product in search engine results. We want the page to be indexed so that people searching for the manufacturers product can still find it on our site but at the same time we risk cannibalisation and essentially having two pages with what will essentially be the same content. Does anyone have any ideas for a suitable solution? I am unsure whether we should create a new page for the new product or whether we should somehow incorporate the new product in to the existing page.
Content Development | | BallyhooLtd0 -
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 -
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 to handle product pages with similar information
We have thousands of product pages with similar information but differentiating variables such as length/width. Example: http://www.savvyboater.com/store/p/2100-Cover-for-V-Hull-Fishing-Boat-with-Side-Console-O-B-14-X-74-.aspx http://www.savvyboater.com/store/p/2101-Cover-for-V-Hull-Fishing-Boat-with-Side-Console-O-B-15-X-76-.aspx http://www.savvyboater.com/store/p/2102-Cover-for-V-Hull-Fishing-Boat-with-Side-Console-O-B-16-X-92-.aspx http://www.savvyboater.com/store/p/2103-Cover-for-V-Hull-Fishing-Boat-with-Side-Console-O-B-17-X-92-.aspx We built individual products instead of grouped products because we recommend specific part numbers for specific make, model, year boats through our finder tool. These pages have recently started showing up in SEOmoz as duplicate content and we are looking for solutions to solve it. We have considered creating a "parent page" that lists all sizes and then using a rel canonical on each individual page to tell google that the parent page is the preferred page. Any thoughts or other ideas on this?
Content Development | | ironpac0 -
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 -
Show all VS show excerpt in a blog post
I saw that you recently changed your blog from "show all" to "show an excerpt" and then "read more", could you explain me the reason? It´s not supossed to be better for the blog readers to see the full posts in the homepage?
Content Development | | diegodjm0