Toggle products and categories via a crontab.

[chibipaw]

zc 1.5.5f , php7.1, mariadb 10.3.x

I'd like to be able to automate turning on or off product and or categories using a shell script via crontab.
Ideally Id have a text file with model numbers and categories names to be toggled on or off so I dont have to physically login to the admin pages to do this?

I figured it would be done directly to the SQL directly by passing the admin tools completely. Is there such a tool available?

Thanks

[mc12345678]

I haven't really tried it, but EasyPopulate V4 at https://github.com/mc12345678/EasyPopulate-4.0
Was recently modified to add cron support to do something like that. I don't recall an answer back about its operational status.

[chibipaw]

I haven't really tried it, but EasyPopulate V4 at https://github.com/mc12345678/EasyPopulate-4.0
Was recently modified to add cron support to do something like that. I don't recall an answer back about its operational status.

huh, if EP has an externally callable script to do automatic deployment, that would be awesome.
I'll come through the docs if that package indeed have something like that.

[chibipaw]

I haven't really tried it, but EasyPopulate V4 at https://github.com/mc12345678/EasyPopulate-4.0
Was recently modified to add cron support to do something like that. I don't recall an answer back about its operational status.

Installed it, played with it.. Sadly, I think it's incomplete, as spews a lot of undefined variables, and there's nothing defining an include file for the contents.

So that's bust. insert sad face.

[torvista]

DBIO
https://www.zen-cart.com/showthread....Support-Thread

[mc12345678]

DBIO
https://www.zen-cart.com/showthread....Support-Thread

Which at last view requires all fields of the associated table(s) to be provided rather than just the field(s) to be updated given the unique identifier to find the product.

[torvista]

Nothing is ever perfect off the shelf, either of these products is a starting point to use a csv to make database changes.

I use Pentaho Data Integration Community to produce a csv from a legacy database. It can be used to directly update any database with any source data, manipulated as you wish. It can produce an executable job/be automated.

[lat9]

Which at last view requires all fields of the associated table(s) to be provided rather than just the field(s) to be updated given the unique identifier to find the product.

Not true. You need to provide a products_id and/or products_model to 'locate' the product, but any import can be limited to the field(s) desired.