+ Start a Discussion

Product and Product2 Objects as they relate to using an External ID custom field

OK...why can't I create a product, using the External ID flag for the key (call it somesite_product_SKU__c)?  I created a custome field, designated it an External ID, yet when I try to create the prodcut,  get the following error:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sf="urn:fault.partner.soap.sforce.com"><soapenv:Body><soapenv:Fault><faultcode>sf:INVALID_FIELD</faultcode><faultstring>INVALID_FIELD: No such column &apos;Nexternal_Product_SKU__c&apos; on entity &apos;product&apos;. </faultstring><detail><sf:fault xsi:type="sf:InvalidFieldFault"><sf:exceptionCode>INVALID_FIELD</sf:exceptionCode><sf:exceptionMessage>No such column &apos;Nexternal_Product_SKU__c&apos; on entity &apos;product&apos;. </sf:exceptionMessage><sf:row>-1</sf:row><sf:column>-1</sf:column></sf:fault></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope>

The field exists in Product 2 not Product even though I used the custom field setup in Product to establish this relationship.  I need to use an External ID and the Product object fields not the fields available by Product 2.....anone have any idea about this???