As an Amazon.com Seller

Not sure if you’ve noticed, but I’ve added an Amazon.com Store link on my side bar, which currently lists the items I’m selling on Amazon.com. I began to buy and sell stuff on Amazon.com a long time back, but only recently (a few months ago) began to push a lot more volume (instead of 4 or 5 items a month, I am now pushing 30+ items a month). And it’s bringing in quite a shiny penny. Actually, I’m not too sure how shiny the penny is as in I haven’t really done any bookkeeping besides knowing that I’m selling items for more than what I purchased it for, which can range from a few dollars to over a hundred dollars per item.

I’m not going to go too deep into how this all works and what my “secrets” are, but if you’re interested in anything I’m selling and I personally know you, I can probably sell it to you at cost. Also ignore anything that’s listed as $2,000 as that just means I’m currently not selling it, probably due to insufficient stock or the pricing isn’t at what I want to sell it for.

I’ve also been maximizing my earnings by using my Amazon.com credit card and directing people to purchase under my affiliates account. The credit card gives me 3% back on all Amazon.com purchases, which has netted me $75 worth of Amazon.com gift certificate rewards for each of the last 2 months. The affiliates account started with only $90 earnings a few months ago, but just last month, I’ve broken $200.

Concurrently, I also list the items in my Half.com Shop, which gets me purchases once in awhile, but they don’t really have that high of an audience as Amazon.com. I’m currently also thinking of becoming a merchant on Buy.com Marketplace, but they have a bit more requirements to join.

All in all, I’m happy with the results.

Changing Amazon Affiliates ID

So now that I have multiple places where I link to Amazon.com items using my affiliates ID, I’ve decided to create multiple Amazon affiliates ID to track where things were coming from.

I knew there was a way to mass edit strings in my blog posts and a quick search resulted in: How to Find & Replace Data in MySQL

To find a string in a certain field and replace it with another string:

update [table_name] set [field_name] = replace( [field_name], '[string_to_find]', '[string_to_replace]' );

So a quick update wp_posts set `post_content` = replace( `post_content`, 'krudoethekrue-20', 'krunk4everblog-20' ); did the trick.

Now I’ll be able to track if people are coming through my HD-Trailers site, my HD-Trailers blog, or my Krunk4ever! blog.