Changing items in database table but not changing in BO

[Whispar1]

Hello,

 

As a way to try to make mass changes easier, I am looking at manually changing items in the database tables.

For instance, in PhpMyAdmin I go to my database and open the ps_product table. From there, I need to change many of the manufacturer references in id_manufacturer from lets say 1 to 3. However, after I make the change, the back office does not change. The item I changed is still "1" and not "3".

Can anyone help me understand why changing the database does not update the back office?

Edited May 2, 2014 by Whispar1 (see edit history)

[NemoPS]

Hi!

Have a look at the ps_product_shop table, it has the very same structure of ps_product

[Whispar1]

Thank You Nemo,

So you are saying that ps_product_shop is where I would make the changes to show in BO?

Just curious, why have two tables that have the same information? Seems redundant?