Try using Data loader, First, you need to be uploaded to the Standard Price Book, this is where the Product ID's are created. Then after you set up each Product with a Standard/List price you can create a Price Book Entry for each of the Products you want to add to the specific custom Price Books.
Try using Data loader, First, you need to be uploaded to the Standard Price Book, this is where the Product ID's are created.
Then after you set up each Product with a Standard/List price you can create a Price Book Entry for each of the Products you want to add to the specific custom Price Books.
https://help.salesforce.com/articleView?id=data_loader.htm&type=5
Thanks,
Vinay Kumar