Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2011
    Posts
    132
    Plugin Contributions
    4

    Default Toggle products and categories via a crontab.

    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

  2. #2
    Join Date
    Jul 2012
    Posts
    14,571
    Plugin Contributions
    17

    Default Re: Toggle products and categories via a crontab.

    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  3. #3
    Join Date
    Jul 2011
    Posts
    132
    Plugin Contributions
    4

    Default Re: Toggle products and categories via a crontab.

    Quote Originally Posted by mc12345678 View Post
    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.

  4. #4
    Join Date
    Jul 2011
    Posts
    132
    Plugin Contributions
    4

    Default Re: Toggle products and categories via a crontab.

    Quote Originally Posted by mc12345678 View Post
    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.

  5. #5
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,046
    Plugin Contributions
    29

    Default Re: Toggle products and categories via a crontab.

    Steve
    github.com/torvista: Spanish Language Pack, Image Checker, Structured Data, BackupMySQL Admin/Auto, Product Listing Sorter, Redsys payment module...

  6. #6
    Join Date
    Jul 2012
    Posts
    14,571
    Plugin Contributions
    17

    Default Re: Toggle products and categories via a crontab.

    Quote Originally Posted by torvista View Post
    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  7. #7
    Join Date
    Aug 2007
    Location
    Gijón, Asturias, Spain
    Posts
    2,046
    Plugin Contributions
    29

    Default Re: Toggle products and categories via a crontab.

    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.
    Steve
    github.com/torvista: Spanish Language Pack, Image Checker, Structured Data, BackupMySQL Admin/Auto, Product Listing Sorter, Redsys payment module...

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    9,103
    Plugin Contributions
    72

    Default Re: Toggle products and categories via a crontab.

    Quote Originally Posted by mc12345678 View Post
    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.

 

 

Similar Threads

  1. v139h How to make new products show first on categories and sub categories...HELP!
    By amandavz in forum Setting Up Categories, Products, Attributes
    Replies: 15
    Last Post: 29 Jul 2013, 01:52 AM
  2. Categories / Sub Categories and Products all in Dropdowns?
    By CIPFriction.com in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 28 Nov 2008, 10:25 PM
  3. auto_loaders initSystem crontab
    By David Bo in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 6 Nov 2006, 10:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR