Printable View
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
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.Quote:
Originally Posted by mc12345678
I'll come through the docs if that package indeed have something like that.
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.Quote:
Originally Posted by mc12345678
So that's bust. insert sad face.
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.Quote:
Originally Posted by 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.
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.Quote:
Originally Posted by mc12345678