Untick - Can be Ordered Online

[Jo@apartyshop]

Is there a way to Untick the "Can be ordered online" box on each product?

I looking for a way to do this to the whole site and then I'll be able to 'tick' the few products that will be available for purchase online.

[Duncan Rounding]

You can create a simple spreadsheet and do an import.
The first row will be your product reference, the second the product short description, and the third would be Can Be Ordered Online (which is 0 for No and 1 for Yes)

You can export the catalog to get a list of the products to start with.

Otherwise you could run an update Query on the database directly if you know a bit of SQL or MS Access.

[NormanRouxel]

Easy to find in the database. ActinicCatalog.mdb, table Product, field Can be ordered online.

[fergusw]

You can create a simple spreadsheet and do an import.
The first row will be your product reference, the second the product short description, and the third would be Can Be Ordered Online (which is 0 for No and 1 for Yes)

You can export the catalog to get a list of the products to start with.

Otherwise you could run an update Query on the database directly if you know a bit of SQL or MS Access.

As Duncan has said above, or there's a third option which would be to buy a plugin program that allows you to perform this function, and many more bulk edit functions in Actinic - TASK for Actinic - which would do exactly what you need, any time you needed to do it.

[Duncan Rounding]

Use at your own risk - Backup your database!

Download the attached file and change the extension from .txt to .vbs. Double click on the file and browse to your database and click OK.

That will set all instances of the Can Be Ordered Online to 0. You can then go and manually check the ones that you want in Actinic or create an import file to update a select few.