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

845

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

1
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
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 | | ExtraDigital

0
Is there any examples of comparing a competitors product to your own .

I'm working for a company that makes large touchscreen displays. I want to add some content to the site and target some competitor keywords by comparing some of our products to theirs. I know I've seen companies do this, I'm just trying to find a tasteful way to do this, and have it help bring in traffic.
Content Development | | zenmatrix

0
Should I put the date on a new content page to show users when it was written or updated?

I've been asked this question at work and not certain of the answer. Personally if I see an 'old' date in a meta description on Google I often scan for more recent articles. In other words it can act as a deterrent. We are a very big social networking site with a large content section. For some of our content the date might be relevant, such as legal information, but often it isn't. Are there any SEO factors in dating content?
Content Development | | CecilyP

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

1