Jump to content

Which table is for the product quantities?


MikeM.
 Share

Recommended Posts

Hi there,

I have a hard time finding the product amounts in the prestashop.

 

This is the current setting on my products:

 

Use the advanced stack management for this product:  TRUE/CHECKED

 

Use the stack management based on the assigned warehouse: FALSE/UNCHECKED

 

Manually input the stock quantities: TRUE/CHECKED

 

 

I need the following information:

 

In which table

In which table can I find the quantities/amounts of the product combinations

In which table can I find the quantities/amounts of the product by settting it normaly through the "quantities tab"
In which table can I find the name of the product combinations?

Edited by MikeM. (see edit history)

Share this post


Link to post
Share on other sites

In which table can I find the quantities/amounts of the product combinations

 

ps_product_attribute

 

In which table can I find the quantities/amounts of the product by settting it normaly through the "quantities tab"

 

 

ps_product

 

In which table can I find the name of the product combinations?

 

ps_attribute_lang

Share this post


Link to post
Share on other sites

ps_product_attribute

 

ps_product

 

ps_attribute_lang

I set the quantity of product id 148 to 1000

 

checking the database, it's neither in one of these tables.

 

PS_Product:

T5Pd2jyl.png

lVCV9pPl.png

 

PS_Product_Attribute [correct because there are no available combinations on this product]:

ZSDjW5jl.png

 

PS_Stock:

JKPVP1ll.png

 

 

 

the rest is unnecessary to show.

 

 

 

I found it in:

 

PS_STOCK_AVAILABLE

 

A message to prestashop.

please do not save things tons of times...

 

 

seems like I had it bugged a few days ago, and now it works.

 

althrough I am still not happy with prestashop, even the source is like "what the heck is this?" as a php scripter myself...

Edited by MikeM. (see edit history)
  • Like 1

Share this post


Link to post
Share on other sites

  • 1 month later...

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
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More