New Module - Product Option Value

Hey OCCF,

I am working with subscription products. I am trying to add a product option (select) with a drop down that displays a query of the customers past purchases. The objective is to allow the customer to log in and select a product subscription they already purchased and allow them to add on items or upgrade the entire package.

Need some guidance on where/how to set this up. Where should this query be set up?
1. catalog/model/catalog/product.php
2. admin/model/catalog/product.php
3. Or would this option "type" need to be added/linked to the oc_option table as a stored procedure of some kind?

Any help, or suggestions are appreciated. TY

Hi,

as a new forum user, please read the most recent forum rules. No OC version posted, no URL / screenshot of a provided example regarding the posted theory.