/
/
Check Shopify stock value against the Rillet balance
For finance teams who want Shopify on-hand inventory valued at cost and compared with the Rillet balance sheet, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
The inventory balance never quite matches the shelves
The inventory balance in Rillet should roughly match what is on the shelves in Shopify, but valuing stock means multiplying every tracked item by its cost across locations. Items with no cost and oversold stock distort the total, and differences go unexplained at month end.
Without PopdockAI
- Export Shopify inventory by location
- Multiply every tracked item by its cost
- Work around items with no cost and oversold stock
- Explain the gap to the ledger at month end
With PopdockAI
- Tracked on-hand stock is valued at cost by location and in total
- Items with no cost are counted and listed
- Oversold items are kept out of the total
- The Rillet balance is compared, with any adjustment described, not posted
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Value Shopify's current on-hand inventory at cost and compare it with the Rillet balance sheet inventory line matching `{inventory-line}` (default Inventory) as of `{as-of-date}` (default today).
**Step 1: Value the Shopify inventory**
Call `shopify-get-inventory-level` filtered by tracked set to true. For each row note location-id, sku, inventory-item-id, available and cost. Page with max-records if needed.
* Value each row as available times cost.
* Rows with no cost cannot be valued. Count them and list the skus.
* Rows with available below 0 are oversold. Leave them out of the total and list them.
Call `shopify-get-location` to turn location-id into names. Total the value by location and overall.
**Step 2: Read the Rillet balance**
Call `rillet-get-balance-sheet-lines` with as-of-date `{as-of-date}` and line-item.contains `{inventory-line}`. If more than one line matches, show each and total them. If none matches, list the balance sheet line items in the asset section so the user can pick the right one, and stop.
**Step 3: Report**
* Shopify value by location, and in total, with the currency.
* The Rillet line items and their amount.
* The difference, and the difference as a percentage of the Rillet balance.
* Items with no cost: count and skus, the first 20.
* Oversold items: sku, location, available.
State plainly that Shopify gives only today's on-hand quantity, so a past `{as-of-date}` compares today's stock with a past balance. State also that Shopify cost is the current unit cost, not the cost layers the ledger used.
**Rules & Guidelines:**
* `shopify-get-inventory-level` and `shopify-get-location` are on the shopify server. `rillet-get-balance-sheet-lines` is on the rillet server.
* This prompt is read-only. Do not call `rillet-add-journal-entry`, `rillet-update-journal-entry`, `shopify-add-inventory-level` or any other write tool. If an adjustment looks necessary, say what it would be and leave posting it to the user.
**Validation:**
* If Shopify returns no tracked inventory, say so and stop.
* If the Shopify currency differs from the Rillet report-currency, show both totals and do not convert.Who it's for
One answer, three teams that use it
Controllers
Explain the inventory balance at close
See the difference in amount and percent, with the items that cause it already listed.
Compare Shopify stock at cost with the Rillet Inventory line at 31 October.
Cost accountants
Find items valued at nothing
Items with no cost are listed, so you can fix the costs that distort the valuation.
Value our Shopify inventory by location and list the items with no cost.
Inventory managers
See stock value by location
Location totals show where the value sits, and oversold items are kept out so they do not muddy the picture.
What is our Shopify stock worth at cost in each location, and how does it compare with Rillet?
How it works
What PopdockAI does when you ask
You give the balance sheet line and a date, and your AI assistant values Shopify stock and compares it with Rillet. It states plainly that Shopify only gives today's stock at current cost.
01
Ask
You give the balance sheet line and an as-of date.
02
Value
It values tracked Shopify on-hand stock at cost by location.
03
Compare
It reads the Rillet balance and shows the difference in amount and percent.
04
Report
You get totals, items with no cost and oversold items kept out.
What PopdockAI provides
The tools behind the answer
Ready made tools for Shopify and one secure connection to your AI tool. No code, no exports.
shopify-get-inventory-level
shopify-get-location
rillet-get-balance-sheet-lines
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
The gap to the ledger, with the items behind it
Related use cases
More ways to put this data to work
Apply Shopify payments to Rillet invoices
Ask your AI to apply Shopify payments in Rillet and it matches each capture to its invoice, sorts out the problem cases and posts only the ready ones after you confirm.
Learn More
Backfill Shopify orders into Rillet
Ask your AI to backfill Shopify orders into Rillet and it finds orders with no invoice, matches customers by email and creates receivable invoices after you confirm.
Learn More
Book Shopify refunds as Rillet credit memos
Ask your AI to book Shopify refunds in Rillet and it matches each to its invoice, skips any already booked, and creates and applies credit memos after you confirm.
Learn More
Reconcile Shopify B2B companies with Rillet customers
Ask your AI to match Shopify B2B companies to Rillet customers and it applies ordered rules, lists matched, probable and one-sided records, and changes nothing.
Learn More
Reconcile Shopify orders with Rillet invoices
Ask your AI to reconcile Shopify orders with Rillet and it matches by order name and gives four tables: missing, mismatched, canceled but open, and invoices with no order.
Learn More
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.