Right - you're adjusting the cost because your pricing is based on a markup from cost, is that right?

Why not just calculate a "sale price" and import the sales price, and start/end dates from an Excel spreadsheet?