Hi cablesnetc,
This project will involve, using Salesforce DataLoader Tool.
Here is my plan to execute the project
1) Receving all Products in csv (or any other format ) , that's mutually convenient.
2) Load All Product Records
3) Create 4 Separate PriceBooks as per Salesforce format and after applying the calculations in Excel.
4) Upload them back in Salesforce
Thanks,
Krishna
P.S. About Me
I am certified Salesforce Developer, Advanced Developer & Administrator.
I have also cleared Sales Cloud, Service Cloud Consultant certifications from Salesforce.
Apart from that, I am ceritified Microsoft Professional and Oracle Certified Associate.
I have been working , consulting Salesforce projects for last 7 years and have overall IT experience of 11 years.