Deleting A Product Feature Record Causing Incorrect value in Features Field at Products Table

Deleting A Product Feature Record Causing Incorrect value in Features Field at Products Table

If you have such issue in deleting a product feature record and causing existing value "features" field in Products table becoming incorrect then you can try the solution in the below.

Let's say you assign a product to the following feature numbers : 2,5,3,10,1
So the field "features" in the Products table will have this value : 2,5,3,10,1

Then, you go to features admin to delete the feature num 1.
After you delete it, when you go to Products table, the "features" field value now showing : 2,5,30.
The correct value should be only feature num 1 to be removed, so the correct value for the "features" field now should be : 2,5,3,10

To fix this, you can follow these steps below :
1. Open file shopa_featureedit.asp using notepad or text editor.

2. Locate this code (around line 415):
tempvalue2 = replace(tempvalue2, "," & featureid, "")

3. Please replace to :
tempvalue2 = replace(tempvalue2, "," & featureid & ",", "")

4. Save the file and upload to your site.

5. You are done.


Times Viewed:
1814
Added By:
Wilson Keneshiro
Date Created:
9/22/2014
Last Updated:
9/22/2014