Thread: Bulk Update Extended Prices

Is there an easy way to bulk update the extended prices without writing a sql script to the database? I have wholesale and retail customer levels and over 1200 products that need wholesale extended pricing. The only way I can see to update it is to go into every product detail page and click the extended prices link and a popup allows me to add the price.

My product types are all the same price so if I could update the product type with the same price in one bulk edit it would save me countless hours.

I do not know sql very well, and thought maybe a mod on the bulk edit update prices xml could include a column for the extended prices and that would save a lot of time.

Anybody have any ideas?

You can do this via WSI and create a request that looks something like below.

Code:

<AspDotNetStorefrontImport>
  <Product Action="Update">
    <Name>Simple Product 1</Name>
    <SKU>01-0001</SKU>
    <Variants>
      <Variant Action="Update">
         <ExtendedPrices AutoCleanup="true">
          <CustomerLevel ID="1" Price="1.95" />
        </ExtendedPrices>
      </Variant>
    </Variants>
  </Product>
</AspDotNetStorefrontImport>

Hi Alfred,

How about a way to bulk IMPORT Extended Prices? I have to import a couple thousand SKU's and can do this through SQL, however I don't know what I would append into the ExtendedPriceGUID column.