Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Image, Product Name, Price, Buy Now, "BRIEF DESCRIPTION


6DV8

Recommended Posts

In any product category my products are listed 1 each line (odd line shaded-even line clear) I have an image of the product, the Name, the model, and the price. To see a description you have to click on a product. I WOULD LOVE TO HAVE AT LEAST THE FIRST 5-10 WORDS DESCRIPTION TO ENTICE THE CUSTOMER TO HAVE A CLOSER LOOK!!!!.

e.g. This product has fantastic qualities due to the................more info.

What do you think - do-able????[/i]

Link to comment
Share on other sites

There are a couple contributions that do this.

 

Short Description in Product Listing 1.2 - puts it all on the same row

 

Description in Product Listing v.2 - adds a new row for the description (with product image spanning both lines, if applicable)

"It's a damn poor mind that can only think of one way to spell a word."

-- Andrew Jackson

Link to comment
Share on other sites

I've downloaded and read readme.txt. Changing the PHP files I can quite easily do - but uh! run SQL?? Is running a SQL Queery easy enough to do. Looking inside my database I see the files that are mentioned. But I'm not sure how to execute what it is asking - ie. running SQL queery. Is this beyond me - keeping in mind that 2 weeks ago I had no idea how to mess with code and now I can.

Link to comment
Share on other sites

That is what I've got (it came with my server). Where it says------

 

Run the following two SQL queries on your database:

 

The first is to enable the display of Products Description in the Listing 0 = No 99 = Yes

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL);

 

I'm not sure what to do - But I can click on "configuration" and I see 'configuration ID - Configuration Title in the table - - Do I set some parameter here.

I really am appreciative of your advice!!

Link to comment
Share on other sites

I'm thinking out loud here- But because I hav'nt actually copied over the php files yet there is not entry in "configuration" that I can see that this is referring too - right! And so if I copied the files over I'd go to php myadmin and click on configuration and set the parameters to "0" or 99" then.

Does this sound right? Am I gettin' closer???

Link to comment
Share on other sites

In phpmyadmin choose your database then click SQL (or find whereever you need to be to run an sql query, it depends on the version) and copy, paste, and run both queries

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '', '', NULL, NULL);

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '350', 'How many characters would you like to display? ', '8', '12', '2002-03-16 18:51:26', '2002-03-16 18:51:26', NULL, NULL);

 

The reason there is nothing under "Configuration>Product Listing" yet is because you haven't run the sql queries.

 

Hope this helps!

"It's a damn poor mind that can only think of one way to spell a word."

-- Andrew Jackson

Link to comment
Share on other sites

Oh yeah...

 

And so if I copied the files over I'd go to php myadmin and click on configuration and set the parameters to "0" or 99" then.

Does this sound right? Am I gettin' closer???

 

This number you'll set in your osCommerce administration under "Configuration>Product Listing".

"It's a damn poor mind that can only think of one way to spell a word."

-- Andrew Jackson

Link to comment
Share on other sites

Paul_C - Hey my man- I didn't click on the databse -Bingo there it is "run mysql". Thanks. I have the confidence now to copy over those php files then I'll run the SQL queery and Voila - I'll have what I want (I bloody hope so after all this)

This Forum is so great! I have learnt so much about codes and databases and stuff right here. Who needs college (I did).

To Paul_C - Thanks.

Link to comment
Share on other sites

You're welcome :D I hope it works out for you.

 

I highly recommend doing as much of the hacking on a development server first and backing up everything (including your database) before making changes to a live site.

"It's a damn poor mind that can only think of one way to spell a word."

-- Andrew Jackson

Link to comment
Share on other sites

:( Spoke too Soon!

MySQL said:

 

 

You have an error in your SQL syntax near '`configuration` (`configuration_id`, `configuration_title`, `configuration_key`,' at line 1

 

 

Does this mean anything? This was run queery 1

Link to comment
Share on other sites

I tried it again with the other version (returns description on same line). That is I returned alll the files back then copied over the other version of php files I ran these queeries:

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Display Product Description (0=disable; 1=enable)', 'PRODUCT_LIST_DESCRIPTION', '1', 'Do you want to Display a truncated Product Description?', '8', '11', '2002-03-16 12:22:22', '2002-03-16 12:22:22', NULL, NULL);

 

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES ('', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '50', 'How many characters would you like to display? ', '8', '12', '2002-03-16 18:51:26', '2002-03-16 18:51:26', NULL, NULL);

 

And both returned syntax errors line 1 again

(Sigh)

Link to comment
Share on other sites

Sorry for the delay, I just got back in.. long night. I just entered the tables into your database, I trust things are working (let me know if otherwise). I put in the info for version 2 of the mod (it's the one I wrote so it's really the only one I feel comfortable supporting thoroughly).

 

I ended up entering the tables into the database by hand. For those interested (having similar problems), the code phpmyadmin echoed back to me for each query was:

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Display Product Description', 'PRODUCT_LIST_DESCRIPTION', '99', 'Set to 0 to disable, set to 99 to enable.', '8', '11', '2002-11-10 21:34:48', '2002-11-10 21:34:48', NULL, NULL);

and

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('0', 'Length of Truncated Product Description', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '500', 'How many characters would you like to display?', '8', '12', '2002-11-10 21:49:33', '2002-11-10 21:49:33', NULL, NULL);

 

I did the setting up, modification, and theme for ironorchid.com but it is based on phpnuke. Eventually I'll make my own CMS, but www.ironorchid.com is, so far, functioning just fine as is (still looking for more writers though, if anyone is interested just pm me) I think I'll leave it be for now (I don't own the site, just co-administer it).

"It's a damn poor mind that can only think of one way to spell a word."

-- Andrew Jackson

Link to comment
Share on other sites

It was like the "Tooth Fairy had visited me and left without me even knowing. This is really great Paul. Above and beyond the call of duty. I'm still not sure what you do - are you the PC fairy, do you work for Oscom or do just help people out????

 

I wonder.................. Can I change the size of the font to the description characters. At the moment I have set the Product name as a Heading style and the description has copied that.

 

Again that was some nice work paul.

 

By the way uhhhh- did you kinda notice my other post about the drop down box by any chance. Just asking!!!!

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...