Simply put, I need a developer who can modify the default OpenCart (OC) Products functionality (Add to cart function).
The mod will need to:
[url removed, login to view] user is logged in. (I believe standard OC functions can address this.)
[url removed, login to view] from an added MySQL table in the OC database. (Details below)
[url removed, login to view]:
[url removed, login to view] the OC product table to add a new True/False field called Customizable. ~ OR ~
[url removed, login to view] a different added MyQSL table in the OC database and if criterion match, set a True/False flag (called Customizable). This option does not require the alteration of the product table. (Option a. above.)
[url removed, login to view] the Customizable flag is true, the follow steps need to occur. Otherwise, treat the product as a standard OC product and ignore the remaining steps. (Currently we display a message to those who are not logged in encouraging them to log in and that is not part of this project scope, as it is already functional in our [url removed, login to view] file.)
[url removed, login to view] from an added table (user_library) in the OC db. The query is based on OC User ID and OC Product Model fields matching the table data.
[url removed, login to view] no matches occur from step 5, a message is to be displayed stating that the user must first create a customized design from the templates shown before adding the item to the cart. (Currently the display of templates AND launching of the designer to create a customized design is not part of this project scope, as it is already functional in our [url removed, login to view] file.)
[url removed, login to view] thumbnail image(s) based on data results from the step 5. Data results contain the thumbnail file name. (Actual thumbnail is stored on the site, not in MySQL)
[url removed, login to view] the thumbnail(s), the user MUST select one before they can add the item to the cart. I propose a required OC radio 'Options' field, but we are very open to ideas. (If step 4. above is false, this is NOT a required selection!)
[url removed, login to view] the user selects a thumbnail, other data retrieved with the MySQL query from step 5 MUST be included as static text with the item details in the shopping cart.
I have a proof of concept, but it is not functional regarding selecting a thumbnail and including the static text as part of the product details in the shopping cart, nor is the formatting set yet.
Ideally, I would like to make this an installable module, but I am not sure it will be possible seeing as how this essentially replaces the standard OC product page. Possibly this can be done using VqMod? As part of the project, we will need to know how to apply the mods to any OC cart we want (Based on it running the same version and template that the mod is created for). We also realize the changes will most likely result in a non-upgradable OC install without requiring additional customization. We are using the standard OC template.
If you have interest in this request please contact me ASAP as I am seriously behind schedule.
Based on interactions with other possible developers, there was serious concern from a developer that the added user_library table I mentioned above contains both a User_ID and Product_Model in the record and therefore will often return multiple matches. To explain why here is the scenario.
[url removed, login to view] creates a design based on Master Templates related to the OC Product_Model.
[url removed, login to view] the user saves their design using the Design Studio, (not in the scope of this project) a new Design ID is created and stored in the user_library table. This record also contains their OC User_ID and the related OC Product_Model .
[url removed, login to view] users will create designs and they should only see their designs. Therefore, the User_ID is required so each user sees only their designs.
[url removed, login to view] user can create multiple designs for the same product_model. As a result and as mentioned above the user can be shown multiple thumbnails when the User_ID and Product_Model match.
[url removed, login to view] yes, there will be multiple entries that contain the same Product_model AND User_Id in the user_library table, but the other data for e
Due to FL character limits, see attachments!