Chronos eCommerce

eCommerce with Google Sheets and NextJS

Chronos eCommerce

Simple eCommerce platform using Google Sheets as backend and NextJS for frontend, enabling indie artists to sell products online with minimal third-party fees

Platform

  • NextJS
  • Google Sheets

Year

  • 2023

Industry

  • eCommerce
  • Art & Merchandise

❓ Unmet needs

An indie artist approached us with the requirement to setup an eCommerce Store to sell her products online. They dominantly operated out of Instagram and were looking for a solution to sell art and merchandise online.

🏹 Objectives

A simple eCommerce Store, where products could be sold directly to customers with minimal third party fees. The products and orders should be easily manageable.

🖼 Products

From doodles to watercolours to digital art in premium stationery, the artist dealt with the following range of products:

  • Notebooks
  • Calendars
  • Postcards
  • Stickers

🗺 Solution

Google Sheet Backend

Google Sheets for Products - Chronos by Coffee

  1. For Products: To easily manage products, a Google sheet was setup as the backend with a list of products and the following information:
    1. id
    2. name
    3. image
    4. description
    5. price
    6. manufacturer
    7. type
    8. quantity
    9. weight
    10. size
    11. images
  2. For Orders: A sheet to capture orders with the following information:
    1. order_no
    2. items
    3. name
    4. address
    5. phone_number
    6. email
    7. bill_amount
    8. order_date
    9. payment_status
    10. order_status

NextJS Frontend

The Google Sheets were integrated to a frontend website built in Next JS. Next JS, being a production grade framework for ReactJS, allowed to leveraged the server side rendering and dynamic component structure. We were able to create a simple and elegant eCommerce site with support for:

  • Product listing
  • Search
  • Cart
  • Checkout
  • Pages like FAQ and Terms
  • Photo Gallery

Chronos Frontend

📈 Impact

  • 50+ products catalogued and managed.
  • Order tracking and shipping made easy.
  • 500+ products shipped
  • 5000+ people reached.

Give a life to your ideas with our innovative solutions.