Extended Information tick boxes disabled after upgrading to v11.

[G.W.Green]

The variable names for the extended information page tick boxes have been changed, due to the introduction of the Single Product per Page feature, and therefore the links to the extended information pages are no longer enabled if you had these enabled before.


To tick "Links from Product Page" | "Text Link to Extended Information Page" for all products:

UPDATE Product SET bSPPDisplayExtInfoByLink = -1

To change the text of "Links from Product Page" | "Link Text" for all products:

UPDATE Product SET sSPPDisplayExtInfoByLinkTxt = "More info…"

To tick "Links from Product Page" | "Extended Info Button Link to Extended Information Page" for all products:

UPDATE Product SET bSPPDisplayExtInfoByBtn = -1

To tick "Links from Product Page" | "Product Image Link to Extended Information Page" for all products:

UPDATE Product SET bSPPDisplayExtInfoByImage = -1

To tick "Text Link" | "Displays the Extended Information Page" option:

UPDATE Product SET nDisplayByLink = 2

To set the new value of the "Text Link" | "Link Text" edit box:

UPDATE Product SET sProductListLinkText = "new text"

To untick any of the options listed above, replace -1 with 0 in the related SQL.


How to run one of these SQL scripts.


To run an SQL query in the SellerDeck database you will need to follow these instructions. You will need Access 2000 or above in order to run a query in your SellerDeck database.

1. First make a backup of your site (File | Snapshot | Export Site)
   
2. Also make a backup of your “Site1” folder, or the folder of the site you are currently using.
   
3. Close down SellerDeck.
   
4. Open Windows Explorer
   
5. Browse to: C:\Program Files\Actinic v11\Sites\Site1* (Or the location of the “Site1” folder you are using)
   
6. Open up “ActinicCatalog.mdb” in Access.
   
7. Go to 'View | Database Objects | Queries
   
8. Click 'New'
   
9. Select 'Design' view
   
10. Click 'close' on the 'Show Table' window
    
11. Then go to 'View | SQL view'
    
12. Copy and paste the SQL statement from above into the page, replacing “SELECT;” if that is already in the page:
    
13. To run the query, go to 'Query | Run'
    
14. Now close the SQL query Window
    
15. Close the Access Database

* All versions after v11.03 will have a file path of 'C:\Program Files\SellerDeck xxxx'.