need free text in the quantity field. If we choose variant, I can add text in the variant place but on google sheet it comes as text with a long number digits. How do I get the text on the sheet without the long text please
When using Neartail with products that have variants, the unique identifier for each variant will always be recorded alongside the variant name in Google Sheets linked with Google Forms. Unfortunately, you cannot remove this unique identifier as it is necessary for tracking orders and inventory.
If you need the variant name without the long number, you can view the orders in Neartail Reports or export the data from Neartail Reports to Google Sheets. Login to Neartail > click on the form to open it > Edit page will be displayed > click Reports > in the Reports page, click on the settings gear icon > click Sync all responses. Please note that this is not a real time sync; the responses will be synced only when you click on the sync option in the Reports page.
When you sync the responses in Neartail 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.
Comments (1)
Sep 2, 2025
When using Neartail with products that have variants, the unique identifier for each variant will always be recorded alongside the variant name in Google Sheets linked with Google Forms. Unfortunately, you cannot remove this unique identifier as it is necessary for tracking orders and inventory. If you need the variant name without the long number, you can view the orders in Neartail Reports or export the data from Neartail Reports to Google Sheets. Login to Neartail > click on the form to open it > Edit page will be displayed > click Reports > in the Reports page, click on the settings gear icon > click Sync all responses. Please note that this is not a real time sync; the responses will be synced only when you click on the sync option in the Reports page. When you sync the responses in Neartail 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