Product Permutation Layout - Include Prices

[KevWal]

Hi

I am just looking at the upgrade from 8.5.0 to 9.02, upgrading via snapshot import.

In 8.5 I have Retail Price Layout set to Additional Price in Brackets, which shows the price of each permutation in the drop down list.

This setting has correctly been imported in to V9.02, but the price does not display. It appears in V9.02 we have an additional checkbox "Include Prices" in the Permutation Layout Options box that needs to be ticked.

So, 3 questions:

1) Why do we need this box, is it not set by the price layout selected?
2) If we need it, why is it not set automatically if Retail Price Layout is set to show the price in the imported snapshot
3) How can I easily edit the database to tick this box for every component?

Thanks
Kevin

[leehack]

I've had a client with the same issue, it appears to be a bug in that this tick does not get applied correctly on upgrade. Not much help I know, but you are not alone.

[KevWal]

Thanks Lee

I guess the important question is how to correct it - I have hundreds of products with the issue.

I know I could do an export and re import but I have had so many problems with that in V8 that I dont want to cause myself more problems.

I believe the easyist way would be to do some SQL in the DB - it should be a simple command to set every cell in col Z to X in table Y, the problem is knowing X, Y & Z and the SQL to do it?

Thanks
Kev

[TraceyG]

Hi Kevin,

To tick the 'include prices' boxes for all components you can run the following query on the database:

- close Actinic
- browse to your site folder and locate the ActinicCatalog.mdb file (take a backup)
- open the file with MS Access
- go to 'Insert | Query'
- select 'Design View'
- go to 'View | SQL View'
- replace the contents with the following:

UPDATE ProductProperties SET ProductProperties.bFlag10 = -1
WHERE (((ProductProperties.nType)=5));

- click on 'Query | Run'
- when it's done you can close the database and open Actinic and the 'Include Prices' boxes should then be ticked.

[KevWal]

Thanks Tracey, that seems to have sorted it.

I assume you will feed this back into the development cycle as a bug?

Thanks
Kevin

[TraceyG]

Hi,

Yes, I am checking it out with them.

[Hi-Peak]

Saved my bacon!

Thanks a lot for this Tracey. I had over 1,000 products to fix across two sites, after upgrading a customer to V9. This has saved me a load of time and hassle.

I have an outstanding support call for this and will let them know about this forum post.

Cheers,

Phil Chapman
Hi-Peak Internet

[Greenmind]

Hi Kevin,

To tick the 'include prices' boxes for all components you can run the following query on the database:

- close Actinic
- browse to your site folder and locate the ActinicCatalog.mdb file (take a backup)
- open the file with MS Access
- go to 'Insert | Query'
- select 'Design View'
- go to 'View | SQL View'
- replace the contents with the following:

UPDATE ProductProperties SET ProductProperties.bFlag10 = -1
WHERE (((ProductProperties.nType)=5));

- click on 'Query | Run'
- when it's done you can close the database and open Actinic and the 'Include Prices' boxes should then be ticked.

Can anyone help me out with this? We have recently upgraded to V10 and have the same problem with none of our component prices showing because of the infamous 'include prices' checkbox being unticked by default. I have tried to follow the instructions above but I have Access 2007 and it doesn't seem to work as described above. It has a 'Query Wizard' and I haven't a clue how to use it. I have no knowledge of Access so am at a loss as to how to fix the issue without spending hours ticking all those pesky little boxes. I don't know why this has not been fixed in V10, as it was obviously a problem in V9.

Any help would be greatly appreciated.

[Greenmind]

Ok, managed it in the end.