Force update all products

[Nick1973]

I'll try and make this simple so you don't have to bother polishing your crystal ball Mr Byte! Hopefully I can save you and your duster a job.

I've added four simple text fields

text1

text2

text3

text4

They are all added into the table 'products' in the database and show up as empty fields in the Zen Cart admin on the product information page.

Each field should have a default value, however as they are new fields the default value does not show up on the front end or in the admin panel.

[Nick1973]

No its nothing to do with stripping html tags, that is independent.

[DrByte]

I've added four simple text fields

text1

text2

text3

text4

They are all added into the table 'products' in the database and show up as empty fields in the Zen Cart admin on the product information page.

Each field should have a default value, however as they are new fields the default value does not show up on the front end or in the admin panel.

Okay. How does using the Preview/Update page in the admin set a value into those fields? How is that value calculated/determined in your site?

And why can't you run a simple SQL query to set those fields the same way?
ie:

update products set text1='default1', text2='default2', text3='default3', text4='default4' where text1='';

or for more detailed control:

update products set text1='value1' where text1='';
update products set text2='value2' where text2='';
update products set text3='value3' where text3='';
update products set text4='value4' where text4='';

Or is there a calculation performed? If so, what?

[Nick1973]

It is just plain text, not a calculation. The default value should automatically show in each field in the admin and on the front end, without having to go through every product and trigger an update to each individual product.

[DrByte]

It is just plain text, not a calculation. The default value should automatically show in each field in the admin and on the front end, without having to go through every product and trigger an update to each individual product.

Okay, then the 2nd SQL I posted above should take care of fixing all the records you've already inserted (or which are blank because of how you added the fields to the database without specifying a default).

And you could change the default value on those fields, in the database schema itself, to something other than blank, so that new records you inject from an external source automatically get that defined default.

Or, you could experiment with the Easy Populate plugin that mc12345678 has been updating and maintaining recently, to do all this editing in a spreadsheet which you can upload to replace the data in your database, periodically as necessary.

[Nick1973]

So are you saying that if I specify a default when creating the fields in the database, then it will cause Zen Cart to automatically see the default? If so then the easier option would be just to recreate the fields with the default.

[mc12345678]

Somewhat following up in the rear with this, it is possible to add a default value for new input when using the ZC standard product entry. That said, it may have already been added, seeing that 1) question related to it hasn't been asked, and 2) such a process (edit and update each product) appears possible at this time.

Yes, EP4 could be used to modify product table entries.

In regards to a plugin that does "require" stepping through the preview/update process, CEON URI Mapping does make modifications as well as Numinix additional fields to name a few... though Numinix's fields are basically additional products table fields, but one could always add some sort of processing function to the code instead of perhaps AJAX to accomodate whatever concept.

[Nick1973]

I tried Numinix Products Fields, but while I have used it on other installs, I'm not entirely sure why, but it wouldn't see the fields so I decided to create the fields myself manually which was in fact alot easier in this case anyway.

[DrByte]

So are you saying that if I specify a default when creating the fields in the database, then it will cause Zen Cart to automatically see the default? If so then the easier option would be just to recreate the fields with the default.

Yes .

[DrByte]

In regards to a plugin that does "require" stepping through the preview/update process, CEON URI Mapping does make modifications

Yes. Those are brutally intrusive, and a mess to recreate the way Nick1973 is asking here. Thankfully he hasn't mentioned that. That would require writing a bunch of custom scripts to do it ... something the CEON URI mod doesn't provide, but they're happy to charge extra for if you can find someone there to respond anymore now that Conor's family has taken it over.