OKA Posted September 29, 2004 Share Posted September 29, 2004 I'm having problems with te buy_now-link. (I'm using the xsell_products_buynow.php version) The link goes to the product_info page, instead of taking it into the cart. The buy_now-link is: http://server/catalog/index.php?cPath=21&a...b0a487b353d8ee3 I think the problem is that the products_id is mentioned twice. But when I make a link hardcoded (just like one in product_listing.php) http://localhost/catalog/index.php?cPath=2...b0a487b353d8ee3, the link becomes correct, but the link goes to the product_info page too. Can anybody help, please? Quote Link to comment Share on other sites More sharing options...
Guest Posted September 29, 2004 Share Posted September 29, 2004 Can anyone please help, we are getting this error message in the products page just beneath 'Recommended Products': 1146 - Table 'pleasure_osc1.TABLE_PRODUCTS_GROUPS' doesn't exist select customers_group_price from TABLE_PRODUCTS_GROUPS where products_id = '32' and customers_group_id = '' [TEP STOP] Yet we installed the sql query below, which is atteched to the x-sell contr. ??? DROP TABLE IF EXISTS products_xsell; CREATE TABLE products_xsell ( ID int(10) NOT NULL auto_increment, products_id int(10) unsigned NOT NULL default '1', xsell_id int(10) unsigned NOT NULL default '1', sort_order int(10) unsigned NOT NULL default '1', PRIMARY KEY (ID) ) TYPE=MyISAM; Thank you Steve Quote Link to comment Share on other sites More sharing options...
optic Posted October 1, 2004 Share Posted October 1, 2004 Can anyone please help, we are getting this error message in the products page just beneath 'Recommended Products': 1146 - Table 'pleasure_osc1.TABLE_PRODUCTS_GROUPS' doesn't exist select customers_group_price from TABLE_PRODUCTS_GROUPS where products_id = '32' and customers_group_id = '' [TEP STOP] Yet we installed the sql query below, which is atteched to the x-sell contr. ??? DROP TABLE IF EXISTS products_xsell; CREATE TABLE products_xsell ( ID int(10) NOT NULL auto_increment, products_id int(10) unsigned NOT NULL default '1', xsell_id int(10) unsigned NOT NULL default '1', sort_order int(10) unsigned NOT NULL default '1', PRIMARY KEY (ID) ) TYPE=MyISAM; Thank you Steve <{POST_SNAPBACK}> Did you create the new fields in the database by inserting the products_xsell.sql? If not, then this is where your problem lies. If so, then fields were not created correctly. Quote Link to comment Share on other sites More sharing options...
Jos Medinger Posted October 26, 2004 Share Posted October 26, 2004 Hi Folks I've installed this contribution and all seems to work well apart from the fact that when I click on any row of the cross sell table, the page refreshes but nothing happens... This is what the scren looks like at that point but clicking on a row gets me nowhere The URL that is generated when hovering over 'Edit' in a row is... http://www.domain.com/catalog/admin/xsell...._product_ID=113 Does anyone have any ideas what I may have missed? Cheers Jos Quote =============== Simple yet Creative Get Online Web Design : getonlinedesign.com =============== Link to comment Share on other sites More sharing options...
Marvin Miller Posted November 6, 2004 Share Posted November 6, 2004 Thanks for writing this mod!! I installed this one (http://www.oscommerce.com/community/contributions,1415) and I did it at around 2 am half asleep and it worked right off the bat! Even though I know nothing about programming so you must have done something very right :thumbsup: I do have one issue though. In the admin it says you can prioritize the items you want cross selled and number them. I changed the numbers around but in the catalog it always shows them in the original order. No errors are given anywhere - do you know what causes this? Thanks; Marvin Quote Best & Thanks;Marvin----------------------osCommerce 2.3.3.4 Link to comment Share on other sites More sharing options...
Marvin Miller Posted January 3, 2005 Share Posted January 3, 2005 No-One? Quote Best & Thanks;Marvin----------------------osCommerce 2.3.3.4 Link to comment Share on other sites More sharing options...
designergirl Posted January 7, 2005 Share Posted January 7, 2005 Hi Folks I've installed this contribution and all seems to work well apart from the fact that when I click on any row of the cross sell table, the page refreshes but nothing happens... This is what the scren looks like at that point but clicking on a row gets me nowhere The URL that is generated when hovering over 'Edit' in a row is... http://www.domain.com/catalog/admin/xsell...._product_ID=113 Does anyone have any ideas what I may have missed? Cheers Jos <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
designergirl Posted January 7, 2005 Share Posted January 7, 2005 Hi, I am having the same problem with the X-Sell Prioritize. No errors, but just won't take the sort order changes. Did you find an answer to how to correct yet? Thanks! Hi Folks I've installed this contribution and all seems to work well apart from the fact that when I click on any row of the cross sell table, the page refreshes but nothing happens... This is what the scren looks like at that point but clicking on a row gets me nowhere The URL that is generated when hovering over 'Edit' in a row is... http://www.domain.com/catalog/admin/xsell...._product_ID=113 Does anyone have any ideas what I may have missed? Cheers Jos <{POST_SNAPBACK}> Quote Link to comment Share on other sites More sharing options...
babycakes Posted February 17, 2005 Share Posted February 17, 2005 Hi, I am having the same problem with the X-Sell Prioritize. No errors, but just won't take the sort order changes. Did you find an answer to how to correct yet? Thanks! <{POST_SNAPBACK}> Hi, A solution for you. B) Simply edit the file includes/module/xsell_products.php on row 15 change the following: $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by xp.products_id asc limit " . MAX_DISPLAY_ALSO_PURCHASED); TO $xsell_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name from " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' and xp.xsell_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by sort_order asc limit " . MAX_DISPLAY_ALSO_PURCHASED); Check your store, priority code should now display correctly. Hope this has helped many! Quote Link to comment Share on other sites More sharing options...
Marvin Miller Posted February 20, 2005 Share Posted February 20, 2005 That worked for me - Thanks Very Much!! :thumbsup: (it's been bugging me for a while) :'( Quote Best & Thanks;Marvin----------------------osCommerce 2.3.3.4 Link to comment Share on other sites More sharing options...
fatmcgav Posted February 23, 2005 Share Posted February 23, 2005 Does anybody know how to make the "We also recommend" box dissapear if there are no recommended products? Cheers Fatmcgav Quote Link to comment Share on other sites More sharing options...
osjunkie Posted February 28, 2005 Share Posted February 28, 2005 SUPER STORE X-SELL REQUEST How difficult would it be to make this contribution useful to owners of shops that have over 10,000+ products? I was thinking if you could have the option of having a drop down to pick a category of products and have it after you pick the product to add cross sell items to be presented the same category as the product. This way it would save a lot of time and confusion to manage a lot of products. If you can do this you are a hero! Brad Quote Link to comment Share on other sites More sharing options...
Pharkie Posted February 28, 2005 Share Posted February 28, 2005 How difficult would it be to make this contribution useful to owners of shops that have over 10,000+ products? <{POST_SNAPBACK}> Not that difficult. The biggest change I think is necessary is to 'integrate' the cross-sell admin into the main Product Management, rather than having a separate interface. Even the interface that it currently has isn't particularly OSC standard i.e. using all the right functions. It's a bit thrown together. If you can identify the main thing preventing it working with lots of products e.g. having to load thumbnails for each product, you may be best focusing on just changing that as a quick fix. To do it properly would take 2-3 days of work I should think. I'm afraid I really don't have time at the moment! Adam Quote Link to comment Share on other sites More sharing options...
fatmcgav Posted February 28, 2005 Share Posted February 28, 2005 Does anybody know how to make the "We also recommend" box dissapear if there are no recommended products? Cheers Fatmcgav <{POST_SNAPBACK}> Anybody know if this is possible???? Quote Link to comment Share on other sites More sharing options...
Pharkie Posted February 28, 2005 Share Posted February 28, 2005 Anybody know if this is possible???? <{POST_SNAPBACK}> It's possible, it's easy, lots of people have done it. It requires a small change to the PHP in the relevant page. I'm afraid I can't get you the details right now, but if you look it should be pretty obvious.. If not, I'll get back on to provide more help in a week or so. Quote Link to comment Share on other sites More sharing options...
fatmcgav Posted February 28, 2005 Share Posted February 28, 2005 (edited) It's possible, it's easy, lots of people have done it. It requires a small change to the PHP in the relevant page. I'm afraid I can't get you the details right now, but if you look it should be pretty obvious.. If not, I'll get back on to provide more help in a week or so. <{POST_SNAPBACK}> Yep, found it. I simply changed: $num_products_xsell = tep_db_num_rows($xsell_query); if ($num_products_xsell >= MIN_DISPLAY_XSELL) { to: $num_products_xsell = tep_db_num_rows($xsell_query); if ($num_products_xsell >= 1) { and it worked a treat. Cheers Fatmcgav Edited February 28, 2005 by fatmcgav Quote Link to comment Share on other sites More sharing options...
chique Posted March 14, 2005 Share Posted March 14, 2005 How difficult would it be to make this contribution useful to owners of shops that have over 10,000+ products? I was thinking if you could have the option of having a drop down to pick a category of products and have it after you pick the product to add cross sell items to be presented the same category as the product. This way it would save a lot of time and confusion to manage a lot of products. If you can do this you are a hero! If anybody can make this work, IT would be great! Quote Link to comment Share on other sites More sharing options...
oldworldcharms Posted March 25, 2005 Share Posted March 25, 2005 It is possible to add cross sell to the shopping cart page - shopping_cart.php This would be a great addition to this Thanks Elizabeth Quote Link to comment Share on other sites More sharing options...
DavidF Posted March 30, 2005 Share Posted March 30, 2005 Would it be a difficult task to modify x-sell to show additional products on a category page, not on an actual product page. The additional products that would be displayed would be based on the CATEGORY chosen, not based on the individual PRODUCT chosen. Has anyone tried this? Quote Link to comment Share on other sites More sharing options...
Bigredman74 Posted May 6, 2005 Share Posted May 6, 2005 I just installed "X-Sell v2-MS2 - Cross Sell for MS2" (21 Apr 2005) and the "Add a missing instruction" (25 Apr 2005) patch. When I click on the "Buy Now" button inside of the "We Also Recommend" box I am taken to the shopping cart, but the item is not being added to the cart. Everything else with contrib seems to be working fine. Any suggestions for this problem is greatly appreciated. Quote My Published & Modified Contributions Helpful Forum Topics: Basic Design Tips & Tricks | Simple Steps to Better Forum Searching | Speed / Performance Optimizations Link to comment Share on other sites More sharing options...
Dont Mess With Texas Posted May 10, 2005 Share Posted May 10, 2005 I just installed this also, is their a admin feature to this that i have to set and if so how to i access it since i dont see anything in my CP. Also does the images generate on random or do i have to set what images are shown because none are showing. Quote Link to comment Share on other sites More sharing options...
Bigredman74 Posted May 10, 2005 Share Posted May 10, 2005 John, The "Cross Sell Products" option should be listed in the admin section under "Catalog". The images that are displayed should be the same ones from your product description. If this isn't showing up there and your images don't appear properly, check the contrib's install instructions to make sure it was installed properly. Once installed properly, this contrib is great, but I still haven't got the "Buy Now" button to add items to the cart. Good luck. Quote My Published & Modified Contributions Helpful Forum Topics: Basic Design Tips & Tricks | Simple Steps to Better Forum Searching | Speed / Performance Optimizations Link to comment Share on other sites More sharing options...
Dont Mess With Texas Posted May 10, 2005 Share Posted May 10, 2005 I dont have the cross sell products option under Catalog in my admin. I do only have 2 items in my store jsut for testing. Let me add another one and see if it shows. Still wont explain why the admin option doesnt show though. Thanks Quote Link to comment Share on other sites More sharing options...
Bigredman74 Posted May 10, 2005 Share Posted May 10, 2005 Do you have the "Administration Access Level Accounts" or other type of restricted admin contrib installed? If so, you will have to add "Cross Sell Products" to the "Catalog" section. If you don't have a restricted admin contrib installed, check your install instructions again. Quote My Published & Modified Contributions Helpful Forum Topics: Basic Design Tips & Tricks | Simple Steps to Better Forum Searching | Speed / Performance Optimizations Link to comment Share on other sites More sharing options...
Dont Mess With Texas Posted May 10, 2005 Share Posted May 10, 2005 No thats the only one i have installed. I have gone over the installation carefully and not many places you can mess up without it give errors. I have the box that says "we also recommend" but no pics and no admin option Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.