[Vtigercrm-developers] Help Needed

[Asha]

Hi Prashanth,

Also make sure to set the Product as active (1) in vtiger_products table,
without which it will not shown up in the popup selection window.

On 4/28/09, ding jianting <dfar2008 at gmail.com> wrote:
>
> Hi,
> Pls execute sql : "SELECT vtiger_crmentity.crmid,
> vtiger_crmentity.description, vtiger_products.*, vtiger_productcf.*
>             FROM vtiger_products
>             INNER JOIN vtiger_crmentity
>                 ON vtiger_crmentity.crmid = vtiger_products.productid
>             INNER JOIN vtiger_productcf
>                 ON vtiger_products.productid = vtiger_productcf.productid
>             LEFT JOIN vtiger_vendor
>                 ON vtiger_vendor.vendorid = vtiger_products.vendor_id
>             LEFT JOIN vtiger_users
>                 ON vtiger_users.id = vtiger_products.handler"
>
> and check product records from shopping cart.
>
> On Tue, Apr 28, 2009 at 9:04 PM, Prasanth <prasanth at aarthikaindia.com>wrote:
>
>>  Hi All
>>
>> I need to insert the product details from shopping cart to CRM. I have
>> inserted values to
>> vtiger_crmentity<http://192.168.0.48/phpmyadmin/tbl_properties_structure.php?db=vtigercrm504&token=f0b6aef7e27f0f501574bad56a57653a&table=vtiger_crmentity>
>> ,
>> vtiger_products<http://192.168.0.48/phpmyadmin/tbl_properties_structure.php?db=vtigercrm504&token=f0b6aef7e27f0f501574bad56a57653a&table=vtiger_products>
>> ,
>>  vtiger_productcf<http://192.168.0.48/phpmyadmin/tbl_properties_structure.php?db=vtigercrm504&token=f0b6aef7e27f0f501574bad56a57653a&table=vtiger_productcf>
>>  tables.
>> But while creating an invoice the newly added product name is not coming
>> in the pop up window for selecting the products.
>> Is there any table need to be updated for this
>> Pls help.
>>
>> Regards,
>> Prasanth D
>>
>> _______________________________________________
>> Reach hundreds of potential candidates - http://jobs.vtiger.com
>>
>
>
>
> --
> ________________________________________
> 上海易客CRM 丁远
> 地址：上海市徐汇区零陵路零陵路631号爱乐大厦
> 电话：021-64876448        传真:021-64876441
> 手机：(0)13701696656     Email:dfar2008 at gmail.com<Email%3Adfar2008 at gmail.com>
> -----------------------------------------------------------------------
>
> _______________________________________________
> Reach hundreds of potential candidates - http://jobs.vtiger.com
>



-- 
Regards,
Asha
vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090511/a691623e/attachment-0003.html