Commerce for products specific to various computer brands.
I am a DCommerce noob and am brainstorming on how to attack a new setup. I am relatively new to Drupal, but am an expert PHP developer and have written a few modules, so I am wet enough, and anticipate having to write a module for this project.
For this project, they sell accessories for computers. I want the buyers to either search for their model, e.g. "HP Model XYZ", or click through, e.g. "HP -> Model -> XYZ". After the computer product has been specified, I want to display the products for that particular computer brand.
I have read that for every version of a product, we need to create a new node. That seems like overkill, so I anticipate storing the products once, and using a customized table (that my module creates) to tie the computer models to the products.
The products will change enough to where my module will read the new inventory sheet from the manufacturer and update the product nodes automatically (so that is another thing I need to figure out how to do).
I hope this makes sense, and I'm not looking for a how-to, but for someone to nudge me in a direction or point me to some good references/resources -- or any good food for thought. I figure I will need to incorporate AJAX in this?
Thanks for any help.