Thread: Import Products with Customer Levels

Hello,

I am building a store with over 6500 products. I am going to use the import products spreadsheet which the template has been provided inside the manual for ASPDNSF. However, these products need to be configured with Customer Levels on them. I can't seem to figure out how to do this, except to go one by one through 6500 products and update them in admin. If I look at the DB it's not any easier as the products customer level table is separate and requires the product id and then you can insert the customer level.

Does anyone have any ideas how I can do this without spending hours and hours going through each of the products one by one to enter the customer level?

Thanks
James

If I were doing this I would export the Product table (probably only ProductID and Name) to Excel. Then put your CustomerLevelID on the same row, and use Excel to create the insert statements for the ProductCustomerLevel table. And then run the resulting insert statements in the database.