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

  • 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...
  • Hosting a viewing party for the OSCARS®
    Last year, I planned an OSCARS® viewing party with my friends. To add some friendly competition and figure out who was coming, I collected p...
  • Collaboration worldwide
    Posted by: Ken Norton, Product Manager, Google Docs & Spreadsheets Whether you're sitting in the same room, across campus, or in dif...
  • Summarize your data with pivot tables
    Starting today, we're rolling out pivot tables in Google spreadsheets. Pivot tables make it easy to process and summarize large data set...
  • The Google Docs for students page
    We recently launched the Google Docs for students page which highlights how various student populations can use Google Docs in their daily ...
  • Announcing your two most requested features: offline document editing and Drive for iOS
    In April, we introduced Google Drive, a place where you can create, share, and keep all your stuff. Today at the Google I/O conference we a...
  • Happy holidays from the Picasa team
    A lot of people who Google Docs also use Picasa Web Albums, so we wanted to let you know about a special offer. We made extra storage for Gm...
  • Dragging and dropping
    Posted by: Ken Norton, Product Manager, Google Docs & Spreadsheets Have you ever come across a link to a document on the web and wished ...
  • New Templates: Embedding spreadsheets in your website
    Did you know that you can publish a spreadsheet and embed it in your website or blog? An embedded spreadsheet is a perfect way to display a...
  • Upload and store your files in the cloud with Google Docs
    We're happy to announce that over the next few weeks we will be rolling out the ability to upload, store and organize any type of file i...

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