This section provides guidance for diagnosing and resolving common issues encountered when using the Shopify Connector with Microsoft Dynamics 365 Business Central. Use the Quick Troubleshooting Table to identify the issue, then follow the Resolutions and Diagnostic Steps.
Before troubleshooting, verify the following:
- The Shopify store is connected in the Shopify Shop Card.
- The required Job Queue Entries are active.
- Synchronization settings are configured correctly.
- The Shopify store has the required API permissions.
Quick Troubleshooting Table
| Issue | Cause | Resolution |
|---|---|---|
| Product creation fails due to missing Inventory Posting Group | The item does not have a valid Inventory Posting Group assigned, or the inventory setup for the location is incomplete. | Open the Inventory Posting Setup Card and assign a valid Inventory Posting Group Code for the relevant location (e.g., the WEB location). |
| Product creation fails because productOptions is blank in the request | Variant option name (e.g., Size or Color) is missing in the Item Variant Framework configuration. | Add the required option name (e.g., Size or Color) in the Description column on the Item Variant Framework page. After updating the configuration, run Refresh Variant Settings, Register Variants, and optionally Update All Group Values. |
| Shopify Market Catalogs is not visible on the Shopify Shop Card | The Shopify Market Catalog page may not be visible directly on the Shopify Shop Card or the action may not be available in the current view. | Use the Search feature in Business Central and search for Shopify Market Catalog to open the page directly. |
| Price updates are not synchronized when running Market Price Sync | The product is in Draft status, which prevents the integration from sending price updates during synchronization. |
Change the product status to Active, verify the price list lines, and run Sync Prices again Note: Market price synchronization requires the product to be Active in Shopify. Products with Draft status may not receive market price updates during synchronization. |
| Error “Location WEB not found in Store WEB” when creating sales orders from Shopify orders | The location used for order processing is not configured or assigned correctly in the store setup. | Create the required location (e.g. WEB) and assign it to the corresponding store Store WEB. After updating the configuration, run the order import again. |
| Posting of Sales Orders fail to update Posted Sales Invoice No. in the Shopify Orders table | The Commerce Send Message option is disabled in Customer Order Setup, or an incorrect webhook URL is configured in the Functionality Profile for Commerce Webhooks. | Enable Commerce Send Message in Customer Order Setup and verify the webhook configuration in the Functionality Profile. Remove incorrect webhook URLs if necessary and retry posting the Sales Order. |
| Fulfillment updates are not sent to Shopify for Click & Collect (C&C) orders | Compression is not enabled in CO Setup, resulting in the CO Status data not containing quantity information required for fulfillment updates. | Enable Compression in CO Setup so that quantity information is included in the CO Status data. After updating the configuration, process the order again to send the fulfillment update to Shopify. Note: Fulfillment updates require valid quantity information in the CO Status data. If this information is missing, the system will not send fulfillment updates to Shopify. |
| Posted Invoice No. is not updated in the Shopify Orders table, and the Processed checkbox remains unmarked after posting the Sales Order. | Another Shopify integration setup (e.g., Shopify Administration configured with same store S0013) exists alongside the Shopify Shop Card setup and intercepts the shipment event, preventing theBusiness Central Shopify connector from receiving it. The Shipping Agent is missing in the Shopify order data, preventing the system from triggering the shipping event. |
Remove or disable the conflicting Shopify integration setup so the shipment event can be processed by the correct connector. Verify the Shipping Method Mapping in the Shopify Shop Card and ensure the Shipping Agent is correctly assigned to the order. |
| Error “The record in table Shopify Mapping already exists.Identification fields and values: ID='S0013",Mapping Type=Tender",External Code 1 ='BOGUS',External Code 2="” occurs when running Migrate Data | A mapping entry for the same record already exists in the Shopify Mapping table. | Open Actions - LS Central Extension - Tender Type, delete the existing mapping entry, and run Migrate Data again to recreate the mapping. |
| Error “Shopify Shop Location does not exist.” occurs when creating a Customer Order (CO) | Shopify locations have not been retrieved or mapped. | Navigate to Locations, select Get Shopify Locations, and configure the location mapping. Then create the Customer Order (CO) again. |
| Error “Item not found” occurs when attempting to fulfill an order after running Migrate Data | The LS Shopify store is not correctly configured, causing product and mapping data not to be migrated to the Business Central Shopify Connector. | Configure the LS Shopify store correctly on the Shopify Administration page, connect it with the Business Central Shopify Connector, and run Migrate Data again. This will migrate products, metadata mappings, image mappings, and tender mappings. After the migration is complete, recreate and fulfill the order again. |
| Error “The Shopify Shop does not exist. Identification fields and values: Code='SC013'.” occurs when fulfilling an order | Orders exist in the Shopify Orders table that reference a Shopify Shop Code SC013 that no longer exists or is not configured in the system. | Navigate to Shopify Orderss in Business Central and delete the orders associated with the shop code SC013. After removing the invalid records, retry fulfilling the order. |
| Posted Invoice No. is not updated in the Shopify Orders table and the Processed checkbox remains unmarked after running Migrate Data | The Send Fulfilment option is enabled in LS Shopify Connector, which interferes with the processing of the order data during migration. | Disable Send Fulfilment in LS Shopify Connector, then create and post the order again. |
| Tracking number is not updated to Shopify | Fulfillment status was not synchronized before updating the tracking number. | After posting the Sales Order, run Sync Shipment to Shopify to synchronize the fulfillment status. Then enter the tracking number on the SO Posted Shipment. The tracking number will be automatically updated to Shopify. |
Diagnostic Steps
How to Review Synchronization Errors:
If synchronization fails:
- Open Job Queue Logs Entries in Business Central. Locate the log entry related to Shopify synchronization and review the error message to identify the issue.
-
Open Web Service Setup and in the Logs FastTab, check Client Log On and set Server Log Level to All. When Business Central sends a request to Shopify, it will be logged in the Web Request Log which can be found on this page by clicking the Related - Web Service menu.
Communications to Shopify will have the Request ID starting with SHGQL-xxxx.
Each Log line has data being send to Shopify (View Request XML) and data coming from Shopify (View Response XML). This can be helpful when debugging what is going on and in many cases needed when sending in support request to LS Retail ehf.. Click on the View buttons and copy the data from the window into any editor that can format REST/Json data so its easier to read, and include it with the support ticket.