Packing Slip attributes sorting randomly

[Alfonso2013]

How can I show them to you? I don't know where to click.

[Ajeh]

Let's say your customers_id was 2, you could do a search for:

SELECT *
FROM zen_customers_basket_attributes
WHERE customers_id = 2;

and obtain all the fields from the customers_basket_attributes for just customers_id 2 ...

[Alfonso2013]

Ok I hope I did it ok. The first screen is the result of the search. The second one when I click on the first attribute. I don't know how to show a table with the values of all of them at the same time. I have to check them one by one.

Sincerely:

Alfonso

[Ajeh]

You have an odd phpMyAdmin that it does not display all the fields on 1 row per attribute ...

I was hoping to spot what might be causing this issue ...

Is this a clean install of Zen Cart v1.5.1 or an upgrade?

[Alfonso2013]

Ok, my host is GoDaddy ( I know, apparently not the best host). You can ask their customer service to install the application and they did it. It is a fresh new installation.

Is everything ok in the SCR4? in product_options_sort_order dropdown Function menu shouldn't be something chosen?

Thanks again.

[Alfonso2013]

Ok, now I am investigating more the SQL table and I have one question: I can see in SCR4 that the products_options_sort_order is defined as TEXT, and the value is 10.00001, where there should be a 10 alone.
Why is defined as text? shouldn't be defined as INT or MEDIUMINT or TINYINT (any numeric definition) so the table can read it as a number and to order the attributes in ascending order?

Will that be the problem? should I try to modify that definition?

[Alfonso2013]

Ok. I could finally take a picture of the sort order of the product_option_sort_order attributes. It looks pretty messy to me. Obviously there is a mistake since I define order in integer numbers of 2 in Zen Cart admin attributes order ( SCR6), and they appear with 5 decimals and in not ascendent order. How can I fix this mess? How can I define the ascendent order?

[Ajeh]

The Sort Order and what is store in the database table for the customers_basket_attributes will appear different, but they are looking more or less correct ...

[Alfonso2013]

SOLVED, SOLVED, SOLVED!!!!!!!!!!!!!!!!!!

I nail it. Thanks Linda, for showing me where to look for the solution.

I am going to explain how I did it, step by step.

Firstable. I read here: (http://www.zen-cart.com/wiki/index.p...ket_attributes) the next, and I quote in BOLD:

"When an order is placed, the orders class takes the information in the currently active cart and transfers the order details from the cart into the orders_products_attributes table, constituting part of the order placed."


Then you go to that table (orders_products_attributes) and in OPERATIONS, you choose MODIFY ORDER BY OF THE TABLE, select (by default) " order_products_attributes_id " ONLY "Ascendent", press CONTINUE, and VOILA!!!!!! (See Picture)

Now all of your orders will magicly arrange and appear with the correct attributes order.

Again, thanks Linda, for showing me where to look for, and I share the solution with the Zen Cart community.

OLD PROBLEM AND BUG, AND MISTERY, SOLVED!!!!!!! IN 2013.

[Ajeh]

Thanks for sharing the solution that worked for you ...

It is odd that you had to do that but I am glad you found this strange issue ...