Product Matrix pricing

[reetp]

I can't quite believe this is so hard.

Our pricing per product does not work on a percentage discount system over quantity (and I can't change that). Yes, we can discount off the total but the basic matrix itself is fixed.

We have set prices per quantity per product.

We can't do base price  -5% / -10% / -20%

Each item has a set of fixed prices eg

Item1 - 50 @ 10.50 - 100 @ 9.50 - 250 @ 8.50

Item2 - 250 @ 3.45 - 500 @ 3.30 - 1000 @ 3.20

This is effectively in a spreadsheet like this:

Product  50 100 250 500 1000 2500 5000

Item1 10.50 9.50 8.50 - - - -

Item2 - - 3.45 3.30 3.20 - -

I did see this module from a long time ago but it doesn't seem available.

 

 

I have looked at some other modules (and asked a developer on one) but nothing seems to suit.

Seems this has been asked before.....

 

Had a look at this but it doesn't display matrix pricing as far as I can see.

 

 

Any suggestions? Otherwise I'm not going to be able to use Prestashop.... !

[Fabrice]

Hi !

I had the same/equivalent problem : we created an excel file, and exported / imported the csv this to a dedicated table.

Then, we imported the prices live from this table. And yes, i am also using Att Wizard pro to display our products.

A good developper should be able to manage this.

Good luck !

Fabrice

[reetp]

Ok - thanks.

I have all the data in CSV or XML so that isn't an issue.

Display is the problem. Interesting you can use Att Wizard - I'll have a look thanks.

[selectshop.at]

Attribute Wizard pro module should be the option you need. It is the only module you can show what you want. Perhaps the cheaper Attribute Wizard or the Attribute Grid fulfills also what you need. Take a look into these two as well.

[reetp]

Thanks for the reply.

Do you actually have a demo that we can try testing to see if we can get the kind of layout we want?

Primarily users cannot buy direct from the site as there are too many variables that we cannot easily price.

So in the simplest instance we would simply like to display a price matrix.

Second, if possible, they could add various items & quantities to a basket so they can get a rough idea on prices, and then be able send that and ask for a quote.

Clearly if they add say 300 they would get the 250-499 price.

We could see they want pricing on say 350 Product X and 1000 Product Y

Last, is it possible to update pricing via the API rather than messing around with spreadsheets etc?

Thank you.

[reetp]

NB - USD300 is a lot of money to spend if it doesn't do exactly what I require !!

There's a limit to how much I'll just throw away on testing 🙂

[selectshop.at]

I think on changeo-site there are demos. I bought the pro version for myself about 7 years ago and also the attribute wizard for some of my customers. Contact the developer if you want detailed answer to the features.

[Fabrice]

Again: you will have to make some changes on the code to make this work. But this module is an excellent base/start and has an interesting approach for displaying things thats PS will not be able to do natively.

[reetp]

Many thanks for everyone taking the time to reply.

I'm trying to get something similar to this - this is just a simple display mode:

https://www.picpasteplus.com/view.php?i=zjsjk48jwp44xpc4sjq4nk81.jpg

More advanced would ideally be they could type in how many they want to get a rough idea of price, and request a full quote.

[reetp]

Just seen I can add files here !

Like this roughly.

[reetp]

19 hours ago, ndiaga said:

You can  use  the  matrix  of   combination  prices  like  this module  does:

 

Hmmmmm. Not sure I see how.

I need some way of adding fixed pricing into Prestahop and I just don't see that.