Modifying a field in the Data Base.......

[Guest CaseyC]

Let me start this out with the fact that I know absolutely ZIP about SQL data base. Now, when I entered my data I put an alpha prefix in front of my product codes (i.e. SKU35123). I would like to change this format without having to edit every one of these through my store admin page. Is it possible through the SQL data base administration to remove the alpha characters and just leave the numbers? All of the product codes are in this format and are 3 alphas and 5 numeric digits.

The Field Name is: productCode

The Field Type is: Varchar(60)

Any help would be greatly appreciated.

Thanks,

Klaus Cook

Houston, Texas

www.gifts.jowestcorp.com

[goober999]

Let me start this out with the fact that I know absolutely ZIP about SQL data base. Now, when I entered my data I put an alpha prefix in front of my product codes (i.e. SKU35123). I would like to change this format without having to edit every one of these through my store admin page. Is it possible through the SQL data base administration to remove the alpha characters and just leave the numbers? All of the product codes are in this format and are 3 alphas and 5 numeric digits.

The Field Name is: productCode

The Field Type is: Varchar(60)

Any help would be greatly appreciated.

Thanks,

Klaus Cook

Houston, Texas

www.gifts.jowestcorp.com

Hi,

First, backup your database or at least export the inventory table. just in case.

Then try this sql statement: update `store1_CubeCart_inventory` set productCode = right(productcode,3)

change the name of the inventory table to match yours.

The above statement will chop the first 3 characters of the product code.

Good luck

/Goober