b2995

My site ships free ground but offers express shipping...which saves the shipping cost. But I keep overlooking it!

Is there a way to display a simple text, bold, in red on the admin/orders page right below payment type "Express Paid" when it's NOT free shipping or when shipping doesn't equal zero?

Thank you!

I finally figured this out and wanted to share it since I've seen a lot of posts on the subject. Since my Option Values are not set in stone, I needed a way to sort by NAME instead of date-when-added or by id.

In the Product_Info.php page, look for the following around 225:

$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . " ' ");

REPLACE WITH:
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . " ' order by pov.products_options_values_name desc");

Can someone please tell me how I can add a simple input field in the ADMIN / ORDERS.PHP page?

I need to add a reference field to the order. This number is not generated until AFTER my customers order. I don't need my customers to see this number...it's just a linking number so I can link the order to an accounting report that is sent to me.

Thank you!

This is driving me absolutely NUTS! It seems everyone is concerned about just sorting the attributes or option values, but I need the Product Options themselves to sort by the order I created them (by ID) on the ADMIN side!

They're listing correctly on the storefront, but I also need them to display in the same order in the ADMIN/ORDERS.php page by ID.

EXAMPLE of a product listed on Admin/Orders.php with their (ID#):
ProductABC
(2) - Color: Blue
(1) - Size: XXL
(3) - Sleeves: [select a sleeve size]

I need them to list by size (1), color (2) then sleeves (3).

Also, is there a way to NOT show an Option Value if nothing is selected (example #3...nothing was selected)? So only #1 and #2 would be listed under this product if those were the only options chosen.

AND...is there a way to make #1 and #2 REQUIRED if it's left on an Option Value ID (example [select color]=ID 5) when my customers ADD the item to cart? My Option Values each list something like [select] as the first ID.

THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU

I run a drop-ship business so every order I have to copy the delivery address and the order details, and email it to my vendors. Does anyone know if there's a contribution where I can click a button or a link that will open my email editor and paste this information for me?

Thank you!