Skip to main content

Notifications

Announcements

Announcing Mentions and Quick Responses!
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Edited Shopify Order /...
Small and medium business | Business Central, N...
Unanswered

Edited Shopify Order / BC Mapping Error

(1) ShareShare
ReportReport
Posted on by Peter Waugh 122
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:
Business Central
  • Suggested answer
    Saif Ali Sabri Profile Picture
    Saif Ali Sabri 231 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

News and Announcements

Announcing Mentions and Quick Responses!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,000 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,658 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans