I know that for each product I can set a maximum order quantity to -1 (unlimited) but I have about 400 products and would like to know where in SQL I can simply go and do a mass add of these (if this is indeed the fix). I imported my products from a spreadsheet I created for version 3.98

When I try to add a product to the cart I get the attached message.

While I'm here, another quick question. I read somewhere that when doing updates you should blow away the old install and reinstall. Should I just not delete the files then? Or has this changed and now doing upgrading is better than uninstalling old module. It's kind of a pain if I would have to completely reinstall, and I can't imagine a company with over 1000 products would want to do this.

Cheers,

-Mike

Here is a sql statement to update all your products with max order qty of -1. From Sql Mgmt Studio execute the following sql:

update smith_products set maxorderqty = -1

To upgrade the module just install the new version over the old one from dnn host -> module definitions menu. As always make sure you have a full backup of your site before installing any new modules.

-Scott

---

Scott Kelly
Project Manager

Agreed! The cart also tests for null now and will not apply the rule which in the end gives you the same result.

---

At your service,
Dave Smith