I have connected Microsoft Dynamics 365 Business Central with Shopify.

Hi @uncap 

Thank you for reaching out and for providing the details of your Business Central–Shopify integration issue. 

I’ve reviewed the behavior you’re experiencing and identified two separate factors influencing the synchronization. Below is a summary of my findings along with recommended next steps. 

Step 1: Shopify product price syncing as 0 

1/ Business Central does not send the item Unit Price directly to Shopify. Instead, it calculates the Shopify price by creating a temporary sales document with quantity = 1, using standard pricing logic based on: 

• Item Unit Price 
• Customer Template 
• Customer Price Group / Customer Discount Group 
• Posting Groups and Currency 

2/ If any of these elements are missing or misconfigured, the calculated price becomes 0, which is what Shopify displays. Here are some recommended checks in Business Central: 

• Ensure each item has a non‑zero Unit Price 
• Open the Shopify Shop Card and confirm a Customer Template Code is assigned 
• Verify the customer template includes a valid Gen. Bus. Posting Group 
• Confirm any price or discount setup applies to quantity = 1 
• If using Shopify B2B catalogs, ensure Sync Prices is enabled and the correct pricing groups are assigned 

You may find further guidance here: Troubleshooting the Shopify and Business Central synchronization 

Step 2: Error: “The Customer does not exist. Identification fields and values: No.='’” 

1/ This error indicates that during synchronization, Business Central attempted to reference or create a customer, but the customer number was empty. This typically happens when: 

• The Customer Template Code is missing or invalid 
• Required posting groups are not set on the template 
• Automatic customer creation fails due to missing setup 

2/ Recommended actions: 

On the Shopify Shop Card, confirm: 

• Auto Create Unknown Customers is enabled 
• A valid Customer Template Code is assigned  Ensure the customer template contains all required posting groups 

Run the sync again in the foreground and review any error or skipped record messages 

To learn more, please visit: 

• What's new in Shopify Connector: Troubleshoot synchronization 
• Shopify Connector for Dynamics 365 Business Central: Integration Guide in 6 Easy Steps 
• Shopify Integration with Dynamics 365 Business Central 

Please note that this information is shared solely for your convenience. The referenced sites are not managed or maintained by independent advisors, and therefore I cannot guarantee the accuracy, security, or suitability of any software or content available on those sites. I recommend reviewing all information carefully and ensuring you fully understand any potential risks before following suggestions from the provided links. 

Once the above configuration items are corrected: 

1. Run the sync in the foreground 
2. Confirm pricing in Business Central calculates correctly 
3. Re‑sync prices to Shopify 

This should resolve both the zero‑price issue and the customer error. 

Note: Please understand that my initial response does not always resolve the issue immediately. However, with your help and more detailed information, we can work together to find a solution.  

I hope this information is useful. Additionally, as other users have raised similar concerns and may not be aware of where to share their feedback, I hope this response helps clarify the situation and suggests a potential next step. Highlighting this information can make it more visible to others in the community who may be facing the same issue, making it easier for them to find guidance and contribute their feedback as well. 

Thank you again for your time and for raising this important usability concern. If you have any further questions or need additional assistance, please don’t hesitate to reach out. 

I look forward to your thoughts on this. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".      

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.  

Two separate things are happening: price calculation is resulting in 0, and at least one document refers to a customer that does not exist in Shopify.

1. Fixing price sync showing 0 in Shopify

Business Central calculates Shopify prices by creating a temporary sales quote for quantity 1 and applying standard price/discount logic. The connector then sends both:

• Price (final customer price), and
• Compare at price (price without discount; if this is less than or equal to Price, it is sent as 0/null).

Key points from the connector behavior:

• Only prices and discounts valid for quantity = 1 are used.
• The price is calculated from item Unit Price, Customer Price Group, Customer Discount Group, and Currency Code.
• The connector only updates Shopify if the calculated price in Business Central is different from the last price already stored in Shopify.

Actions to take in Business Central:

1. Open Shopify Products and run Sync Prices to Shopify in the foreground (disable “Run Syncs in Background” on the Shopify Shop Card first). If an error occurs, use Copy details to get the AL call stack and error details.
2. On the Shopify Shop Card, verify:
   • Customer Template Code is set and that template has a valid Gen. Bus. Posting Group (needed for price calculation).
   • Any Customer Price Group / Customer Discount Group used for Shopify pricing are correctly configured and active.
3. For B2B/catalog pricing (if used):
   • Open Shopify Catalogs / Shopify B2B Catalogs.
   • Ensure the relevant catalog has Sync Prices enabled and the correct Customer Price Group and Customer Discount Group set.
4. Check the item itself:
   • Confirm Unit Price is not 0.
   • Confirm any price/discount setup for the customer or price group is correct for quantity 1.

If the calculated “price without discount” is less than or equal to the final price, the connector will send 0 for Compare at price by design; this is not an error. If Shopify is showing the main price as 0, focus on the Business Central price setup and the customer/template used for price calculation.

2. Resolving “The Customer does not exist. Identification fields and values: No.=''”

This error is consistent with the connector’s export rules for posted sales invoices and customers:

• A posted sales invoice is skipped if the Customer doesn’t exist in Shopify.
• A customer is skipped if required data (like email) is missing or duplicates exist.

Steps to troubleshoot:

1. Open Shopify Skipped Records in Business Central.
   • Review entries for Customer and Posted sales invoice.
   • Check the Reason column for why each record was skipped (for example, “Customer doesn’t exist in Shopify” or “Customer has an empty email”).
2. For customers referenced by invoices or price calculations:
   • Ensure the customer exists in Shopify (either created manually in Shopify or exported from Business Central).
   • Ensure the customer has a valid email and no conflicting duplicate email/phone.
3. For posted sales invoices:
   • Confirm the Customer No. on the invoice is not the default Shopify customer number or the number used in the Shopify customer template (these are skipped by design).
   • Ensure Payment term mapping is set up for that invoice’s payment terms.
   • Ensure the invoice has valid lines (no negative/fractional quantities, no empty item numbers).
4. Run the sync again in the foreground so any customer-related errors are shown immediately and can be copied via Copy details.
5. Where to see and control skipped/failed records

• Use Shopify Skipped Records to see all records that were not processed and the reasons.
• Adjust Logging Mode on the shop to ensure skipped records are logged as needed.
• Use a retention policy to keep the skipped records table from growing indefinitely.

If, after correcting customer data and price setup, the issue persists, collect the AL call stack from the error dialog and involve a Microsoft partner or support as described in the Shopify Connector support article.

References:

• Troubleshooting the Shopify and Business Central synchronization
• Synchronize items and inventory
• Walkthrough: Set up and use the Shopify Connector
• What support is offered for the Shopify Connector?