# Walt's Tools Inventory — Setup Instructions

## Directory layout on the server

    public_html/
    └── walts-tools/
        ├── admin/
        │   ├── add_item.php
        │   ├── dashboard.php
        │   ├── locations.php
        │   ├── login.php
        │   ├── logout.php
        │   └── upload_batch.php
        ├── includes/
        │   ├── auth.php
        │   ├── db.php
        │   └── sku.php
        └── uploads/
            └── photos/          ← create this, set to chmod 755

---

## Step 1 — Run the schema in phpMyAdmin

Select the SAME database you used for the china painting inventory.
Paste and run tools_schema.sql. It creates all tools_ prefixed tables
and leaves the existing china painting tables untouched.

---

## Step 2 — Configure includes/db.php

Use the same DB_NAME, DB_USER, and DB_PASS as the china painting site.
Update ADMIN_PASSWORD to match.

---

## Step 3 — Upload files and set permissions

Upload preserving folder structure above.
Set uploads/photos/ to 755 in cPanel File Manager.

---

## Step 4 — Login

Visit: https://terrywaltz.com/walts-tools/admin/login.php

---

## SKU format

WT-00001, WT-00002, etc.
Sequence lives in the tools_sku_sequence table.

---

## Photo naming for batch upload

WT00042_1.jpg    — item WT-00042, photo 1
WT00042_2.jpg    — item WT-00042, photo 2
WT00042_1_primary.jpg  — set as thumbnail

---

## Key differences from china painting inventory

Extra fields on each item:
- manufacturer     brand or maker name
- era              approximate age / decade
- research_notes   what you found out about the tool
- approx_value     your research estimate (separate from asking price)

Tag types: brand, material, era, condition, other
(Era and condition tags duplicate the free-text fields above intentionally —
use whichever is more convenient for searching/filtering later.)

---

## What's next

- admin/edit_item.php   — edit any item
- index.php            — public browsing page
- item.php             — single item page for buyers