OSCommerce and SPPCgroup

[m.n.thomassen]

I installed OSCommerce together with SPPC and it works perfect for my customer groups.

 

Byt for several customers i have specific agreements,

so i need a kind of 'customers_products' functionality.

 

Customer A has a price X for product A.

Customer B has a price Y for product A.

 

If there a solution or contribution for the issue i mentioned above?

 

Thanks,

Marcel

[Jack_mcs]

Create a group for customer of type A and type B and assign the prices accordingly.

 

Jack

[m.n.thomassen]

Jack,

 

if it was that easy .....

 

We are talking about 10000 products for about 5 customer groups (50000 rows in products_groups). Thats necessary.

 

But for about 50 customers i have about 100 products customer specific agreements.

 

With then option you mentioned i have to define 50 customer specific customer groups,

which means 500000 rows in products_groups. The advantage is that it is what i want,

but there are a few disadvantages.

 

1) More maintenance (can be automated, maybe)

2) Less performance (in theory. I don't have experience with mysql databases of this size on a webserver)

3) More disc-space (in theory. I don't have experience with mysql databases of this size on a webserver)

 

If you think and can confirm that the disadvantages mentioned are due to the fact that i

don't have the experience, but in fact are no issue at all, i would be very happy.

 

Thanks,

Marcel

[Jan Zonjee]

I installed OSCommerce together with SPPC and it works perfect for my customer groups.

 

Byt for several customers i have specific agreements,

so i need a kind of 'customers_products' functionality.

 

Customer A has a price X for product A.

Customer B has a price Y for product A.

 

If there a solution or contribution for the issue i mentioned above?

No, it doesn't exist. Should not be too hard on the catalog side to implement but making an admin page to administer this would be ... a challenge.

[m.n.thomassen]

I created a table named products_cusomers,

with the fields name customers_id, products_id, customers_price,

but because i don't have a lof of experience with php,

i would like someone to help/guide me in a few php-files.

 

I suggest:

1) oscommerce/products_new.php

2) oscommerce/includes/classes/products_shopping_chart.php

 

I allready tried to modify the code between

// BOF Separate Pricing Per Customer

and

// EOF Separate Pricing Per Customer

but with no succes

 

Thanks,

Marcel