Assigning Products to Product Groups

[Waggers]

This is one of those really stupid questions!

Being an art materials supplier we stock many different product ranges with the same name from different suppliers and to differentiate the products in the shopping cart I have given it product name similar to:

Genuine Naples Yellow Light – Old Holland Oil - 225ml

In order to cope with our mix and match discounts I have to create a product group for each size for each manufacturer – In this case Old Holland Oil 225ml.

The problem I have is when I come to assign select the members to the product group. The list showing the unassigned products isn’t wide enough to see the complete item description and I can’t see a way of expanding the window.

Is there a “back door” way via, say, the site’s ActinicCatalogue.mdb file?

We have several hundred products that are named in this way and I’m trying to avoid renaming all for them.

Richard

[Guest]

Hi Richard,

I am checking this with the development team and will get back to you at the earliest.

[Guest]

Hi Richard,

Hovering over each product in the list should display the full description.Using the Search in the Product Groups dialog may also help to find the desired products more easily.Alternatively if you are looking for a database hack then try the following:

1) Close Actinic.
2) Go to "C:\Program Files\Actinic v8\Sites\Site1", take a backup of the "ActinicCatalog.mdb" file.
3) Open DB with Access 2000 (or 2003)
4)Edit "DiscountProductGroups" table and make a note of the nID value for the group that you want to add/remove products to/from
5)Open the Product table and find the field nGroupID.Set nGroupID to -1 to remove it from all groups.Set nGroupID to n to add it to the group whose nID is n above.
6)Save and Exit Access before opening Actinic.

[Jan]

You can also set the group up in the product details, there is a drop down box at the top of the discounts page.

Regards,

[Waggers]

Thanks Sumiya and Jan,

I appreciate the info.

Richard