-
Here is my SQL structure. The pid is what I use to access the categories. Amazonid is obvious. Parentid is the parent category's amazon id. textid is an optional text identifier to use instead of pid (I'm not using it). Name is the name. mode is the mode (mode is sometimes necessary).
CREATE TABLE blank_categories (
pid mediumint(9) NOT NULL auto_increment,
amazonid int(12) NOT NULL default '0',
parentid int(12) NOT NULL default '0',
textid varchar(70) NOT NULL default '',
name varchar(70) NOT NULL default '',
mode varchar(20) NOT NULL default '',
PRIMARY KEY (pid),
UNIQUE KEY amazonid (amazonid,parentid),
KEY textid (textid),
KEY parentid (parentid),
KEY mode (mode)
) TYPE=MyISAM;
-
Here is the code I use to parse browsenodes.com files into my db:
Code:
$quotelist = file("$url");
$db = mysql_connect("localhost", "user", "pw");
if (!$db) { echo( "<P>Unable to connect to the " . "database server at this time.</P>" ); exit();}
mysql_select_db("dbname", $db);
function addquote($element){
$quote_array = explode("|",$element);
$name = $quote_array[0];
$parentid = $quote_array[1];
$amazonid = $quote_array[2];
$mode = $quote_array[3];
global $db;
$result1 = mysql_query("INSERT blank_categories SET name = '$name', parentid = '$parentid', amazonid = '$amazonid', mode = '$mode'", $db);
if (!$result1) { echo("<P>Error performing query: " . mysql_error() . "</P>");
}
}
array_walk($quotelist, 'addquote');
?>
Its modified from a script I made to do much the same thing with quotes for my literature site's quote db so that explains the naming conventions. Access it like http://www.example.com/script.php?ur...enodesfile.txt
When getting the browsenodes.com files use | as a seperator and make sure it includes mode.
-
Oh My God.
You'll never guess how many items I sold through AWS yesterday.
200 of these: http://www.kissitmakeitbetter.com/item/B0000532MK/
I'll only make say $30 off of it, but damn. That is alot of items. I don't know why but people are always buying the health type stuff in bulk.
Whats great about that is that it will help power me up to the next tier.
Now Amazon only has 4 left in stock.
-
lol. That helps :)
I only have 6 items left needed to get to my next tier (5%)
-
I missed out on getting into the scaling tier thing this quarter - damn me and my laziness!
CHRIS! Thanks very much for posting all that - extremely generous of you!
BTW, how long did you have the site open for spidering before you announced it to us here?
And would URLs like: www.domain.com/cat/1 be less spiderable that www.domain.com/cat/1/ ?
-
I announced it as soon as I was finished with it. The same day I submitted to Google.
I think one reason that my kissitmakeitbetter.com and discountpowertools.net have been spidered could be PR. Kissit had a bunch of PR to start with and I linked to discountpowertools from jalic.com which fluctuates between a 6 and a 7.
-
Oh... those two URLS are equally spiderable.
-
How do you guys from looking at the search engine (first link on first page) are an affiliate link and not from Amazon?
-
-
What tier are you on now? I'm still on 5% lol
-
No sales :( But 16 clicks on the buy button by 11 different people
-
It takes a LOT of clicks to get sales. At least it does for me :)
I've had 2668 clicks and only 185 sales. Only 31 of those sales are kitchen items, the rest are south beach diet books.
-
I've had about 90 clicks and 1 sale, heh
-
Really? Cool. What did they buy? Anything good? :) is the rate 5%? or 7.5%?
-
Well I don't know if I can class it as a sale, as MarkB bought it (thanks Mark) :)
It was a DVD, I'm not sure weather its 5% or 7.5%.
