equate Posted January 2, 2003 Posted January 2, 2003 Hi, I got oscommerce going btw, and the main topic of my site is customized computers. Therefore I have LOTS of options that I plug in. Is there anyway on the pull down menues to list them from leat expensive to most expensive? Or alphbetical? Just mainly so their not strooled all over.
equate Posted January 2, 2003 Author Posted January 2, 2003 would there be any way to make a script to do it?
Ajeh Posted January 2, 2003 Posted January 2, 2003 When looking at the products the customer can click the titles to sort them.
equate Posted January 3, 2003 Author Posted January 3, 2003 what do you mean they can sort them? Like on the pulldown menu, I want to display what comes standard first ($0) then they can change the options upgrading the prices, that way if they don't want to change an option they can add to cart at the list price, But if they just hit add to cart now it would take some options and jack the price up,..
Ajeh Posted January 3, 2003 Posted January 3, 2003 I am sorry ... I think I misinterpreted what you are trying to sort. I was referring to the product listings. I think you are referring to the attributes on the product_info page You can change the order of the display to be by price so the lowest option is at the top and the highest is at the bottom. Just change the order by on the select statement for the attributes.
equate Posted January 4, 2003 Author Posted January 4, 2003 What??? I se no option to "list by price"
equate Posted January 4, 2003 Author Posted January 4, 2003 heres exactly what i want to do, I want "Standard Case" at the top of the list so it is the default option, I want it to list so the the cheapest items are at the top and most expensive at the bottom.. http://www10.brinkster.com/equate/attrib.jpg Thats what I have now, "Case Full Black" is at top I want it below "Standard Case"
equate Posted January 4, 2003 Author Posted January 4, 2003 ok this is seriously pissing me off so bad now, im ready to throw my computer out the window. I add attributes, I get them all in order, then I ad another then It puts it at the bottom of the list, ok.. then I add another, it puts it at the top of the list... wtf.. theres no order, this POS just puts crap where ever it feels like, so when users add the un customized computer to their cart it adds a bunch of crap they don't want because it won't choose my default setting... this program is serisouly ****ed up for attributes..
Ajeh Posted January 4, 2003 Posted January 4, 2003 One of the reasons that I and others have written various add-ons for sorting the attributes in the exact order per product that you want is so that you do not have this frustration. You might look into the Attributes Sorter and Copier add-on in the contributions as it would solve your problem on this.
equate Posted January 4, 2003 Author Posted January 4, 2003 ok good, man i thought it was just me.. its usually ALWAYS the user thx man
equate Posted January 4, 2003 Author Posted January 4, 2003 Im assuming I want the Alternative Attribute Handling, what version is it for tho? It just says current.. so I am assuming 2.2? If then how do i make it go lol? I did just what It said but i see no change.
equate Posted January 4, 2003 Author Posted January 4, 2003 nvm wrong one.. lemem jus play around abit
Ajeh Posted January 4, 2003 Posted January 4, 2003 The one I am referring to is the Attributes Sorter and Copier v5.0 That is the current one for the November 1, 2002 and newer snapshots. There is also an Attributes Sorter v4.0 which does not contain the copier features but works on older snapshots prior to November 1, 2002 And ... I think the Attributes Copier v1.0 will work with either. That was just a simple one for copying attributes to duplicate products. Not a full blown copier like the current version is. Got all that? :shock:
equate Posted January 4, 2003 Author Posted January 4, 2003 bah, I installed the wrong one.. well lemme jut dump everything, i basically messsed it all up and Ill put that one on and start over, thx for the help
equate Posted January 4, 2003 Author Posted January 4, 2003 Ok, im confused on how to set this up, it says inser this configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Category/Products Display Order', 'CATEGORIES_SORT_ORDER', 'model', '<b>Valid Orders:<br>products_name<br>products_name-desc<br>model<br>model-desc</b>', 1, 99, '2002-12-30 13:28:47', '0000-00-00 00:00:00', NULL, NULL Into configuration.. which one? I don't really get what im doing
Ajeh Posted January 4, 2003 Posted January 4, 2003 Using phpMyAdmin, you are changing the table called configuration and the change is the code listed below. 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 ('', 'Category/Products Display Order', 'CATEGORIES_SORT_ORDER', 'model', '<b>Valid Orders:<br>products_name<br>products_name-desc<br>model<br>model-desc</b>', 1, 99, '2002-12-30 13:28:47', '0000-00-00 00:00:00', NULL, NULL); This will add a new row to the table and that can then be edited from the Admin under the My Store setting.
equate Posted January 4, 2003 Author Posted January 4, 2003 ahh ok, then when Im in phpmyadmin and I goto the table and select the sql option SELECT * FROM `configuration` WHERE 1 Is already there in the box, do I just delete that?
Ajeh Posted January 4, 2003 Posted January 4, 2003 Yes, just delete that each time and paste in the new commands for each of the tables as described in the README.txt file.
equate Posted January 4, 2003 Author Posted January 4, 2003 it won't go!!!... I did everything the instructions said, I added all the table changes and copied all the files over, but when I goto attributes it dosn't look anything like it does in the demo. all I see different is a sort order option
Ajeh Posted January 4, 2003 Posted January 4, 2003 Are you sure you downloaded the Attribtues Sorter and Copier v5.0? Attributes Sorter v4.0 just has a sorter. Attributes Copier v1.0 just has a copy attributes on duplicate products. If you do not see the Coming Soon stuff ... sounds like you loaded v4.0
equate Posted January 4, 2003 Author Posted January 4, 2003 No i am sure I got 5.0, I tried firts doing it all myself by copying the files, then I tried just copying the "catalog" and "admin" folders from the zip to my folders so it added the stuff. Then I added the sql tables.. I still don't see all the options I should
Ajeh Posted January 4, 2003 Posted January 4, 2003 The one you want is at: http://www.oscommerce.com/community/contributions,772
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.