Search Forum Home   DotNetNuke  CATALooK.netStore  Importing Produ...  Importing Product Attributes    2/16/2010 2:52:35 PM SCI-1DDF17DA6B834B91BF8779A7D8E34139 2 posts Importing Product Attributes Can the attributes applicable to a product be specified when importing products from Excel ?  5/5/2010 12:02:19 PM SCI-113361 4 posts Re: Importing Product Attributes The way I do this is using a SQL statement after importing the data. Below example is for three attributes - change the product number to the range you need. Add/subtract the attributes as needed. INSERT INTO {databaseOwner}CAT_ProductsOptions (ProductID, OptionID, Vieworder) select ProductID, 1, 0 from CAT_Products where ProductID > 100 and ProductID < 1000 and ProductID not in (select ProductID from CAT_ProductsOptions where OptionID = 1) INSERT INTO {databaseOwner}CAT_ProductsOptions (ProductID, OptionID, Vieworder) select ProductID, 2, 0 from CAT_Products where ProductID > 100 and ProductID < 1000 and ProductID not in (select ProductID from CAT_ProductsOptions where OptionID = 2) INSERT INTO {databaseOwner}CAT_ProductsOptions (ProductID, OptionID, Vieworder) select ProductID, 3, 0 from CAT_Products where ProductID > 100 and ProductID < 1000 and ProductID not in (select ProductID from CAT_ProductsOptions where OptionID = 3)  Page 1 of 1   DotNetNuke  CATALooK.netStore  Importing Produ... Flat View Tree View Oldest To Newest Newest To Oldest