AccSoft Consulting Group

ERP, Retail and eCommerce solutions designers and developers

+1 888-929-3266
Email: info@accsoft.com

AccSoft Consulting Group
100 Consilium Place, Suite 200 <br> Toronto, ON M1H 3E3 <br> Ontario, Canada

Open in Google Maps
QUESTIONS? CALL : 888.929.3266
  • Home
  • Dynamics GP
  • Retail
  • Microsoft 365
  • Dynamics 365
  • BLOG & STORIES
  • Contact Us
CONTACTUS
  • Home
  • Posts tagged "ecommerce"
January 29, 2023

Tag: ecommerce

Microsoft Shopify Connector for Dynamics 365 Business Central

Monday, 06 June 2022 by Sadaf Afzal

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

business centralCustomer SynchronizationDynamics 365dynamics 365 Business CentralecommerceeCommerce solution for Microsoft Dynamics Business CentralIntegrate Shopify with Business CentralInventory SynchronizationItem SynchronizationMicrosoft Shopify Connectormultiple storesPrice SynchronizationShopifyShopify and Business CentralShopify ecommerceShopify IntegrationShopify store
Read more
  • Published in Business Central, Dynamics 365 BC, eCommerce Solutions for Microsoft Dynamics
1 Comment

Uploading inventory items from Microsoft Dynamics GP to Magento eCommerce

Friday, 17 December 2021 by AccSoft Evangelist
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.

GP Login Page

Step-2: Click on the E-commerce button in the left navigation bar.

GP Navigation Bar

Step-3: Click on the Data Synchronize link in the utility Section.

utility section

Step-4: Select items module from the drop-down menu.

drop-down menu

Step-5: Hit the process button and the items will start uploading to Magento instantly.

data sync

inventory uploaded to magento

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

  1. On the Admin sidebar, go to System > Data Transfer > Export.
  2. For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
  3. 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

  1. On the Admin sidebar, go to System > Data Transfer > Export.
  2. For the Entity Type menu, choose Stock Sources. The export only extracts data for products with an SKU.
  3. 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.
  4. 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

  1. On the Admin sidebar, go to System > Data Transfer > Import.
  2. For the Entity Type menu, choose Stock Sources. As a result, the export only extracts data for products with an SKU.
  3. Select configurations for the Import Behavior.
  4. Select the .csv file to import.
  5. 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.

dynamics gpecommerceeCommerce Solutions for Microsoft Dynamics GP - Magentoinventoryinventory managementmagentoMagento eCommerceMagento Inventory from GP
Read more
  • Published in Add-on, Dynamics GP, eCommerce Solutions for Microsoft Dynamics, Inventory Management, Technology
No Comments

Recent Posts

  • How to create Parent & Child relationship in Business Central Customer Card

    Business Central is a comprehensive solution fo...
  • Customer Management in Microsoft Business Central Shopify Connector

    Customer Management in Microsoft Business Centr...
  • Item Creation in Microsoft Business Central Shopify Connector

    Items/products are the fundamental part of an E...
  • Order Management in Microsoft Shopify Connector

    ERP and eCommerce platform integration is one o...
  • How to make a relationship between No. Series in Business Central

    No. Series relationship in Business Central all...

Recent Comments

  • bigcommercedev on Microsoft Shopify Connector for Dynamics 365 Business Central
  • Customization - Microsoft Dynamics CRM: Add custom Field on Microsoft Dynamics CRM: Export Customizations

Archives

  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • May 2021
  • May 2018
  • August 2017
  • August 2015

Categories

  • Add-on
  • Business Central
  • Dynamics 365 BC
  • Dynamics GP
  • eCommerce Solutions for Microsoft Dynamics
  • Inventory Management
  • Magento
  • Microsoft 365
  • Mobile
  • Retail Software (RMH)
  • Technology
  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Loading

Dynamics GP

  • GP Data Migration & Upgrade
  • GP Features & Functionality
  • GP Solution Development
  • GP – Accsoft Services

Retail POS

  • RMH Software Implementation
  • RMS and RMH Support
  • Software Customization services
  • Retail POS Add-on

Microsoft 365

  • Overview
  • Microsoft 365 for Business
  • Features
  • Microsoft 365 Plans

Dynamics 365

  • D365 Business Central – Financial
  • D365 Business Central – Operations
  • Dynamics 365 – Sales and Service
  • D365 Business Central – Business Intelligence

Loading

  • GET SOCIAL

© 2021 All rights reserved. AccSoft Group of Companies

TOP