Variables and new Tabs not showing up on Product Details.

[Orchid]

Further to this I got back to support and told them I was a developer and therefore would probably be able to repair the database manually if they told me how, they've given a set of instructions which I'm going to attempt and I'll post back success or failure.

The development team have recreated the problem on the supplied site, they have created a new variable and it won't display on existing products but will on newly created ones, so they exported the site (.csv file) then imported with replace selected in the import dialog and the products now shows the variables fine using 8.5.1. This is the only work around and the cause is EC needs to populate the UserDefinedProperties table with values that correspond to the product\variable relation, and this can't be done using SQL.

[Orchid]

This works perfectly - also it's not hard you don't need to be a developer to work out how to do it. If you follow the instructions to the letter it works.

create a new product.
create a new variable
export hierarchical
import selecting replace

Everything fixed.

[Orchid]

update to above - it only kinda works the variable are showing up again - however new ones don't appear on the properties tab unless you repeat the procedure this obviously isn't very useful - now that I have the database schema I'm going to examine further.

[Orchid]

ok now have a complete fix.
create a new product.
create a new variable
export hierarchical
import selecting replace

- Take a snapshot for backup purposes
- Shut down Actinic
- Open ActinicCatalog.mdb in the site folder
- Click on the "Queries" button
- Double click "Create Query in Design View"
- Go to View | SQL View
- Copy and paste the following SQL:

UPDATE Product SET Product.nContentCategory = 2
WHERE (((Product.[Short description])<>"") AND ((Product.nProductType)=0)) OR (((Product.nProductType)=1));

- Close the window and save the query
- Run the query by double clicking on it
- Double click "Create Query in Design View"
- Go to View | SQL View
- Copy and paste the following SQL:

UPDATE Product SET Product.nContentCategory = 6
WHERE (((Product.[Short description])="") AND ((Product.nProductType)=2));

- Close the window and save the query
- Run the query by double clicking on it
- Save the query modifications and exit Access.
Open Actinic and now your variables should be back to normal.