Way to store prices per part along with effective dates

Summary:

Is there any way by which we can store prices for parts with valid from and valid to dates.

Content (required):

We are getting Net Price for items from SAP via webservice call, want to avoid the same and store all the required prices in CPQ with timely data loads.

Part Net Price Valid From Valid To

1234 100 01-Dec-2022 31-Dec-2023

1234 101 01-Jan-2024 31-Dec-9999

Parts Master: It cannot be stored with multiple dates.

Price book cannot be implemented due to 30 price books limitations as well as no facility to mention dates.

Pricing Engine: No columns for Dates. In Bulk Download I can see "Range From" column, can we use this?