A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | # | orderId | total | createdAt | uid | tel | address | transactionId | transactionData | count | subtotal | discountTotal | discountData | items | note | status | ||
2 | 1 | -L_t7mj6VLuN5EdxS-5Jt92rlnR | 9.1 | 2019-03-13T22:19:01.960Z | 1LXPDE2qW_2s6nE3eAihfu2rEkWs | user@sheetbase.net | 397526004 | Thuan My, Chau Thanh, Long An | 2 | 19.1 | 10 | {"AUTO":{"identity":"Happy new year","type":"AUTO","value":10,"description":"An auto discount."}} | {"product-2":{"qty":2,"timestamp":1552515523329,"product":{"#":2,"slug":"product-2","title":"Product 2","sku":"P002","price":5.3,"unit":"kg","thumbnail":"https://placeimg.com/300/300/tech"}},"product-3":{"qty":5,"timestamp":1552515528687,"product":{"#":3,"slug":"product-3","title":"Product 3","sku":"P003","price":1.7,"unit":"lt","thumbnail":"https://placeimg.com/300/300/nature"}}} | archived | ||||
3 | 2 | -L_t9BwVjBwnT6eUSM-ivnIZnm4 | 23.3 | 2019-03-13T22:25:11.456Z | 1LXPDE2qW_2s6nE3eAihfu2rEkWs | user@sheetbase.net | 397526004 | Thuan My, Chau Thanh, Long An | 2 | 25.3 | 2 | {"CODE":{"identity":"GOOD","type":"CODE","value":2,"description":"It's good, isn't it?"}} | {"product-2":{"qty":1,"timestamp":1552515835573,"product":{"#":2,"slug":"product-2","title":"Product 2","sku":"P002","price":5.3,"unit":"kg","thumbnail":"https://placeimg.com/300/300/tech"}},"product-1":{"qty":2,"timestamp":1552515848301,"product":{"#":1,"slug":"product-1","title":"Product 1","sku":"P001","price":10,"unit":"pc","thumbnail":"https://placeimg.com/300/300/animals"}}} | This is a note! | archived | |||
4 | 3 | -L_tBb9qDcKr3zK_35QgDHkj63O | 44.19 | 2019-03-13T22:35:43.158Z | 1LXPDE2qW_2s6nE3eAihfu2rEkWs | user@sheetbase.net | 397526004 | Thuan My, Chau Thanh, Long An | 3 | 49.1 | 4.91 | {"CODE":{"identity":"LOVE","type":"CODE","value":0.1,"description":"Love ya!"}} | {"product-1":{"qty":3,"timestamp":1552516515930,"product":{"#":1,"slug":"product-1","title":"Product 1","sku":"P001","price":10,"unit":"pc","thumbnail":"https://placeimg.com/300/300/animals"}},"product-2":{"qty":2,"timestamp":1552516514816,"product":{"#":2,"slug":"product-2","title":"Product 2","sku":"P002","price":5.3,"unit":"kg","thumbnail":"https://placeimg.com/300/300/tech"}},"product-3":{"qty":5,"timestamp":1552516517248,"product":{"#":3,"slug":"product-3","title":"Product 3","sku":"P003","price":1.7,"unit":"lt","thumbnail":"https://placeimg.com/300/300/nature"}}} | new | ||||
5 | 4 | -L_tEiEaHrBUUeC4gqNNvv-WTTa | 9.4 | 2019-03-13T22:49:18.566Z | 1L_tEZKh1FBbDLPaIXjzZXt6YaW0 | lamnhan92@gmail.com | 397526004 | Thuan My, Chau Thanh, Long An | 2 | 24.4 | 15 | {"AUTO":{"identity":"Happy new year","type":"AUTO","value":10,"description":"An auto discount."},"CUSTOM_1":{"identity":"New user","type":"CUSTOM_1","value":5,"description":"Welcome friend."}} | {"product-2":{"qty":3,"timestamp":1552517336516,"product":{"#":2,"slug":"product-2","title":"Product 2","sku":"P002","price":5.3,"unit":"kg","thumbnail":"https://placeimg.com/300/300/tech"},"$key":"product-2"},"product-3":{"qty":5,"timestamp":1552517352591,"product":{"#":3,"slug":"product-3","title":"Product 3","sku":"P003","price":1.7,"unit":"lt","thumbnail":"https://placeimg.com/300/300/nature"},"$key":"product-3"}} | archived | ||||
6 | 5 | -L_wZulwUtatDYfesPesUHDvt6K | 19.6 | 2019-03-14T14:20:46.589Z | 1L_tEZKh1FBbDLPaIXjzZXt6YaW0 | user@sheetbase.net | 123456789 | 2 | 34.6 | 15 | {"AUTO":{"identity":"Happy new year","type":"AUTO","value":10,"description":"An auto discount."},"CUSTOM_1":{"identity":"New user","type":"CUSTOM_1","value":5,"description":"Welcome friend."}} | {"product-3":{"qty":11,"timestamp":1552573214570,"product":{"#":3,"slug":"product-3","title":"Product 3","sku":"P003","price":1.7,"unit":"lt","thumbnail":"https://placeimg.com/300/300/nature"}},"product-2":{"qty":3,"timestamp":1552573203517,"product":{"#":2,"slug":"product-2","title":"Product 2","sku":"P002","price":5.3,"unit":"kg","thumbnail":"https://placeimg.com/300/300/tech"}}} | new |