With this simple sql query we are going to add, in an easy and fast way, the categories in another store INSERT into `oc_category_to_store` (category_id, store_id) SELECT category_id, 0 from oc_category; Replace the 0 (zero) with the id of the other store(id).