Category Archives: XML

If you’ve ever wanted a tab delimited list of product attributes and prices to update pricing, here’s one way:

Export product attributes through ‘Utilities > Export Data > Export Attributes to XML File’

1. When exporting choose ‘Replace All Mode
2. You will have to add a root level element around the xml generated by miva and the file:
   PS C:\>$a = Get-Content .\provide.xml PS C:\>Set-Content .\provide.xml -value "<products>",$a,"</products>"

   1 2	PS C:\>$a = Get-Content .\provide.xml PS C:\>Set-Content .\provide.xml -value "<products>",$a,"</products>"

   Now bring in file as xml:

   PS C:\>$xml = [xml] (Get-Content .\provide.xml)

   1	PS C:\>$xml = [xml] (Get-Content .\provide.xml)

   Run this command to generate a tab delimited list of Product_Code, Code, & Price

   PS C:\>$xml.Products.ProductAttributeOption_Add | foreach { $_.product_code + "`t" + $_.Price } > .\provide-list.txt

   1 2	PS C:\>$xml.Products.ProductAttributeOption_Add |                foreach { $_.product_code + "`t" + $_.Price } > .\provide-list.txt

   For more information on Powershell’s xml capabilities and how easy it is to use XML with Powershell visit Powershell XML on Code Project

   .