/
/
Check every Wave product has an AvaTax item and tax code
For operations teams who want to find sold products with no tax mapping before tax goes wrong, just by asking their AI assistant.
On this page
Connector
Connect Wave, pick your AI tool and paste the prompt.
The problem
Products with no tax code surface too late
Products sold in Wave may have no item or tax code in Avalara AvaTax, and nobody notices until tax is wrong. Checking means finding each item and then confirming its tax code is set and active.
Without PopdockAI
- Export the sold products from Wave
- Search AvaTax for each item
- Look up each tax code to see if it is active
- Work out by hand which products to fix first
With PopdockAI
- Sold, unarchived products are read from Wave
- Each is matched to an AvaTax item and tax code
- Missing items, missing codes and inactive codes are flagged
- Description only matches are marked possible
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** For Wave products that are sold and not archived (filtered by `{name-contains}` when given), find the matching item in Avalara AvaTax and report which products have no item or no tax code.
**Step 1: Read products from Wave**
Call `wave-get-product` (Wave server) with `is-sold` true, `is-archived` false and, when given, `name.contains`. Keep name, description, unit-price and income-account-name.
**Step 2: Find the AvaTax item**
For each product call `avalara-avatax-get-item` (Avalara AvaTax server) with `item-code` equal to the Wave product name. If nothing matches, retry with `description.contains` set to the product name. Keep item-code, tax-code and item-group.
**Step 3: Describe the tax codes**
For each distinct tax-code found, call `avalara-avatax-get-tax-code` (Avalara AvaTax server) with `tax-code` to get its description and whether it is active.
**Step 4: Report**
A table with Wave product, unit-price, AvaTax item-code, tax-code, tax-code description and status (mapped, item without tax code, tax code inactive, no AvaTax item). End with counts and the products to fix first, highest unit-price first.
**Rules & Guidelines:**
* Wave tools start with wave-, Avalara AvaTax tools with avalara-avatax-. Both servers must be connected.
* Read-only. Do not call `avalara-avatax-item-add`, `avalara-avatax-item-update`, `avalara-avatax-item-delete`, or any Wave add, update or archive tool.
**Validation:**
* If Wave returns no products, say so and stop.
* A description match that is not an exact name match is reported as "possible match" only.Who it's for
One answer, three teams that use it
Operations managers
Know which products are not set up
See which sold products have no AvaTax item, so they can be set up before more sales go through.
Which Wave products that we sell have no item in Avalara AvaTax?
Tax accountants
Catch inactive tax codes
Find products whose tax code is no longer active, with the code description beside each one.
Check Wave products with Training in the name and tell me if any AvaTax tax codes are inactive.
Catalog managers
Keep the catalog consistent
Compare the product list with the tax items so every product sold is mapped the same way in both systems.
Show me a table of our Wave products with their AvaTax item code and tax code, with the unmapped ones first.
How it works
What PopdockAI does when you ask
You ask, and your AI assistant checks each sold Wave product in Avalara AvaTax. It only reads, and lists the products to fix first by unit price.
Ask
You optionally give part of a product name.
Match
It reads sold Wave products, finds each AvaTax item, then checks each tax code and whether it is active.
Report
You get a table of each product's status, counts and the products to fix first.
What PopdockAI provides
The tools behind the answer
Ready made tools for Wave and one secure connection to your AI tool. No code, no exports.
wave-get-product
avalara-avatax-get-item
avalara-avatax-get-tax-code
This report is built from Get data tools only. PopdockAI applies the row, field and parameter rules your admin sets, and every query is written to the audit trail.
The outcome
Tax mapping gaps found before they cost you
Related use cases
More ways to put this data to work
One prompt template with infinite possibilities.
Your AI assistant adapts its approach, tone, and capabilities to match each unique context while you maintain a single, manageable workflow.
Join forward-thinking companies that are transforming their operations with intelligent, secure AI automation.

.webp)
