Updating Magento Quantity Available

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
jimAtXR
Posts: 6
Joined: Tue 19 Sep 2017 20:41

Updating Magento Quantity Available

Post by jimAtXR » Thu 15 Mar 2018 18:23

Please confirm that you don't support updating the quantity available for Magento inventory. I have tried using the Magento Destination object with "Action" set to Update without success. I just get an error that says "InventoryStockItems does not support UPDATE operation". I use another tool outside of SSIS that does update inventory using the API operation called "catalogInventoryStockUpdate", but I would rather have this in an SSIS job.
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Updating Magento Quantity Available

Post by Shalex » Mon 19 Mar 2018 18:07

Magento InventoryStockItems is a view, and it is not possible to write data to this object.
Top
Post Reply

Return to “SSIS Data Flow Components”