Skip to content
Hypamoon

For teams that run on TOConline

TOConline sales report by product family

TOConline has sales reports per customer and per product, with a download to Excel. Sales grouped by product family, compared with the same month last year, is put together in a spreadsheet after that.

How it goes today

  1. Run the sales by product report for last month.
  2. Download it to Excel and add the family of each product.
  3. Do the same for the month a year earlier.
  4. Build a pivot table and send it on.

How it can go

See each month which product families sell, next to last year.

On the second day of each month a report with net sales per product family for last month, next to the same month last year, with the top products and customers in each family. Credit notes are taken off. It goes by email to you and whoever you name.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. TOConline works with a sign-in instead of a key: you sign in to TOConline once to give access, never in the chat.

Your request

With Hypamoon, on the second day of each month, take last month's sales lines from TOConline and group them by product family. Show net sales per family next to the same month last year, with the five biggest products and customers in each family, and take credit notes off. Email the report to me and our sales lead.

You set up the access yourself in TOConline under Empresa, Configurações, Dados API, and sign in once. It stays yours.