Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Collaborative Filtering


wizardsandwars

Recommended Posts

I think this is a worhtwhile topic.

 

As you can see, the moderators here aren't going to stand for your inflamatory remarks. Please refrain from calling me ignorant in the future.

 

Now then, perhaps if you had elaborated on your thoughts a little, instead of just posting a completly pointless thread, you might have gotten a little more discussion. Personally, I think that this is a *very* worthwhile topic, I just think you went about it all wrong.

 

What sort of information would you like displayed? I'm certain that you are correct, and that there could be quite a bit more information to filter on in order to 'customize' the shoppers experience. However, you haven't exactly provided any suggestions.

 

So far, as far as I know, these are the contributions that suppport Collaborative Filtering and are currently available to the OSCommerce connumity.

 

Products who purchased this item have also purchased - Looks up former sales with this product and displays products that were purchased together.

Family Products - Groups like products, defined by the shop owner

x-Sell - Cross selling module.

Ratings and Reviews from other customers

The ability to insert these ratings and Reviews on the product info page

 

In addition to that, I also have the following installed on our websites....

The majority of our inbounds links and advertising so that it comes in through the categories, rather than through the main index, so that customer see categories that interest them.

Best sellers over the past 30, 60 or 90 days.

 

Ok, so now that you sparked up some conversation, would you care to ebaborate on what you had in mind? I am more than open to your suggestions (provided you don't continure to insult me or try to sell me something)

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Hey Chris....

 

Glad to see you're still here.

 

Anybody in particular you're talking to? Do you have any ideas for advancing the personal experience of registered customers?

 

Just interested in your thoughts.....I know you've done a lot for the community, and one idea may spark another.

 

-Chris

Chris Sullivan

Link to comment
Share on other sites

Yeah, I was talking to a guy that started a thread with the same title. I think I ruffled his feathers a bit, and he started hurling insults, and the thread got nuked. But I thought it was a worthwhile conversation.

 

I think he was saying that there should be more collaborative filtering, or presentation of dynamic content preceeding like customers, demographics, or other meta data we can collect pertaining to the customer.

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

The contributions / features you mention are static 1-dimensional promotional techniques. They require manual data entry and do not dynamically adjust according to customer behaviors. These, can easily be built using additional tables and some simple SQL statements to display them.

 

Fully developed collaborative filtering technologies using n-dimensions algorithms are at least 10 years beyond this.

 

I have been monitoring this project for a very long time, and know its strengths and weaknesses very well ? which is strong case for not developing extensions for it.

 

Of course there is no collaborative filtering in OSC, but judging from the insightful responses, I can comfortably substantiate there will be none.

Link to comment
Share on other sites

OK.

 

So you didn't come here to have a discussion, you came here to hurl insults at the developers and the community, with an elitist attitude, and nothing meaningful of your own to contribute.

 

They require manual data entry and do not dynamically adjust according to customer behaviors

 

False. obviously, you do not know this project nearly as well as you think. Many of these contributions no not require manual data entry, and do adjust accoring to customer behaviors.

 

These, can easily be built using additional tables and some simple SQL statements to display them.

 

Very 'insightful'. Care to point out what data might be useful here?

 

 

Fully developed collaborative filtering technologies using n-dimensions algorithms are at least 10 years beyond this.

 

Well, if it takes 10 years to build, then I'm not sure I"m interested. :D

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

False. obviously, you do not know this project nearly as well as you think. Many of these contributions no not require manual data entry, and do adjust accoring to customer behaviors.

 

I beg to differ.

 

 

Family products

 

 

1. Installation -

 

ALTER TABLE products add column products_family varchar(24) null;

 

 

2. Admin manual data entry

 

tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_family) values ('" . tep_db_input($product['products_quantity']) . "', '" . tep_db_input($product['products_model']) . "', '" . tep_db_input($product['products_image']) . "', '" . tep_db_input($product['products_price']) . "',  now(), '" . tep_db_input($product['products_date_available']) . "', '" . tep_db_input($product['products_weight']) . "', '0', '" . (int)$product['products_tax_class_id'] . "', '" . (int)$product['manufacturers_id']. "', '" . $product['products_family'] . "')");

 

3. Selection

 

$family_query = tep_db_query("select products_family from " . TABLE_PRODUCTS . " where products_id = " . $currentid . "");

 

 

 

X-Sell

 

1. Installation

 

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;

 

 

2. Admin manual data entry

 

INSERT INTO " . TABLE_PRODUCTS_XSELL . " VALUES ('',$_POST[add_related_product_ID],$temp,1)

 

 

3. Selection

 

$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);

 

 

Do you still want to refute this?

 

 

Fully developed collaborative filtering technologies using n-dimensions algorithms are at least 10 years beyond this.

 

Well, if it takes 10 years to build, then I'm not sure I"m interested. :D

 

 

Please read that again, such algorithms have been available before amazon's IPO and at least 3 years before OSC.

Link to comment
Share on other sites

Yeah, I'd still refute that. I did say *many* and not *all*. There are other contributions that do not require manual entry.

 

But that's really beside the point. Let's talk about YOU. What do YOU offer. What is it YOU are suggesting?

 

What data would you collect, and how would you use it to customize a customers browsing experience?

-------------------------------------------------------------------------------------------------------------------------

NOTE: As of Oct 2006, I'm not as active in this forum as I used to be, but I still work with osC quite a bit.

If you have a question about any of my posts here, your best bet is to contact me though either Email or PM in my profile, and I'll be happy to help.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...