I made a simple SQL script that will update all of your catalog_items catalog_name to match the furni's public name. This specific code should work fine with MySql
Arcturus
Plus R2
For the newbies:
Run this SQL using Navicat/phpmyadmin, go to your hotel and type :update catalog
Arcturus
Code:
UPDATE catalog_items INNER JOIN items_base ON catalog_items.item_ids = items_base.id SET catalog_items.catalog_name = items_base.public_name
Code:
UPDATE catalog_items INNER JOIN furniture ON catalog_items.item_id = furniture.id SET catalog_items.catalog_name = furniture.public_name
For the newbies:
Run this SQL using Navicat/phpmyadmin, go to your hotel and type :update catalog