Hi all
I have a few questions looking at the demo shop data:
Does oxarticles.oxprice always include tax or can it be set per shop?
How is the tax percentage linked to oxarticles? (oxarticles.oxvat is empty)
Is which table are the languages configured for oxtitle, oxtitle_1? (and by extention all the other locale related text fields)
In which table is the number (and names) of languages set?
Thanks
Schalk Vorster
Hi,
oxarticles.oxprice is the base article price in DB. This base price is used for later computation in oxArticle::getPrice() where VAT and other price modifications like discounts are applied in this step. If oxarticle.oxvat is empty, the eShop tries to use VAT from oxcategory data (if the article is assigned to any), and if that one is empty too, then the eShop takes the default VAT, entered in Admin interface as dDefaultVAT option.
As for languages - all available languages are entered in Admin/Master Settings/Languages. Language ID is used as a suffix for all language fields, except where language Id is 0, the suffix is skipped. e.g. texts for german language in demoshop are in oxtitle column, and texts for english - in oxtitle_1.
The array of languages is kept in oxconfig parameters aLanguages and aLanguageParams (also related oxconfig values are aLanguageURLs and aLanguageSSLURLs).
I hope this info helps 
Best regards,
Šarūnas Valaškevičius