Welcome to the Q&A Forum

Browse the forum for helpful insights and fresh discussions about all things SEO.

Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Why does Magento Admin show 39,000 records (database only has 5000 products)

Content Development

846

Prime85 last edited by

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
1 Reply Last reply
Reply Quote 0
KeriMorgret last edited by

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?
1 Reply Last reply
Reply Quote 0

Got a burning SEO question?

Subscribe to Moz Pro to gain full access to Q&A, answer questions, and ask your own.

Start my free trial

Browse Questions

View

From

Sorted by

With category

Explore more categories

Related Questions

Best SEO Structure For E-Commerce With Products Using Multiple Categories

site structure seo

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.
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.
Content Development | | nb2e4fg

0
How important is content production in the online store of gas coolers?

HiI am the manager of a store site in the field of online air conditioning store at a novinmarket.com address Not much content can be produced for the air conditioner Is it important to produce content on store sites as well?
Content Development | | sarairan

0
Multiple Domains with the same Products

Hi, I have a client with three companies selling the same products on each. Two brand sites and One which shares all the products. Currently, they are all using the same description and imagery. How damaging will this be for duplicate content? Thanks, Ashleigh
Content Development | | Ashcastle

0
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 | | whiteonlySEO

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 | | BallyhooLtd

0
Using Product Descriptions in Meta Description

Hi All We have over 10000 Products and a while ago we spent some time adding Product Descriptions to the Product Pages, For Example we have Product - Black Snazaroo Face Paint Product Description - Great for Childrens parties, fundraising events, Halloween or other festive faces. An easy makeup to apply and remove. All Snazaroo face paints are Non toxic, Fragrance free and Skin friendly. Snazaroo is suitable for all skin types, however it is always recommended you do a skin patch test on a small area before full application. Unfortuantly our Meta Descriptions really need some work, for example this same page contains the following meta descriptions We realise this could be holding our site back. Is it ok to use the same Product Description inside the Meta Description Tags also, for example can we use the Meta Description for this Page - Thanks
Content Development | | AMG100

0
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.
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?
Content Development | | vulonl

0
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 | | anthonybriant

0