PowerShell Cmdlets

PowerShell Cmdlets

Compatible With: Community 1.3, 1.4,, 1.4.2, 1.5, 1.6, 1.6.1,, 1.7, 1.8, 1.8.1, 1.9, 1.9.1, 1.9.2, 1.9.3

Tech Specifications

Current Version:
Stable Build
21 September, 2017
Extensions, Reporting & Analytics
License Type:


An easy-to-use set of PowerShell cmdlets offering live read, write, update and delete access to live Magento data - just like working with SQL server.

Other Extensions by CData Software

Excel Add-In
JDBC Driver


Back to top

Access Magento data from PowerShell! The CData Cmdlets for Magento provides the easiest way to connect with Magento data from the command-line. The cmdlets leverage a straight-forward design, similar to the Microsft SQL Server Database Engine cmdlets, that makes it easy to import, export, backup, analyze, transform, & connect to your Magento data. With the module, you get native cmdlets for PowerShell (Connect-Magento, Disconnect-Magento, Invoke-Magento, Select-Magento, Add-Magento, Update-Magento, and Remove-Magento) that can be used to manipulate Magento data from within PowerShell.

  • Easy-to-use cmdlets with a simple SQL interface to live Magento data.
  • Read, write, and update Magento Customers, Inventory, Products, Orders, etc. from PowerShell scripts.
  • Easily pipe data into and out of flat files, databases, and other data stores for archival, backup, and synchronization.

The cmdlets offer a simple Transact-SQL interface for connecting with data in real time from Microsoft PowerShell. Use PowerShell scripting to normalize and/or de-duplicate Magento data. Easily interact with real-time data. Connect scripts with scheduling apps (like the Windows scheduler) to automate common integration tasks.

Release Notes

Back to top


  • Compatible with CE: 1.3 1.4 1.4.2 1.5 1.6 1.6.1 1.7 1.8 1.8.1 1.9 1.9.1 1.9.2 1.9.3
  • Stability: Stable Build
  • Description:



Back to top
The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Q & A

Back to top


Back to top