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.

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.