Partage via


Import and export more data for Shopify B2B companies and company locations

Enabled for Public preview General availability
Users, automatically - Apr 1, 2025

Business value

To make e-commerce more efficient and reliable, the connector expands the information that Shopify and Business Central exchange in B2B scenarios. The Shopify Connector now imports all company locations, including payment terms and tax IDs, and uses this information for automatic entity mapping. When you export data to Shopify, the sync includes the tax ID, company ID, and company/attention details to improve order information and traceability. When you create catalogs automatically, you ensure consistent pricing across both Shopify and Business Central.

Feature details

We've improved how we handle company details for B2B scenarios. We continue to enhance the integration between Shopify and Business Central, so you can provide exceptional service to your B2B customers.

When you import a company from Shopify, you also import all its locations. You can access these locations on the Shopify Locations page. You can open this page from the Shopify Companies and Shopify Company Card pages.

The first imported location is the default location. It creates the customer and adds address information and other fields on the customer card. When you export a customer as a Shopify company, the Shopify Connector creates one company location. In Business Central, you see this location as the default location.

Company Locations action

The Company Location feature in Shopify enables merchants to set default payment terms. When you export customer information as a Shopify company, the process transfers payment term details to Shopify and stores them in the default company location if:

  • The Payment Term field in the Customer Card contains a value.
  • The Shopify Payment Terms Mapping page has a corresponding record.

When you import a Shopify company, you see the payment terms for each company location. If you configure the Shopify Connector to update the customer, it uses the payment term from the default location. The corresponding record on the Shopify Payment Terms Mapping page must exist.

In Shopify, each company location can have a tax ID. When you export a customer as a Shopify company, the process stores the tax ID in the default company location. Use the new Company Tax ID Mapping field on the Shopify Shop Card page to choose whether to send the Registration Number or the VAT Registration No. as the tax ID.

When you import Shopify companies, the tax ID at the default Shopify Location enables you to map imported companies to existing customers. Select By Tax ID in the Company Mapping Type field on the Shopify Shop Card page to turn on this mapping logic.

Mapping by tax ID

The latest release of the Shopify connector introduces individual prices and discounts. These prices and discounts complement the global pricing structure and the customer price group and customer discount group pricing structures. Individual prices and discounts give you more flexibility and personalization for B2B customers.

When you export a customer as a Shopify company, you fill in the Customer No. field for the catalog if you set up the Shopify Connector to create a catalog. This enhancement makes sure the connector uses the specific customer to calculate prices. You don't need to fill in the Customer Price Group, Customer Discount Group, or Allow Line Discount fields. Turn on the Sync Prices toggle and select Sync Prices to start synchronizing catalog prices. Your customers see consistent pricing in Shopify and Business Central.

When you export a customer as a Shopify company, the connector adds the value from the No. field on the Customer Card page to the Company ID field. This step improves traceability. The Shopify Connector also adds the company name to the Company/Attention field in the company location it creates. You use this name in imported orders.

Tell us what you think

Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.

Additional resources

B2B Companies (docs)