How to count how many of each product was ordered?

"how many of each item the group chose"- Google Docs Editors Community

This is a common question, and 72 people on Google's forum have asked it: once everyone has ordered on your Google Form, how many of each item is that? The Summary tab draws one chart per question, which doesn't add up quantities, and a formula in the response Sheet has to be written, copied down and fixed when a new row breaks it. A miscount means someone's order goes missing. Neartail's Sales by product report adds up every order on your form and shows how many of each product were ordered, ready to download as a PDF.

To get the count, import your Google Form and follow the steps below.

1. Import your Google Form

On the page that opens, paste your Google Form's link or click Browse to pick it, then click Import. Select your currency and click Continue. When it says "Your order form is ready", Neartail has made a product from each question with a price and added an order total and summary. If it says no products were found, add a price to any question. Click Preview your form, then click Edit form under Manage to open the form builder.
The Neartail page to import a Google Form, with a form link pasted in and the link box and the Import button marked

2. Send the link to your group

In your form, click SHARE, click Link, click Copy and send the link to the people ordering. Each person opens it and orders what they want.
The Share tab of Team lunch order with the form link and the Copy button marked

3. Open Sales by product

When everyone has ordered, click ORDERS, then Sales by product. The report opens on the year, with an arrow on each side of it.
The Orders tab of Team lunch order, with ORDERS, the Sales by product tab and the year 2026 marked

4. Read how many of each were ordered

SUM of Quantity sold is your count. To send it on to whoever prepares the order, click the ⋮ and choose Download as PDF.
The Sales by product table with the SUM of Quantity sold column marked: Chicken wrap 4, Veggie wrap 2, Garden salad 2 and 8 in all

Summary

Google Forms charts each question but doesn't count how many of each product were ordered across everyone's orders. With Neartail, Sales by product adds up every order and gives you that count, ready to download. Import your Google Form and complete the steps above.

Count how many of each product was ordered on your form.

Import the Google Form everyone orders from, then open Sales by product under ORDERS to see how many of each product were ordered, ready to download as a PDF.

Last updated: