PRODUCT QUANTITY CONTROLS - INSTALLATION

1. Back up the website files and database.
2. For an existing database, run only migrations for columns that are not already present:
   - 2026_08_27_product_quantity_rules.sql adds optional stock and minimum quantity.
   - 2026_08_27_product_seo_fields.sql adds the product SEO fields and repairs favicon/OG paths.
3. For a fresh database, import Prop_adjusted.sql instead; do not run those two migrations afterward.
4. Upload every site file, preserving the folders shown in this package.

ADMIN BEHAVIOUR

- Minimum Order Quantity left blank: customer starts at 1.
- Minimum Order Quantity entered: customer cannot order less than that number.
- Stock Quantity left blank: unlimited quantity.
- Stock Quantity set to 0: product is out of stock and hidden from the shop.
- Stock Quantity entered above 0: customer cannot order more than that amount.
- If both values are entered, the minimum cannot exceed the available stock.
