Post by jloberg » Tue Apr 10, 2012 6:57 pm

Simply put, I need a developer who can modify (preferably as an installable module) the default Products page.

The mod will need to:
  • Read from a new MySQL table in the OpenCart database.
  • Based on UserID & Product ID match it will display thumbnails. (Stored on the site, not in MySQL)
  • These thumbnails need to be a (radio selection?) 'Options' field.
  • If a differnt MySQL query matches, this 'Option' field will be requried.
  • The selected text data HAS to be part of the product's cart submission.
I have a proof of concept, but it does not function regarding getting the Option Field to add to the cart.
Ideally I would like to make this an installable module, but I am not sure how seeing as how it is basically a replacement to the product page. Maybe VQMOD?

If you have any interest in this request please contact me ASAP as I am behind schedule for this mod.

Thank you,
jloberg

Newbie

Posts

Joined
Tue Apr 10, 2012 6:22 pm

Post by jloberg » Thu Apr 12, 2012 4:02 am

Clarifications based on a failed attempt.
OC = OpenCart
  • Modify OC product table to add a new True/False field called Customizable.
  • If the product is marked as Customizable the follow will occur. Otherwise treat the product as a standard product.
  • Read from an added table (user_designs) to the OC db. Results must match OC User ID and OC Product Model.
  • Display a thumbnail image based on results containing the thumbnail file name.
  • The user MUST select one of the thumbnails as a product option. The data associated with the thumbnail will be the product option, not the thumbnail image.
  • The data from the selected thumbnail option must be part of the shopping cart, but the user cannot change the value of the data.
  • If there are no matching results a message will be displayed that the user must first create a customized design before adding the item to the cart. (Currently the display or templates AND launching of the designer to create a customized design is not part of the project scope)
There was a serious concern from the first developer that attempted this that the user_designs table I mentioned above contains both a User_ID and Product_Model in the record and there could be multiple matches. To explain why here is the scenario.
  • User creates a design based on Master Templates related to the Product_Module.
  • When the user saves their design a new ID is created and stored in the user_designs table with their OC User_ID and OC Product_Model
  • Many users will create their own designs based on the same product_model. So User_ID is required so each user sees only thier designs
  • A user can create designs for any products (product_model) that are marked as customizable = true
  • A user can create multiple designs for the same product model. As a result and mentioned above the user can be shown multiple thumbnails when the User_ID and Product_Model match. This is why the user must select the thumbnail of the design they want to use as a product option. So yes, there will be multiple entries that contain the same Product_model AND USER_ID, but the other data for that record will be different (the thumbnail file name and data to be included as the product option).
Anyone interested in doing this, I REALLY need to make sure that you fully understand the need before you start it. It is not fair to anyone to spend time on this if they do not understand it until they have a lot of their (and my) time invested.

Newbie

Posts

Joined
Tue Apr 10, 2012 6:22 pm

Post by jloberg » Sat Apr 14, 2012 8:45 pm

Wow,

We are amazed that what we thought would be a relatively simple request (as we do it now with straight PHP) would pose to be such a challenge to integrate with OpenCart.

For over a month now, we have been trying internally and reaching out through various freelance sites and even with this thread to the OpenCart devloper community looking for someone to help us. We are not even asking for free help, just someone that can us do what we need done.

We had one gentleman who tried and was unsucessful. I can't blame him, it was apparently due to a misunderstanding of the project. We have since cleared up the request documentation and reposted the specific needs. We have not had anyone contact us since.

We do NOT want to give up on OpenCart as it seems like a very solid Ecommerce solution with MANY bells and whistles we see as benefical and we looked forward to learning and building on it. We even planned on using it as the foundation for our Consumer version for our Design Studio.

We are making one last attempt on this thread and we will also reach out to a few OC developers directly to see if we can find someone to help us solve what we thought was a relatively simple project.

If you have knowledge of the Product Controller and how to change it, we want to talk with you.

Thank you!
Jerry

Newbie

Posts

Joined
Tue Apr 10, 2012 6:22 pm

User avatar
Active Member

Posts

Joined
Thu Nov 11, 2010 6:11 pm
Location - New Zealand (Tokomaru, Palmerston North)
Who is online

Users browsing this forum: No registered users and 5 guests