By DavisProjects on

Hi Everyone.

Am looking to move over to drupal. I have found solutions to pretty much everything except for 3 functionality issues.

1. Product Quotation database.

We are looking to adapt our old quotation database and integrate it into our site. Basically each of our products have 3 attributes, material, finish, and backing structure. For each product there is several options of each attribute. Each user can flag various options and it will generate a budget price for the sales person to use.

What modules will be able to do the above or near enough?

⋅ Categories: Drupal 6.x

Comments

mradcliffe’s picture

mradcliffe
he/him
Primary language English
commented

Does this project require ecommerce functionality or are you just displaying products and generating quotes for those products?

You could use CCK and (ecommerce or ubercart) to create "products" and "orders" (ubercart attributes may help though they are limited by design). For quotes you may use Ubercart Quotes. If you don't want the robustness of an ecommerce solution you don't have to bother with it.

You could just create a "product" content type and a "quote" content type that has a node reference to the product. You can create views for salespeople to browse quotes by exposed filters (a kind of faceted search). You can also make views for customers to browse products by exposed filters.

A quote content type might have a node reference field, a status field, a hidden sales price, a field for each of the attributes that's radio buttons or selects, etc... and then let customers create quotes. You could create a custom module that uses hook_nodeapi to act on the various fields to set the correct price (I bet the math for that is already done).