Jump to content

SQL data names?


galleriaaurea

Recommended Posts

  On 1/31/2017 at 10:31 AM, galleriaaurea said:

Hello,

i know that ps_product>price shows price tax EXCLUDED

in which variable the price TAX INCLUDED is stored, please?

in which "show if article is absent (yes/not"?

in which "text to show if article is absent"?

 

THANK YOU

 

Hi,

 

ps_product.price is base price, not price tax excluded. It's quite often the same, but sometimes these two may differ.  

 

Price with tax isn't stored directly in DB. Reason is simple - the tax may be different for every shipping / invoicing address, see tax rules. 

Link to comment
Share on other sites

  • 2 weeks later...
  On 1/31/2017 at 10:31 AM, galleriaaurea said:

Hello,

i know that ps_product>price shows price tax EXCLUDED

in which variable the price TAX INCLUDED is stored, please?

in which "show if article is absent (yes/not"?

in which "text to show if article is absent"?

 

The active field determines whether an article is visible or not. If it is not there is no trace of it.

 

When an article is not available (out of stock) you get the message from the available_later field in the product_lang table.

Link to comment
Share on other sites

  On 2/14/2017 at 3:27 PM, musicmaster said:

The active field determines whether an article is visible or not. If it is not there is no trace of it.

 

When an article is not available (out of stock) you get the message from the available_later field in the product_lang table.

Thank you, but there is an other field: the one that you change in quantity field. i show it to you : it's the one evidenced in this image (it's in italian, i hope you'll understand)

siono.jpg

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...
tracking pixel