Thread: SQL Import customer levels ?

Hello, trying to get this code to work:

UPDATE Product SET CustomerLevelID=1 WHERE ProductID=####;

Doesn't seem to be working.

Also trying to set Customer Level Extended Prices as well, so my products I uploaded will be selected for Customer Level, and then add the extended prices for those products

I'm trying to use my excel sheet to make a query, Product ID is column A, VariantId is column B, Customer Level is column C, and Extended Price is column D

Anyone know what I'm doing wrong ?

There is no CustomerLevelID in the Product table....

You need these queries :-

C#/VB.NET Code:

="INSERT INTO dbo.ProductCustomerLevel (ProductID, CustomerLevelID) values ("&A1&","&C1&");"
 
 
="INSERT INTO dbo.ExtendedPrice (VariantID, CustomerLevelID, Price) values ("&B1&","&C1&","&D1&");" 


TTFN

BFG