Thread: Quick WSI query

Does anyone know how to set the weight for ALL products in a db to 100g? We don't have anything in our weight item but would want to try and set the weight so we can begin charge shipping by weight.

Thanks

Dean

No worries I ran a SQL script that worked

Product weights are stored in the ProductVariant table. Thanks for the update, we're glad you are all set.

For anyone else that's curious, in WSI you would just do something like this:

Code:

<AspDotNetStorefrontImport>
  <Query>
    <SQL>
      <![CDATA[ 
        update dbo.ProductVariant set Weight='100'
      ]]>
    </SQL>
  </Query>
</AspDotNetStorefrontImport>

It's easier than trying to do this for each product

Code:

<AspDotNetStorefrontImport>
  <Product Action="Update" ID="#">
    <Variants>
      <Variant Action="Update" ID="#">
        <Weight>100</Weight>
      </Variant>
    </Variants>
  </Product>
</AspDotNetStorefrontImport>