/
/
Enter a Shopify order in Dynamics GP without rekeying
For order entry and finance teams who want a Shopify order created as a Dynamics GP sales document, by asking their AI assistant.
On this page
Connector
Connect Shopify, pick your AI tool and paste the prompt.
The problem
Rekeying Shopify orders into GP invites duplicates
Rekeying a Shopify order into Dynamics GP means finding the customer, checking every SKU exists, applying discounts and freight and making sure it was not already entered. A duplicate or a missing line goes straight through to fulfilment and billing.
Without PopdockAI
- Check GP to see if the order was already entered
- Find the right customer by company or email
- Check every SKU exists as a GP item
- Retype lines, discounts and freight by hand
With PopdockAI
- Canceled orders and orders already in GP are stopped
- The customer is found through the B2B link or name and email
- Every SKU is checked as a GP item, and nothing is created for it
- You confirm the document, and the GP total is compared with Shopify
The prompt
Use this prompt
Copy it into any AI tool connected to PopdockAI. Swap the values in braces for your own.
**Objective:** Post the Shopify order `{order-name}` to Dynamics GP as a Sales Order Processing document in batch `{batch-number}` using the SOP document ID `{document-id}` (default STDORD).
**Step 1: Read the Shopify order**
Call `shopify-get-order` (Shopify server) with `name` = `{order-name}`. If it matches nothing or more than one, say so and stop. Stop if `cancelled-at` is set. Call `shopify-get-order-line` (Shopify server) with its `order-id` for `sku`, `quantity`, `price` and `total-discount`, and `shopify-get-order-shipping-line` (Shopify server) for the shipping charge.
**Step 2: Check it is not already in GP**
Call `dynamics-gp-get-rm-sales-trx` (Dynamics GP server) with `customer-po-number` = `{order-name}`, passing `company` = `{gp-company}` when it is given. If a document comes back, report its `sop-number` and stop.
**Step 3: Resolve the GP customer and items**
Call `shopify-get-company-contact` (Shopify server) with `customer-email` = the order `email`. If it returns a contact, call `shopify-get-company` (Shopify server) with its `company-id` and use the company's `external-id` as the GP customer ID. Otherwise look for a GP customer with `dynamics-gp-get-rm-customer` (Dynamics GP server) by `customer-name.contains`, and check that its `main-email-address` equals the order `email`. If no single customer is found, list the candidates and stop; do not create a customer from this prompt.
For each line, confirm the `sku` exists as a GP `item-number` with `dynamics-gp-get-iv-item` (Dynamics GP server). If any SKU is missing or empty, list them and stop.
**Step 4: Confirm**
Show the planned document: customer, date, PO number = `{order-name}`, each line (item, quantity, unit price after discount), freight, tax, and total. Ask the user for the SOP number to use (or confirm the one they gave). Wait for an explicit yes.
**Step 5: Write**
Call `dynamics-gp-rm-sales-trx-add` (Dynamics GP server) once, with `sop-type` = order, `sop-number`, `document-id` = `{document-id}`, `batch-number` = `{batch-number}`, `customer-id`, `document-date` = the order date, `customer-po-number` = `{order-name}`, `freight-amount` and `tax-amount`. Then call `dynamics-gp-rm-sales-line-item-add` (Dynamics GP server) once per order line with `sop-number`, `sop-type`, `customer-number`, `item-number`, `quantity` and `unit-price`.
**Step 6: Verify**
Re-read with `dynamics-gp-get-rm-sales-trx` and `dynamics-gp-get-rm-sales-line-item` (Dynamics GP server) and compare the GP total with the Shopify `total-price`. Report any difference.
**Rules & Guidelines:**
* Writes happen only on Dynamics GP, only after confirmation: `dynamics-gp-rm-sales-trx-add` once and `dynamics-gp-rm-sales-line-item-add` once per line.
* Do NOT call `dynamics-gp-rm-customer-add`, `dynamics-gp-iv-item-add`, `dynamics-gp-rm-sales-trx-update` or any Shopify write tool such as `shopify-update-order`.
**Validation:**
* If a line add fails, stop, report which lines were written and which were not, and give the `sop-number` so the user can finish or delete it in GP.
* Discounts are applied into the unit price; say so in the confirmation if the order has any.Who it's for
One answer, three teams that use it
Order processing
Enter web orders without rekeying
Post a Shopify order to GP in one message, with discounts folded into prices and freight included.
Post Shopify order #1988 to Dynamics GP as a sales order in batch WEB.
B2B account managers
Get wholesale orders into GP fast
Orders from linked B2B companies find the right GP customer, so they move to fulfilment without a hold.
Enter Shopify order #2051 from Contoso Ltd into Dynamics GP as an order in batch B2B.
Operations managers
Stop duplicates reaching the warehouse
Orders already in GP are stopped before anything is created, so nothing is picked or billed twice.
Check whether Shopify order #2099 is already in Dynamics GP, and post it as an invoice if not.
How it works
What PopdockAI does when you ask
You give the order, batch and document type, and your AI assistant checks for duplicates and resolves the customer and items. The sales document is created only after you confirm.
01
Ask
You give the Shopify order name, batch and document type.
02
Check
It stops on a canceled order or one already in Dynamics GP.
03
Resolve
It finds the GP customer and confirms every SKU is a GP item.
04
Create
You confirm the document, it creates it and compares the total with Shopify.
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-order
shopify-get-order-line
shopify-get-order-shipping-line
microsoft-dynamics-gp-get-rm-sales-trx
shopify-get-company-contact
shopify-get-company
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-iv-item
microsoft-dynamics-gp-rm-sales-trx-add
microsoft-dynamics-gp-rm-sales-line-item-add
microsoft-dynamics-gp-get-rm-sales-line-item
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
Each order in GP once, complete and checked
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)
