Thread: Bulk Update of Product Dimensions

We have our APDNSF site up and running with about 450-500 products currently. Unfortunately we do not have the correct shipping dimensions on some of our products. I need to update the dimensions on the product variants. Is there a simple way to do a bulk update of just one product variant field? We don't have an Excel import file that we can modify and load and I don't see a way to export anything but a price list. I am not averse to doing this through the database, I just don't want to have to touch every product separately through the admin interface. Any ideas?

Use WSI

Code:

<AspDotNetStorefrontImport>
  <Product Action="Update" ID="#">
    <Variants>
      <Variant Action="Update" ID="#">
        <Dimensions>
          <UOM>IN</UOM>
          <Length>#</Length>
          <Width>#</Width>
          <Height>#</Height>
        </Dimensions>
      </Variant>
    </Variants>
  </Product>
  <Product Action="Update" ID="#">
    <Variants>
      <Variant Action="Update" ID="#">
        <Dimensions>
          <UOM>IN</UOM>
          <Length>#</Length>
          <Width>#</Width>
          <Height>#</Height>
        </Dimensions>
      </Variant>
    </Variants>
  </Product>
  <Product Action="Update" ID="#">
    <Variants>
      <Variant Action="Update" ID="#">
        <Dimensions>
          <UOM>IN</UOM>
          <Length>#</Length>
          <Width>#</Width>
          <Height>#</Height>
        </Dimensions>
      </Variant>
    </Variants>
  </Product>
</AspDotNetStorefrontImport>