AbleCommerce Shopping Cart Software

I have a batch of around 1800 items that I want to restrict to a certain group. I've created the group and I know it's ID and I also know the productIDs of the 1800 items I want to add to this group.

What is the best way to add all of those items to a group. I should add that many of these items are also restricted to three other groups, and I want to keep those restrictions in place as well as adding the new group restriction.

Hi,

You can use the Data > Export > Products feature. Get 1 sample product setup with the group restrictions and export this single product to see how the fields need to be formatted. Select ProductId, EnableGroups, and ProductGroups for your fields.

Once you have the format of the column headings and data format, simply take your CSV file and make the adjustments to your 1800 items.

Backup your database!!

Then use the Data > Import > Products feature.

If you have any specific questions about how to use the feature, just let me know. It's a great little tool. Very powerful when making mass updates.

Katie