I'm not adverse to putting a couple keywords in the url, like on the main part of this site. However amazon titles are probably 10 words on average and that makes the url extremely long. Too long for my tastes.
Printable View
I'm not adverse to putting a couple keywords in the url, like on the main part of this site. However amazon titles are probably 10 words on average and that makes the url extremely long. Too long for my tastes.
I actually have two - together, the sites have made 58 sales this year (items sold, that is).Quote:
Originally posted by cameron
What is your AWS site url Mark?
www.buymetal.net is the one doing best.
www.mygroovywedding.com/shop/ was my first (basic) attempt at AWS using Mr Rat's perl script.
Buy Metal uses the same script, but more trimmed down as far as items spiderabobble.
Oh, and on the 29th someone ordered 10 coffee mills LOL
I'm still trying to get my product pages to work like /product/asin
I can do it for none amazon pages, but no amazon ones...
Which method are you using?Quote:
Originally posted by incka
I'm still trying to get my product pages to work like /product/asin
I can do it for none amazon pages, but no amazon ones...
Yep. I agree. A lot of the words used in the title are just additional features of the product and don't really contribute much. If you look on my URL's I've just included the first 4 words of the product title. That way it normally includes the make and model of the product, plus two other words for good measure.Quote:
Originally posted by Chris
I'm not adverse to putting a couple keywords in the url, like on the main part of this site. However amazon titles are probably 10 words on average and that makes the url extremely long. Too long for my tastes.
I figure that a lot of other AWS stores will be using the product title for their own html page title in a detailed product page. So I've actually just used the first 4 words on these page titles too. Hopefully, it will increase the keyword density of the important keywords that people will use in their search terms and give a slight edge over the competition that are using the whole product title and wasting the density over inconsequential words. Of course the danger of just using the first 4 words is titles that just seem to stop abruptly and therefore people will be less likely to click on them from the search engine. The majority of the time they make sense though. It's too early to tell how this is going to work out, because my sites that do it haven't even been deep crawled yet.
Im using Dan's script with .htaccess and
$var_array = explode("/",$PATH_INFO);
$ASIN = $var_array[2];
Try this code:
PHP Code:$var_array = explode("/",$REQUEST_URI);
$var = $var_array[2];
$Asin = $var;
Remember variable names are case sensitive so if you need a variable named "Asin" then "ASIN" will not suffice.
Chris, I'm wondering if you're able to share a slice of your code?
I have nodes stored in an sql DB, in a table which is simply:
as an example.Code:ID NODE
6 67207
In my code, I have:
And then $cat is called when asked for the node number later on.PHP Code:$var_array = explode("/",$REQUEST_URI);
$sql = "SELECT node FROM cat WHERE id=$var_array[3]";
$result = mysql_query($sql);
if ($result == 0) { $cat = 67207; } else { $cat = $result; }
But it only produces an error with AWS - obviously the node is not being carried through... Any ideas?
Mark, I think there's a few things missing from your code. Try:
I'm not certain, but that's just what I would do out of habit. Try echoing your $sql var and then run it through mysql manually. Also try echoing $result to make sure $cat is being set to something meaningful.PHP Code:$var_array = explode("/",$REQUEST_URI);
$sql = "SELECT node FROM cat WHERE id='$var_array[3]'";
$result = mysql_query($sql);
if ($result == 0) { $cat = 67207; } else { $cat = mysql_result($result, 0, 'node'); }
That seems to have done the job, mate :)
Why was my code not working?
All I need now is Chris's node spider script to do all this for me automatically ;) Any chance of that, Chris? :)
Depending on how you have your field types set in your database, you needed the quotes in your sql to make it valid.
You can't always access $result directly either.
www.buymetal.net/ - PHP-powered AWS now up :) Have to wonder how to power the main page without just having it static or redirected... will have to work on that I think.
Grrr.. I still can't get my code to work...