Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSCommerce and SPPCgroup


m.n.thomassen

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...