Product attribute combinations and tier pricing

Is this possible?

Just to make sure to see if I did my configuration is right way. I have one product with main SKU 1000. I have many attribute combinations (30-of them) based on size and color and appropriate SKU

For example
blue color and size 100 => SKU is 1000-B-100
blue color and size 110 => SKU is 1000-B-110
blue color and size 120 => SKU is 1000-B-120
red color and size 100 =>  SKU is 1000-R-100

For every of those combinations I need to have possibility that I have prices per customer roles (tier pricing). Now I have all those like grouped and simple products inside but shop is very very slow as there is more then 7000 items in shop. I thought that having those in product variants will speed up shop but I can not find way to use tier pricing.

Marko

bubbi wrote:

I'm not completely sure I understand, but....

If you need to have tier pricing for your products based on the customer role, it is probably best to follow this logic:

CREATE PRODUCT
set Subject to ACL: "true", and Limited to Customer Role(s): Guest and Registered
create all appropriate attribute combinations
set price and tier prices which should appear for "normal customers"

DUPLICATE PRODUCT
change Limited to Customer Role(s): SpecialRole1
set price and tier prices which should appear for logged in "SpecialRole1 customers"

DUPLICATE PRODUCT
change Limited to Customer Role(s): SpecialRole2
set price and tier prices which should appear for logged in "SpecialRole2 customers"

Thank you for trying to help.

I'm nos sure I can go this way as every attribute combination needs to have tier pricing.

In my original example
SKU: 1000-B-100 - this combination (blue, 100 cm) has its own tier pricing and its different from 1000-R-100 (red, 100 cm). Lets say that you need 50+ pieces of 1000-B-100 for some discount for role Registered. For another role (SpecialRole1) you need 200+ pieces of 1000-B-100 as they already have lower price than Registered role.
As for 1000-R-100, Registered user need to buy 25+ pieces for discount price, and SpecialRole1 customer needs 120+ pieces to have reduction in price.

Basically I need possibility to set tier price per every attribute combination.

Marko

That's not possible out of the box, but you can at least configure a "Price override" on each attribute combination.
For example, you'd set the "Overridden price" value accordingly for each attribute combination.
And by following my previously recommended methodology, you'd be able to specify different prices for each product attribute combination.. for each product (one for each role)

Other than that, I think you'll need to develop (or have developed) a plugin.

But what is with different pricing for different quantities per attribute combination. That what you suggest can be done only for unit price (price override).

All this what I'm talking about is possible in a way I did it (out of the box) but I think that its slowing nopcommerce down).

I have created grouped product and inside that I have simple products as mush as combinations I have (sometimes 30). Every simple product is basically 1 attribute combination and then I can set tier pricing as mush as I need.

Having that, I ended up from 850 products to 7800 products and each of those products has at least 5 tier pricing (1 for each role where I set quantity at 1 and user role to role I want) and some extra for real tier pricing (xx+ pieces for role yy).


So I did cover all what I need but nopCommerce is taking about 70-100 sec to open for the first time. After that every category that I open needs cca 6-7 sec (after that its only 2-3 sec for those opened categories).

You can look this preliminary shop at http://shop1.pride.hr.

Example of 1 product with many simple products (attribute combinations)
http://www.shop1.pride.hr/product-empty-heavy-bag-without-filling-1000

Thank you really for trying to help.