sorting in xsell

[peecz]

Hi.

I am pretty new to this whole oscom scene. Recently added xsell - seems better than related_products nevertheless I am having problems.

My shop has more than 4000 goods. Each product_id was assigned randomly. Since it is sorted by product_id I have to look up each products id in mysql table "products" then divide products_id by 20 [products shown per page] and this is how i get xsell page on which the product i am interested in is listed. [alltogether 430 pages :'( ]

 

So I was thinking - is it hard to implement search function and is it hard to implement sorting by product name? The most awesome thing would be if the listing was divided alphabeticaly according to "products name" [e.g A B C D E F G H and when you click on A it shows all products where products name starts with A.

 

Since I am newbie and don't know heck about php and now just a little bit more about sql, I don't know whether this is possible and how hard it is. Would be very grateful if somebody did this.

 

Thanks

;)

[Top_Speed]

So I was thinking - is it hard to implement search function and is it hard to implement sorting by product name? The most awesome thing would be if the listing was divided alphabeticaly according to "products name" [e.g A B C D E F G H and when you click on A it shows all products where products name starts with A.

 

You can do this with MS Excel (or most any spreadsheet that can export tab D format).

 

i.e.

1st import your products in (I'll say Excel) Organize your cells (Decript) Alphabetically A-Z, make your v_categories_name_1 your 1st Category, ...._2 (the next) until you have enough child folders to put your items where you want.

The last would be your products folders (i.e.) v_categories_name_3 which would be lets say your "A" group listing. Simple copy & paste teh "A" until you find the group of products that start with B, then you would copy & paste "B" in that column and so forth. This would breakup your items like you want.

 

If you don't make the folders A-Z, they will be made for you, just name the parent folder with the correct name.

 

IT sounds worse than it is, once you get the hang of it... it will fly. I would test like the first few rows on import to see what & where it goes :blink:

Cheers! KJ

[joma]

just wondering, i am looking over this, but i sell caravans. not computers, although i want to allow custome building of caravans. There is no way to like this to either attributes or have hidden categories because i for say can't sell some things that get done when a van is build to the public..anyone understand..?? I have been trying to do it with just attributes, but i am not having any luck with changing my product_info.php file..coz i am new to php.. :angry:

 

 

you can see what i mean at

 

http://www.caravanmart.com.au

Edited December 13, 2004 by joma