[USEFUL] Simple classifieds engine with google sheet database backend [CODE]
If you want to post a classified (ads, some lots to sell, etc.) on your website fast and easy, or if you're having to post a lot of them, google sheets can help. Just add this code to your server and you're ready to go.
Technology stack and dependencies of the project
- [Physical] Ubuntu Server with LAMP
- This repository
- Handlebars.js (included in /js)
- TableTop.js (included in /js)
- jQuery (included in /js)
- Google Sheets table with db structure like below
Database structure
| timestamp | name | desc | price | date_from | date_to | condition | picture_url | yandex_money | btc | ltc | eth |
|---|
The rows are lots (sale items).
Required fields: name, price, email
Automatically given: timestamp
Optional fields:
- desc - description
- date_from - date to start publishing an add/classified (for scheduling purposes)
- date_to - date to hide the add/classified
- condition - lot condition (working / broken / unknown)
- picture_url - link to lot image
- yandex_money - yandex.money wallet
- btc - BTC wallet
- ltc - LTC wallet
- eth - ETH wallet
Example screenshot
Project presentation (in Russian)
- https://docs.google.com/presentation/d/1zzrE7dnpU0The2fRIoAqnYidcbumPj6UxriMQI-lsow/edit?usp=sharing
Installation
git clone https://github.com/sxiii/oldhack
Example project
ToDo / Help needed & RoadMap
- Implement registration and ads editing
- Implement a working Cryptocompare API to calculate price for ads
- Clean javascript libraries, maybe rewrite everything
Tested web browsers
Repository
GitHub Account
Hope this project will be useful for you. Please feel free to ask, test, comment, and contribute.
Cheers :),
Den Ivanov aka @sxiii from Random City
Thank you for your contribution. In the current state, it seems like a small project where you are just displaying the data from the excel to a website, but RoadMap looks great. One thing is that you can move the hard-coded excel file location to some configuration file.
Your contribution has been evaluated according to Utopian policies and guidelines, as well as a predefined set of questions pertaining to the category.
To view those questions and the relevant answers related to your post, click here.
Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]
Thank you for your review, @codingdefined! Keep up the good work!
Hi @sxiii!
Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your post is eligible for our upvote, thanks to our collaboration with @utopian-io!
Feel free to join our @steem-ua Discord server
Hey, @sxiii!
Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!
Get higher incentives and support Utopian.io!
Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via SteemPlus or Steeditor).
Want to chat? Join us on Discord https://discord.gg/h52nFrV.
Vote for Utopian Witness!