Pre-Configuring options BEFORE install

[Convergence]

I do not know your details on the shops??

But operating many shops, order fufillment, tracking, accounting, etc. can become an ominus task.

There is a Multi-site 3rd Party module that might be of interest where by you operate multiple shops - served from one Database.

The directions are sparse to none but others have has success and this might be of interest to you

Actually, ZenCart does not have cron capability, this is done at the linux level BUT can be for some shell script that acts upon ZenCart items.

What action is it you desire to be automated?

In Store Manager (admin/store_manager.php) We'd like to set up a cron to:

1) "Empty Admin Activity Log table from the database" (.../admin/store_manager.php?action=clean_admin_activity_log)
2) "Optimize Database to remove wasted space from deleted records" (.../admin/store_manager.php?action=optimize_db)

Also, we have Easy Populate 1.2.5.4 installed - We want to:

1) Create Model/Price/Qty tab-delimited .txt file in temp dir (.../admin/easypopulate.php?download=tempfile&dltype=priceqty) - We'll then use a script to retrieve the file automatically from our temp folder, make our pricing changes, and then have a script send it back to the temp folder.
2) After #1 is done, we want the same text file imported back into the database (Import from Temp Dir (temp/) - Insert into db).

This will allow us to download the Model/Price/Qty tab-delimited .txt file, say on Monday, giving plenty of time to make our changes before having the file automatically uploaded say on Wednesday.

Thinking the upload portion may require something extra as EP creates a differently named .txt file with each download to the temp directory - so at a loss as how that would work - hmmmm.

Even considered testing macros to do this.

:)

Thanks for any suggestions you may have on this as well.

[kobra]

OK, I am "anal" about this but I did not see where you are making a DB backup???

I would highly suggest that you make DB backups BEFORE messing with anything in the DB automatically or manually.

[Convergence]

OK, I am "anal" about this but I did not see where you are making a DB backup???

I would highly suggest that you make DB backups BEFORE messing with anything in the DB automatically or manually.

D'oh - yes we backup the databases manually - another cron job is needed for that as well. That's on top of our dedicated servers retaining daily, weekly, monthly backups :)

[kobra]

For the download issues in EP I do not see any integrity issues and one would extract the php that excecutes this into another php file and then cron the excecution of this file...If you use cPanel it appends the hashbang otherwise you need to include it.

Yhe upload I see as problematic and troublesome that could lead to data integrity issues unless the shop is placed into maintenance mode before the upload and might suggest that one do this manually anyway.

As you have root access can you determine if you have mutt installed?
At the cmd line logged in as root enter

$ rpm -qa | grep mutt

If so I have a DB backup routine that can be cron'd
email me through the profile details here