Guest Posted March 12, 2004 Posted March 12, 2004 Can anyone tell me, which needs to be downloaded from the contribution section and the order in which to install? seems to be a bit of a hit and miss there, perhaps I am seeing too many things. Is there a single contribution listing which has everything? Quote
masat Posted March 13, 2004 Posted March 13, 2004 Hey John, Your right it is confusing. I have been working on this mod for about three days now. It looks like I installed the ms2 contrib and the add to cart contrib. Load those up on your ms2 cart and test them out. You may need the add to cart fix. I don't remember what it did exactly. If you use the registry contrib be careful. There are numerous obstacles to overcome. I have completely lost track of the changes I've made with those two contribs sharing the cart. Both are excellent contribs and my hat is off to the folks that supplied them. Once xsell is installed it works great. I still have a bug in shopping_cart.php with the registry though but it's something I can overlook for now. If I may I would like to supply some advice to all. Download a fresh ms2 and make a backup copy of it. Install your mods into the copy and make sure it works first. Make a fresh backup of your store before making any changes. Then, using some compare program, integrate the changes paying close attention to what you are adding, deleteing, or changeing. I have many contribs installed and I have found some of them just don't like to play together. Quote How do you know when you know what you want to do for the rest of your life?
a.niedermann Posted March 20, 2004 Posted March 20, 2004 I've got a problem with this mod. I don't use the database field manufacturer, because we produce all products by our own. because with this contribution have to have a manufacturer, I can not choose any product. I have the same screen as AlaneinHilo! But I just have something about 50 Products! has anybody any idea for solving this?? thanks andreas Quote
iveo Posted March 30, 2004 Posted March 30, 2004 WHAT A MESS! I'd like to use some of the features of X-SELL, but it seems there is no way - not alt all! - to accomplish that... ...I mean - I even don't find any quite actual contribution and don't like the idea of fixing all of the bugs manual with looking through the bunches of updates... ...there is no overview in this project - everyone is posting crappy tipps and small upgrades instead of bringing it to a new version?! ANY IDEAS OF A WORKING CONTRI WILL BE APPRECIATED! :angry: Quote
notset4life Posted April 5, 2004 Posted April 5, 2004 To see a limtied number of products if you ammend the code in xsell_products.php file in the admin section around line 218 where it says if (!$add_related_product_ID ) { $query = "select b.language_id,a.products_id, b.products_name, ?b.products_description,a.products_quantity, a.products_model, ?a.products_image,b.products_url, a.products_price FROM products a,products_description b WHERE b.products_id = a.products_id AND b.language_id = 1 ORDER BY a.products_id LIMIT 0,100; "; Ammend the last line where is says order by and then put a limit.. I have put 100 and you will see it.. This works by showing 100 items, but it there are way to add a "more" or "next button? I can't get to any other pages v Quote
AlaneinHilo Posted April 29, 2004 Posted April 29, 2004 Thank you LazyP for the fix on the xsell_products.php file. My catalog has only about 50 products at the moment so size was not causing the problem for me. Using your change b.language_id = 2 to b.language_id = $languages_id fixed my problem and x-sell seems to be working perfect now. andreas: Have you made the change LazyP suggested? I am able to use cross-sell with products with no manufacturer. Does it give you an error when you try to cross sell products without manufactures? -Alane Quote www.luminousgifts.com
yakseller Posted July 8, 2004 Author Posted July 8, 2004 I found a small bug in xsell_cart.php and am working to fix it. If anyone else has any ideas, please let me know. The problem is, if 2 products have the same xsell products, and both are put into your cart, the xsell products will show up 2 times. Some code is needed to make sure that no product is duplicated in the xsell cart box. Does anyone use this contribution? Quote
yakseller Posted July 8, 2004 Author Posted July 8, 2004 To fix this problem, add the line: array_push($productid_array, $xsell['products_id']); After: if (!in_array($xsell['products_id'], $productid_array)) { And Before: if ($drawtable) { So it should read: if (!in_array($xsell['products_id'], $productid_array)) { array_push($productid_array, $xsell['products_id']); if ($drawtable) { Quote
szenses Posted July 17, 2004 Posted July 17, 2004 hi can anyone tell me, which x-sell contribution this contribution is meant to update? Quote
yakseller Posted July 19, 2004 Author Posted July 19, 2004 This is the forum for this contribution: http://www.oscommerce.com/community/contri...ll/search,xsell To fix the manufacturers problem, change the query to this: $xsell_query_raw = "SELECT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, xp.xsell_id, m.manufacturers_name, m.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' AND p.products_id = xp.xsell_id AND xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' AND p.products_id = pd.products_id ORDER BY pd.products_name"; Quote
tonysoprano Posted July 30, 2004 Posted July 30, 2004 help me.....what can i do?....... I surrender with this problem .... i follow the readme ...everything ok..... but.....products is repeat 3 times (watches picture) Congratulation for this contributions.......thanks for all (excuses for my english) Quote
yakseller Posted July 30, 2004 Author Posted July 30, 2004 Tonysoprano, Can you verify that these items do not appear in your xsell_products table multiple times? Quote
tonysoprano Posted August 4, 2004 Posted August 4, 2004 (edited) Hi......yakseller......thanks you for your time reply: noo...only happens to me...when i install your contribution on the original x-sell contributions.... screensamples .....maybe you can help me step1: install x-sell original contributions...... everything....ok Step 2....I install your contributions...and readme.txt.....step by step In Admin Everything ok IN...Catalog.......I SEE TWO MATRIX NAME ???........and same picture (3times).Why?.....i delete matrix product in table products ... when seeing that ---I review the tables products_xsell in sql.... look....prod ID 48..with... x-sell (ID 6, 46,54)......everything is ok.... ok...now i review Table products in sql.... look 46 and 54..... they are not Matrix name or picture your xsell_product.....is calling matrix name.....??... PD: I USE BTS.1.3 but i thing bts1.3 is working ok.... with x-sell prod..... (i tested ) .... Edited August 4, 2004 by tonysoprano Quote
tonysoprano Posted August 5, 2004 Posted August 5, 2004 mmm..... (solution2) step 3 (i install 19 Jul 2004 - Updated Xsell Product Listings -the last contribution) I am so close..... to fix it (but .....tell me why? your contributions is calling a matrix (twice).... ?? MATRIX??....I Delete matrix.....in the beginning IT CAN BE this code the problem (maybe) : $xsell_query_raw = "SELECT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, xp.xsell_id, m.manufacturers_name, m.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' AND p.products_id = xp.xsell_id AND xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' AND p.products_id = pd.products_id ORDER BY pd.products_name"; P.D: Do you speak spanish ???..... Quote
yakseller Posted August 5, 2004 Author Posted August 5, 2004 No, I don't speak Spanish (atleast not well). Try chaning that SQL query to: $xsell_query_raw = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, xp.xsell_id, m.manufacturers_name, m.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' AND p.products_id = xp.xsell_id AND xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' AND p.products_id = pd.products_id ORDER BY pd.products_name"; Quote
tonysoprano Posted August 6, 2004 Posted August 6, 2004 :D finally... "the solution".....everything ok......thanks for you time..... the solution....is was...in Table SQL products_description :D :D :D :D :D :D :D but i need to ask....... http://www.oscommerce.com/community/contributions,2219 Master Products by Galen you use that contribution???....... (i like this contribution....) you? Quote
tonysoprano Posted August 6, 2004 Posted August 6, 2004 (edited) Hi......yakseller if you have time...can you contribute .....with this contribution..... http://www.oscommerce.com/community/contributions,2219 MASTER PRODUCTS BY GALEN ....plus it puts a checkbox next to each Options/Additional Items item, and will add all selected items to the cart with the main item when "Add To Cart" is selected. Can you....edit...MASTER PRODUCTS BY GALEN + (WITH) YOUR CONTRIBUTIONS.....23 Jan 2004 - New Listing, plus adding to cart........ Thanks :D :ph34r: Edited August 6, 2004 by tonysoprano Quote
aspiringarts Posted October 17, 2004 Posted October 17, 2004 This contrib is working fine for me. However to make it easier to work with, I'd like to set the image display size on the admin side. They're full-size right now, which is too big. I'd also like to see more items per page. Any suggestions? Thanks, Susan Quote
zirh Posted December 1, 2004 Posted December 1, 2004 Hello, Iam using XSELL - Updated Product Listing contribution 19 Jul 2004 its working with a bug : the module show the same product twice for each language I can't fix it I need help thanks Quote
yakseller Posted December 6, 2004 Author Posted December 6, 2004 (edited) Hello, Iam using XSELL - Updated Product Listing contribution 19 Jul 2004 its working with a bug : the module show the same product twice for each language I can't fix it I need help thanks <{POST_SNAPBACK}> You need to add the language to the main sql query. I didn't add this in, because my shop is only in one language. $xsell_query_raw = "SELECT DISTINCT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, xp.xsell_id, m.manufacturers_name, m.manufacturers_id from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m ON p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_XSELL . " xp, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' AND p.products_id = xp.xsell_id AND xp.products_id = '" . $HTTP_GET_VARS['products_id'] . "' AND p.products_id = pd.products_id AND pd.language_id = '" . $languages_id . "' ORDER BY pd.products_name"; Add the same thing if you are using my XSELL CART. Edited December 6, 2004 by yakseller Quote
e-hobbies Posted January 9, 2005 Posted January 9, 2005 How can I get this to show up above the add to cart buttons? http://www.e-hobbies.co.nz/product_info.ph...&products_id=36 Quote
yakseller Posted January 14, 2005 Author Posted January 14, 2005 How can I get this to show up above the add to cart buttons?http://www.e-hobbies.co.nz/product_info.ph...&products_id=36 <{POST_SNAPBACK}> Just add the module to the products_info page above where those buttons are. Quote
pquigley Posted March 3, 2005 Posted March 3, 2005 i have installed the xsell_cart contribution and everything is working, but it is not removing items from the xsell_box when they are added to the cart. Can anyone help? Quote
New 
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.
Note: Your post will require moderator approval before it will be visible.