Community
The issue we have concerns sheet *“ORDER DETAILS”*, some of the names of our products are not being downloaded correctly into the Google Sheet. The new name we gave in the form for the products (fruit & veggies) are not updating in the Google sheet. For some reason, the names in column E and F are correct, then *they are not correct in column G to AK*. And then we have what looks like correct names again.
To help you check faster: *all our product names for vegetable and fruit have their country of origin into brackets* (ie: (Thailand), (Australia), etc)) *included in their name*. If one sees the name of a fruit or vegetable on row 1 that does not have the country of origin, then it means the name is not the one we edited in the form.
As a consequence, the macros we are developing for the Google sheet are not working as the names are not matching.
Comments (1)
Aug 22, 2024
Hi Ruchi, we already discussed this on email. When you export the data from Neartail Reports, it will 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. If you add new products in the form, it will be added at the end in the Order Details sheet. If you update the product name, it will not be updated in the Order Details sheet currently. We plan to implement this option in the coming releases. In the meantime, you can use Neartail Reports or use a pivot table option on the Order lineitems sheet that will have current product name.
Add your comment
Add photo