Problem of "One per household"??

[ez2ask]

Hi, I have a question about "Product Qty Maximum" and it's related to "one per houlsehold" order condition......

I have a product that limits "ONE per household" and I did set "Product Qty Maximum" to 1 and "Products Quantity Box Shows" sets "NO", this product has no attributes. So, one customer only allows to order one of that item.

When customer set up an account then order this item for one, there is no problem at all, but when customer finish the check out and add that product to cart again, the program allows the customer to order the second times, third times......... So, I found out there is one customer has more than one order at the same item.

My question is how to prevent that happened, is there anything that I forgot to set up or........ Please help!!! Hurry!!! Really appreciate!!

[Ajeh]

You would need to have some code customized to block purchase of these types of products based on previous orders ...

[ez2ask]

You would need to have some code customized to block purchase of these types of products based on previous orders ...

Thank you for the reply. Which file/function should I change and where is it? Can anyone help me? Thank you very much.

[Ajeh]

Most likely you want to block at the shopping cart ...

Have it automatically test the product ... if already bought ... throw a message and do not add it ...

[ez2ask]

Most likely you want to block at the shopping cart ...

Have it automatically test the product ... if already bought ... throw a message and do not add it ...

Thanks Ajeh!!

But, I still don't know which file and function and where I should modify. Would you mind telling me more about the coding part? Really appreciate!!!

[Ajeh]

I'd have to sit down and write it more than likely ...

You have to decide if:

1 product does not show once ordered (harder to do)

2 product is blocked from being added to the cart and message given saying failed

3 product just gives message No way ... No Checkout until you put it back

There are a lot of ways to do this ... I don't know what level of coding you can do ...

You might look at how the call for price is done and just switch the add to cart button ... but that does slow things down on a per product check for a previous order ...

You can look at the minimum/maximum/unit check is done and do a look up similar to that before adding to the cart ...

You need something to identify what the product(s) is/are that cannot be purchased more than once ...

You need something to check the orders_products table for products in orders for the customer to see what's been added ...

You need to decide what to do for customers not logged in ... as in what if they add 1 to cart that already is purchased then login?

So ... there are a lot of tests to be done here ... but you only want to test the specific products and not all products as that takes time on lists etc.

This is not to discourage you but to help you break down all the things you need to take into account to test can the customer buy the product ... and then decide how do you want to handle that ...

[ez2ask]

I'd have to sit down and write it more than likely ...

You have to decide if:

1 product does not show once ordered (harder to do)

2 product is blocked from being added to the cart and message given saying failed

3 product just gives message No way ... No Checkout until you put it back

There are a lot of ways to do this ... I don't know what level of coding you can do ...

You might look at how the call for price is done and just switch the add to cart button ... but that does slow things down on a per product check for a previous order ...

You can look at the minimum/maximum/unit check is done and do a look up similar to that before adding to the cart ...

You need something to identify what the product(s) is/are that cannot be purchased more than once ...

You need something to check the orders_products table for products in orders for the customer to see what's been added ...

You need to decide what to do for customers not logged in ... as in what if they add 1 to cart that already is purchased then login?

So ... there are a lot of tests to be done here ... but you only want to test the specific products and not all products as that takes time on lists etc.

This is not to discourage you but to help you break down all the things you need to take into account to test can the customer buy the product ... and then decide how do you want to handle that ...

Hi, Ajeh:

I guess you are right......there are lots of things need to consider and will make the coding more difficult. Hopfully, the next version of zencart will put this kind of situation to the core/main program and make it as one of the product's attribute or something else.......

Really appreciate your time to think of the problem for me and it's really help me to think this kind of situation deeply. Thank you so much for your help.