Community
hi suporter, im trying to set price for my Variants, everything looks good, but when i check the data in my sheets, i got data like this format : my_variants | 1717842021776 * 1
I dont need suffix 1717842021776 * 1 so please let me know how to remove it from my form.
i tried change the answers type to multichoice , data is oke but it not auto calculator the order amount anymore.
so can you tell me did i miss anything.
so much thanks !
Comments (1)
Jun 9, 2024
When you add a product with variants, Neartail generates a unique id for each variant so that it can track the orders and the inventory. This unique id will be recorded in Google Forms and the linked Google Sheets. It cannot be removed. If you used the Neartail templates to create your order form, then you can sync the data to google sheets. Login to Neartail > click on the form to open it > Edit page will be displayed > click Reports > click on the Export button in the bottom right corner. The unique id will not be included in this sheet. When you sync the Neartail reports to Google Sheets, we create three sheets. (1) Order summary: This includes the customer contact details, amount and other fields in the form. (2) Order lineitems: This includes the order lineitems data. You can use the pivot table option on this sheet to create the aggregate reports you need. (3) Order details: This includes the quantity ordered for the products in each order. Each product will be added as a column. For products with variants, each variant will be a separate column.
Add your comment
Add photo