Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Edited Shopify Order /...
Small and medium business | Business Central, N...
Answered

Edited Shopify Order / BC Mapping Error

(1) ShareShare
ReportReport
Posted on by Peter Waugh 125
We have edited and removed a product, from Shopify Order (unsynced item) and replaced it with the correct item (Resynced BC/Shopify orders)
When processing the BC Shopify Order, we get error - Not everything can be mapped.
The Shopify Order has had the offending product removed, however we cannot remove the line in the BC Shopify Order 
 
Has anyone has this experience, and how to resolve 
 
Thank you 
Categories:
Dynamics 365 Business Central
  • Verified answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 652 Super User 2025 Season 1 on at
    Edited Shopify Order / BC Mapping Error

    My response was crafted with AI assistance, tailored to provide detailed and actionable guidance for your query.
    The issue you’re encountering occurs because the synchronization between Shopify and Business Central (BC) has created a record in BC for the original item, and simply editing the Shopify order after syncing does not automatically remove the reference in BC. 

    Root Cause

    • In Business Central, Shopify orders are imported as sales orders with line items. When you edit an order in Shopify (e.g., removing/replacing an item), the changes may not completely sync back into BC if the original item or order lines have already been processed or partially imported.
    • The "Not everything can be mapped" error typically means BC is still trying to process a reference to the original unsynced item that no longer exists in Shopify.

    Resolution Steps

    1. Verify the Shopify Order in BC:

      • Go to Sales Orders in BC and open the problematic Shopify order.
      • Look for the line item that corresponds to the product removed in Shopify.
      • Confirm if it’s marked as "unsynced" or contains any mapping issues.

    2. Manually Remove or Correct the Line in BC:

      • If the offending line is still in the BC order and cannot be deleted directly, follow these steps:
        • Change the "Shopify Line Item ID" field on the offending line to blank. This will disconnect the line from Shopify’s synchronization.
        • Manually delete the line from the order.
      • If BC doesn’t allow deletion (e.g., due to posting or status locks), cancel the order and recreate it.

    3. Reimport the Correct Order:

      • After fixing or canceling the order in BC, manually trigger a reimport of the corrected order from Shopify:
        • Navigate to Shopify > Orders in BC.
        • Locate the order, then select Actions > Resync Order.

    4. Verify the Shopify Connector Setup:

      • Ensure that the mapping in the Shopify connector for the specific product is correct:
        • Go to Shopify > Products > Item Mappings in BC.
        • Confirm that the new item in the Shopify order is properly mapped to an item in BC.

    5. Run a Test Sync:

      • Perform a test sync to verify there are no mapping errors:
        • Go to Shopify > Synchronization > Synchronize Orders.
        • Check for any errors or warnings in the synchronization log.

    6. Clear the BC Order if Necessary:

      • If the order remains problematic and cannot be processed, use the "Reset Shopify Order" feature in BC:
        • Open the order in BC.
        • Use the action Functions > Reset Shopify Order Status.
        • This allows the order to be treated as a new incoming order upon the next sync.

    Preventing Future Issues

    1. Avoid Editing Shopify Orders Post-Sync:

      • If changes are necessary, ensure they’re made before the order syncs to BC.
      • Alternatively, handle adjustments directly in BC instead of editing in Shopify.

    2. Enable Product Mapping Validation in BC:

      • In the Shopify connector setup, enable stricter validation for product mapping. This ensures that items not mapped to BC will throw an error during initial sync rather than causing issues later.

    3. Use a Process for Returns/Exchanges:

      • Instead of editing orders directly, use returns or exchanges workflows for changes in Shopify. This ensures proper handling in BC without disrupting mappings.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,468 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,287 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans