Ordering in multiples (Product Qty Units) for wholesale customers?

Hi all,

I desperately need to figure out SOME way to get this done, and I'm sure there has to be a solution somewhere...I just can't figure it out.

The Dual Pricing mod works great for one thing we need, which is just wholesale pricing for our retail customers. However, here's the problem. We need regular customers to be able to order whatever number of units (usually it will be 1 only of a product), but wholesalers must only be able to order units in multiples of 4 (our wholesale 'packs') or 6 in the case of one product.

I am thinking maybe some combination of Dual Pricing with Product Qty Units, although i'm all for another solution if there is one.

I know enough PHP to get around, but not Zen Cart as of yet and am still learning how it works. I know basically I need to find a way to display one ordering option to regular customers and another to retailers/wholesale in multiples of a specified number.

Is there some way I can achieve this?

Thanks!

Skye

Why not just "clone" your store, separating the retail from the wholesale? Then, this and future problems would be much easier to solve. Just an idea.

That doesn't seem like a solution. Running two stores, two databases, having two admin panels, inventories, etc etc is not what I'm trying to achieve at all.

Yea, well, like I said...........it was just an idea. Didn't mean to ruffle any feathers. Sorry.

But, I don't think what you're wanting is been created, yet. Sound like a good project to work on, huh?

No feathers ruffled, just frazzled from reading my 100000th post in here looking for a solution. Don't mean to be short.

Maybe I can come up with something, I'm just hoping to find something I can do to the template quick-n-easy style that doesn't require too many brain cells. I thought maybe just a couple conditional statements somewhere in the template using this:

if##($_SESSION['customer_id'])##{
####$customers_id##=##$_SESSION['customer_id'];
########$customer_check##=##$db->Execute("select##*##from##"##.##TABLE_CUSTOMERS##.##"##where##customers_id##=##'$customers_id'");
##if##($customer_check->fields['customers_whole']##!=##"0")##{##
########
CODE##YOU##WANT##TO##USE##IF##CUSTOMER##IS##WHOLE##SALE

##}
}

not sure why it keeps sticking those #s in there, but that's the code to check if it's a logged in wholesale customer... just don't know what to do from there.