New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2: Add An Item As A Shopify Variant

Microsoft Dynamics 365 Business CentralThis post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 2.

The 17th of the new functionality in the Application section is add an item as a Shopify variant.

The new release of the Shopify connector allows you to export items from Business Central as variants in Shopify. This gives you more flexibility and convenience when you manage product information across both applications.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: –
General Availability: Oct 2024

Feature Details

Shopify and Business Central both offer extensive features for managing products and variants. Depending on your needs, you can choose different options. In Shopify, where you focus on convenience for customers, and in Business Central, where other criteria are taken into consideration, such as the ability to define an assembly BOM.

Microsoft are adding support for export scenarios when Shopify has products with variants, but the list of items is flat on the Business Central side. You can use the Add item as Variant action on the Variants subpage of the Shopify Products page.

Shopify Products

Details

The item is added as a Shopify variant under the existing product option (for example, color, material, or title, if the product only had the default variant). If the Shopify product has more than one option, you can’t add the item as Shopify variant.

You can add items as variants if they have their own item variants—however, only the item itself is added, and not item variants.

You can’t add an item as a variant if the UOM as Variant toggle is turned on on the Shopify Shop Card page.

Shopify always creates a variant, even if you haven’t defined any. This variant is called Default title. When you add more variants via Shopify Admin, this technical variant entry is deleted. The Shopify connector runs similar logic. When the first item is added to Shopify as a product, the Default title variant is added to Shopify and to Business Central. When you run the Add Item as Variant action, the selected item is added as a variant and the default variant is deleted in both Shopify and Business Central.

When adding an item as a variant, the connector won’t search by SKU or barcode.

Product information overview

Production information Business Central: Flat item list.
Only items, no variants.
Business Central: Items with item variants
Shopify: Flat product list.
Only products, no variants.
Supported

Import into Business Central.
Use barcode or SKU field in the Shopify product to point to an item in Business Central.

Export items from Business Central via the Add Item to Shopify action.

Not supported

You can manually create products/items in both systems independently, and use the barcode or SKU for automatic mapping or map products to item variants manually.

Shopify: products with variants Supported

Microsoft recommend that you select Item No., Vendor Item No. or Barcode in the SKU Mapping field and add the barcode or SKU on the variant to ensure that when a product/variant is imported from Shopify it finds the corresponding item in Business Central.

Export from Business Central via the new Add Item as Variant action.

Supported

Recommendation is to select Item No.+Variant Code in the SKU Mapping field and add the barcode or SKU on the variant to ensure that when the product or variant is imported from Shopify it finds the corresponding item or variant in Business Central.

Export from Business Central via the Add Item to Shopify action.

For more information, see Effect of Shopify product SKUs and barcodes on mapping and creating items and variants in Business Central

My Opinion

It’s good seeing the enhancements to the Shopify connector which is available with Business Central as standard. I’ve been involved with a couple of implementations of Shopify integrated wth Business Central. This particular enhancement wouldn’t have been of use, but the flexibility it provides sounds good.

Click to show/hide the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2 Series Index

New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 2
Auto-Apply Templates When You Synchronize Data With Dataverse
Use New Reports And Demo Data for Financial Reporting
Manage Subscription Billing and Revenue and Expense Recognition
Integrate Field Service with Service Management
Archive Service Management Documents
View Item Availability in Field Service Work Orders
Export Posted Sales Invoices to Shopify
Replenish Items for Projects
Reconcile Payment Transactions in Shopify with Invoices
Use Directed Put-Away and Pick Warehouses with Projects
Capture Data from E-Docs with Azure AI Document Intelligence
Add Invoice and Receipt Documents to E-Documents in Bulk
Import, Export Product Info Using Shopify Metafields
Define Shipping Information For Shopify Shipping Fees
Enable Locations In Shopify Refunds
See Improved Usability For Service And Projects
Allow More Than One User To Post Warehouse Entries at a Time
Add An Item As A Shopify Variant
Use Excel Reports For Consolidation And Fixed Assets
Synchronize Product Translations To Shopify
Use Specific Prices And Discounts When Synchronizing Prices In Shopify
Add Extended Text To Project Planning Lines
Use A Default Quantity Of 1 For Accounts On Documents
Stay Current With Shopify Connector
Analyze Fixed Asset And Subscription Billing In Power BI
Use Refreshed Demo Data For Sustainability
Suggest Number Series with Copilot
Chat with Copilot and Learn to Use Installed Add-On Apps
Complete Bank Account Reconciliation Faster with Copilot
Create Product Information Faster with Copilot
Summarize Any Record with Copilot
Experience Enhancements to Analysis Assist with Copilot
Start Using Copilot Without Having to Set Things Up
Create Sales Lines Easily with Copilot
Automate Tests for Your Copilot Extensions with the Business Central Test Toolkit
Start Creating Power Automate Flows With Copilot
Raise Awareness Of Copilot Actions On Card, Document, And Listplus Pages
Display Errors And Messages In Copilot Prompt Dialogs
Experience Enhancements To Chat With Copilot
Get Usage Telemetry On Copilot Extensions As An ISV
Use Copilot With Agent Capabilities To Automate Sales Order-Taking
Start Using Integration with IRS for 1099 Submissions
Start Using E-Documents Framework Localized for Germany
Enable Additional Countries and Regions
Show Features With Demo Dataset For Czechia
Deferral Accounting – Posting The Original Amount As Correction – Czechia
Posting Of Alternative Customer-Vendor Posting Groups – Czechia
Calculate And Post Vat Settlement By Activity Code – Italy
Advance Letters With Reverse Charge – Czechia
Vat Return Feature Now Available – Czechia
Include Employee Transactions In Exchange Rate Adjustment Report – Czechia
Improve Vat Reporting And Adjustments – Czechia
Allocations Functionality In Cash Desks – Czechia
Sales Advance From The Project – Czechia
Enable Use Of Other Currencies – Czechia
Submit IRS 1099 Forms Electronically To IRIS
Use The E-Documents Framework In The Spanish Version
Use Updated Saf-T 1.3 In Norway
E-File IRS 1099 Forms Without Integration
Set Up Easier In-Client Performance Profiling with Rules
Use the Ternary Operator when Coding in the AL Language
Pull Extension Source from GitHub when Opening Visual Studio Code from the Web Client
Use the 'This' Keyword for CodeUnit Self Reference
Restore Extensions if Publishing from Visual Studio Code Fails
Use Improved Features for Report Documents
Package Resources in Extensions and Access from AL
Run Code Action for 'With' for File, Project, or Workspace
Type Testing and Casting Operators for Interfaces
Extend Al Interfaces
Extend and Customize Profiles from Other Extensions
Remove Friction When Working With External App Dependencies
Specify And Use Full-Text Search Indexes On Table Fields
Run Page Scripts In Pipelines For Automated Testing
Manage Environment Updates More Flexibly
Migrate Record Links and Notes with Cloud Migration Tooling
Manage Per-Tenant Extensions in Admin Center
View App Compatibility with Future Versions in Admin Center
Get Notified About Issues with Job Queue Background Processing
Get List of Manageable Environments for Microsoft Entra Apps
Support IPv6 for Enhanced Security and Scalability
Encrypt Data At-Rest With Customer-Managed Encryption Key
Get External Notifications When Job Queue Entries Fail
Use E-Documents with Power Automate
Use Multiple VAT Numbers for a Customer
Achieve Sustainability Scorecards and Goals
Navigate the Sustainability Manager Role Center with Ease
Add Attachments When You Send Electronic Documents
Record Greenhouse Gas Emissions Using Purchase Invoices
Report Sustainability Entries with Financial Reports
Use New Service Providers in the E-Documents Framework
Purchase Carbon Credits
Enable Internal Carbon Fee Calculation in Sustainability
Track Sustainability Certificates For Items And Vendors
Use Multiple Subcategories For One Sustainability Account
Use Embedded Power Bi Reports Out Of The Box
Do Ad Hoc Analysis On Fixed Assets, Projects, And Services
Use Advanced Settings In The Power Bi Connector
Use Built-In Named Formulas In Excel Layouts
Access Keys with Key Tips In More Languages
Use Drag and Drop On File Upload Dialog to Attach Multiple Files
Resize Columns Even when Personalization isn't Enabled
Change The Data Search Method In Lists

What should we write about next?

If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.

Your Name

Your Email

Suggested Topic

Suggestion Details

Leave a Reply

Your email address will not be published. Required fields are marked *