-- =====================================================================
-- Book Stock Update — 30 July 2026
-- Source: Book Stock 30-07-2026.xlsx
-- Run in phpMyAdmin on oiqgdmug_taidb
-- REVIEW EACH STATEMENT BEFORE EXECUTING
-- =====================================================================

-- Step 1: Ensure 'Online Store Website' stock location exists
INSERT INTO `inventory_stocklocation` (`name`, `code`, `location_type`, `address`, `is_active`, `created_at`)
VALUES ('Online Store Website', 'ONLINE-STORE', 'other', '', 1, NOW())
ON DUPLICATE KEY UPDATE `name` = `name`;

-- Capture the location ID into a variable
SET @loc_id = (SELECT `id` FROM `inventory_stocklocation` WHERE `code` = 'ONLINE-STORE');

-- =====================================================================
-- Step 2: Update catalog_app_book.stock  (102 books)
-- =====================================================================

-- Millicent Akoth Oloo
UPDATE `catalog_app_book` SET `stock` = 37
  WHERE UPPER(`title`) = UPPER('A PILLAR OF HOPE');

-- Ciku Kimeria
UPDATE `catalog_app_book` SET `stock` = 13
  WHERE UPPER(`title`) = UPPER('DANCE OF THE MONKEYS');

-- Ciku Kimeria
UPDATE `catalog_app_book` SET `stock` = 17
  WHERE UPPER(`title`) = UPPER('OF GOATS AND POISONED ORANGES');

-- Wanjiku Kironyo
UPDATE `catalog_app_book` SET `stock` = 20
  WHERE UPPER(`title`) = UPPER('WHAT HAPPENED TO US?');

-- Wanjiku Kironyo
UPDATE `catalog_app_book` SET `stock` = 21
  WHERE UPPER(`title`) = UPPER('BORN TO BE UNSTOPPABLE');

-- Wanjiku Kironyo
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('CUCU');

-- Wanjiru Thuku
UPDATE `catalog_app_book` SET `stock` = 2
  WHERE UPPER(`title`) = UPPER('DAWN OF FORTUNE');

-- Nicholas Bwebare
UPDATE `catalog_app_book` SET `stock` = 30
  WHERE UPPER(`title`) = UPPER('DESIRE AT DAWN');

-- Dennis J. Indimuli
UPDATE `catalog_app_book` SET `stock` = 14
  WHERE UPPER(`title`) = UPPER('RENDITIONS OF THE SOUL');

-- Dennis J. Indimuli
UPDATE `catalog_app_book` SET `stock` = 13
  WHERE UPPER(`title`) = UPPER('WHEN THE WORLD IN MY VOICE SINGS');

-- Eng. Luke Kangogo Kittony
UPDATE `catalog_app_book` SET `stock` = 24
  WHERE UPPER(`title`) = UPPER('AN AUTOBIOGRAPHY: AVIATOR PAR EXCELLENCE');

-- Betty Kathungu-Furet & Morris Munene Kathungu
UPDATE `catalog_app_book` SET `stock` = 13
  WHERE UPPER(`title`) = UPPER('AFRICA''S BOOK OF GREATS V1');

-- Sharon Gwada
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('BEST BEFORE ''09');

-- MBIRA RIMI
UPDATE `catalog_app_book` SET `stock` = 14
  WHERE UPPER(`title`) = UPPER('NEW CONFIDENT AFRICA');

-- Gladwell Pamba, Natasha Muhanji, Eric Rugara, Vera Kabusheme...
UPDATE `catalog_app_book` SET `stock` = 30
  WHERE UPPER(`title`) = UPPER('TOMORROW I WILL BE HERE');

-- Cynthia Abdalla
UPDATE `catalog_app_book` SET `stock` = 20
  WHERE UPPER(`title`) = UPPER('WHEN RIVERS SAY GOODBYE');

-- Sarah Haluwa
UPDATE `catalog_app_book` SET `stock` = 9
  WHERE UPPER(`title`) = UPPER('SINNERS');

-- Wambui Kieya
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('THE SINS OF OUR FATHER');

-- Beth Ruga
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('SHADOWS IN MY SUNSHINE');

-- Wanjiku Gitagia
UPDATE `catalog_app_book` SET `stock` = 8
  WHERE UPPER(`title`) = UPPER('DEPORTEE');

-- Mukii Gachugu
UPDATE `catalog_app_book` SET `stock` = 8
  WHERE UPPER(`title`) = UPPER('DREAM OF AFRICA: CHAOS BEFORE ORDER');

-- Nixon Nyariero Seko
UPDATE `catalog_app_book` SET `stock` = 20
  WHERE UPPER(`title`) = UPPER('THE GEN Z PARENT');

-- John Odhiambo
UPDATE `catalog_app_book` SET `stock` = 12
  WHERE UPPER(`title`) = UPPER('ENDURING LOVE & FAITHFULNESS');

-- ELIJAH OPONDO OCHIEL
UPDATE `catalog_app_book` SET `stock` = 6
  WHERE UPPER(`title`) = UPPER('THE CROOKED SOCIETY - OLDER VERSION');

-- ELIJAH OPONDO OCHIEL
UPDATE `catalog_app_book` SET `stock` = 10
  WHERE UPPER(`title`) = UPPER('THE CROOKED SOCIETY');

-- Dr. Tabby Munyoki
UPDATE `catalog_app_book` SET `stock` = 8
  WHERE UPPER(`title`) = UPPER('BREAKING THE ORPHAN SPIRIT');

-- Gakuru Githinji
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('THE PRESENT HINDSIGHT');

-- David Major Ogola
UPDATE `catalog_app_book` SET `stock` = 8
  WHERE UPPER(`title`) = UPPER('STRANDED');

-- Nicholas Mbugua
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('A Reflection on Our Cultures');

-- Nyambur Muhoro
UPDATE `catalog_app_book` SET `stock` = 11
  WHERE UPPER(`title`) = UPPER('The Work Life : A guide to growing, thriving, and Leading From Your First Job Onwards');

-- Nicholas Mbugua
UPDATE `catalog_app_book` SET `stock` = 9
  WHERE UPPER(`title`) = UPPER('Basics of Financial Literacy for Teens and Begginers');

-- Eva Jason
UPDATE `catalog_app_book` SET `stock` = 18
  WHERE UPPER(`title`) = UPPER('THE DAYS OF HIS POWER');

-- Eva Jason
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('TRUST THE CLOCKMASTER');

-- Eva Jason
UPDATE `catalog_app_book` SET `stock` = 14
  WHERE UPPER(`title`) = UPPER('HEART AND SKILL');

-- Eva Jason
UPDATE `catalog_app_book` SET `stock` = 14
  WHERE UPPER(`title`) = UPPER('THE HEART OF A WORSHIPPER');

-- Eva Jason
UPDATE `catalog_app_book` SET `stock` = 15
  WHERE UPPER(`title`) = UPPER('THE POWER OF CHOICE');

-- Eva Jason
UPDATE `catalog_app_book` SET `stock` = 15
  WHERE UPPER(`title`) = UPPER('THE LIFE OF A WORSHIPPER');

-- Eva Jason
UPDATE `catalog_app_book` SET `stock` = 17
  WHERE UPPER(`title`) = UPPER('THE OVERLAPPER''S MINDSET');

-- David Kuria Mbote
UPDATE `catalog_app_book` SET `stock` = 9
  WHERE UPPER(`title`) = UPPER('THE INCOMPLETE GRAVESTONE');

-- Zohid Muhammed
UPDATE `catalog_app_book` SET `stock` = 2
  WHERE UPPER(`title`) = UPPER('MOUNTAINS REMEMBER');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('THOUGHT LEADER''S CODE');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 2
  WHERE UPPER(`title`) = UPPER('THE POWER OF PURPOSE : A guide to finding your life''s Mission');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('ADAM AND THE GARDEN PROMISE SERIES 1');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('NOAH AND THE RAINBOW PROMISE SERIES 2');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('ABRAHAM AND THE STARRY PROMISE SERIES 3');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('MOSES AND THE MOUNTAIN PROMISE SERIES 4');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('DAVID THE KINGLY PROMISE SERIES 5');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 1
  WHERE UPPER(`title`) = UPPER('JESUS THE GREATEST PROMISE SERIES 6');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('Munching Ninja: Kenyan Everyday Fruits, Colouring Book 1');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 2
  WHERE UPPER(`title`) = UPPER('Munching Ninja: Kenyan Exotic Fruits, Colouring Book 2');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('Munching Ninja: Kenyan Garden Veggies, Colouring Book 3');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('Munching Ninja: Kenyan Power Veggies, Colouring Book 4');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 2
  WHERE UPPER(`title`) = UPPER('Munching Ninja: Kenyan Power Snacks, Recipe Book 5');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 2
  WHERE UPPER(`title`) = UPPER('Munching Ninja: Kenyan Power Meals, Recipe Book 6');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('RAY''S CULTURAL QUEST PART 1');

-- Dr Anuradha Khoda
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('CULTURAL CLUB ADVENTURE PART 2');

-- Flora Awiti
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('GIRL GET OFF THE FLOOR');

-- Susan Muthoni
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('Family Rise Up Against Gender-Based Violence');

-- Nashon Okoa
UPDATE `catalog_app_book` SET `stock` = 4
  WHERE UPPER(`title`) = UPPER('DON''T BUY THAT HOUSE');

-- 
UPDATE `catalog_app_book` SET `stock` = 4
  WHERE UPPER(`title`) = UPPER('THE ABNORMAL STUDENT');

-- 
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('ELIMINATING PROJECT DELAYS COST OVERRUNS');

-- 
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('THE 7 RULES OF REAL ESTATE INVESTMENT');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 4
  WHERE UPPER(`title`) = UPPER('CONFESSIONS OF NAIROBI MEN');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('GUILTY');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('DAMN, GIRL! STOP THAT');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 2
  WHERE UPPER(`title`) = UPPER('THINGS I WILL TELL MY DAUGHTER');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 4
  WHERE UPPER(`title`) = UPPER('CONFESSIONS OF NAIROBI MEN BOOK 2');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 6
  WHERE UPPER(`title`) = UPPER('MAD WOMEN');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('CONFESSIONS OF NAIROBI MEN AND WOMEN: THE LAST CHAPTER');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('CONFESSIONS OF NAIROBI WOMEN');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 1
  WHERE UPPER(`title`) = UPPER('EVERYTHING I KNOW ABOUT LIFE');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('LETTERS TO MY SON');

-- Joan Thatiah
UPDATE `catalog_app_book` SET `stock` = 6
  WHERE UPPER(`title`) = UPPER('CONFESSION OF NAIROBI WOMEN: BOOK TWO');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('QUEENEX CRE ACTIVITIES PRACTICE BOOK - PLAY GROUP');

-- Wangui Kuria, Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 8
  WHERE UPPER(`title`) = UPPER('QUEENEX CRE ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 1 (PP1)');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('QUEENEX CRE ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 2 (PP2)');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('QUEENEX CREATIVE ACTIVITIES PRACTICE BOOK FOR Playgroup (COMPETENCY BASED CURRICULM0');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('QUEENEX ENVIRONMENTAL ACTIVITIES PRACTICE BOOK - PLAY GROUP');

-- Wangui Kuria/ Josselyne Nyakwela
UPDATE `catalog_app_book` SET `stock` = 10
  WHERE UPPER(`title`) = UPPER('QUEENEX ENVIRONMENTAL ACTIVITIES PRACTICE BOOK - PP1');

-- Wangui Kuria/ Josselyne Nyakwela
UPDATE `catalog_app_book` SET `stock` = 10
  WHERE UPPER(`title`) = UPPER('QUEENEX ENVIRONMENTAL ACTIVITIES PRACTICE BOOK - Pp2');

-- Ekas
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('BLOSSOM KISWAHILI WARIDI');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('QUEENEX LANGUAGE ACTIVITIES PRACTICE BOOK - PLAY GROUP');

-- Terrie Pendo, Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('QUEENEX LANGUAGE ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 1 (PP1)');

-- Terrie Pendo, Mercy Kirui, Josselyne Nyapola
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('QUEENEX LANGUAGE ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 2 (PP2)');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 2
  WHERE UPPER(`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PLAY GROUP (COMPETENCY BASED CURRICULUM)');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 6
  WHERE UPPER(`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PLAY GROUP');

-- Wangui Kuria, Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 8
  WHERE UPPER(`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 1 (PP1)');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 1
  WHERE UPPER(`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 2 (PP2) (COMPETENCY BASED)');

-- Mercy Kirui, Wangui Kuria
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 2 (PP2)');

-- MERCY KIRUI
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('PREMIER REVISION ENCYCLOPEDIA PLAY GROUP');

-- Farayi L. Ziswa
UPDATE `catalog_app_book` SET `stock` = 70
  WHERE UPPER(`title`) = UPPER('SELLING TO INFORMAL MARKETS');

-- Zacchaeus Murianki
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('THE AMERU SOCIAL ROLE OF GICHIARO');

-- Zacchaeus Murianki
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('THE AMERU HISTORY AND THE RISE OF NJURI NCHEKE');

-- Erick Kimathi
UPDATE `catalog_app_book` SET `stock` = 1
  WHERE UPPER(`title`) = UPPER('RIITHO NTURENE');

-- TRUPHIE NJIRU & WANGECHI GITHAIGA
UPDATE `catalog_app_book` SET `stock` = 4
  WHERE UPPER(`title`) = UPPER('THE FUN ANIMAL PUZZLE BOOK');

-- TRUPHIE NJIRU & WANGECHI GITHAIGA
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('THE ANIMAL TRIVIA GAME');

-- TRUPHIE NJIRU & WANGECHI GITHAIGA
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('WHERE DID THE WORLD COME FROM');

-- Mercy Kirui
UPDATE `catalog_app_book` SET `stock` = 10
  WHERE UPPER(`title`) = UPPER('BLOSSOM READ ALOUD SOUNDS PRACTICE BOOK 1');

-- Brian Wekesa, Lisa Pendo
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('PREMIER COMBINED PRACTICE BOOK - PRE-PRIMARY 1');

-- Brian Wekesa, Lisa Pendo
UPDATE `catalog_app_book` SET `stock` = 5
  WHERE UPPER(`title`) = UPPER('PREMIER COMBINED PRACTICE BOOK - PRE-PRIMARY 2');

-- Wangui Kuria
UPDATE `catalog_app_book` SET `stock` = 3
  WHERE UPPER(`title`) = UPPER('QUEENEX CREATIVE ACTIVITIES PRACTICE BOOK FOR PRE-PRIMARY 1');

-- Wangui Kuria
UPDATE `catalog_app_book` SET `stock` = 7
  WHERE UPPER(`title`) = UPPER('QUEENEX CREATIVE ACTIVITIES PRACTICE BOOK FOR PRE-PRIMARY 2');

-- =====================================================================
-- Step 3: Upsert inventory_inventorybalance for Online Store Website
-- (sets quantity_on_hand; leaves quantity_reserved unchanged / 0 if new)
-- =====================================================================

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 37, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('A PILLAR OF HOPE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 37;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 13, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('DANCE OF THE MONKEYS')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 13;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 17, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('OF GOATS AND POISONED ORANGES')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 17;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 20, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('WHAT HAPPENED TO US?')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 20;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 21, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('BORN TO BE UNSTOPPABLE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 21;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('CUCU')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 2, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('DAWN OF FORTUNE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 2;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 30, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('DESIRE AT DAWN')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 30;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 14, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('RENDITIONS OF THE SOUL')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 14;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 13, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('WHEN THE WORLD IN MY VOICE SINGS')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 13;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 24, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('AN AUTOBIOGRAPHY: AVIATOR PAR EXCELLENCE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 24;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 13, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('AFRICA''S BOOK OF GREATS V1')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 13;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('BEST BEFORE ''09')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 14, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('NEW CONFIDENT AFRICA')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 14;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 30, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('TOMORROW I WILL BE HERE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 30;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 20, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('WHEN RIVERS SAY GOODBYE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 20;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 9, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('SINNERS')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 9;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE SINS OF OUR FATHER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('SHADOWS IN MY SUNSHINE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 8, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('DEPORTEE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 8;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 8, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('DREAM OF AFRICA: CHAOS BEFORE ORDER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 8;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 20, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE GEN Z PARENT')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 20;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 12, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('ENDURING LOVE & FAITHFULNESS')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 12;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 6, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE CROOKED SOCIETY - OLDER VERSION')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 6;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 10, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE CROOKED SOCIETY')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 10;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 8, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('BREAKING THE ORPHAN SPIRIT')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 8;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE PRESENT HINDSIGHT')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 8, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('STRANDED')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 8;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('A Reflection on Our Cultures')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 11, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('The Work Life : A guide to growing, thriving, and Leading From Your First Job Onwards')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 11;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 9, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('Basics of Financial Literacy for Teens and Begginers')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 9;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 18, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE DAYS OF HIS POWER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 18;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('TRUST THE CLOCKMASTER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 14, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('HEART AND SKILL')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 14;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 14, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE HEART OF A WORSHIPPER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 14;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 15, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE POWER OF CHOICE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 15;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 15, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE LIFE OF A WORSHIPPER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 15;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 17, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE OVERLAPPER''S MINDSET')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 17;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 9, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE INCOMPLETE GRAVESTONE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 9;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 2, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('MOUNTAINS REMEMBER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 2;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THOUGHT LEADER''S CODE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 2, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE POWER OF PURPOSE : A guide to finding your life''s Mission')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 2;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('ADAM AND THE GARDEN PROMISE SERIES 1')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('NOAH AND THE RAINBOW PROMISE SERIES 2')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('ABRAHAM AND THE STARRY PROMISE SERIES 3')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('MOSES AND THE MOUNTAIN PROMISE SERIES 4')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('DAVID THE KINGLY PROMISE SERIES 5')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 1, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('JESUS THE GREATEST PROMISE SERIES 6')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 1;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('Munching Ninja: Kenyan Everyday Fruits, Colouring Book 1')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 2, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('Munching Ninja: Kenyan Exotic Fruits, Colouring Book 2')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 2;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('Munching Ninja: Kenyan Garden Veggies, Colouring Book 3')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('Munching Ninja: Kenyan Power Veggies, Colouring Book 4')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 2, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('Munching Ninja: Kenyan Power Snacks, Recipe Book 5')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 2;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 2, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('Munching Ninja: Kenyan Power Meals, Recipe Book 6')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 2;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('RAY''S CULTURAL QUEST PART 1')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('CULTURAL CLUB ADVENTURE PART 2')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('GIRL GET OFF THE FLOOR')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('Family Rise Up Against Gender-Based Violence')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 4, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('DON''T BUY THAT HOUSE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 4;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 4, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE ABNORMAL STUDENT')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 4;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('ELIMINATING PROJECT DELAYS COST OVERRUNS')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE 7 RULES OF REAL ESTATE INVESTMENT')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 4, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('CONFESSIONS OF NAIROBI MEN')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 4;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('GUILTY')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('DAMN, GIRL! STOP THAT')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 2, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THINGS I WILL TELL MY DAUGHTER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 2;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 4, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('CONFESSIONS OF NAIROBI MEN BOOK 2')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 4;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 6, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('MAD WOMEN')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 6;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('CONFESSIONS OF NAIROBI MEN AND WOMEN: THE LAST CHAPTER')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('CONFESSIONS OF NAIROBI WOMEN')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 1, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('EVERYTHING I KNOW ABOUT LIFE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 1;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('LETTERS TO MY SON')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 6, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('CONFESSION OF NAIROBI WOMEN: BOOK TWO')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 6;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX CRE ACTIVITIES PRACTICE BOOK - PLAY GROUP')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 8, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX CRE ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 1 (PP1)')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 8;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX CRE ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 2 (PP2)')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX CREATIVE ACTIVITIES PRACTICE BOOK FOR Playgroup (COMPETENCY BASED CURRICULM0')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX ENVIRONMENTAL ACTIVITIES PRACTICE BOOK - PLAY GROUP')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 10, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX ENVIRONMENTAL ACTIVITIES PRACTICE BOOK - PP1')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 10;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 10, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX ENVIRONMENTAL ACTIVITIES PRACTICE BOOK - Pp2')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 10;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('BLOSSOM KISWAHILI WARIDI')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX LANGUAGE ACTIVITIES PRACTICE BOOK - PLAY GROUP')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX LANGUAGE ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 1 (PP1)')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX LANGUAGE ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 2 (PP2)')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 2, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PLAY GROUP (COMPETENCY BASED CURRICULUM)')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 2;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 6, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PLAY GROUP')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 6;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 8, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 1 (PP1)')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 8;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 1, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 2 (PP2) (COMPETENCY BASED)')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 1;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX MATHEMATICAL ACTIVITIES PRACTICE BOOK - PRE-PRIMARY 2 (PP2)')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('PREMIER REVISION ENCYCLOPEDIA PLAY GROUP')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 70, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('SELLING TO INFORMAL MARKETS')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 70;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE AMERU SOCIAL ROLE OF GICHIARO')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE AMERU HISTORY AND THE RISE OF NJURI NCHEKE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 1, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('RIITHO NTURENE')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 1;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 4, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE FUN ANIMAL PUZZLE BOOK')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 4;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('THE ANIMAL TRIVIA GAME')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('WHERE DID THE WORLD COME FROM')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 10, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('BLOSSOM READ ALOUD SOUNDS PRACTICE BOOK 1')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 10;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('PREMIER COMBINED PRACTICE BOOK - PRE-PRIMARY 1')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 5, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('PREMIER COMBINED PRACTICE BOOK - PRE-PRIMARY 2')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 5;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 3, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX CREATIVE ACTIVITIES PRACTICE BOOK FOR PRE-PRIMARY 1')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 3;

INSERT INTO `inventory_inventorybalance` (`book_id`, `location_id`, `quantity_on_hand`, `quantity_reserved`)
  SELECT b.`id`, @loc_id, 7, 0
  FROM `catalog_app_book` b WHERE UPPER(b.`title`) = UPPER('QUEENEX CREATIVE ACTIVITIES PRACTICE BOOK FOR PRE-PRIMARY 2')
  ON DUPLICATE KEY UPDATE `quantity_on_hand` = 7;

-- =====================================================================
-- END OF SCRIPT
-- Verify row counts: each UPDATE/INSERT should affect exactly 1 row.
-- If any shows 0 rows affected, the title did not match — fix manually.
-- =====================================================================