# Inventory CRM Crontab Configuration
# Install with: sudo crontab -e (or for www-data: sudo crontab -u www-data -e)
# Replace /var/www/inventory-crm with your actual install path

# Low stock check & email alerts (every 6 hours)
0 */6 * * * /usr/bin/php /var/www/inventory-crm/cron/check_low_stock.php >> /var/log/inventory-crm-cron.log 2>&1

# Sync tracking status from Shiprocket (every 30 minutes)
*/30 * * * * /usr/bin/php /var/www/inventory-crm/cron/sync_tracking.php >> /var/log/inventory-crm-cron.log 2>&1

# Daily product sync from Shopify (3 AM)
0 3 * * * /usr/bin/php /var/www/inventory-crm/cron/sync_products.php >> /var/log/inventory-crm-cron.log 2>&1

# Weekly cleanup of old webhook logs (keep 30 days, runs Sunday at 2 AM)
0 2 * * 0 /usr/bin/mysql -u DB_USER -pDB_PASS inventory_crm -e "DELETE FROM webhook_logs WHERE created_at < DATE_SUB(NOW(), INTERVAL 30 DAY); DELETE FROM email_log WHERE created_at < DATE_SUB(NOW(), INTERVAL 30 DAY); DELETE FROM activity_log WHERE created_at < DATE_SUB(NOW(), INTERVAL 90 DAY);" >> /var/log/inventory-crm-cron.log 2>&1
