Bookworld India

Catalogue overview

Checking local service…
This is the dedicated Bookworld development environment. Imports remain staged until a production PostgreSQL deployment is explicitly configured and approved.

Phase 1 workflow

  1. Upload a distributor Excel/CSV source
  2. Map columns and normalize controlled values
  3. Validate ISBN, data types and suspicious values
  4. Review duplicates and proposed changes
  5. Approve or reject the staged batch
  6. Production importer writes canonical catalogue only after approval

Start a staged import

Files are copied into private local staging. The original distributor workbook is never changed.

or upload a new supplier file

Column mapping

Current Bookworld distribution mapping:

Import batches

Catalogue

The production catalogue is Work → Edition → Product. Approved staged records will appear here after a PostgreSQL production database is configured.

Search fields are prepared for title, ISBN, contributor, publisher, subject, description, contents and permitted OCR.

Publishers and imprints

Controlled publisher and imprint masters are part of the PostgreSQL schema. Import review proposes normalized publisher records instead of repeating free text.

Authors and contributors

Contributor masters support author, editor, translator, illustrator, compiler and foreword roles at work or edition level.

Subjects

The subject master is hierarchical. A closure table supports fast browsing from a broad subject down to curated sub-subjects.

Suppliers and offers

Supplier stock and costs never overwrite bibliographic identity. One product can have multiple supplier SKUs, costs, procurement times and stock snapshots.

Rights and digital assets

Every permission defaults to unknown / not public. A public cover, preview or OCR asset requires an explicit rights grant with optional expiry and evidence.

Data issues

Open an import batch to filter malformed ISBNs, duplicate candidates, missing metadata, and suspicious price, year, stock and discount values.

Discovery administration

Loading controlled subjects, collections, aliases and match candidates…

Commerce operations

Sign in with an authorised local staff account to manage orders, inventory, refunds, billing, shipping and reports.