[Vtigercrm-developers] Help Needed

ding jianting dfar2008 at gmail.com
Tue Apr 28 06:19:39 PDT 2009


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>
-----------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20090428/8c114402/attachment-0003.html 


More information about the vtigercrm-developers mailing list