Well I finally got round to updating my Buy Jewellery Online site.
It’s been sitting there promoting Valentine’s Day for over two months now. But it was my first attempt at a mashup store, so it needed a complete overhaul.
So I’ve replaced it entirely with an instance of my Affiliate Mashup Store. Took me about 20 minutes to get it up and running with about 12,000 products spread across US and UK catalogues (a nice feature of the mashup store is Geo-IP location, since a lot of my traffic is international).
The tricky part with making a jewellery store is the keywords. Fortunately my US merchants had a tonne of products with ‘jewelry’ as a keyword (about 100,000 of them in fact) so setting up the US catalogue was easy.
The UK catalogue was a little harder though, since there were only around a dozen ‘jewellery’ keyword products available. That meant I had to run the catalogue tool over and over again, with searches like ‘necklace’, ‘pendant’, ‘gold chain’, ’silver chain’ etc.
I managed to get around 1000 UK products though, and no chainsaws as far as I can tell, which is good enough.
One thing to note if you’re populating a catalogue with multiple keywords like this is to make sure you don’t add duplicate entries. For example, I ran the tool once with the keyword ‘jewellery’. When running it again with, say, ‘necklaces’, I had to specify ‘necklaces -jewellery’; otherwise I might have added products with both keywords the second time, resulting in duplicate products in my catalogue.
Now I just need to do some more SEO. I was in 3rd place on Google for ‘buy jewellery online’ last month. Now it’s down in 8th. Time to start cranking out some more links.