Re:Ask HN: What project are you currently working on?
by collyw on Wednesday July 15, 2015 @02:13PM
(#9893024)
Excel as a back end sound like a terrible idea to me. Any reason why?
Re:Ask HN: What project are you currently working on?
by periram on Thursday July 16, 2015 @12:38PM
(#9898279)
Most of the clients are very used to an "Excel" like interact for their backend. I am not using excel per se, but using excel to manipulate data and seamlessly push the changes to e-commerce.
So the user uses google docs and all its rich UI to manipulate data very quickly and with the click of a button (inside google spreadsheet) the data gets pushed to the ecommerce (after validation). The status of each update is then pushed back to the spreadshet.
The goal here is to let users use their familiar UI for managing their e-commerce backend.
It was my mistake to say that I am using excel as the backend. The correct phrase is that I am using the google spreadsheet as the data manipulation UI for ecommerce and then sync-ing it to the ecommerce backend.
Re:Ask HN: What project are you currently working on?
by replete on Wednesday July 15, 2015 @02:51PM
(#9893249)
Checkout Google FusionTables, pretty much the same idea.
Re:Ask HN: What project are you currently working on?
by periram on Thursday July 16, 2015 @12:39PM
(#9898289)
FusionTables looks awesome.
I am currently using a simple ETL wrapper for google spreadsheets and it seems to be more than enough to do the sync for limited amount of data.
This is perhaps what I need to scale it to larger data sets.
Again, I deally I will use the underlying db for e-commerce as well, so that there is only one data model.
I have built the features for magento for managing products, categories, images, mapping from simple to configurable products, configurable attributes etc. It works well for up to 10K skus.
Looking to expand it to shopify and other ecommerce backends. It would be great to run the ecommerce right out of the spreadsheet (cahced of course) instead of having another copy.