How do I publicize a company's product list on the web?

Posted on 2012-03-15
Last Modified: 2012-03-30
A company that I am working for has a database of the items that they are selling. The items are generally sold by part number. Pages have been generated manually for selected part numbers and have generally fared very well in Google.

The customer would like to programmatically generate a page for each part number yielding potentially thousands of pages. There is a small universe of buyers so that there will be relatively few searches for the numbers so that just a few hits should raise the rank of the pages.

What do I need to do to optimize the SEO of these pages?

What issues are there in generating thousands of similar web pages?
Question by:dovidf
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 25

Expert Comment

ID: 37726451
It seems very inefficient to do this way, but I guess if getting in search engine is the goal, then I guess you could do it.  Google works by the actual page contents--the text so in this case it would work well unless they change so frequently that it is useless. Apart from that it seems more practical to have a database generated webpage hits the DB and generates the pages via PHP/ASP/or ASP.NET depending upon your preference.  I'm not sure what issues you are looking for in generating thousands of pages.  Do you plan to generate thousands of HTML pages and upload them? Do they stay fairly static for a while?  If yes to the first question and no to the second, then I don't think it would be a good idea to do it this way.  If yes to both, then I guess you could argue that it is worth it in order to have better SE results in Google.
For me as a user it would look a bit cooky to have 1000 HTML pages rather than one .php page that can generate the first 50 entries, or search all products and give results in 25/50/100 per page results or something of the like.

Author Comment

ID: 37727113
What about generating pages with say 250 part number links on each page until the database is exhausted and then putting up a detail page when one of the 250 part numbers is clicked on?

Would the part number loaded pages rank?
LVL 25

Expert Comment

ID: 37727164
Hmm. I'm not sure about that. I just haven't known many places to display static pages for so much data instead of just dynamic.  Is the goal for search engines to hit it or for people to use your site and your own search page?  Most dynamic pages have a search form where you get the info they want and search your own DB and display the results.  If this is not what you are wanting to do, you can certainly choose to generate static pages.

If you put X pages out there with 250 links per page (static HTML) and each links to a static HTML page then yes it should rank because Google spidering should traverse each link.

Again, this seem unorthodox to me in designing a site and seems like a lot of pages that shouldn't need to be.

On the other hand you could have 250 links, each of which points to a PHP page passing in the Part# and that should also work and only require that you have 4 pages for 100 parts (250 links per page) and one php file.


It should expect to be called like

And when php gets that number it should hit the database and display a generated page,  with all info relative to that part.  That should probably rank as Google could follow each link to the generated page also.
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI


Author Comment

ID: 37727243
The situation that I am trying to handle is one where a user says I want to buy part abcd1234 so I would want my site to rank highly for that number. The user is not nearly as likely to come to the site and do a search.

I don't understand why it would take 4 pages besides the php page. Once I have a template for what I want to show when someone clicks one of the part number links, all I should need is the php code and the template to fill in the details for the part number selected.
LVL 25

Accepted Solution

SStory earned 500 total points
ID: 37727480
Well, if you do it the normal way, yes you really _COULD_ do it with one php page.
It would probably be easy to do it with more than one. One page where you list and have the search form, that submits the results to the back end PHP file. This is the normal way of doing it.

You however mentioned listing all of your parts on static pages 250 a page. So if there are a 1000 you'd need 4 static HTML pages and one partlookup.php page that could be given a part number and show the result.  I was just telling you what you'd have to do to do it they way you first mentioned.  What I've mentioned above is the normal way of doing fact a more normal way would be the first page being PHP, and listing everything by default from the database in a paged format, if you like, dynamically, with the links dynamically generated as well, and when clicked upon they could go to the same page with a param to list only that product. At the top of the page their could be a search box that let them filter what they wanted. Or you could just populate a huge combo box. There are many ways to do it.

Author Comment

ID: 37762081
Do you think that this would work from an SEO point of view? Would putting up 250 item pages rank due to the limited number of advertisers and the high interest of those seeking?
LVL 25

Expert Comment

ID: 37787593
Here's a good article on SEO:

To be honest with you I'm not sure which way would yield better results. Of course you'd want to use keywords which search engines utilize, but it is often more about the actual content for some SEs.  I'd never build 250 pages myself, I'd just build the one searchable page and try to market to get people to my site by traditional marketing manners. Perhaps your keywords section could be auto generated by a script to include every part number on that first-home page.  That would make the page bigger in size, but if every part number is 7 digits long and there are 3000, then that is roughly 24000 bytes in if each takes a byte, or in unicode 48000 bytes if it take 2 bytes per char.  That is including the commas.  But for sites that hold more to text in the <body> section and not the meta data, you might consider generating all part numbers separated by spaces and placing that at the bottom of the page, font size 4pt or something small and the same color as the background so it will be invisible.  In that case the search engine should think it relevant and part of the body, but the user shouldn't see it.

Featured Post

Limited time offer using promo code EXPERTS25

Designed with a wealth of functionality and convenience, ATEN's new Thunderbolt™ 2 Sharing Switch takes your Thunderbolt setup to the next level. Now through August 31, 2017, Experts Exchange members get 25% off the US7220 on the ATEN USA eShop using promo code EXPERTS25.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question