Jump to content
Latest News: (loading..)
Skittles

Optional Related Products, Version 4.0

Recommended Posts

Hi all!

 

If you are familiar with Optional Related Products Ver. 3.3, you know that I have stepped up to support and continue development of this useful contribution. There have been numerous requests for features, and I have tried to incorporate them in what is about to be a new release.

 

I've made some serious changes to Optional Related Products for Version 4.0! There are changes in the Admin and how it works, giving you more control over the looks and function; There are display options reminiscent of the product listing options, where you can decide what details to display on the page. The Optional Related Products code is now a module called by an include statement in products_info.html.

 

I am currently looking for a few beta testers! I need a couple of shop owners that have never installed the contribution, as well as one or two who would be upgrading. If you consider yourself a newbie to osCommerce, you're feed back could be invaluable in creating an installation guide that takes some of the pain out of the installation process. Don't be shy.

 

I'm looking for feedback on the installation procedure: Were the instructions easy to follow? Was everything there, etc.

 

The 'package' you'll receive is complete, except for a 'User's Guide" which I've just recently decided to create. (The user's guide is not needed to install the contribution. It will only explain what the various options are, how and why/when to use them.)

 

If you are interested in beta testing Version 4.0, please leave a post in this thread, and I'll PM you with further information.

 

I am hoping to release Version 4.0 no later than next Friday (02/23/2007).

 

Thanks in advance for your time.

-Skittles

Share this post


Link to post
Share on other sites
Hi all!

 

If you are familiar with Optional Related Products Ver. 3.3, you know that I have stepped up to support and continue development of this useful contribution. There have been numerous requests for features, and I have tried to incorporate them in what is about to be a new release.

 

I've made some serious changes to Optional Related Products for Version 4.0! There are changes in the Admin and how it works, giving you more control over the looks and function; There are display options reminiscent of the product listing options, where you can decide what details to display on the page. The Optional Related Products code is now a module called by an include statement in products_info.html.

 

I am currently looking for a few beta testers! I need a couple of shop owners that have never installed the contribution, as well as one or two who would be upgrading. If you consider yourself a newbie to osCommerce, you're feed back could be invaluable in creating an installation guide that takes some of the pain out of the installation process. Don't be shy.

 

I'm looking for feedback on the installation procedure: Were the instructions easy to follow? Was everything there, etc.

 

The 'package' you'll receive is complete, except for a 'User's Guide" which I've just recently decided to create. (The user's guide is not needed to install the contribution. It will only explain what the various options are, how and why/when to use them.)

 

If you are interested in beta testing Version 4.0, please leave a post in this thread, and I'll PM you with further information.

 

I am hoping to release Version 4.0 no later than next Friday (02/23/2007).

 

Thanks in advance for your time.

-Skittles

I'm game.

Share this post


Link to post
Share on other sites

I am up for the upgrade? I have a test store which is a clone of my live store where I would be willing to give it a try. It is a heavily modded store too.

 

I am not sure which version of related products I have at the moment as I am trying to figure it out :o

Judging by the link in my sig its 3.3c ?

Edited by Get-Wireless 2

Share this post


Link to post
Share on other sites

I've got 2 local test sites using Xampp. One is vanilla latest snapshot. The other one is latest snapshot with several mods including Opt. Products 3.3c. Can try either initial install, upgrade, or both depending on your needs. Willing to help if I can.

Share this post


Link to post
Share on other sites
I've got 2 local test sites using Xampp. One is vanilla latest snapshot. The other one is latest snapshot with several mods including Opt. Products 3.3c. Can try either initial install, upgrade, or both depending on your needs. Willing to help if I can.

MagickWomyn,

 

I'd love to send you the beta package. PM me your email address and I'll drop one off to you right away.

 

-Skittles

Share this post


Link to post
Share on other sites

Hi Skittles,

 

I'm an almost complete OScommerce newbie, but your related products module looks like just what I need. I'm having a headache installing it though, so your proposed install guide sounds like a great idea!

 

I'm comfortable with editing the php files, but am decidedly unsteady in MySQL. What is the command to load your SQL file into my database?

 

If you want to test out a draft install guide on someone, I'm possibly a good candidate (able to follow instructions, but largely clueless!)

 

Thanks,

 

Richard

 

PS - Also happy to try out the v4 beta.

Edited by letsplaydrums

Share this post


Link to post
Share on other sites

Optional Related Products, Version 4.0 has just been released. You can download it from here.

 

My thanks to the beta-testers. Their efforts have been much appreciated.

 

By the way, if you are using Graphical Borders 2.1, this release supports it. Simply substitute one modified file and you're up and running. See the installation instructions for details.

 

-Skittles

 

New features for Version 4.0:
 - The database table has been renamed from `products_options_products` to
	`products_related_products`
 - A SQL Setup Utility has been added. This PHP file is accessed via the
	Admin as the last step of the installation, and makes all the
	changes to the database for installation or upgrade, depending on
	what option is chosen. It includes an option to remove the table and
	all the entries supporting this contribution.
 - A direct link to the configuration page has been added to the Related
	Products page.
 - A link to the SQL Setup Utility has also been added to the Related
	Products page.
 - The code used in product_info.php is now in a separate file:
[[catalog/]]includes/modules/related_products.php
 - Supports multiple display options, controlled in Admin Configuration.
  - Display Thumbnail Image (original option)
	- Default is True.
  - Display Product Name
	- Default is True.
  - Display Product Model
	- Default is False.
  - Display Price
	- Default is True.
	 - Uses sprintf with language constant define:
	   i.e. define('RELATED_PRODUCTS_PRICE_TEXT', '@ %s');
  - Display Quantity Available
	- Default is False.
	 - Uses sprintf with language constant define:
	   i.e. define('RELATED_PRODUCTS_QUANTITY_TEXT', 'Only %s left!');
  - Display "Buy Now" Button
	- Default is False.
 - The Related Products admin page has been revamped:
  - Uses text instead of image buttons for the basic list,
	compacting the list for easier viewing (and less scrolling.)
  - New Reciprocate function Inserts association in both directions.
  - Inherit function can be set to also Insert.
  - Delete function has been streamlined.
	 - Delete Confirmation is now optional, set in Admin
	 - A "pop-up" Delete Confirmation box allows confirmation or cancel
	   without refreshing the page. The page is only refreshed after the
	   Delete has been completed.
  - It is no longer possible to create duplicate entries.
  - Additional control of display has been added. Options are in Configuration.
 - The Related Products Configuration has new Options
  - Multiple display options control the look of the Admin page.
	 - Admin Display: Maximum Rows
		- Default is 10.
		- Sets the maximum number of rows listed per page.
	 - Admin Display: Drop-Down List Maximum Length
		- Default is 0. (Unlimited)
		- Allows you to set a maximum length for the Product Name
		  in the drop-down list. Does not affect the basic list.
		  This is helpful when the product has a very long name, or
		  when displaying both the Model and Name of the product.
	 - Admin Display: Display List Maximum Length
		- Default is 0. (Unlimited)
		- Allows you to set a maximum length for the Product Name
		  in the basic list. Does not affect the drop-down list.
		  This is helpful when the product has a very long name, or
		  when displaying both the Model and Name of the product.
	 - Admin Display: Use Product Model
		- Default is False.
		- Allows you to include the Model. List is still ordered by
		  product name. Can also be used alone.
	 - Admin Display: Use Product Name
		- Default is True.
	 - Admin Display: Combine Model and Name separator
		- Default is ':'.
		- When using Model with Name, provides separation between the two.
		- Only shows when "Use Product Model" is True. Can be empty.
	 - Admin Function: Inherit includes Insert.
		- Default is False.
		- When set, both the product and it's associated products are "related"
		  to the target product. Normally, this takes two operations.
	 - Admin Function: Delete Confirmation.
		- Default is True.

Share this post


Link to post
Share on other sites
hi to all , i am a little confuse about this module , can someone explained it to me thx

 

Joe,

 

This contribution allows you to relate one product to another. It's a cross sell add on. If the customer clicks item A then in the product information page they'll also see any items you related to it. Such as Item B, Item C... etc. It gives them the option to buy other products that are either add-ons or related in some way... like parts of a set only at individual prices. It allows them to pick and choose the items that are similar to make their own set. Make sense? It allows you to increase sales this way.

 

I looked at x-sell and other contributions that are similar. For ease of install, not too far from really newbie state, it was a breeze. It's easy to work with and the newest release has a lot of really good features. Another thing I considered was the support offered, Skittles has been there every step of the way. I have V4.0 on a vanilla install and also did the upgrade from V3.3 on a modified site. No problems either way. Give it a try.... you'll like it.

 

HTH

Share this post


Link to post
Share on other sites
hi to all , i am a little confuse about this module , can someone explained it to me thx

APPRENTICE WEBM,

 

Take a look at the html User's Guide:

Be sure to click on the first image, titled 'Screenshot: Example Product Info Page', for a full size example of the product info page. Seeing what it does to the page should help you decide if you want this contrib for your store.

 

Have a great weekend,

-Skittles

Share this post


Link to post
Share on other sites

thx for all of you , i am going to install it and see it in action . one more questin i also have the Cross Sell module would it be a problem if i used them both or it isn't possible ?

i will be waiting for your replies

Share this post


Link to post
Share on other sites
hello i installed it but i have one more question , how do i change the color the gray color bar

APPRENTICE WEBM,

 

First, I have no experience with other cross-selling contributions. I do not know if the two will work together...

 

Second, the stock module uses styles defined in stylesheet.css to retain the same look as the other boxes throughout the store:

class="productlisting"

class="productListing-heading"

class="productListing-data"

You can change the definitions in stylesheet.css. However, any changes will take effect for every box on your site that is using these classes.

 

Or, if you have changed the source code on your site to use different classes, you can change them in the module as well. For example:

class="productlisting" becomes class="new_productlisting",

class="productListing-heading" becomes class="new_productListing-heading", and

class="productListing-data" becomes class="new_productListing-data"

Alternately, it may be that you are using a template for your site that changes the way the boxes are created. In that case, you may need to modify the stock module to behave the same as the template.

 

If you aren't using these three classes anywhere else on your site, you can change them without worrying that they will mess up something somewhere else.

 

However, I recommend modifying the module file ([catalog/]includes/modules/optional_related_products.php) to use the classes that are used throughout your site. It could save you some real headaches at a later date.

 

Hope this helps.

-Skittles

Share this post


Link to post
Share on other sites

hi Skittles, thx for everything , actually the crosseling work very well but i am still confuse on how to change the color on where it says " Other Product that you might like " i know that it is somewhere in the style_sheet , so can you pin point me to it .

Share this post


Link to post
Share on other sites

hi it's me again , i change the color and everything looks fine and i now i am trying to figure out how to put the " other product you might like to buy " to go left instead of being in the center . any help if possible. but i really appreciate everything you did for us ( meaning the oscommerce community)

Share this post


Link to post
Share on other sites
hi it's me again , i change the color and everything looks fine and i now i am trying to figure out how to put the " other product you might like to buy " to go left instead of being in the center . any help if possible. but i really appreciate everything you did for us ( meaning the oscommerce community)

APPRENTICE WEBM,

 

Sorry I wasn't available sooner.

 

In your favorite text editor, open the module file ([catalog/]includes/modules/optional_related_products.php), and around line 49 look for:

	  <td align="center" class="productListing-heading"> <?php echo TEXT_RELATED_PRODUCTS ?> </td>

Change it to:

	  <td align="left" class="productListing-heading"> <?php echo TEXT_RELATED_PRODUCTS ?> </td>

Save and upload the file. That should do it. :)

 

-Skittles

Share this post


Link to post
Share on other sites

Anita;

 

Thank you for all of your eforts on this contribution. It's very nicely done and provides excellent options from the Admin interface. Install was a breeze and your instructions and user guide are first rate!

 

My little suggestion for upcoming versions (I've looked at doing this and just don't have the capability to bring it off) would be to make the item selection from within the Admin interface a search function rather than dropdowns (similar to what was done in Select Specials)

 

I've also noticed that whenever I do an addition or update, there is a long pause before the screen refreshes. I have around 3000 products in the database, and I suspect that the delay is due to the number of products. I don't know if there's a way to streamline the queries that are being done to improve the speed (and possibly reduce the query load) or not...


... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Share this post


Link to post
Share on other sites

Anita;

 

Thank you for all of your eforts on this contribution. It's very nicely done and provides excellent options from the Admin interface. Install was a breeze and your instructions and user guide are first rate!

 

My little suggestion for upcoming versions (I've looked at doing this and just don't have the capability to bring it off) would be to make the item selection from within the Admin interface a search function rather than dropdowns (similar to what was done in Select Specials)

 

I've also noticed that whenever I do an addition or update, there is a long pause before the screen refreshes. I have around 3000 products in the database, and I suspect that the delay is due to the number of products. I don't know if there's a way to streamline the queries that are being done to improve the speed (and possibly reduce the query load) or not...


... if you want to REALLY see something that doesn't set up right out of the box without some tweaking,

try being a Foster Parent!

Share this post


Link to post
Share on other sites

hi, just installed it, and everything was going great :D (i upgraded from 3.3c)

 

but now ive finished when i visit my site there is a huge white space on the left...

 

click here to see what i mean

 

and the related products do not show up...

 

 

help please!!

Share this post


Link to post
Share on other sites
hi, just installed it, and everything was going great :D (i upgraded from 3.3c)

 

but now ive finished when i visit my site there is a huge white space on the left...

 

click here to see what i mean

 

and the related products do not show up...

help please!!

Benjjj6,

 

A quick look at the page's source code shows a pesky little comment tag! Every thing after it is being ignored.

 

Look for:

<!----------------------- Not editable part -------------------------------->

  <tr><td>

	</td>
  </tr>


<tr>
	<td><img src="images/pixel_trans.gif" width="100%" height="10" border="0" alt=""></td>
  </tr>
<!--
  <tr>

 

And remove the comment code, shown here just before the <tr> tag.

 

I think that should take care of it.

 

Have fun,

-Skittles

Share this post


Link to post
Share on other sites

thankyou soooo much, that worked perfectly :D

 

just a few more little things...

 

is it possible to make all the picture thumbnails slightly smaller? and the text smaller?

 

Where can i edit the text "Other Products You Might Like"?

Share this post


Link to post
Share on other sites
thankyou soooo much, that worked perfectly :D

 

just a few more little things...

 

is it possible to make all the picture thumbnails slightly smaller? and the text smaller?

 

Where can i edit the text "Other Products You Might Like"?

Benjjj6,

 

First, the image size is controlled by the configuration options. This image is the same size as the images in your product listing. Here's the code:

 

	  if (RELATED_PRODUCTS_SHOW_THUMBS == 'True') {
	echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . "\n"
		 . tep_image(DIR_WS_IMAGES . $attributes_values['products_image'], $attributes_values['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"').'</a><br>' . "\n";
  }

Notice SMALL_IMAGE_WIDTH and SMALL_IMAGE_HEIGHT? Those are set in Admin Configuration->Images: Small Image Width and Small Image Height.

 

If you would like to create a new image size for the Related Products, you can add new constants and use the new constants instead. One way to do that, without using the database, is to add the "define" to the language file for product_info.php, kind of like this:

 

define('ORP_IMAGE_WIDTH', '80');

define('ORP_IMAGE_HEIGHT', '80');

 

Then change the code above to this:

 

	  if (RELATED_PRODUCTS_SHOW_THUMBS == 'True') {
	echo '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products_id_slave) . '">' . "\n"
		 . tep_image(DIR_WS_IMAGES . $attributes_values['products_image'], $attributes_values['products_name'], ORP_IMAGE_WIDTH, ORP_IMAGE_HEIGHT, 'hspace="5" vspace="5"').'</a><br>' . "\n";
  }

If your images aren't all the same ratio, you can force them to all be the same width by leaving the height blank, like this:

 

define('ORP_IMAGE_WIDTH', '80');

define('ORP_IMAGE_HEIGHT', '');

 

I notice that you are not using the stock image handling code. (product_thumb.php?img=images/15310f.jpg&w=100&h=68 was the give-away.) If you start using a custom image size, via new defined constants, you may need to modify the code in the image contribution to support the new constants.

 

Second, the text is contained in paragraph tags (<p></p>) within the table cell (<td></td>) which uses the class "productListing-data". To change the appearance, (text size, line spacing, etc.), add a new css definition in stylesheet.css. Look for:

TD.productListing-data {

font-family: Verdana, Arial, sans-serif;

font-size: 10px;

}

Immediately after, add a new class definition for the paragraph tag. For example, to make the font size always 90% of the size defined for TD.productListing-data, add this definition:

TD.productListing-data P {

font-size: .9em;

}

You can also control the padding, margin and other attributes of the paragraph contents here.

 

Third, "Other Products You Might Like" is set as a define in the language file for product_info.php, [catalog/]includes/languages/english/product_info.php.

 

I believe that answers your questions.

 

If it's alright with you, I'd like to include your questions (and my answers) in a FAQ for my website.

 

Talk to you soon,

-Skittles

Share this post


Link to post
Share on other sites
Anita;

 

Thank you for all of your eforts on this contribution. It's very nicely done and provides excellent options from the Admin interface. Install was a breeze and your instructions and user guide are first rate!

 

My little suggestion for upcoming versions (I've looked at doing this and just don't have the capability to bring it off) would be to make the item selection from within the Admin interface a search function rather than dropdowns (similar to what was done in Select Specials)

 

I've also noticed that whenever I do an addition or update, there is a long pause before the screen refreshes. I have around 3000 products in the database, and I suspect that the delay is due to the number of products. I don't know if there's a way to streamline the queries that are being done to improve the speed (and possibly reduce the query load) or not...

mugitty,

 

I'll take a look at the code in Select Specials and play around with a search based solution.

 

I think you are correct about the delay, that it is caused by the large number of items being returned for the drop-down lists.

 

Having to refresh the page for every change was the incentive behind several new features: 1) Reciprocate, 2) the option to combine Insert with Inherit, and 3) using a pop-up confirmation (or, optionally, no confirmation) for the delete function.

 

It could be a while before I have anything for you. I have several projects in the works, right now, that have to take priority.

 

My wonderful beta testers and I thank you for your kind words. We hope you will enjoy using this contribution, even with thousands of products!

 

Thanks again,

-Skittles

Share this post


Link to post
Share on other sites

Hi everyone!

 

First of all , thank u for the contribution!!.

 

Well i have a little problem, i´ll put a picture to show u the problem.

 

 

error1on2.jpg

 

 

error2zn7.jpg

 

I hope u can help me, im a new user.

 

Thanks!!

Share this post


Link to post
Share on other sites
Hi everyone!

 

First of all , thank u for the contribution!!.

 

Well i have a little problem, i´ll put a picture to show u the problem.

 

[images can be viewed in previous post]

 

I hope u can help me, im a new user.

 

Thanks!!

Hat3,

 

According to the error message, your product_info.php file is calling optional_related_products.php from the [catalog/]includes/modules directory, but the file is missing.

 

Assuming everything was working before making your modifications, it looks like the module file hasn't been uploaded to the modules directory.

 

Upload the module file, and see if that fixes it.

 

-Skittles

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×