HexxWorld Blog

I own a Cafepress Premium shop called HexxWear and for the past month or so I have been working on optimizing my shop for mobile web and smartphones. My mobile site is not yet ready for purchasing product from it but I do have featured products displayed with links to them in the main desktop version of my shop.

As with most web development one of the keys to owning a website is ensuring that there is as little manual maintenance as possible. This is done by developing or integrating dynamic elements on your page by means of scripts or other software.

Previously, on my HexxWear mobile site, I had to manually post five featured products. This is approach is not very convenient. So I decided to add PHP into the mix by displaying random featured products. In order to do that I needed a database of my products that the PHP can pull from. Cafepress, as far as I know, will most likely not provide me with a database dump of my shop products (no one has answered my question in the forum yet).  So how can I obtain the necessary data from my shop that I can import into my own SQL database?

The answer to this question is not quick and simple and takes a little time to cleanup prior to importing. However, I have proven that it is possible using a combination of a third party tool called podToolbox, Microsoft Excel (or equivilent spreadsheet application), basic text editor (i.e. notepad, wordpad). There may be quicker procedures for obtaining your cpshop data, but I could not find one aside from the third party tool cpshop. I may look into that later, but from what I saw from the sample sites they are not mobile compliant.

You can also download and view the .pdf of this procedure for viewing later. I also have this posted on Instructables.com.

(continue reading…)