How to use my own PK on products/ categories

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
12 years ago
Hello,

I am working on syncing my internal products database with nopCommerce, therefore most products already exist in  internal db, and I would like to upload them to MSSQL nop-database.
I want to re-use all PK's that are in internal DB since it would make it easy for me to match them and automate the sync. It does not allow me to manually add the PK, since the PK is set to autoincrease in the DBMS.

How can i change it so I could add my own PK numbers, but I also want the DB to continue behaving properly if I use the admin CP and add products manually?
0
12 years ago
SET IDENTITY_INSERT [table name] ON

when done

SET IDENTITY_INSERT [table name] OFF
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.