Specta Quickstart, as shipped in the download

SPECTA — QUICKSTART
===================

REQUIREMENTS
------------
  - PHP 8.0+ with extensions: pdo, pdo_sqlite (or pdo_mysql), fileinfo, curl
  - MySQL 5.7+ OR SQLite 3 (SQLite requires no extra setup)
  - An API key for OpenAI or Anthropic, or a running Ollama (set after install, or during)
  - A web server (Apache with mod_rewrite, or Nginx with try_files)


SHARED HOSTING / CPANEL (RECOMMENDED FOR MOST BUYERS)
------------------------------------------------------
1. Upload the contents of the `app/` folder to your web root (e.g. public_html/)
   or a subdirectory (e.g. public_html/specta/).

2. Make sure these directories are writable by PHP:
     data/
     data/uploads/

   Via cPanel File Manager: right-click -> Permissions -> set to 755 or 775.

3. Visit https://yourdomain.com/install/ in your browser.

4. Fill in the installer:
     - Database: choose MySQL (fill in host/name/user/pass) or SQLite (no setup)
     - Company name and base currency
     - AI provider and API key (or leave blank to configure later in Settings)
     - Admin email + password

5. The installer writes config.php, creates a starter "General Product Catalog"
   schema, and redirects you to the login page.

6. Log in. Go to Settings to verify your AI provider and API key.

7. Under Templates, adjust the starter template, edit one of the three shipped
   samples (Electronics / Apparel / Food & Beverage), or create your own — one
   column per line; roles auto-detect, or force with "Label | role". Optional
   flags: number/text, required/optional, unit:mm (they drive the per-field
   confidence score on the review grid).

8. Click New Catalog for a single file — or Batches -> New Batch to upload up
   to 20 spec sheets at once and process them as a queue ("Process next" or the
   hands-off auto-advance page; one file per request, no cron needed).

9. Review: low-confidence cells are highlighted amber/red. Click a cell (or Tab
   to it and press Enter) to correct + confirm it. Thresholds live in Settings.

10. Export WooCommerce / Shopify / plain CSV or JSON. The Woo/Shopify column
    layouts are editable per template (Templates -> mapping). VERIFY the column
    set against your store's current import format before a production import.


VPS / SELF-HOSTED
-----------------
Requirements same as above. Apache example:

  <VirtualHost *:80>
    DocumentRoot /var/www/specta/app
    <Directory /var/www/specta/app>
      AllowOverride All
      Require all granted
    </Directory>
  </VirtualHost>

Run the web installer as above, or use the CLI seeder:

  php bin/demo.php    # loads demo data (login: admin@specta.app / admin123)


DOCKER (QUICK TEST)
-------------------
  docker run --rm -p 8080:8080 \
    -v "$(pwd):/var/www/html" \
    -w /var/www/html \
    php:8.3-cli \
    php -S 0.0.0.0:8080 router.php

  Then visit http://localhost:8080/install/


POST-INSTALL SECURITY CHECKLIST
--------------------------------
  [ ] config.php is protected (the .htaccess does this automatically)
  [ ] data/ is not web-accessible (.htaccess blocks it automatically)
  [ ] Use HTTPS in production
  [ ] Keep PHP updated


NOTES
-----
  * Extraction accuracy depends on the model you choose. Claude 3.5 Sonnet and
    GPT-4o give the best results on dense multi-page catalogs.
  * Multi-page PDFs work best with Anthropic (native document support). Other
    providers treat PDFs as best-effort — convert pages to images for reliability.
  * The review step lets you correct any product row before exporting.
  * Export presets: WooCommerce CSV, Shopify CSV, plain CSV, and JSON.
  * No API calls are ever made without your explicit click on "Extract Products".