Parameters   Output Objects  

Updates AdobeCommerce data.

Syntax

Update-AdobeCommerce [parameters]

Remarks

The Update-AdobeCommerce cmdlet allows you to use a syntax similar to SQL UPDATE statements to update AdobeCommerce data.

$conn = Connect-AdobeCommerce -User 'admin' -Password 'admin' -Url 'https://myadobecommercehost'
Update-AdobeCommerce -Connection $conn -Table "Products" -Columns @("Name") -Values @("13") -Id "25"

The Where parameter can also be used to specify the primary key of the table:

Update-AdobeCommerce -Connection $conn -Table "Products" -Columns @("Name") -Values @("13") -Where "EntityId = '25'"

The primary key can also be passed to the cmdlet along the pipeline:

Select-AdobeCommerce -Connection $conn -Table Products -Where "EntityId = '238'" | Update-AdobeCommerce -Columns @("EntityId") -Values @("238 2")