galleriaaurea Posted January 31, 2017 Share Posted January 31, 2017 Hello,i know that ps_product>price shows price tax EXCLUDEDin 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 Link to comment Share on other sites More sharing options...
DataKick Posted January 31, 2017 Share Posted January 31, 2017 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 More sharing options...
galleriaaurea Posted February 14, 2017 Author Share Posted February 14, 2017 thank you.what about the other 2 fields, please? Link to comment Share on other sites More sharing options...
musicmaster Posted February 14, 2017 Share Posted February 14, 2017 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 More sharing options...
galleriaaurea Posted February 17, 2017 Author Share Posted February 17, 2017 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) Link to comment Share on other sites More sharing options...
DataKick Posted February 17, 2017 Share Posted February 17, 2017 This field (in english When out of stock) is stored in table ps_stock_available, column out_of_stock. It can have 3 values: 0 = deny orders 1 = allow orders 2 = use global settings as set in the Products Preferences page Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now