Free Online Storage

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Wednesday, 3 February 2010

Free e-commerce catalogs managed with Google Docs

Posted on 09:00 by Unknown
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:

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 seeking volunteers to help with a variety of technical tasks starting with template design.

Posted by: Dan Salcedo, Founder and CEO of www.OpenEntry.com, dsalcedo@OpenEntry.com
Email ThisBlogThis!Share to XShare to Facebook
Posted in Guest Post, spreadsheets | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • More Google Experiments That Hide Results URLs
    There are at least two other versions of the Google experiment that removes search results URLs . The first alternate version places site na...
  • Add a Keyboard Shortcut for Chrome's App Launcher
    I'm not sure why Chrome's app launcher doesn't have a keyboard shortcut, but it's pretty easy to add one. For Windows XP, r...
  • Merge cells vertically in Google spreadsheets
    There are many times when you want to format your spreadsheets in a certain way to make your data easier to read and understand. Starting to...
  • Docs on the iPhone with Chris Pirillo
    Posted by: Meredith Whittaker, Program Manager Chris Pirillo , Gnomedex Conference founder, CNN.com Live technology contributor, and one of ...
  • Posting to a blog is a bit too easy
    Posted by: Andrew Chang, Marketing Manager Oops. As many of you have noticed, yesterday I accidentally posted my personal to-do list onto t...
  • Google Now for Google's Homepage in Testing
    It looks like Google Now won't be limited to Android, iOS and Chrome , it will also be added to Google's homepage. Some code from a...
  • The End of This Internet
    "Congratulations, you've reached the end of this internet. Look for another?" That's the message you see when you use the ...
  • Google Docs welcomes DocVerse
    (Cross-posted from the Google Enterprise Blog ) The future of productivity applications is in the cloud. We've always believed the web ...
  • Speakout gears up
    Posted by: Jen We now have lots of schools participating in our Global Warming Student Speakout from each of the locations listed below. We...
  • Google Play Music Offers Tag Suggestions
    Google's online music service started to suggest better tag values for the songs you've uploaded. If you right-click a song or an a...

Categories

  • Acquisitions
  • Ads
  • Android
  • Annoyances
  • April Fools Day
  • attachments
  • back to school
  • Blogger
  • charts
  • chat
  • Chrome
  • Chrome extensions
  • chrome web apps
  • Cloud Connect
  • collaboration
  • comments
  • community
  • discussions
  • DMCA
  • docs
  • document list
  • documents
  • documents list
  • drawings
  • drivebacktoschool
  • Easter Egg
  • education
  • Faces of Docs
  • forms
  • gmail
  • gone google
  • Google Alerts
  • Google Analytics
  • Google Apps Blog
  • Google Apps Script
  • Google Calendar
  • Google Cast
  • Google Checkout
  • Google Chrome
  • Google Chrome OS
  • Google Cloud Connect
  • Google Contacts
  • Google Dictionary
  • Google Docs
  • Google Docs Viewer
  • google documents
  • google drive
  • Google Earth
  • Google Goggles
  • Google Hangouts
  • Google Instant
  • Google Keep
  • Google Latitude
  • Google Local
  • Google Maps
  • Google Music
  • Google News
  • Google Notebook
  • Google Now
  • Google Pack
  • Google Photos
  • Google Play
  • Google Plus
  • Google Reader
  • Google Sites
  • Google Suggest
  • Google Takeout
  • Google Talk
  • Google Toolbar
  • Google Translate
  • Google Trends
  • Google Voice
  • Google Wallet
  • Google+
  • googlenew
  • Greasemonkey
  • Guest Post
  • holiday
  • iGoogle
  • Image Search
  • images
  • InOut
  • iOS
  • Keep
  • Knowledge
  • mobile
  • OCR
  • offline
  • OneBox
  • paperless
  • pdfs
  • photo
  • photos
  • Picasa Web Albums
  • presentations
  • product ideas
  • profiles
  • quickoffice
  • Reddit
  • research
  • save to drive
  • scripts
  • Security
  • sharing
  • sheets
  • shortcut
  • slides
  • spell check
  • spreadsheets
  • stock photos
  • storage
  • students
  • tables
  • teachers
  • templates
  • Tips
  • User interface
  • videos
  • Viewer
  • Visualization
  • Voice Search
  • Web Search
  • Yahoo
  • YouTube

Blog Archive

  • ►  2013 (519)
    • ►  December (33)
    • ►  November (44)
    • ►  October (64)
    • ►  September (50)
    • ►  August (63)
    • ►  July (60)
    • ►  June (57)
    • ►  May (62)
    • ►  April (49)
    • ►  March (33)
    • ►  February (1)
    • ►  January (3)
  • ►  2012 (34)
    • ►  December (4)
    • ►  November (4)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (1)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (2)
    • ►  February (5)
  • ►  2011 (80)
    • ►  December (4)
    • ►  November (1)
    • ►  October (7)
    • ►  September (10)
    • ►  August (11)
    • ►  July (8)
    • ►  June (9)
    • ►  May (1)
    • ►  April (8)
    • ►  March (8)
    • ►  February (8)
    • ►  January (5)
  • ▼  2010 (118)
    • ►  December (11)
    • ►  November (16)
    • ►  October (6)
    • ►  September (13)
    • ►  August (13)
    • ►  July (7)
    • ►  June (15)
    • ►  May (11)
    • ►  April (7)
    • ►  March (7)
    • ▼  February (6)
      • Using Google Docs as a data mashup platform
      • Google Docs: the tool for the 21st century classroom
      • A web clipboard for Google Docs
      • Simple wedding planning with Google Docs
      • Save safely with new saving buttons
      • Free e-commerce catalogs managed with Google Docs
    • ►  January (6)
  • ►  2009 (82)
    • ►  December (14)
    • ►  November (4)
    • ►  October (10)
    • ►  September (10)
    • ►  August (4)
    • ►  July (6)
    • ►  June (6)
    • ►  May (5)
    • ►  April (4)
    • ►  March (8)
    • ►  February (7)
    • ►  January (4)
  • ►  2008 (97)
    • ►  December (6)
    • ►  November (4)
    • ►  October (6)
    • ►  September (8)
    • ►  August (5)
    • ►  July (7)
    • ►  June (11)
    • ►  May (20)
    • ►  April (13)
    • ►  March (6)
    • ►  February (6)
    • ►  January (5)
  • ►  2007 (25)
    • ►  December (1)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (3)
    • ►  July (4)
    • ►  June (3)
    • ►  May (2)
    • ►  April (2)
    • ►  March (1)
    • ►  February (2)
    • ►  January (1)
  • ►  2006 (10)
    • ►  December (2)
    • ►  November (4)
    • ►  October (4)
Powered by Blogger.

About Me

Unknown
View my complete profile