Import to update attribute options prices

[Jake Herbert]

Hi,

I'd like to do a bulk import to update our attribute option prices.

I can't find a simple way to do this.

I have tried the XML import, but keep getting errors.

I tried the following:

<ProductAttributeOption_Update product_code="Thermarest-Air-Head-Down-Pillow" attribute_code="Option">
<code>MidnightPrintL</code>
<price>6</price>
</ProductAttributeOption_Update>

But that yields an error "ProductAttributeOption_Update: Missing required attribute option_code"

We have hundreds of option prices. Currently doing it manually in admin takes too long.

Any help appreciated.

Thanks

[Leanne]

It looks like you're missing the option_code in the first line. From the LSK:

<ProductAttributeOption_Update product_code="chest" attribute_code="trap" option_code="fireball">
<Code>fireballz</Code>
<Prompt><![CDATA[Fireball (+ 500 sp)]]></Prompt>
<Image></Image>
<Price>500.00</Price>
<Cost>700.00</Cost>
<Weight>0.00</Weight>
<DefaultOption>No</DefaultOption>
</ProductAttributeOption_Update>

[Jake Herbert]

Hi,

Thanks so much Leanne. Sometimes it's right in front of me and I miss it.