Magento 2 plugin, overriding promotional pricing
Budget: €250 – €750 EUR
I need a plugin that would override promotional pricing based on predefined SQL queries (for integration with external system that defines promotion rules). I will supply these SQL queries. The plugin must make it possible to populate several custom SQL tables via API calls, and use provided SQL queries to calculate promotional price based on info in these tables.
There will be two main SQL procedures , one will return promotional price for single item (in a given user/time/product context), it will also return information if the price differs based on the number of items ordered. If the price differs depending on number of items ordered the second procedure will return a table of "amount - price" pairs for a given product/user/time context.
There will be two main SQL procedures , one will return promotional price for single item (in a given user/time/product context), it will also return information if the price differs based on the number of items ordered. If the price differs depending on number of items ordered the second procedure will return a table of "amount - price" pairs for a given product/user/time context.