Documentation & API Architecture

1. Hostinger MySQL Database Architecture

Stockerly connects using PDO with prepared statements to guarantee SQL injection immunity. The production configuration resides in config/db.php:

$host = 'localhost';
$db   = 'u394928266_stockerly';
$user = 'u394928266_stockerly';
$pass = '!momusAce@13!';
$charset = 'utf8mb4';

All table migrations are pre-built in database.sql, ready for one-click import in Hostinger phpMyAdmin.

2. Inventory Sync & Post API

Clients can programmatically push real-time stock balances and retrieve analytical telemetry:

POST https://your-domain.com/api/inventory/push

{
  "sku": "IND-SEN-902",
  "item_name": "Ultrasonic Level Sensor Pro 400",
  "stock_quantity": 84,
  "stock_status": "in_stock",
  "price": 349.00,
  "specs": {
    "range": "0.2m - 12m",
    "lead_time_days": 2
  }
}

3. Automated Hostinger Cron Execution

To trigger automatic sync with Shopify, Amazon SP, and custom ERP systems every 15 minutes in your Hostinger cPanel Cron Jobs:

*/15 * * * * /usr/bin/php /home/u394928266/public_html/cron/sync.php > /dev/null 2>&1

Developer Documentation & Sync Guide

Contents

1. Hostinger MySQL Database Architecture

2. Inventory Sync & Post API

3. Automated Hostinger Cron Execution