Force update all products

[Nick1973]

I need to add some default values to all products which I plan to do through MYSQL so all products have the same values for product descriptions.

In order to pick up the values from the database, Zen Cart requires each product to be updated through the admin. There's alot of products so how would I force the admin to update all products at the same time rather than going through each one and clicking 'Preview' then 'Update'

[mc12345678]

There is a SQL tool where you can enter your SQL to perform your desired action. In admin->tools->install sql patches.

When entering your sql, refer to the table(s) without a prefix, ie. products not zen_products, and be sure to end your sql query with a semi-colon (;).

Suggest backing up your database before doing any of this though...

As for the above description, in one place identified the need to update the description, in another stated that all that was needed was to select preview then update. While the above explanation accomplishes the first part, it doesn't accomplish the second... Was that just information left off, or are you expecting an action that is normally performed upon moving through preview to update to also be performed?

[Nick1973]

or are you expecting an action that is normally performed upon moving through preview to update to also be performed?

Yes I am expecting the update to be performed without the need to login and go through every product to update them one by one once fields have been updated in the database.

[DrByte]

In order to pick up the values from the database, Zen Cart requires each product to be updated through the admin.

Please explain more about this "requirement".

The only such "requirement" I can think of is a recalculation of the cached values of products_price_sorter which contains the lowest available price based on applicable discounts. And you can force the recalculation of this via Admin->Tools->Store Manager.

What other "requirements" are you saying need to be done?

[Nick1973]

Ok, I have added some extra fields and I want to apply a default value to these in MYSQL. The fields in MYSQL update in the database, however they don't update in the admin or on the front end as I would need to click preview and then update for them to process.

[DrByte]

Ok, I have added some extra fields and I want to apply a default value to these in MYSQL. The fields in MYSQL update in the database, however they don't update in the admin or on the front end as I would need to click preview and then update for them to process.

Then, since only you know the unique custom updates required for those fields, perhaps it's best that you write the SQL queries that will auto-update those fields the same way you've coded the Preview/Update pages to update them.

[mc12345678]

Yes I am expecting the update to be performed without the need to login and go through every product to update them one by one once fields have been updated in the database.

Well, see, there's a difference between running a sql to update the data and the actions that can be programmed into the evolution of preview to update. There are plugins that call additional code during this preview/update process which would not get activated when running a sql command. Therefore, if wanting action to be taken exactly related to the process performed by ZC during the review/update process then something else needs to be considered besides a sql command. This may now be a duplicate of DrBytes response, but I already wrote this, so submitting anyways.

[Nick1973]

Your answer doesn't really help that much to be honest in this instance. Perhaps give me an idea of what I should write, that would be a starting point.

[DrByte]

There are plugins that call additional code during this preview/update process

Please elaborate. Which plugins? And what do they do?

EDIT: mc12345678 ... sorry, I thought you were Nick1973 there.
If there are actual plugins involved here, we need to know what they are.

There's nothing in ZC currently that automatically simulates the whole preview/update process.

There isn't enough info available about what the actual updates are that Nick1973 needs to fire on all records.

Your answer doesn't really help that much to be honest in this instance. Perhaps give me an idea of what I should write, that would be a starting point.

I can't give you any useful help without knowing entirely how you've altered your site from original Zen Cart code. Maybe my crystal ball needs polishing?

[DrByte]

Is this whole discussion entirely related to your other discussion too? Strip HTML and WORD formatting
Or is there more beyond that?