gerstavros Posted July 12, 2022 Share Posted July 12, 2022 I want to export in an app the product's discounted price but i can't find it in database. Where is it? Also is there a full database structure documenation? I could only found a pdf for ps 1.4 version... Link to comment Share on other sites More sharing options...
Daresh Posted July 12, 2022 Share Posted July 12, 2022 It's not that simple, a discount may not be that general, it may depend on specific customer group, country, currency adn more. So one product with a single base price can have many discount prices under different conditions. Db structure documentation - I don't know any... Link to comment Share on other sites More sharing options...
gerstavros Posted July 12, 2022 Author Share Posted July 12, 2022 41 minutes ago, Daresh said: It's not that simple, a discount may not be that general, it may depend on specific customer group, country, currency adn more. So one product with a single base price can have many discount prices under different conditions. Db structure documentation - I don't know any... Ok but where is the declaration of which product is into each discount for example? Link to comment Share on other sites More sharing options...
Daresh Posted July 12, 2022 Share Posted July 12, 2022 It's mainly in specific_price table, but a group discount may be also assigned to a customer group. 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