Thread: SKU's not updating

I exported my price list to a spreadsheet. I wanted to edit the sku's. When I uploaded the updated price list, with new sku's, the sku's weren't updated. Any ideas why? We are using 8.0.1.2

You could always get Excel to produce a set of update statements. If your spreadsheet has columns A to M (ProductID to Inventory) then in cell n2 put the following formula:

Code:

="update productvariant set skusuffix='" & H2 & "' where variantid=" & B2

where column B is for the VariantID, and column H is for the SKUSuffix.

Then drag/copy the cell down through your remaining rows. This will give you a whole lot of update statements which will change your SKUSuffix column on the ProductVariant table.

Please note: Do this on a test server/db first. And take a backup of your live data first before running on the live db.

This is my preferred method for bulk updating data.

The statements will look something like this:

Code:

update productvariant set skusuffix='A600/750' where variantid=2
update productvariant set skusuffix='A600/950' where variantid=3
update productvariant set skusuffix='BF205401000' where variantid=4
update productvariant set skusuffix='BF205401150' where variantid=5
update productvariant set skusuffix='BF206851000' where variantid=6
update productvariant set skusuffix='BF206851150' where variantid=7

From Memory the Price excel import only updates prices matched against the SKU. If you want to update the SKU you will need to use the Bulk Excel Import spreadsheet.