We changed the skin on our site a few months ago. I didn't delete the old skin, and I sometimes link to images in folders of the old skin instead of moving them. We have a couple of customers who have complained about not being able to see any products, and upon investigation we realized that the old skin is showing when they log in sometimes (not always). I can log in as them, most of the time (9 out of 10) I see the wrong skin with no products then I log in with my own information and the site always displays correctly. Only 2 customers have had this complaint so far, we are receiving orders so not everyone has this problem.

Any ideas?
in General by (260 points)

1 Answer

0 votes

It sounds like their accounts just have the old SkinID saved.  You should be able to fix it with some SQL statements.

Make sure you have a backup of your database before continuing!

The best way is probably just a blanket update, rather than filtering by customer.  That way you catch any customers who are running into this and just aren't reporting it.

Start with this one, replacing the # with your new skin ID:

UPDATE Customer SET SkinID = #

If you're on version 9 or 10, run this one too, again with your skin ID:

UPDATE Profile SET PropertyValueString = '#' WHERE PropertyName = 'SkinID'

There can be trickiness with getting the skinID in version 10.  If you've got any doubt of what skinID you should be using, the folks in Support can help you figure that out.

by (13.5k points)