Update-Shopify Cmdlet
Updates Shopify data.
Syntax
Update-Shopify [parameters]
Remarks
The Update-Shopify cmdlet allows you to use a syntax similar to SQL UPDATE statements to update Shopify data.
$conn = Connect-Shopify -InitiateOAuth 'GETANDREFRESH' -ShopURL 'https://yourshopname.myshopify.com' -OAuthClientId 'myoauthclientid' -OAuthClientSecret 'myoauthclientsecret'
Update-Shopify -Connection $conn -Table "Customers" -Columns @("Id") -Values @("1668776136772254") -Id "25"
The Where parameter can also be used to specify the primary key of the table:
Update-Shopify -Connection $conn -Table "Customers" -Columns @("Id") -Values @("1668776136772254") -Where "Id = '25'"
The primary key can also be passed to the cmdlet along the pipeline:
Select-Shopify -Connection $conn -Table Customers -Where "FirstName = 'jdoe1234'" | Update-Shopify -Columns @("FirstName") -Values @("jdoe1234 2")