Kryptronic Software Support Forum

I've imported my V6 shop using the converter, but am unable to save any changes made to existing products. There are two errors flagged:
The first is in "Display": Product Detail Display Type needs to be set to "Default", which can be done through the web interface so more an annoyance that an error. See later in posting for a general fix.
The second is in "Reviews"  where both "Average Overall Review Score" and "Number of Approved Reviews" were shown as "Not Applicable". There is no way to change these fields. I've tried with Reviews on the store both turned on and off and still get the same error.

The way I solved it was to run a raw database command
System Dashboard > System > Database > Raw Database Admin

Then run

update ecom_prod set reviewsavg=0, reviewsnum=0 where reviewsavg="";

I could then edit and save the pre-existing products

To solve the first problem for all products, run

update ecom_prod set lgdisp="default" where lgdisp="noimg";

Last edited by bbac (08-22-2012 06:05:52)