Free e-commerce catalogs managed with Google Docs
February 3rd, 2010 | Published in Google Docs
Guest post: Dan Salcedo is founder of the DC based international development organization OpenEntry, with the mission of helping small and medium enterprises (SMEs) worldwide benefit from the exciting new opportunities opened up by global e-commerce. Working with a team of volunteer developers, he built a catalog generator that enables SMEs in developing countries to create their own free e-commerce catalogs, managed via a Google spreadsheet.
Years ago, I noticed artisans in developing countries were selling their items to a long chain of middlemen that only paid them 10-15% of the final retail price, even through conventional fair trade channels. So I launched a non-profit organization to help artisans disintermediate all the middlemen by selling directly through e-commerce catalogs that they could create and manage themselves. We recently relaunched our OpenEntry catalog generator using a bunch of Google tools including Docs, Sites, Checkout, Picasa Web Albums, AdSense, and Apps Engine. And our User Manual, built on Google Sites, is full of YouTube videos. This enables us to offer totally free e-commerce catalogs (software, hosting, user support) to artisans and SMEs worldwide including the following:
Each catalog is managed by filling out a Google spreadsheet with three sheets containing information on the company, products, and additional pages (see products sheet below).
The images are stored on Picasa Web Albums and sellers use Google Checkout (as well as PayPal and 2Checkout) to accept credit card payments. Google Sites helps users generate attractive HTML that can be added to some of the spreadsheet fields to improve aesthetics. Google App Engine reads the spreadsheet, then generates the catalog hosted on Google servers. These tools also made it surprisingly easy to enable OpenEntry catalogs to be managed with a smart phone.
Google recently added a feature enabling the ownership of their spreadsheets to be transferred to a third party, which makes it easy to transfer spreadsheets to the final SME vendor. This is very good news because it enables the OpenEntry User Support team in Nepal to set up catalogs and transfer ownership to the SME vendor who can then operate it securely. This also means we can now transfer blocks of catalog accounts to young, ambitious entrepreneurs anywhere in the developing world, enabling them to start their own legitimate enterprises. Even though the OpenEntry catalogs are free, the entrepreneurs can charge for setup, digital images, custom templates, training, maintenance, etc. And they can even do it from an Internet cafe until they can afford their own computer. This reinforces the conclusion of the United Nations Development Program evaluation of our platform (under its previous name, CatGen) that generated 4000 jobs for artisan women and "a relatively inexperienced group of young IT professionals" in Nepal.
Because this is a non-profit initiative, OpenEntry is to help with a variety of technical tasks starting with template design.
Years ago, I noticed artisans in developing countries were selling their items to a long chain of middlemen that only paid them 10-15% of the final retail price, even through conventional fair trade channels. So I launched a non-profit organization to help artisans disintermediate all the middlemen by selling directly through e-commerce catalogs that they could create and manage themselves. We recently relaunched our OpenEntry catalog generator using a bunch of Google tools including Docs, Sites, Checkout, Picasa Web Albums, AdSense, and Apps Engine. And our User Manual, built on Google Sites, is full of YouTube videos. This enables us to offer totally free e-commerce catalogs (software, hosting, user support) to artisans and SMEs worldwide including the following:
www.NatureNepalHS.com
Nature Nepal-Herbal Care
Nepal
main.openentry.com/mereville
MerevilleyTrust
India
www.pupbd.org
Pollee Unnyon Prokolpo
Bangladesh
Each catalog is managed by filling out a Google spreadsheet with three sheets containing information on the company, products, and additional pages (see products sheet below).The images are stored on Picasa Web Albums and sellers use Google Checkout (as well as PayPal and 2Checkout) to accept credit card payments. Google Sites helps users generate attractive HTML that can be added to some of the spreadsheet fields to improve aesthetics. Google App Engine reads the spreadsheet, then generates the catalog hosted on Google servers. These tools also made it surprisingly easy to enable OpenEntry catalogs to be managed with a smart phone.
Google recently added a feature enabling the ownership of their spreadsheets to be transferred to a third party, which makes it easy to transfer spreadsheets to the final SME vendor. This is very good news because it enables the OpenEntry User Support team in Nepal to set up catalogs and transfer ownership to the SME vendor who can then operate it securely. This also means we can now transfer blocks of catalog accounts to young, ambitious entrepreneurs anywhere in the developing world, enabling them to start their own legitimate enterprises. Even though the OpenEntry catalogs are free, the entrepreneurs can charge for setup, digital images, custom templates, training, maintenance, etc. And they can even do it from an Internet cafe until they can afford their own computer. This reinforces the conclusion of the United Nations Development Program evaluation of our platform (under its previous name, CatGen) that generated 4000 jobs for artisan women and "a relatively inexperienced group of young IT professionals" in Nepal.
Because this is a non-profit initiative, OpenEntry is to help with a variety of technical tasks starting with template design.