Aug 132012

Quite a bit of time has passed without any new contributions to this poor out of date site. The reason being I have been so busy with my new eCommerce site I have not had a minute to work on this site. Before I get too far ahead of myself I decided I needed to slow down and analyze a bit what has been going on. It’s time to let all you people out there in internet land learn how to do what I do.

Now it’s not the easiest thing in the world to do this – I won’t lie. I have a LOT of experience running eCommerce sites (coming up on 8 years). I finally decided to tackle one entirely on my own. SEO, Programming, Adwords, Marketing, and all that good stuff. The good news is, I am pushing up on $200,000 in sales and there is still 2 months left in the first year! The bad news is there is so goddamn much to do I don’t have a minute to breath.

Perhaps this blog can once again become a way for me to structure my thoughts and move forward with new ideas. I would love to meet other people interested in discussing this kind of stuff.

Marketing strategy includes eBay,, and sales made through emails and phone calls generated by internet marketing.

So whether you sell Kitchen Faucets, Bathroom Faucets, Wall Mount Faucets or other weird stuff I think I can help. This site is designed to be a laser targeted eCommerce site. You may read in the world of internet marketing how important it is to have your niche. I’ve experimented with this kind of thing before doing affiliate marketing – specifically through Amazon Affilates but I found I could make more money selling my own products.

I happened to have connections in the Faucet and plumbing fixtures world from my previous employment which is why I started this kind of site. With suppliers and product knowledge you can go quite far with just a touch of internet marketing magic. Haha – what that really means is working a lot for not a lot of money. But it can be done.

I don’t really want this blog to turn into some 4 hour work week type thing about how to live your life but I will point out a few interesting tidbits. I am a U.S. citizen currently living in Beijing, China. I have been learning mandarin and supporting myself with selling products to US customers.

You might say, how the hell can you run an ecommerce business all the way from China. Well that’s a good question. Maybe if you stick with me through my sporadic posts I’ll manage to explain more.

Let’s just say step one is you have to have a website that you control. This site as well as Faucetlist – Your home For Faucets and Plumbing Fixtures! are registered through

Bluehost has been awesome to work with and I can’t imagine going anywhere else. is also hosted with Bluehost. Faucetlist is actually hosted by another eCommerce service platform provide that we will get into next time but the domain is still with Bluehost. CLICK HERE TO SIGNUP FOR BLUEHOST.COM I know you won’t regret it.

Ok, that’s it for now, btw, sorry for typos or any shit like that. I am not a great proof-reader and I never claimed to be much of a writer either!

Sep 292011

Ok, well this is going to be a little boring (and seemingly pointless) for some, yet extremely useful for others. I’m writing it down for personal reference. As for me, this is extraordinarily useful stuff. Get ready for an excel / open office lesson. If you want to start an eCommerce business, the most important concept for you to understand is that you must have control of your data. I cannot stress enough the necessity to be able to manipulate your data. Chances are, if you are trying to learn how to start an ecommerce business, the tips outlined in this article (and in the next article on how to use VLookup) will seem confusing and/or pointless. Stick with me as there’s a method to my madness. I didn’t build an 1.2 million/year business from scratch without a few tricks! Follow along as I work on doing it again!

If you are operating a webstore, you will likely have thousands of products. The initial launch for my soon-to-be released site will contain approximately 2000-2500 products. The initial launch will only reflect a small number of the products that will be for sale in the future. Keeping track of everything you’ve got selling is going to be absolutely essential.

You can manually upload one by one, adjusting price one by one, adjusting everything manually one by one. It will work. And when your suppliers raise prices 5% good luck to you. When a collection is discontinued and you have to delete it all by hand, one by one good luck to you. We have computers now. Fucking use them.

Losing control of your data can be a terrible time drain. A prominent developer I used to work with would always say, if it can be automated, automate it. If it’s a repetitive task, automate it. No exceptions.

Ok, excel. And a little of open office. Why? Just because both have some advantages. Obviously most sites call for .csv files – In which case you really have to use excel. Open office is good too. Let’s discuss some common problems for eCommerce merchants.

Problem 1
You have a file full of images. You need those images to be listed in an excel spreadsheet so you can match them up with MSRP, items specifics, UPC, Cost, Sell Price, etc. This is absolutely essential if you hope to upload products to your website in bulk.

I have 2000 images. They are named Product.jpg, Product2.jpg, Product3.jpg and so on. How can I get this list into excel without typing each item individually?

Step one, prepare to dust off those ms dos skills you haven’t used since the 90s.

Go to file, run, and type “cmd” – This will pull up the dos menu.

Type “Dir c:\(your file location) > c:\(your file location)\filelist.txt

This creates a text file for you with a list of all the files in the folder.

Now, look in the (your file location) folder and you will see the filelist.txt file. Open it. Select All, Copy. Them go to Open Office and open a new spreadsheet and Paste in the contents.

A “Text Import” windo will pop-up. You will need to look at the “Separated by” section and make sure the “Space” box is check. Also, check the “other” box and add a “.” – This will make sure the .jpg from the filelist will be dropped into a separate column. Last, click the box next to “Merge delimiters” – this will set up the formatting nicely so you will have one column with just the product code.

Now that you have this list, you can combine it with some other powerful features – namely, VLookup. How to use VLookup will be the subject for the next post.

A brief bonus tip. You have a section on a bulk upload file calling for a link to the image location on your ftp. You have uploaded all your products as .jpgs in ftp:\(your location)\product1.jpg…product2.jpg…product3.jpg etc. Now you want a list in the spreadsheet.

Use the & function. In your spreadsheet, build the link. Have column A say: http://www.(your location) Column B will be the part number (or image names list – that we just learned how to extract!) Column C will be “.jpg” (which may or may not be necessary depending on what data you currently have). Last you need Column D for the formula. Type “=ColumnA&ColumnB&ColumnC” That’s it!

One last tip about spreadsheets. If you have created a list with a formula, and then you go to copy and paste it to another spreadsheet, you may lose the data. To circumvent this annoyance, copy and past first into a blank text file, then copy and paste again to the other spreadsheet. This will preserve the order.

AUTOMATION is key. If this doesn’t make sense to you feel free to ask. If you have encountered this sort of problem (like I do all the time), this info. could be quite helpful! I certainly hope it is! Next up, VLookup.