Module for database and discounts. Is there such a thing? Please read.

[Alex Nitu]

I'm a facing a problem with finding an app or a module that can do the following thing and maybe someone can point me into the right direction:

 

In our ERP we have a table of discounts based on quantity and we would like to apply different tables of discounts (ex: for 10+ pcs. price is "X", for 20+ pcs. price is "Y") to groups of products, and to show different tables for different groups of customers. As far as database goes, this table needs to be created inside the Prestashop platform (I didn't find any option inside the BO and therefore an app might be needed), then associated with the table_ID that comes out from the ERP. In the Prestashop platform, the table, for example (Table 42) needs to be applied to groups of products which we have grouped through a code, let's say 3DP.

 

So my full sentence would say something like: table_ID is applied to product_group 3DP, all applied to Customer group 1.

Or it can say: table_ID is applied to product_group 3DP and product_group 3DA, all applied to Customer group 1.

 

Well, maybe it's too much to think of more product groups, but at least one group would be enough for now.

 

Any idea if there is such a thing or do I need to contract somebody to create it for me?

['Woger]

If you just want to add a table to the database, most providers offer phpmyadmin, in which you can manage your database. Maybe it's easier or faster to change the PHP a bit so it recalculates the discount, but offcourse that would be for all products.

Can't you just make cart rules for every discount? Like giving 5% when amount is 10 and ging another 5% when amount is 20 etc. ? 

[Alex Nitu]

If I would do that it would kinda defy the purpouse. The customer needs to see the table inside product page. So among the information on product page, there has to be a table (as in displayed table) of discounts based on quantity, and applied to certain client groups. It won't help me set up cart rules for thousands of products or the "around 60 tables" that I have to display for 60 groups of products (not just 60 products). So, yes, you are right in saying that I need to use a table inside the DB but that means writting a module that can use customer groups, products (customized with my product group code) and then the said tables.

 

So, any way I look at it, seems that the project has to be created by a programmer.

 

The reason I posted this is because I thought there might be a module (that I couldn't find) that can already do this, and I'm still waiting on info if somebody knows something.