inventory

Is there a suggested way to keep track of inventory in CBSubs?

tofraser wrote: Is there a suggested way to keep track of inventory in CBSubs?

Please clarify - I have no idea what you are asking.

For instance, using the merchandise plan type, I have 20 widgets in stock and don't want to sell more than I have in stock. Can I enter the quantity of items in my inventory into the plan so that the system won't sell more items than I have in stock?

Thanks,
Tim

Hi Nick,

Bumping this one to see if you have an answer.

Thanks,
Tim

tofraser wrote: For instance, using the merchandise plan type, I have 20 widgets in stock and don't want to sell more than I have in stock. Can I enter the quantity of items in my inventory into the plan so that the system won't sell more items than I have in stock?

Thanks,
Tim

Nothing out of the box.

Only thing I can suggest is to create a table in your database that contains the inventory amounts of the merchandise items. table could have columns like: id, merchid, stockamount

Then use the CB SQL integration to decrement the relevant merchandise row stockamount in this table everytime a merchandise item is purchased

Then use the CB Query field (available to Professional members) to grab the current stockamount value.

Finally configure the merchandise plan in CBSubs to conditionally appear only if stoclamount is > 0.

This could work - at least for existing (already registered) users trying to purchase.
I don't think its possible for registration process though.

Thanks, Nick. I think it would be necessary for the system to work for people who were not registered, so hopefully it won't be a deal breaker... I'll let the client decide... hopefully, they'll be able to develop a manual process for now and just refund people if the stock runs out.