Microsoft Shopify Connector for Dynamics 365 Business Central
Microsoft Shopify connector easily integrates Business Central and Shopify to ensure smooth operations between backend ERP and front-end e-commerce stores. This blog covers some prominent features of the connector.
Connect Multiple Stores
Connect multiple Shopify stores with Business Central. Connector denotes stores as shops. Go to Shopify >> Shops >> New to create a new store. After filling in the general information go to Process >> Request Acces to make the connection.
After establishing a connection between two platforms, specify and select your preferences in the Item synchronization, customer synchronization, Inventory synchronization, and order processing tab. The list of connected stores appears under the Shops menu.
Bi-Directional Product Integration
Sync products from Shopify to Business Central and also add products to Shopify from Business Central. Go to Shopify >> Products and the list of all products appears. Store code and also the preview URL let you know which store product it is for multiple stores. Moreover, the selected product variants appear under the Shopify variants list.
Customer Integration
Sync and create Shopify customers to Business Central. Furthermore, the connector gives an option to create Shopify customers with order import or import orders in a guest customer. Define tax area code and also the tax business posting group in Shopify Customer Templates.
Mappings
Easily map Shopify and Business Central shipping and payment methods with each other.
From Shopify Shop Card go to Related >> Shipment Method Mapping. Shopify shipping methods appear in the first column, map them with corresponding Busines central shipping methods.
Similarly, From Shopify Shop Card go to Related >> Payment Method Mapping. Likewise, map Shopify payment gateways to corresponding Business Central payment methods.
Order Processing
Import orders from Shopify to Business Central. Go to Process >> Sync Orders from Shopify. The list of all orders with other details like financial status, fulfillment status, created at, etc will appear under orders. Shop code against each order will let us know to which store this order belongs in the case of multiple stores.
Still, a lot more is there to explore in this connector. accsoft has years of experience in implementing Microsoft Dynamics ERPs and also providing support to clients. So for further assistance and to make us your implementation partner reach us at info@accsoft.com
Uploading inventory items from Microsoft Dynamics GP to Magento eCommerce
Export Inventory from GP
It is easy to upload inventory items from GP to Magento. Items to be uploaded to Magento e-commerce are marked in GP. They should include quantities, multi-tier price levels, attributes, and meta information.
If the item is modified manually in GP, the data is updated as soon as the changes are saved. If the items are modified in bulk, for example, through export and import features, they can be updated when the next scheduled data transmission takes place. You can also use the procedure below to update it.
Step-1: Log on to Microsoft Dynamics GP.
Step-2: Click on the E-commerce button in the left navigation bar.
Step-3: Click on the Data Synchronize link in the utility Section.
Step-4: Select items module from the drop-down menu.
Step-5: Hit the process button and the items will start uploading to Magento instantly.
Importing and Exporting Inventory in Magento
For catalogs with a large number of products, use the native Import and Export features. Use it along with expanded Inventory Management options to update sources and quantities by SKU. So, you can add new sources and update inventory quantities for all or a specific source.
- Commerce automatically assigns the Default Source to your products when upgrading Commerce or importing new products. If you import products with a custom source assigned, the Default Source will still be added with a quantity of 0. To update sources and quantities, use these import instructions.
- Single Source merchants use import to update only product quantities. In short, all existing and added products are assigned to the Default Source.
- Multi-Source merchants use import to add multiple sources and quantities per row per SKU.
To import updates, firstly, export a CSV file for specific or all sources. Then, edit the CSV file and add a row per SKU for each source and quantity. You need the source’s code when adding a new source and adding quantities of stock. However, you cannot add or update stocks using import-export features.
Export product data for all sources
- On the Admin sidebar, go to System > Data Transfer > Export.
- For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
- Click Continue. The file generates and downloads to open and edit.
After updating inventory amounts and product data, import the file back into Commerce.
Export product data for a specific source
- On the Admin sidebar, go to System > Data Transfer > Export.
- For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
- Use the Entity Attributes to filter the exported products for a specific source. For source_code, enter the code for the source in the filter field.
- Click Continue. Consequently, the file generates and downloads to open and edit.
Finally, after updating inventory amounts and product data, import the file back into Commerce.
Import product data
- On the Admin sidebar, go to System > Data Transfer > Import.
- For the Entity Type menu, choose Stock Sources. As a result, the export only extracts data for products with an SKU.
- Select configurations for the Import Behavior.
- Select the .csv file to import.
- Finally, click Check Data and complete the import.
For more information, please visit us at Microsoft Dynamics GP – Great Plains
AccSoft Business Solutions will help you in dealing with the issue you are looking at now.
You can email us at info@accsoft.com or call us at 1-888-929-3266.