Thread: Import

Is it possible to import directly into the category table or does a script alter multiple tables when creating a category through the admin portal?

If all you're doing is creating a category you can insert it directly into the DB. Once you get into mapping products to the category, you'll also need the ProductCategory table.

Due to the CatID being an identity I am unable to import into that field. Any suggestions?

You can insert into identity fields, you just have to turn that on:

Code:

set IDENTITY_INSERT [dbo].Category ON;
INSERT [dbo].Category(CategoryID,column,column,column,column,column,column, etc) values(value,value,value,value,value,value,value, etc);
set IDENTITY_INSERT [dbo].Category OFF;

Thanks Scott!!!

That must be new to 2k5 or 2k8? I jumped from 2000 to 2008.