AbleCommerce Shopping Cart Software

Is there a way to enable group restrictions for all products currently in the store?

We are using AbleCommerce GoldR9 (build 7670) and have an item database of ~60K items. I'm hoping there is a way to enable group restrictions for all items. We have the groups set up already. I looked into the batch editing feature, but it still looks like a manual process of individually enabling the restrictions for each item.

Is it possible to perform a SQL update query that could enable this for all products?

You can use the Data > Import > Products feature. There is an option to update products. You can individually select which fields to work with, so you'll have an easier time in working with the large data set.

You will need to first enable group restrictions and then assign one or more groups. You can export using the fields below:

EnableGroup
ProductGroups

I would also include Product ID and name.

Then add the values. TRUE for the "EnableGroup" column, and your Group Name(s) for "ProductGroups" column.

Once you have your CSV file completed, you can update all the products. I would make a database backup first though.

I'm sure this could be done with an SQL query, but it would be difficult unless all the products had the same group name. With a spreadsheet to work with, you can at least use Excel's fill or copy feature to update large groups of products at once.

Thanks. This looks very doable.