jeffy777

Is it possible to have it auto-escape apostraphes?

found it thanks! http://www.oscommerce.com/forums/index.php?act...ndpost&p=684128

yes, it is running php5, and I just tried it on a server running php4 and it worked great. Now I'll see if I can find that fix, thanks :) If you happen to know a link to the post with the fix that would be great

Hi, I can only get it to update one product (the first row), it doesn't want to change any of the others. It exports the file fine and everything. I made sure there weren't any wierd characters in the descriptions. Any ideas?

I had this contrib running great on one server, then I moved the store to a different server and I got erros when trying to add an additional image. I fixed the problem by commenting out this line in admin/categories.php $sql_data_array = array_merge($sql_data_array, $add_data_array); Now all seems to be well :) Thought this might be helpful to someone.

Your answer is here: http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=729849

I'll try this one more time: Anyone?

Can anyone help me with this? I basically would like for it to export everything except the attribute stuff. Can it be done?

Is there a way to have it export a complete txt file except without the attribute info?

Well, it wouldn't be hard to make a custom script that just pulls all your products from the database and displays them like that,

Actually, there is a similiar contrib that works for your stor index: http://www.oscommerce.com/community/contributions,2125

Find ($column >= 3) and change it to ($column >= 2)

You just need to click "SQL" after selecting your OScommerce database, then copy and paste the query in and hit GO.

You need to run that query on your database. Hopefully your web host has provided you access to phpmyadmin? PS - I'm not the author btw :)

Ok, I've noticed that if you go to the Text Control page and then to the index.php section, if you specify a default Title and Description for index.php it is overridden if you put a Title and description for the Categories (when you edit the category tags individually). I like this. But I've also noticed that if you put keywords for index.php and for the categories then it will connect all the keywords together. Is there anyway to have it only use the index.php for the main catalog index, then only use the category keywords for the catgories? I hope that isn't too confusing :) Nevermind, I figured it out: I changed this: if (HTTA_CAT_DEFAULT_ON=='1') { $tags_array['keywords']= $the_category['categories_htc_keywords_tag'] . ' ' . HEAD_KEY_TAG_ALL . ' ' . HEAD_KEY_TAG_DEFAULT; } else { $tags_array['keywords']= $the_category['categories_htc_keywords_tag'] . ' ' . HEAD_KEY_TAG_DEFAULT; } To this: if (HTTA_CAT_DEFAULT_ON=='1') { $tags_array['keywords']= $the_category['categories_htc_keywords_tag'] . ' ' . HEAD_KEY_TAG_ALL . ' ' . HEAD_KEY_TAG_DEFAULT; } else { $tags_array['keywords']= $the_category['categories_htc_keywords_tag']; }

The only thing bad about editing the files directly is that if you make a mistake then you don't have a backup. So you should always download the file first, save a copy, then make your edit and upload. Everyone makes mistakes now and then, so it's better to be safe than sorry B)

so did you have to do anything to product_listing_col.php to get it to work? It's not working great for me...:( Well, I should say the product sort is working fine, but the Product Listing in Columns v2.1 is not. :blink:

Actually, I didn't make any edits to product_listing_col.php Do you have the 2 contribs working together properly?

Cool, thanks for caring, I really appreciate it :thumbsup:

I just tried using Product Listing in Columns v1.3 instead of of v2.1 and everything displays fine with the product sort contrib installed, but I'd much rather use v2.1 becasue of the attributes/add multiples. So the problem with v2.1 must be with product_listing_col?

hmmm....no luck for me: I set the name and buy now button both at 1 (everything else at 0) and now the button shows on top and the name shows doubled underneath, but the products are still sorted properly :). I tried just about every other combination of numbers lol. I think something needs changed to the code in products_listing_col.php since the product sort contrib has some edits in product_listing.php......... Here are the changes the contrib calls for to product_listing.php.... ================================================================= catalog\includes\modules\product_listing.php Line 64 Replace if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) { with //sort order if ($column_list[$col] == 'PRODUCT_LIST_SORT_ORDER'){break;} if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') && ($column_list[$col] != 'PRODUCT_LIST_MULTIPLE')) { // if ( ($column_list[$col] != 'PRODUCT_LIST_BUY_NOW') && ($column_list[$col] != 'PRODUCT_LIST_IMAGE') ) { //end sort order ------------------------------------------------------------------------------------------------------------------------ Line 95 Before switch ($column_list[$col]) { case 'PRODUCT_LIST_MODEL': Add //sort order if ($column_list[$col] == 'PRODUCT_LIST_SORT_ORDER'){break;} //end sort order ================================================================= So is this anything that needs to be somehow integrated into product_listing_col.php? The code is so much different from product_listing.php that I don't know where to begin :P What file are you referring to here?

Hey guys, I'm away from the store for the night, so I can't troubleshoot anything now, but I will tomorrow. It would be great if we could get to the bottom of this one! Here is the sql statement for the sort contrib: ALTER TABLE products ADD products_sort_order INT( 4 ) DEFAULT '0' NOT NULL; INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('', 'PRODUCT_LIST_SORT_ORDER', '6', '', '0', '', now());

good job, I'm glad you didn't give up :) Now if only I could solve my problem.....:(

Frank, have you tried combining this Product Listing in Columns contrib with this Product Sort contrib: http://www.oscommerce.com/community/contributions,2541 (latest revised version) If you can get it to work properly, that would be incredibly cool :) It still keeps displaying improperly for me (shows 2 "buy now" buttons per product, etc.) Thanks for all your hard work guys!

It looks like you're using an older version of the contrib?