Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * * 1 votes

MATCHING PRODUCTS CROSS-SELL


119 replies to this topic

#1 homewetbar

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

Posted 09 August 2007, 18:13

The purpose of this contribution is to allow you to cross-sell matching or coordinating products to customers for almost any use such as completing an outfit, other books in a series, color matching items, etc....

This is done by simply adding product SKUs (product ids) to the product page in admin in the following fashion SKU, SKU, SKU, etc.

Then on the catalog product page 3 of these SKUs are randomly selected to display as "matching" cross-sell items if they are in stock, allowing you to increase your cross sells and not have to micro-manage them. Can be easily added to even the most modified of stores.
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

#2 homewetbar

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

Posted 09 August 2007, 18:18

This contribution has now been released: http://www.oscommerce.com/community/contributions,5347

Thanks go to all of the other contribution makers, as I'll freely admit I looked at bits and pieces of other oscommerce contribution codes for help in the designing of this contribution.

Edited by homewetbar, 09 August 2007, 18:21.

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

#3 bruyndoncx

  • Community Member
  • 2,382 posts
  • Real Name:Carine Bruyndoncx
  • Gender:Female
  • Location:Belgium/ Antwerp/ Turnhout/ Arendonk

Posted 09 August 2007, 20:41

do you have a screenshot of this code in action ?
I have been using family products, I wonder how different this is ?
Hava a nice day !
Carine Bruyndoncx

KEUKENLUST, Everything but the kitchensink !

#4 homewetbar

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

Posted 09 August 2007, 20:54

View Postbruyndoncx, on Aug 9 2007, 03:41 PM, said:

do you have a screenshot of this code in action ?
I have been using family products, I wonder how different this is ?

Hello,

I do not have a screen shot but here is the gist of the current layout (which you can modify easily for your site):

Matching products:

[Image] [Image] [Image]
name name name

It works kinda like the JC Penney cross sell shown here: http://www3.jcpenney.com/jcp/ProductsHOM.a...;itemid=11aa54b but in horizontal fashion instead of verticle.

The thought is not to try and do a listing like a category, rather showcase products that match/coordinate with the product they are looking at that they can click on and then view and add them to their cart.

Edited by homewetbar, 09 August 2007, 20:58.

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

#5 zoomedia

  • Community Member
  • 4 posts
  • Real Name:Rocky

Posted 17 August 2007, 23:45

Hi I was amazed how easy the directions are for this contribution! Anyway the problem: admin the sku numbers pop up I add them but the products they do not show up in the catalog online here's a screen shot [img]http://healingcrystals.net/ascrn.jpg[/img] Everything seems fine but when the item is loaded there is no matching sku'S here is the link to see this is the product with the added skus: http://healingcrystals.net/store/product_i...;products_id=82
Any help would be greatly appreciated,
Rocky

#6 midwestp

  • Community Member
  • 3 posts
  • Real Name:Erik
  • Location:Ohio

Posted 18 August 2007, 22:29

I went through all the steps. I am having a problem with the change to catalog/product_info.php. It seems to be when I add the code about line 220. When I add it, I get an error every time I click on a product at my store. It says there is a > on line 409. One try, I manage to take out the > that was the right one, then there was an error that a $ was located at about line 440.

Any ideas? I was able to delete that code before line 220 and my site works again. However, the contribution does not work.

#7 homewetbar

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

Posted 18 August 2007, 23:02

View Postzoomedia, on Aug 17 2007, 06:45 PM, said:

Hi I was amazed how easy the directions are for this contribution! Anyway the problem: admin the sku numbers pop up I add them but the products they do not show up in the catalog online here's a screen shot [img]http://healingcrystals.net/ascrn.jpg[/img] Everything seems fine but when the item is loaded there is no matching sku'S here is the link to see this is the product with the added skus: http://healingcrystals.net/store/product_i...;products_id=82
Any help would be greatly appreciated,
Rocky

Did you do the product_info.php steps?
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

#8 homewetbar

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

Posted 18 August 2007, 23:04

View Postmidwestp, on Aug 18 2007, 05:29 PM, said:

I went through all the steps. I am having a problem with the change to catalog/product_info.php. It seems to be when I add the code about line 220. When I add it, I get an error every time I click on a product at my store. It says there is a > on line 409. One try, I manage to take out the > that was the right one, then there was an error that a $ was located at about line 440.

Any ideas? I was able to delete that code before line 220 and my site works again. However, the contribution does not work.

Sounds like you are missing a ; ?> or <?php bracket somewhere.
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

#9 zoomedia

  • Community Member
  • 4 posts
  • Real Name:Rocky

Posted 20 August 2007, 21:49

View Posthomewetbar, on Aug 18 2007, 04:02 PM, said:

Did you do the product_info.php steps?
yes then I get an error message syntax error line 277 I did notice that I have a box that goes with the product called " other customers who bought this also bought and shows 6 photos here is the code:
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td>
<?php
if ((USE_CACHE == 'true') && empty($SID)) {
echo tep_cache_also_purchased(3600);
} else {
include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
}
it comes right after the matching products code could that be causing the problem?
Thanks :)

#10 homewetbar

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

Posted 20 August 2007, 22:20

View Postzoomedia, on Aug 20 2007, 04:49 PM, said:

yes then I get an error message syntax error line 277 I did notice that I have a box that goes with the product called " other customers who bought this also bought and shows 6 photos here is the code:
<tr>
<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
</tr>
<tr>
<td>
<?php
if ((USE_CACHE == 'true') && empty($SID)) {
echo tep_cache_also_purchased(3600);
} else {
include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS);
}
}
it comes right after the matching products code could that be causing the problem?
Thanks :)


I've got an extremely modified store so it's hard for me to tell you exactly what point in the code you should put the matching cross sell code if it does not work for you in the default area, but I poped my code in the instructions into jEdit to check and the code itself does not have any errors according to jEdit.

Backup your file and try moving it around in the product_info.php and see what happens. It's not going to do any harm, worst case it won't work, then try it in another spot and so on and so on. Then please post what you find and where you actually get it to work for others to see in the forum.

Edited by homewetbar, 20 August 2007, 22:21.

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

#11 cliquei

  • Community Member
  • 3 posts
  • Real Name:Heriberto neto

Posted 25 August 2007, 13:26

I have got the same problens...anyone discovered what it is ? I have put it eveywhere.. the code may have a problem inside ?

quote name='homewetbar' date='Aug 20 2007, 07:20 PM' post='1124956']
I've got an extremely modified store so it's hard for me to tell you exactly what point in the code you should put the matching cross sell code if it does not work for you in the default area, but I poped my code in the instructions into jEdit to check and the code itself does not have any errors according to jEdit.

Backup your file and try moving it around in the product_info.php and see what happens. It's not going to do any harm, worst case it won't work, then try it in another spot and so on and so on. Then please post what you find and where you actually get it to work for others to see in the forum.
[/quote]

#12 homewetbar

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

Posted 25 August 2007, 15:52

View Postcliquei, on Aug 25 2007, 08:26 AM, said:

I have got the same problens...anyone discovered what it is ? I have put it eveywhere.. the code may have a problem inside ?

quote name='homewetbar' post='1124956' date='Aug 20 2007, 07:20 PM']
I've got an extremely modified store so it's hard for me to tell you exactly what point in the code you should put the matching cross sell code if it does not work for you in the default area, but I poped my code in the instructions into jEdit to check and the code itself does not have any errors according to jEdit.

Backup your file and try moving it around in the product_info.php and see what happens. It's not going to do any harm, worst case it won't work, then try it in another spot and so on and so on. Then please post what you find and where you actually get it to work for others to see in the forum.

Try moving the code up one line... Tell me how that works.
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

#13 cliquei

  • Community Member
  • 3 posts
  • Real Name:Heriberto neto

Posted 25 August 2007, 18:35

View Posthomewetbar, on Aug 25 2007, 12:52 PM, said:

Try moving the code up one line... Tell me how that works.


Getting this part out of the end solved my problem...



<tr>
<td>
<?php

#14 cliquei

  • Community Member
  • 3 posts
  • Real Name:Heriberto neto

Posted 25 August 2007, 18:38

Now that I got it to work it seens like the easiest ans most perfect cross sell solution fo oscommerce right now..

Maybe the only thing is to make that last step on product_info easier for people.. I almost gave up trying.. hehe

Nice script !

#15 homewetbar

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

Posted 27 August 2007, 18:46

It appears just a ?> was missing at the end of the product_info.php code. I have added that to the install now.
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

#16 kbking

  • Community Member
  • 266 posts
  • Real Name:Chris

Posted 28 August 2007, 06:44

View Posthomewetbar, on Aug 9 2007, 10:54 PM, said:

Hello,

I do not have a screen shot but here is the gist of the current layout (which you can modify easily for your site):

Matching products:

[Image] [Image] [Image]
name name name

It works kinda like the JC Penney cross sell shown here: http://www3.jcpenney.com/jcp/ProductsHOM.a...;itemid=11aa54b but in horizontal fashion instead of verticle.

The thought is not to try and do a listing like a category, rather showcase products that match/coordinate with the product they are looking at that they can click on and then view and add them to their cart.

Hello!

This seems like an awsome addition.

I'm planning to add the new SPPC 4.20, which is going to be released this week by Janz. I guess there has to be some modifications to yours in order to make them play nice together. My question is, would you mind consider looking into this?

#17 homewetbar

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

Posted 28 August 2007, 16:54

View Postkbking, on Aug 28 2007, 01:44 AM, said:

Hello!

This seems like an awsome addition.

I'm planning to add the new SPPC 4.20, which is going to be released this week by Janz. I guess there has to be some modifications to yours in order to make them play nice together. My question is, would you mind consider looking into this?


I have no idea what SPPC is... However this contrib is a very light install and should not interfer with other contribs unless the contribs you are installing heavily modify oscommerce, it that case you are likely a skilled enough programmer to make them "play nice" together anyway so I wouldn't worry about 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

#18 kbking

  • Community Member
  • 266 posts
  • Real Name:Chris

Posted 28 August 2007, 19:41

I haven't looked at this contrib yet, but since you say it it's very light, I think I'll manage to do it.

Anyway, thanks for your answer! :).

#19 claireb85

  • Community Member
  • 14 posts
  • Real Name:Claire

Posted 21 September 2007, 16:44

Hey just wanted to say really good contribution, really easy to install and works perfect

Thanks :thumbsup:

#20 runweb

  • Community Member
  • 166 posts
  • Real Name:jacksmith

Posted 01 October 2007, 12:20

Great Contrib !
That`s just I searched for. Very uncomplicated Cross Selling module !

I have only 1 wish:

it would be nice if it would be possible to make more than 3 Cross Selling Items......

:rolleyes:

This is the best Cross Selling contrib because very uncomplicated !!
I tried out 2-3 contribs but they were not very useful for admins...
OSC Webmakers Edition modiefied with many other contribs and enhancements.
+ STS 4.5.7 for 2.2MS2 and RC1