07-10-2012 08:49 AM
07-10-2012 09:36 AM
Internally, you have two Product Tables:
So, the only way I've been able to do that is to create a custom table, linked to the Master Product Table, with the additional fields... then a pretty tricky plugin that detects new Ops and writes the linked data
07-10-2012 10:55 AM
Hopefully I'm understanding this correctly. Creating a new product, adds that item to the product table where various parameters are set for it such as the name, price, itemID and cost. When a product is added to an opportunity, an OpportunityProduct is created based upon an item from the product table, but now coupled with relative opportunity information.
If you're doing this programmatically (creating the product), when you add a custom product to an opportunity, so long as the fields are set, it should populate automatically.
07-11-2012 02:57 PM
No Matthew, it does not. Say for example you add a custom Product field for “unit of measure” (each, per foot, 12 per case, etc.) to TBL_PRODUCT. The field does not populate when I enter a product name. As Mike indicated above, there are 4 fields that are linked to PRODUCTID (NAME, ITEM, COST, PRICE) and these are the only fields that populate automatically. (Try it!)
Custom product fields must be entered manually each time a product is added to an opportunity. Go figure…
What is the master product table called? Is TBL_PRODUCT the master table?
Also, look at the SQL diagram below. There are a few things that are kind of odd.