Hi Prashanth,<br><br>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.<br><br><div><span class="gmail_quote">On 4/28/09, <b class="gmail_sendername">ding jianting</b> <<a href="mailto:dfar2008@gmail.com">dfar2008@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>Pls execute sql : "SELECT vtiger_crmentity.crmid, vtiger_crmentity.description, vtiger_products.*, vtiger_productcf.*<br> FROM vtiger_products<br> INNER JOIN vtiger_crmentity<br> ON vtiger_crmentity.crmid = vtiger_products.productid<br>
INNER JOIN vtiger_productcf<br> ON vtiger_products.productid = vtiger_productcf.productid<br> LEFT JOIN vtiger_vendor<br> ON vtiger_vendor.vendorid = vtiger_products.vendor_id<br>
LEFT JOIN vtiger_users<br> ON <a href="http://vtiger_users.id" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">vtiger_users.id</a> = vtiger_products.handler"<br><br>
and check product records from shopping cart.<br><br><div class="gmail_quote"><div><span class="e" id="q_120ece3727cec39f_1">
On Tue, Apr 28, 2009 at 9:04 PM, Prasanth <span dir="ltr"><<a href="mailto:prasanth@aarthikaindia.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">prasanth@aarthikaindia.com</a>></span> wrote:<br>
</span></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><span class="e" id="q_120ece3727cec39f_3">
<div bgcolor="#ffffff">
<div><font face="Palatino Linotype">Hi All</font></div>
<div><font face="Palatino Linotype"></font> </div>
<div><font face="Palatino Linotype">I need to insert the product details from
shopping cart to CRM. I have inserted values to </font></div>
<div><a title="InnoDB free: 8192 kB (142 Rows)" href="http://192.168.0.48/phpmyadmin/tbl_properties_structure.php?db=vtigercrm504&token=f0b6aef7e27f0f501574bad56a57653a&table=vtiger_crmentity" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><font face="Palatino Linotype">vtiger_crmentity</font></a><font face="Palatino Linotype">,</font></div>
<div><a title="InnoDB free: 8192 kB; (`productid`) REFER `vtigercrm504/vtiger_crmentity`(`crmid (12 Rows)" href="http://192.168.0.48/phpmyadmin/tbl_properties_structure.php?db=vtigercrm504&token=f0b6aef7e27f0f501574bad56a57653a&table=vtiger_products" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><font face="Palatino Linotype">vtiger_products</font></a><font face="Palatino Linotype">,</font></div>
<div><font face="Palatino Linotype"> </font><a title="InnoDB free: 8192 kB; (`productid`) REFER `vtigercrm504/vtiger_products`(`produc (12 Rows)" href="http://192.168.0.48/phpmyadmin/tbl_properties_structure.php?db=vtigercrm504&token=f0b6aef7e27f0f501574bad56a57653a&table=vtiger_productcf" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"><font face="Palatino Linotype">vtiger_productcf</font></a><font face="Palatino Linotype"> tables.</font></div>
<div><font face="Palatino Linotype">But while creating an invoice the newly
added product name is not coming in the pop up window for selecting the
products.</font></div>
<div><font face="Palatino Linotype">Is there any table need to be updated for
this</font></div>
<div><font face="Palatino Linotype">Pls help.</font></div>
<div><font face="Palatino Linotype"></font> </div>
<div><font face="Palatino Linotype">Regards,</font></div>
<div><font face="Palatino Linotype">Prasanth D</font></div></div>
<br></span></div>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://jobs.vtiger.com</a> <br></blockquote></div><span class="sg"><br><br clear="all">
<br>-- <br>________________________________________<br>上海易客CRM 丁远<br>
地址：上海市徐汇区零陵路零陵路631号爱乐大厦<br>电话：021-64876448 传真:021-64876441<br>手机：(0)13701696656 <a href="mailto:Email%3Adfar2008@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Email:dfar2008@gmail.com</a><br>
-----------------------------------------------------------------------<br>
</span><br>_______________________________________________<br>
Reach hundreds of potential candidates - <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br><br clear="all"><br>-- <br>
Regards,<br>Asha<br>vtiger Team