srturner47,

your update fixed many issues, but... i was trying to edit an order today by adding an item to an order and got this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '27.0000', products_options_id = ' at line 5
in:
[insert into orders_products_attributes set orders_id = 2043, orders_products_id = 2383, products_options = 'length', products_options_values = '3/8" x 33'', options_values_price = '27.0000', products_options_id = '23', products_options_values_id = '174', price_prefix = '';]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
fix ideas?

thanks.