3 ms·
I am working on using google spreadsheet / excel as the backed for e-commerce. I have built the features for magento for managing products, categories, images
by periram 11y ago
I am working on using google spreadsheet / excel as the backed for e-commerce.
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.
- collyw 11y agoExcel as a back end sound like a terrible idea to me. Any reason why?
- periram 11y agoMost 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.
- replete 11y agoCheckout Google FusionTables, pretty much the same idea.
- periram 11y agoFusionTables 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.