Duplicate content isn’t a problem for just for VPASP powered sites. It can cause problems for any site and many online catalogs suffer from this problem too. It is a particular problem for online retail sites because they may want to include the same product in several categories to enable their customers to easily find it whilst browsing through categories of interest. This typically means that a site has multiple versions of what is the same page content.

From the search engines perspective (and their users) they only want a single page to come up in their search results and the search engines (unless told otherwise - see below) will select which page they think is the most relevant. This in itself might not be a problem, but losing ‘link juice’ (inbound links from other sites) may well be and that is important when it comes to that product getting good search results for its keywords.

For example, a site has a product page display in several categories as follows:

/products/56-sony-bravia.asp
/shop/shopexd.asp?id=56
etc etc

The problem is that if other sites link in the ‘link juice’ most likely will get spread over several url’s.

Quite often people refer to ‘being penalized’ by the search engines because they have duplicate content. This is un-true. The search engines are simply trying to keep their listings uncluttered.

Fortunately, there are things which can be done to resolve this conundrum. The major search engines now recognise something called canonical urls. This simply allows the site to direct the search engines to a preferred version of the url. In doing so it is that url which will appear in the search engine listings and it will inherit any link juice from any duplicates. This is good news because it means that you can concentrate your SEO efforts on a single page.

Duplicate content can be a real problem for VPASP powered sites including those that use the SEO Pak.

We have a solution...

Product File Management Enhancements (BYZ163)

It gives the VPASP owner complete control over the way product pages are named (which is great for SEO) and you can specify canonical urls! It also cleverly eliminates duplicate content from VPASP’s dynamic pages by using 301 redirects to tell search engines that that dynamic page has now moved and to go look at your preferred page.

You can find out more about other useful VPASP SEO bolt-ons we’ve developed here.

You need to be careful not to define tables greater than 8k in SQL Server as it can cause problems.

If you are using a Windows Web Server we’ve developed a nice little tool which will check your SQL database and will highlight any tables where there may be problems. It can also be used, simply to show your defined table sizes.

ASP Table Size Calculator

More information on the SQL Server limit bug / problem:

8k Limit Bug Text/Ntext Cursor Processing Bug

Yandex is an over zealous Russian search engine that will scrupulously index as many pages as your site can offer up and it’s spider enjoys it’s work. Yandex may be industrious but unless you have pages of interest to Russian speakers you may want to restrict it’s spidering of your site because it can use a lot of your valuable bandwidth allowance.
To prevent Yandex from crawling simply add the following to your robots.txt file:

User-agent: yandex bot
Disallow: /

I received an email from a client today, and after I finished the reply I realised I’ve been asked the same questions many times before.

Having looked at your site, I think that it would benefit you to use some of our add ons from this page: http://www.bigyellowzone.com/byz_vpasp_seo_bundle.html

As you will be well aware to get the best positions you really need inbound links from quality sites / pages to make a real difference. For most ecommerce site that’s a very tall order as it isn’t feasible to do that for thousands of products in inventory. The good news is that its the same for your competitors. I am aware of some sites who get inbound links to some of their products which are high margin or high profile for them. But that’s an expensive game and costs (especially in time soon outweigh benefits) However, there are things you can still do with the on page content that can help (see below).

As far as the bundle goes. I’d recommend implementing all the products on the page I’ve linked to above with the exception of the friendly pages. As you have a mature site with established pages it would be a step back (ed. less mature sites may benefit).

Something which can make a difference is by in site cross linking. I don’t know what your level of technical expertise is, but the content enhancements enable you to do things like cross link categories and cross link products. For example you could add a section on your category page that links to top sellers within that category. Or cross link products to the most popular products within category, or brands etc. Telling visitors a product is most popular is also a good psychological trick as where they are presented with 5 very similar alternatives they feel more confident buying something other people have bought are more likely to convert. There are many permutations, but what it does is to create in site links of relevance. If done well those links can help with navigation too.
You might also want to consider internal link building by using ( BYZ116 Enhanced Paging/Searching) to link brand names or other cross category relationships. BYZ116 builds search page results that can be indexed by search engine.

I’d also strongly recommend that you consider using the product feeds. Specifically, the Google feed (the others may / may not work out for you as they are paid for inclusion). The feed loads product data direct in to Google’s shopping engine so Google can make sense of searches where people put in things like product ids or UPC (unique product code).

Just an observation on your product pages (this may be applicable to other pages too). You may want to consider using standard heading tags <h1>Heading 1</h1> etc. for items of key data like product name and model. There are a few tips on stuff like that here: http://www.bigyellowzone.com/vpasp_seo_guide.html

As for improving conversions we’ve found that the best way to find out why people aren’t buying (or are buying) is to get as much feedback as you can about the site. Try running a contest or sending out a follow-up email a couple of weeks after a customer orders (offer them a coupon - it can lead to further sales conversions on its own). For example, when I used a Mac running Safari (it may look different on Windows) to look at your homepage and I can see that your links are blue on a black background which makes them hard to read. An important part of getting good conversions is getting all those small things right because they can add up.

The most cost effective way to buy the software is to join our membership subscription program. You get all the add ons we have produced at a heavily discounted price: http://www.bigyellowzone.com/vpasp_add_on_hosting_plans.html

We’ve released our new predictive search add on for VPASP today. It’s one of those amazingly simple, but powerful, things that can make searching a site so much easier. Try the demo: http://www.bigyellowkey.com/mysoftware_product_details.asp?prdid=362&opu=n

We’ve added some real time demos so you can tryout our software before you buy.

If you receive an official sounding email from someone from a domain registry saying that they are contacting you because a customer of theirs wants to register your domain using several Asian extensions this is a scam.
You can either ignore the email, or if it genuinely worries you (or you actually plan to launch a Taiwanese website) then use a reputable registration company to register the domains. Under no circumstances use the company that emailed you to register the domains.
Unfortunately, the internet registration bodies have opened a Pandora’s box through their greed by forcing owners pay a fee to make their records private where once this was free. Domain owners will see much more of this kind of criminal activity and they need to be on their guard.

We’ve started a featured products section on BigYellowZone.com. The idea is to provide more in-depth information, product images and movies. The first featured product is the new release of the invoice and packing slip. http://www.bigyellowzone.com/byz_packing_slip_invoice.html

Some things just keep getting better and better. Over the years people make suggestions. We listen and then eventually we get them done. Version 22 is one of those things - bulk printing. No longer do people have to print individual invoices and slips. It can be done in one go.

http://www.bigyellowkey.com/mysoftware_product_details.asp?prdid=199&opu=n&remtop=Y&remleft=Y&remright=Y&rembottom=Y&remmerchantid=0

We’ll be releasing our new super duper drop-down menu tomorrow. We’re just finishing off the documentation and packaging it up ready for download.
If you decide to buy the menu please do let us know how you get on and send us a link. We think it makes VPASP site sooo easy to navigate and that can only be a good thing.