Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 1 votes

MATCHING PRODUCTS CROSS-SELL


  • You cannot reply to this topic
119 replies to this topic

#41 GraemeN

  • Community Member
  • 8 posts
  • Real Name:Graeme Nelson

Posted 01 November 2007, 18:02

View Posthomewetbar, on Nov 1 2007, 04:49 PM, said:

Using model # is unreliable, I HIGHLY recommend you use the product IDs/skus. Product ids are ALWAYS unique as they are generated by Oscommerce.

Yes, I agree. The SKU is still shown in the pop-up and you must enter the SKU to identify matching products. Displaying the product model only helps you find the right SKU.

#42 phpgirl

  • Community Member
  • 31 posts
  • Real Name:joel
  • Location:New York

Posted 05 November 2007, 04:24

I insalled it and it sometimes works and sometimes i only get the Matching items: header but no item under it ( i try the same item)

where is the link to the item
http://www.monpetitchild.net/product_info....;products_id=29

here is the code
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<?php
// MATCHING PRODUCTS
if (tep_not_null($product_info['products_matching'])) {
$product_matches = explode(',', $product_info['products_matching']);
$total_match_count = sizeof($product_matches);
// Display only if more than 1 match
if ($total_match_count > 1) {
?>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td><?php include(DIR_WS_MODULES . FILENAME_MATCHING_PRODUCTS); ?></td>
</tr>
<?php
}
}
?>
<tr>
<td>
<?php
if ((USE_CACHE == 'true') && empty($SID)) {
echo tep_cache_also_purchased(3600);
} else {
// include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
}
?>


please sombody help me here
thanks

#43 homewetbar

  • Community Member
  • 699 posts
  • Real Name:Keith W.
  • Location:USA

Posted 05 November 2007, 23:25

View Postphpgirl, on Nov 4 2007, 10:24 PM, said:

I insalled it and it sometimes works and sometimes i only get the Matching items: header but no item under it ( i try the same item)

where is the link to the item
http://www.monpetitchild.net/product_info....;products_id=29

here is the code
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<?php
// MATCHING PRODUCTS
if (tep_not_null($product_info['products_matching'])) {
$product_matches = explode(',', $product_info['products_matching']);
$total_match_count = sizeof($product_matches);
// Display only if more than 1 match
if ($total_match_count > 1) {
?>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td><?php include(DIR_WS_MODULES . FILENAME_MATCHING_PRODUCTS); ?></td>
</tr>
<?php
}
}
?>
<tr>
<td>
<?php
if ((USE_CACHE == 'true') && empty($SID)) {
echo tep_cache_also_purchased(3600);
} else {
// include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
}
?>
please sombody help me here
thanks

Very strange, what do you have in the admin fields? It's almost like you included some extra spaces... For instance in admin the cross-sell matches would be 567, 421 if those we the matching product ids. It's almost like you added extra products like this: 567,421,,,,,,

Edited by homewetbar, 05 November 2007, 23:25.

Most Valuable OsCommerce Contributions:
Also Purchased (AP) Preselection (cuts this resource hogging query down to nothing) -- Contribution 3294
FedEx Automated Labels -- Contribution 2244
RMA Returns system -- Contribution 1136
Sort Products By Dropdown -- Contribution 4312
Ultimate SEO URLs -- Contribution 2823
Credit Class & Gift Voucher -- Contribution 282
Cross-Sell -- Contribution 5347

#44 khelmick

  • Community Member
  • 4 posts
  • Real Name:Kris Helmick

Posted 09 November 2007, 05:41

Hello,

I installed everything, but after I add the sku's and go to save I get this message:


"1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 = '192,135,142', products_date_available = null, products_weight = '1.00', products_st' at line 1

update products set products_ship_sep = '0', products_quantity = '0', products_model = 'Mens-Idiot-001', products_price = '19.9500', 0 = '192', products_date_available = null, products_weight = '1.00', products_status = '1', products_tax_class_id = '1', manufacturers_id = '', products_image = 'idiot-men.jpg', products_last_modified = now() where products_id = '147'

[TEP STOP] "

Any Idea what I did wrong?!

Edited by khelmick, 09 November 2007, 05:42.


#45 khelmick

  • Community Member
  • 4 posts
  • Real Name:Kris Helmick

Posted 09 November 2007, 09:14

Please Disregard the above post. I re-installed it and it works great.

Thank you!!

Edited by khelmick, 09 November 2007, 09:19.


#46 lahada

  • Community Member
  • 2 posts
  • Real Name:Zara

Posted 13 November 2007, 14:46

Hello,

I just installed this contribution and everything seemed to work perfectly - but no cross selling products appear on the frontend.

admin section seems ok.

any ideas?

thank you very much

#47 homewetbar

  • Community Member
  • 699 posts
  • Real Name:Keith W.
  • Location:USA

Posted 13 November 2007, 17:55

View Postlahada, on Nov 13 2007, 08:46 AM, said:

Hello,

I just installed this contribution and everything seemed to work perfectly - but no cross selling products appear on the frontend.

admin section seems ok.

any ideas?

thank you very much


You need 2+ products listed in the cross sell feed for it to show.
Most Valuable OsCommerce Contributions:
Also Purchased (AP) Preselection (cuts this resource hogging query down to nothing) -- Contribution 3294
FedEx Automated Labels -- Contribution 2244
RMA Returns system -- Contribution 1136
Sort Products By Dropdown -- Contribution 4312
Ultimate SEO URLs -- Contribution 2823
Credit Class & Gift Voucher -- Contribution 282
Cross-Sell -- Contribution 5347

#48 negri21

  • Community Member
  • 26 posts
  • Real Name:Ryan

Posted 13 November 2007, 23:34

is there a way to change the placement of the 3 2 or 1 items i decide to have? like underneath the main items description or somewhere other than the right side?

#49 lahada

  • Community Member
  • 2 posts
  • Real Name:Zara

Posted 14 November 2007, 07:39

thank you homewetbear.
that's what I already tried out; I tried woth 2 products, 3, and 5.
doesn't seem to change anything.

I must have gone wrong somewhere but I can't figure out where..

I have STS current version installed - do I have to make any changes to STS ?
anyone got to work this contribution together with STS?

thank you so much for any ideas

#50 henk3001

  • Community Member
  • 24 posts
  • Real Name:henk
  • Location:Netherlands

Posted 23 November 2007, 18:37

Uhm, how do you chan it to product model .

Thx HEnk

#51 runweb

  • Community Member
  • 166 posts
  • Real Name:jacksmith

Posted 24 November 2007, 09:18

View Postlahada, on Nov 14 2007, 08:39 AM, said:

thank you homewetbear.
that's what I already tried out; I tried woth 2 products, 3, and 5.
doesn't seem to change anything.

I must have gone wrong somewhere but I can't figure out where..

I have STS current version installed - do I have to make any changes to STS ?
anyone got to work this contribution together with STS?

thank you so much for any ideas

I don`t thing, that you have to make changes into STS - I installed MPCS, too and it works as you can see here:
http://www.run-x.de/shop-2/catalog/product...;products_id=51

Don`t think that you have to make changes into STS.
OSC Webmakers Edition modiefied with many other contribs and enhancements.
+ STS 4.5.7 for 2.2MS2 and RC1

#52 datawebuk

  • Community Member
  • 18 posts
  • Real Name:Phil

Posted 02 December 2007, 22:10

I've got this contribution installed and working well. http://spacomponents.co.uk/product_info.ph...;products_id=57
I have a dummy product that is deactivated so it doesn't show in the store, and this way the Matching Products contrib will display if there is only one matching product (see this example http://spacomponents.co.uk/product_info.ph...products_id=448 )

QUESTION: I need more than one product image per product. Any ideas of the best contribution to use that works alongside the Matching Products contribution?

#53 homewetbar

  • Community Member
  • 699 posts
  • Real Name:Keith W.
  • Location:USA

Posted 08 December 2007, 00:37

View Postdatawebuk, on Dec 2 2007, 04:10 PM, said:

I've got this contribution installed and working well. http://spacomponents.co.uk/product_info.ph...;products_id=57
I have a dummy product that is deactivated so it doesn't show in the store, and this way the Matching Products contrib will display if there is only one matching product (see this example http://spacomponents.co.uk/product_info.ph...products_id=448 )

QUESTION: I need more than one product image per product. Any ideas of the best contribution to use that works alongside the Matching Products contribution?

It will work with any extra images contrib. There are alot in the contrib section of this site. Big images works well for me, I think it might be called more pics or something similar.
Most Valuable OsCommerce Contributions:
Also Purchased (AP) Preselection (cuts this resource hogging query down to nothing) -- Contribution 3294
FedEx Automated Labels -- Contribution 2244
RMA Returns system -- Contribution 1136
Sort Products By Dropdown -- Contribution 4312
Ultimate SEO URLs -- Contribution 2823
Credit Class & Gift Voucher -- Contribution 282
Cross-Sell -- Contribution 5347

#54 nikko50

  • Community Member
  • 14 posts
  • Real Name:Nick

Posted 02 January 2008, 18:45

View Postphpgirl, on Nov 5 2007, 04:24 AM, said:

I insalled it and it sometimes works and sometimes i only get the Matching items: header but no item under it ( i try the same item)

where is the link to the item
http://www.monpetitchild.net/product_info....;products_id=29

here is the code
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<?php
// MATCHING PRODUCTS
if (tep_not_null($product_info['products_matching'])) {
$product_matches = explode(',', $product_info['products_matching']);
$total_match_count = sizeof($product_matches);
// Display only if more than 1 match
if ($total_match_count > 1) {
?>
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td><?php include(DIR_WS_MODULES . FILENAME_MATCHING_PRODUCTS); ?></td>
</tr>
<?php
}
}
?>
<tr>
<td>
<?php
if ((USE_CACHE == 'true') && empty($SID)) {
echo tep_cache_also_purchased(3600);
} else {
// include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
}
?>
please sombody help me here
thanks

Replace the code with this...

// MATCHING PRODUCTS CONTRIB
if (tep_not_null($product_info['products_matching'])) {
if (substr( $product_info['products_matching'],-1,1) == ',')
{
$product_info['products_matching'] = substr($product_info['products_matching'],0,-1).'';
}
$product_matches = explode(',', $product_info['products_matching']);
$total_match_count = sizeof($product_matches);
// Display only if more than 1 match
if ($total_match_count >= 1) {

#55 EricK

  • Community Member
  • 311 posts
  • Real Name:Eric_K
  • Gender:Male
  • Location:Atlanta, GA USA

Posted 08 January 2008, 05:51

Graeme,

Installed it with no problems, thank you for this nice contribution. I tried two other cross-selling contribs before MATCHING PRODUCTS CROSS SELL, and yours is the best by far.

Thanks again,
EricK

#56 homewetbar

  • Community Member
  • 699 posts
  • Real Name:Keith W.
  • Location:USA

Posted 08 January 2008, 19:10

View PostEricK, on Jan 7 2008, 11:51 PM, said:

Installed it with no problems, thank you for this nice contribution. I tried two other cross-selling contribs before MATCHING PRODUCTS CROSS SELL, and yours is the best by far.

Thanks again,
EricK


You're welcome. Glad you like it.
Most Valuable OsCommerce Contributions:
Also Purchased (AP) Preselection (cuts this resource hogging query down to nothing) -- Contribution 3294
FedEx Automated Labels -- Contribution 2244
RMA Returns system -- Contribution 1136
Sort Products By Dropdown -- Contribution 4312
Ultimate SEO URLs -- Contribution 2823
Credit Class & Gift Voucher -- Contribution 282
Cross-Sell -- Contribution 5347

#57 GraemeN

  • Community Member
  • 8 posts
  • Real Name:Graeme Nelson

Posted 10 January 2008, 20:32

View PostEricK, on Jan 8 2008, 05:51 AM, said:

Graeme,

Installed it with no problems, thank you for this nice contribution. I tried two other cross-selling contribs before MATCHING PRODUCTS CROSS SELL, and yours is the best by far.

Thanks again,
EricK
Thanks, but it's Keith W.'s contribution - I just posted an update / suggestion. I agree, great contribution - Thanks to Keith!
Regards,
Graeme

Edited by GraemeN, 10 January 2008, 20:33.


#58 MichaelB

  • Community Member
  • 15 posts
  • Real Name:Michael Bennett
  • Gender:Male

Posted 19 January 2008, 04:38

I have used this contribution and love it. Now, I have rebuilt my site from scratch after scouring the contribs for all the features I want available in my store. My question is this ..... has anyone successfully installed this contrib with Open Featured Sets (contrib #4066)??? If so, how? My main problem is the merging of the queries used by both contribs, as they both modify the same ones. This is the final contrib I need to plug-in. Any help would be greatly appreciated.

#59 homewetbar

  • Community Member
  • 699 posts
  • Real Name:Keith W.
  • Location:USA

Posted 22 January 2008, 22:35

View PostMichaelB, on Jan 18 2008, 10:38 PM, said:

I have used this contribution and love it. Now, I have rebuilt my site from scratch after scouring the contribs for all the features I want available in my store. My question is this ..... has anyone successfully installed this contrib with Open Featured Sets (contrib #4066)??? If so, how? My main problem is the merging of the queries used by both contribs, as they both modify the same ones. This is the final contrib I need to plug-in. Any help would be greatly appreciated.

I've never used that one myself, but it should work with any contribution.
Most Valuable OsCommerce Contributions:
Also Purchased (AP) Preselection (cuts this resource hogging query down to nothing) -- Contribution 3294
FedEx Automated Labels -- Contribution 2244
RMA Returns system -- Contribution 1136
Sort Products By Dropdown -- Contribution 4312
Ultimate SEO URLs -- Contribution 2823
Credit Class & Gift Voucher -- Contribution 282
Cross-Sell -- Contribution 5347

#60 ianric

  • Community Member
  • 373 posts
  • Real Name:Ian Richardson
  • Gender:Male
  • Location:Manchester, UK

Posted 28 January 2008, 18:27

View Posthomewetbar, on Jan 22 2008, 10:35 PM, said:

I've never used that one myself, but it should work with any contribution.
Hi

Installed this a while ago and all is working but this morning I noticed a small error in my code and have tried all day to solve but can't. How do I add an "add to cart" button underneath?? I've done it but the product_id is ALWAYS the product you are looking at. When you pick "add to cart" the right product does get added AND you are taken to the "product not found" page

This is the code I have modded, I have just formatted it different

'text' => strtoupper($matching_products['products_name']) . '<br><br>' . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $matching_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $matching_products['products_image'], $matching_products['products_name'] . ' - ' . $matching_products['products_title'] . ' Label Side A', SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><br><a STYLE="text-decoration:underline" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $matching_products['products_id']) . '">' . $matching_products['products_title'] . '</a> (' . $matching_products['products_media'] . ')<br><br>' . $products_price . '<br><br><a href="' . tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $matching_products['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW) . '</a>');

And this is the link I get

https://www.icr-records.co.uk/product_info.php?products_id=236&action=buy_now&products_id=503&osCsid=1f24c.....

Note 2 different product_id's. 236 is the current item I am viewing and 503 is the matching product_id. I have tried all the "add to cart" functions and still can't get it to work.

Please could someone point me in the right direction.

Cheers

Ian