Connectors

/

Shopify

/

Post a Shopify order to Dynamics GP
Write
Cross-Connector

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.

Try PopdockAI free
Get a live demo
Post a Shopify order to Dynamics GP
Post Shopify order #1042 to Dynamics GP as a sales order in batch SHOPIFY.
Order #1042 is not in Dynamics GP yet, and every SKU is a GP item. - Customer: CONTOSO0001, Contoso Ltd - Lines: 3 items, discounts folded into prices - Freight: 12.00 - Total: 482.40 Shall I create the sales order?
Shopify
Sample figures. Your results come from your own account.
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

On this page

The problem

The problem

The prompt

Who it's for

How it works

Tools used

Connector

Shopify

Shopify
Run it on your own Shopify data.

Connect Shopify, pick your AI tool and paste the prompt.

Try PopdockAI free

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.

Prompt
**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.

Your AI tool

02

Check

It stops on a canceled order or one already in Dynamics GP.

shopify-get-order
microsoft-dynamics-gp-get-rm-sales-trx

03

Resolve

It finds the GP customer and confirms every SKU is a GP item.

shopify-get-order-line
shopify-get-order-shipping-line
shopify-get-company
shopify-get-company-contact
microsoft-dynamics-gp-get-rm-customer
microsoft-dynamics-gp-get-iv-item

04

Create

You confirm the document, it creates it and compares the total with Shopify.

Your AI tool

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.

get-data

shopify-get-order

Returns Shopify orders with their financial status, fulfillment status and total. Filter by order number or name, customer, email, financial status, fulfillment status, created date and total price.
get-data

shopify-get-order-line

Returns the line items on Shopify orders with their price, quantity and fulfillment status. Filter by order, product, SKU, title, vendor, price and quantity.
get-data

shopify-get-order-shipping-line

Returns the shipping charges on Shopify orders, with the method title, code, source and amount. Filter by order, title, code, source and amount.
get-data

microsoft-dynamics-gp-get-rm-sales-trx

Returns Sales Order Processing documents such as quotes, orders and invoices from Dynamics GP Sales, with the customer, dates, salesperson and document totals. Filter by batch number, customer ID, SOP type, SOP number, salesperson ID, document amount, customer name and document date, and pick the company and the maximum number of records.
get-data

shopify-get-company-contact

Returns the contacts of Shopify B2B companies. Filter by company, contact name, email, job title and whether they are the main contact.
get-data

shopify-get-company

Returns Shopify B2B companies with their order count and total spent. Filter by name, company id, external id, customer since date, order count and total spent.
get-data

microsoft-dynamics-gp-get-rm-customer

Returns customer records from Dynamics GP Receivables Management, including contact details, class, terms and balances. Filter by salesperson ID, hold, customer name, state, zip, customer balance, customer class and city, and pick the company and the maximum number of records.
get-data

microsoft-dynamics-gp-get-iv-item

Returns inventory item records from Dynamics GP Inventory, including item type, class, costs, units of measure and valuation settings. Filter by item class code, item description, current cost, item number, abc code, item short name, valuation method and item tracking option, and pick the company and the maximum number of records.
run-action

microsoft-dynamics-gp-rm-sales-trx-add

Adds a sales transaction in Dynamics GP through eConnect; GP defaults any field not listed. Requires batch number, document ID, document date, SOP type, SOP number and customer ID. Optional: subtotal, salesperson ID, shipping method, location code, customer PO number and freight amount. Writes to the live Dynamics GP company database.
run-action

microsoft-dynamics-gp-rm-sales-line-item-add

Adds a sales transaction line in Dynamics GP through eConnect; GP defaults any field not listed. Requires SOP number, item number, SOP type and customer number. Optional: document ID, requested ship date, site ID, item description, unit of measure and unit price. Writes to the live Dynamics GP company database.
get-data

microsoft-dynamics-gp-get-rm-sales-line-item

Returns sales document lines from Dynamics GP Sales Order Processing, with the customer, item, quantity, prices and costs of each line. Filter by location code, SOP type, item number, SOP number, customer name, customer ID, item description and extended price, and pick the company and the maximum number of records.
Read only.Nothing in Shopify Changes

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.

How Popdock AI secures your data

The outcome

Each order in GP once, complete and checked

Try PopdockAI free
Get a live demo

Related use cases

More ways to put this data to work

All Ramp use cases

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.

Try PopdockAI Free
See Documentation