Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Product listing sort order


spooks

Recommended Posts

Ok I get you now sam, I see theres an extra php casing around it! making it like a proper php link and not just a crappy html it actually keep them like on file while they are shopping ok! wicked!!! well that is one of those terrible problems out of the way! im gona try on my flash buttons too! but the thing that is puzzleing me is why would the ostemplate be without these better links? i used this version : oscommerce-2.2rc2a

 

 

osC rc2a is not a template, if u download that from this site u will find all links use tep_href_link, many templates are written with bad code, as frankly the writers don't have a clue, they make it pretty so u buy it, they care nothing more.

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

  • Replies 177
  • Created
  • Last Reply

in flash u create an xml file with the links, that way it works, take a look at http://addons.oscommerce.com/info/4545

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

ok I am looking at the xml file for this addin and i can see a link to the products id so id say it pulls the image of a new product out of your new products(?) php(?) and embeds them into the flash as it rotates. whe you click it loads the right product id page. but this also looks like it eather goes on your header or footer (im a bit paranoid, will this change any thing or just add in?) it is a pity they dont show what happens in the swf (what code they put in the fla file to make it connect) looks cool though.

i found this site here http://www.kirupa.com/developer/actionscri...h_php_mysql.htm it look like you can some how write php in flash!

Link to comment
Share on other sites

To Sam,

 

I don't understand any of this and i looked and looked on goggle all tonight. I've also tested again my site carrying around all sorts of items and i never loose them and it never logs me out. i am gonna try tomorrow with a few friends to see how the site copes with more than one user logged in using the site.

On a separate note I read your vampires thing looked around the forum and find that you post a great deal sam! it is funny tho your general attitude does not make seance to me. you recommend this flash carousel addin to another poor soul who asks 'anyone' who knows please help. but you also say xml to him too. You like to help but only so far like to point others in the right direction (this is the impression i get from you sam)

this is what you do politely when some one is taking the ppp* to mabey say "ok ive helped you enough now move on." it is a very strange way to act inishialy (i am sorry i cant spell any thing right) sam it seems confusing that you spend lots of time on here but have the same attitude of everyone.

 

I hope i am not offending you but the vampires thing alog with your attitude has slightly offended me... specially when i found that you told this flash button use the addin and xml to another as if knowledge is precious and to be guarded like "find your own knowlege" even though they didnt ask you personaly! dude i am a great artist I can draw any thing! I am not a php programmer im still not even shure what it is lol i just really really am desperate to start selling my work as i am broke! no doubt this other person was similar, dont forget that this is a forum for getting help Sam, its a place where people who are very talented at there work and want to sell it but are having problems dealing with advanced php html xml java and all sorts of mumbojumbo. Its not that they want there work done 'for' them! its that php and java are not easy i have been googling for days and days my eyes are now square!

 

If your attitude is still this help vampires, mabey you should not be aloud to fly around danggling half help in peoples faces with this get your own knowlege attitude. how would you know that xml is what i need youve obviously read it somewhere a tutorial or some thing? i mean look when ever i find something new out i tell people how! see any of my posts a few are questions and are a few saying hey look i can do this now you can to!

 

Ben.

 

ps: if this double posts then it just means that this site has problems!

Pps: forums themselve are made by help vampires, because its an exellent way of getting all of your work done for you having lots of helpful bussy bees answering all yor help desk questions so you dont have to! mabey forums themselves go against your principals Sam.

Link to comment
Share on other sites

A strange rant! I did`nt write the 'help vampire' piece, but it describes some here, if u object to it then reply to that post. When you've been around this forum for a while you will see quite a few 'helpers' point out that post to certain people, for good reason.

 

It seems your main reason for your rant is that I pointed a possible solution but did'nt hang around to spell it out to you, sorry but I'm not here all the time!!!

 

One of the objectives of this forum is to help poeple learn to find their own solutions, then they need less & less help, so pointing them in the right direction is much better than spelling it all out to them, so they learn nothing & just keep asking.

 

Anyway that site u found looks a usefull resource so I`m sure you'll be able to use that to sort yours.

 

 

PS If u feel u can ignore the sid issue, fine its no skin off my nose, but read the 'further reading posts' I gave, because you ignore it at your own peril.

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

I aint ignoring you bruv nor what you say about sid, i just find you really confusing! infact i have not slept cant digest xml i can find things but with no clear outcome or intention (it seems like xml is a communication between languages, simple xml seems feasable to learn but only if all the meaning less jargon is replaced with some sort of goal in mind)

 

Ive been thinking of how i could get around this but still do what you are saying with the links and so far ive come up with this:

 

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Untitled Document</title>

<script language="JavaScript" type="text/JavaScript">

<!--

function MM_reloadPage(init) { //reloads the window if Nav4 resized

if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {

document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}

else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();

}

MM_reloadPage(true);

//-->

</script>

</head>

 

<body>

 

 

<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="819" height="150">

<param name="movie" value="bar.swf">

<param name="quality" value="high">

<embed src="bar.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="819" height="150"></embed>

</object>

<div id="Layer1" style="position:absolute; width:160px; height:84px; z-index:1; left: 16px; top: 22px;"><a href="<?php echo tep_href_link('NEW.php'); ?>" class="style7 style1 style1" >NEW</a><img src="png.png" width="74" height="48" border="0"></a></div>

</body>

</html>

 

I started off I think experimenting with some sort of planetary image map example and then I went to cutting out my swf buttons trying to convert my swf bar to a html one using a table (it looked terrible). now I am trying to use a layer over my swf, the layer is suppost to contain a see through button that has the html <a href="<?php echo tep_href_link('NEW.php'); ?> style sid friendly link in it. but so far the swf seams to aurgumentively want to be on top of everything!

Link to comment
Share on other sites

I just asked my mums huspand who has been running his os commerce site for a year or so, if he has ever had problems with orders going missing, items being lost and accounts becoming muddled. he said no!

Link to comment
Share on other sites

osCsid i just entered that in the search at Club osCommerce and it came up with nothing! dont you think that if it was a real problem then it would at least have a mention! your a fake Sam

Link to comment
Share on other sites

Flaming is against forum rules, go away you ignorant t....

 

http://www.oscommerce.info/kb/osCommerce/D...plementations/4

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

  • 2 weeks later...

Hi,

 

I have read the whole thread and there are a few of you that have the same problem that I am facing now. All my product names are starting with "F." followed by a number, ie "F.10 xxxx" or "F.1 xxxx". Now, when they are listed they come up as follows:

 

F.10 xxxx

F.1 xxxx

 

Obviously I would like them to come up as follows:

 

F.1 xxxx

F.10 xxxx

 

Can anybody help me with a code for this?

 

Thansk!

 

Hans

Link to comment
Share on other sites

Thats standard for the way any computer sorts data. If u want it any other way you'll have to write your own algorithm

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

Is there any way to use this with ultimate SEO URL ON ?

I have searched all over the net and i found nothing for this.

Can you help me please?

 

 

Ok

 

Don't tell me, you have search engine friendly url is set to 'on'?

 

If you look in the thread for that contrib you will see posts about that issue & the fix.

 

 

Wow! Spooks, you are the Bestest!

 

I did install the Ultimate SEO URLs contrib a while back. When I turn that off, my sort order problem goes away!!! Thanks so much for your help in pointing that out to me. I have not found the fix yet, but I see there are several versions after the one I installed, so it may be in one the new ones or in the thread somewhere. I guess will have to go find it.

 

Thanks again

Link to comment
Share on other sites

the fixes are was refering to are here

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

  • 1 month later...
I took a look at that thread & unfortunately thats more of a 'work around' than a fix, you should'nt be messing with product-listings.php as the '+' is created in functions/general.php by the function tep_create_sort_heading.

 

The line in question is 870:

 

$sort_suffix = (substr($sortby, 0, 1) == $colnum ? (substr($sortby, 1, 1) == 'a' ? '+' : '-') : '') . '</a>';

 

you could simply replace both the '+' & '-' with '' or use images for more obvoise display of the function.

 

Thanks Alot!

I was struggling to remove the sorting order completely, but this worked just fine!

Thanks again!

Link to comment
Share on other sites

  • 2 weeks later...

Excellent, thank you so much for your topic! :)

 

I've done what you've shown and changed the code to:

 

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
	  $_GET['sort'] = 0 . 'a';
	  $sort_sql = " order by p.products_date_added ASC, pd.products_name";
} else {

 

However, for whatever reason, my products are listing in DESC order (oldest added at the top to newest added at the bottom). No matter what I change I can't get it to ASC (newest products at the top, oldest added at the bottom).

Am I missing something really simple? :huh:

 

Removing the a and the ASC also didn't work. Hmm. I'm not sure what else to change. This is for products listed under categories right?

 

Any help would be greatly appreciated, as always :)

 

-Taven

Link to comment
Share on other sites

Urg! I just can't get this to work.

 

I noticed that on my "New Products" module, that the products were being listed by date_added and in the correct order, newest(top) to oldest(bottom). So I checked the code for it in new_products.php and found:

 

order by p.products_date_added desc

 

Ok. So "desc" seems to list them from newest(top) to oldest(bottom). Makes sense.

 

So then why does...

 

if ( (!isset($HTTP_GET_VARS['sort'])) || (!ereg('^[1-8][ad]$', $HTTP_GET_VARS['sort'])) || (substr($HTTP_GET_VARS['sort'], 0, 1) > sizeof($column_list)) ) {
	  $_GET['sort'] = 0 . 'd';
	  $sort_sql = " order by p.products_date_added desc, pd.products";
} else {

 

 

... list my products from oldest(top) to newest(bottom), the complete opposite of the new products page? And when I change desc to asc and d to a absolutely nothing changes with the order of the products?

 

I must be missing something. I just don't know what. :(

Link to comment
Share on other sites

  • 3 weeks later...

It's been a while I know; but I've only gotten the chance to give it a good look today. :lol:

 

For others with the problem above, here's the solution.

 

The line:

 

$sort_sql = " order by p.products_date_added desc, pd.products";

 

Should actually be:

 

$listing_sql .= " order by p.products_date_added desc, pd.products_name";

 

Here's Why:

 

First of all, $sort_sql is not used anywhere else in the code- making it useless. The correct variable to be setting is $listing_sql.

Second, you don't assign the string to $listing_sql, as that overwrites the beginning half of the query already assigned to it. Instead, you want to add it to the end. So, replace '=', with '.='

Third, pd.products does not exist in the database at all- there is no "products" column in the table "products_description". The correct column is 'products_name', so in full, 'pd.products_name'

 

Perhaps the original code was written for an older version of OSCommerce? Otherwise- I'm not quite sure why the original code worked for anyone. :huh:

 

With those three things corrected, all products will successfully list by the date they were added. :)

 

 

-Taven

Link to comment
Share on other sites

This seems to be u fixing an issue that is perculier to u, if you read this thread it has

 

$listing_sql .=

but u used

 

$sort_sql =

 

and found it didnt work till you 'fixed' it by putting

 

$listing_sql .=

why did'nt you just read through first?

 

 

obviously pd.products must be some typo u introduced some time or other

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Link to comment
Share on other sites

This seems to be u fixing an issue that is perculier to u, if you read this thread it has

 

$listing_sql .=

but u used

 

$sort_sql =

 

and found it didnt work till you 'fixed' it by putting

 

$listing_sql .=

why did'nt you just read through first?

 

 

obviously pd.products must be some typo u introduced some time or other

 

I did. ;)

But I obviously missed something however, or in an attempt to get it to work changed something breaking it further. Instead of leaving my "simple mistake" question completely unanswered however -as it had been for two weeks or so- I decided to answer it myself once I found the time to solve it, just in case someone would find themselves in the same or similar situation, however rare that might be. Looking back, yes, your code should have worked the first time I used it. :)

Link to comment
Share on other sites

  • 2 weeks later...

Hi spooks,

 

thanks for this cool thread. i;ve had a look through the forum and i have not yet found an answer to what i am trying to do.

 

i want to have the items the client orders sorted alphabetically on thiir order listing, which is also what the invoice and packing slip prints from.

 

it makes it a lot easier to fill the order if they are in alphabetical than the way it is now (which i am certain is the order they added them to the cart).

 

 

would the suggestions you have made so far apply to this? and if so is there anything different i need to do? and where to go?

 

sorry for the dumb question but i am 30 pages into a search on the forum and have not yet found the answer i think is correct.

 

Cheers

 

AL

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...