Thread: SQL To Set all products to a specific customer level

I have a customer level all customers get set to after login, my customer has not set new products in the database for the last 2 years to that customer level when adding them. it's customer level id is 2, so is there an SQL command that works on version 7.0.2.5 that will go through all products and add the customer level 2 to each product in the database?

thanks,

This should do it :-

Code:

DELETE FROM dbo.ProductCustomerLevel WHERE CustomerLevelID = 2; 
INSERT INTO dbo.ProductCustomerLevel (ProductID, CustomerLevelID) SELECT ProductID, 2 from dbo.Product;

TTFN

BFG

what does the delete line do, would just the second line work if I just want every product in the database to now have the checkmark for the customer level 2 beside it?

thanks for the help.

The delete clears out all of the old links first. Otherwise you might/would end up with errors. There are many different ways of doing the same thing. It's easier than trying to add only ones that are missing.

Run the script - it's solid advice. Of course, you should do this in a test environment first to be sure you achieve the results you are expecting.

worked great thanks.