Jump to content

Where is the product price located in the DB ?


Bjarstal

Recommended Posts

Hi

I try to figure out where the product sell price is stored in the DB. I've found 2 locations and they are

ps_product
ps_product_shop

If I in 

ps_product_shop

change the price the change also take place in Backend and in Frontend, and it is all fine, but if I make the change in

ps_product

nothing at all happens neither in Backend, nor in Frontend. So what is then the price in

ps_product

all about, from where does it come and what is its purpose?

I ask for your help because I intend to set up a way of using Dolibarr as the center of my websites and when changing the price or other info about a product in Dolibarr, it will via SQL commands and Cron be distributed to my other sites. I intend to use the product reference to identify the product on all sites.

 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...