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 "Magento Inventory from GP"
January 29, 2023

Tag: Magento Inventory from GP

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