How create bulk website with amount, total, and checkout fields?
I have google sheet with rows like Name, Price. I would like to create website with folowing things:
- Website automaticly sync with google spreadsheet and update Name, Price
- In website any user can check this table, input numbers in Amount row.
3.SubTotal row for each Name will automaticly calculate, according to Amount. SubTotal=Price*Amount
- Button, which can place user's order with all names, prices, amounts and calculations info which user choose.
- Total will automaticly calculate sum of all SubTotal values.
I don't need page for each product, which I want to sell, I want it all in one table. Is it possible? Any ideas how can I do something like this? Thank you.