Deleting Products, Options & Shipping

I have these 4 Issues (PS3), please take a look:

1 - I have deleted a product which I do not see on the front end but it keeps showing in the admin/products area which is very "Annoying", please let me know what to do..

2 - I have set up about 20 products with many options of length and color, and now some of the products show their options out of order, 32/24/16/18/10/12 where the first few show the option of size correct, 12,14,16,18,24,32, etc. (How do we correct this & why)..

3 - In this store, I will offer 2 shipping methods, Is there a way to choose the shipping before going to PayPal, just like any other store out there you pick your choices, and then shipping and then you pay after you have explored your shipping options.

4 - I placed a 10.00 item to test, I go through the checkout and after continuing with Paypal last step, I come back to a page where it wants me to login again, where the

Order Summary has the price, but the
PayPal Express Check out is empty
Shipping Info = empty
and email address field is not available
Password = Field Open
Confirm Password again = Field Open

1) was this a product that had options You will need to delete the options before you can delete the product itself.

2) on the product_details.php page, add an order by clause to the options recordset:
change:

$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID  WHERE ps3_options.OptionGroupID = %s  ", GetSQLValueString($OGIDParam_OptionValues, "int"));

to:

$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID  WHERE ps3_options.OptionGroupID = %s  ORDER BY OptionNameOptionName ASC", GetSQLValueString($OGIDParam_OptionValues, "int"));

3) Power store does not support selecting the shipping provider, it would require hand coding to accomplish . This has been added a s a feature request to be considered for a future version.

4) this is an issue that was corrected in the Power Store 3.01 upgrade, make sure you are using the power store 3.01 files that are available from the download center.

Thanks for Reply:

As far as issue

#1 (I have deleted a product which.....) when I go to manage, I do not see anything so no options are there for me to remove, the product shows up in the admin but when I click on
A) "Product Details" (I see a shopping cart that is empty)
B) "Update" (It's empty)
C) "Manage Options" (It's empty)
D) "Delete" (It let's me delete but again it's there listed)
E) "Charts" (Nothing)
so as you can see I have tried everything within that product, there is nothing else to delete, options or otherwise.

#2 (Will do)

#3 OK

#4 I think I did upload 3.01 but that have been an old store so I will check..

Item #2
"on the product_details.php page, when I did what you asked, I received this error on the front page "Unknown column 'OptionNameOptionName' in 'order clause'" so I put back the old for now..

Please let me know

sorry the order by clause should be:
ORDER BY OptionName

$query_OptionValues = sprintf("SELECT ps3_options.OptionID, OptionName FROM ps3_options INNER JOIN ps3_optiongroups ON ps3_optiongroups.OptionGroupID = ps3_options.OptionGroupID  WHERE ps3_options.OptionGroupID = %s  ORDER BY OptionName ASC", GetSQLValueString($OGIDParam_OptionValues, "int"));

They seem to be mostly fine, but take a look.. I still have a problem with this....

Products_Detail.php?ProductID=149

for the single digit sizes to show at the top of the list, you will need to add a leading 0:
08" - 09"