Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
#1 01-26-2004 10:36:44
- Rizcorp
- Member
- Registered: 01-22-2004
- Posts: 18
Product Options Order
Does anyone know how to reorder product options. It apperars top place them in the order I created the options.
Bob
Offline
#2 01-26-2004 10:39:14
- sgreiner
- Member
- Registered: 07-26-2003
- Posts: 78
Re: Product Options Order
Bob,
See if this helps.
Scott
Scott
Offline
#3 01-26-2004 10:39:47
- Greg
- Member
- Registered: 12-07-2002
- Posts: 315
Re: Product Options Order
Change the order set to suit your needs. If one order set doesn't fit another product you need to setup another set of options.
Greg
GRC Web Building & Graphics
Offline
#4 01-26-2004 10:42:23
- Rizcorp
- Member
- Registered: 01-22-2004
- Posts: 18
Re: Product Options Order
I tried to change the product options order in the product page. Had no success.
Bob
Offline
#5 01-26-2004 10:43:41
- Greg
- Member
- Registered: 12-07-2002
- Posts: 315
Re: Product Options Order
sgreiner,01/26/2004 10:39:14 AM wrote:
Bob,
See if this helps.
Scott
That hack is for displaying related products. He wants to display the product options in a particular order, which is the order you created the option.
Greg
GRC Web Building & Graphics
Offline
#6 01-26-2004 10:50:59
- Greg
- Member
- Registered: 12-07-2002
- Posts: 315
Re: Product Options Order
Rizcorp,01/26/2004 10:42:23 AM wrote:
I tried to change the product options order in the product page. Had no success.
Bob
The routine writes that from the data/tables/optionsel.csv
Whatever order it's in there is the order it'll write it.
I don't understand why the order won't change through the admin, but you can go into the table and change it there.
Greg
GRC Web Building & Graphics
Offline
#7 01-26-2004 13:08:43
- scoutch
- Member
- Registered: 07-03-2003
- Posts: 3167
Re: Product Options Order
I'm sure this is a matter of CHMOD setting. Are you sure that all your CSV files are correctly set for writing permissions on your admin panel or FTP software ?
______________________________________________
THIS USER HAS BEEN BANNED FROM THIS FORUM.
If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________
Offline
#8 01-26-2004 13:35:39
- Rizcorp
- Member
- Registered: 01-22-2004
- Posts: 18
Re: Product Options Order
I am Using MySQL database
Offline
#9 01-26-2004 13:37:22
- scoutch
- Member
- Registered: 07-03-2003
- Posts: 3167
Re: Product Options Order
Oh ! I'm not using it yet but, by the time that someone will answer to you on this, I will find the answer since I'm supposed to have mySQL Database soon enough. 
______________________________________________
THIS USER HAS BEEN BANNED FROM THIS FORUM.
If this post contains any language related to
code samples, advice, etc., please read this
entire thread before making a decision to use
this post as a basis for any change to your
software installation.
______________________________________________
Offline
#10 01-26-2004 14:16:40
- Greg
- Member
- Registered: 12-07-2002
- Posts: 315
Re: Product Options Order
Rizcorp,01/26/2004 01:35:39 PM wrote:
I am Using MySQL database
If you were able to write to the file using the admin the first time I assume your permissions are OK, but like scoutch said, check them. Who knows something could have changed.
What you do to edit a file in the MySQL DB is to covert that file back to CSV do the edit and convert it back to MySQL.
Let me know what you find.
Greg
GRC Web Building & Graphics
Offline
#11 01-27-2004 14:25:35
Re: Product Options Order
I'd leave that one table (optionsel) in CSV mode if ordering of the items in it is an issue for you. MySQL has a very strange way of ordering the items in that table (for some reason unknown to me to date).
Nick Hendler
Offline
#13 08-29-2004 04:01:29
- Steven
- Member
- Registered: 04-21-2004
- Posts: 84
Re: Product Options Order
webmaster,01/27/2004 02:25:35 PM wrote:
I'd leave that one table (optionsel) in CSV mode if ordering of the items in it is an issue for you. MySQL has a very strange way of ordering the items in that table (for some reason unknown to me to date).
Nick, has there been any advance in being able to order product options in the desireable order for MYSQL users?
Steven
Offline
#14 09-09-2004 10:52:54
Re: Product Options Order
This will be addressed in CCP6, but in CCP 5.x it's not possible. The problem is with MySQL as it wants to return primary keys in alphabetical order. There is no way to do an ORDER BY INSERTION ORDER or anything like that in MySQL.
Nick Hendler
Offline
#15 11-19-2004 07:54:17
- rachaelr
- Member
- Registered: 11-12-2004
- Posts: 31
Re: Product Options Order
Am I right in thinking this thread is relating to the order that options are displayed on the page?
Ie I have products with multiple options (a pricing option, various other options), and I want my pricing option to display FIRST in the options area.
Will I need to hack the table ID's to resolve this? Or has someone done a perl fix to display the options in teh order they are added in the Product page?
Please let me know ASAP as this is a relativley big issue for our site...!
thanks
Rachael
Offline
#16 11-24-2004 06:03:49
- Hurricane
- Member
- Registered: 07-21-2004
- Posts: 2
Re: Product Options Order
Hi, I'm using the standard flat file method and I'm having diffculty re-ordering my Product Options. I realise they are in the order you created them but that's not much help really.
Is there a way around this without having to re-enter each option?
Thanks
Offline
#17 11-24-2004 14:22:08
Re: Product Options Order
You can edit the CSV files directly. This post was about option selection items - they're stored in the file ./data/tables/optionsel.csv. Make sure you download & upload this file in BINARY mode.
Nick Hendler
Offline