Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

lilwoo

Archived
  • Posts

    9
  • Joined

  • Last visited

Profile Information

  • Real Name
    Briana

lilwoo's Achievements

  1. Ya! I just set this up on my site. I followed the previous "checklist"; make sure your shop has the zip code set in the shipping section, make sure your products have weights assigned, enable the usps module using your "Web Tools" user ID as both your user ID and your password in the usps module, and set it to production server. Then call USPS (1-800-344-7779) and ask them to switch you to the production server on your web tools account. It updates almost immediately. After I did all of this, it magically started working. Hope this helps someone.
  2. I can't believe it!!!! I fixed it. I had and extra $ that was leftover when I had inserted //HTC BOC $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]), 'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]), 'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]), 'products_head_title_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])), 'products_head_desc_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_desc_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_desc_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])), 'products_head_keywords_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_keywords_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_keywords_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]))); //HTC EOC Thanks everybody for your help!!! Hope this process will help somebody else. You have to be REALLY accurate and attentive when you're replacing pieces of the code!! :)
  3. Do you know which code I should be looking for? I'm still stuck.
  4. Here is my code in the admin/categories.php file that (I think) relates to product insertion. To me, it looks like it is correct (?). Are there any visible errors that you see? if ($action == 'insert_product') { $insert_sql_data = array('products_date_added' => 'now()'); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_PRODUCTS, $sql_data_array); $products_id = tep_db_insert_id(); tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')"); } elseif ($action == 'update_product') { $update_sql_data = array('products_last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'"); } $languages = tep_get_languages(); for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $language_id = $languages[$i]['id']; $//HTC BOC $sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]), 'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]), 'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id]), 'products_head_title_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_title_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_title_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])), 'products_head_desc_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_desc_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_desc_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id])), 'products_head_keywords_tag' => ((tep_not_null($HTTP_POST_VARS['products_head_keywords_tag'][$language_id])) ? tep_db_prepare_input($HTTP_POST_VARS['products_head_keywords_tag'][$language_id]) : tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]))); //HTC EOC if ($action == 'insert_product') { $insert_sql_data = array('products_id' => $products_id, 'language_id' => $language_id); $sql_data_array = array_merge($sql_data_array, $insert_sql_data); tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array); } elseif ($action == 'update_product') { tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "' and language_id = '" . (int)$language_id . "'"); } } There are also two instances of the update_product that also look correct. Again, I really appreciate this!!
  5. Thank you so much for your time, I fixed the problem (hopefully) by removing the changes I made to the column_left.php file (they were optional in the instructions. But I think that your suggestions would still be beneficial! The html is kind of messy. :blush: anyways, thank you, thank you!!
  6. I think you're right. Do you know how/where I would go about changing this code? I'm a "follow the instructions" programmer right now, and I'm not sure where to go about changing this. In any case, thank you VERY much for the advice.
  7. I've recently installed two contributions (Header Tags Controller and "Bigger Product Image"). I'm a TOTAL newbie. I don't know much about how this all works, but I'm trying to figure it out. After making the required database changes, everything looks/works great EXCEPT for when I try to add a new product through my admin panel. I get this error when I try to finalize the product ("insert"): 1054 - Unknown column 'products_quantity' in 'field list' insert into products_description (products_quantity, products_model, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added, products_id, language_id) values ('22', '', '45', null, '23', '1', '1', '', 'fashion_show-389.jpg', now(), '35', '1') [TEP STOP] Can someone please advise me on how to fix this. I've tried undoing and then re-executing the two database queries, to no evail. I would be extremely appreciative of some advice. Thank you!!!
  8. After installing the Header Tags Controller Contribution to my OSC, my product page is all messed up. All pages in my shop are fine except for this. The formatting is all off and I'm not sure how to fix it. I would greatly appreciate some help. please reference: http://www.azhiaziam.com/catalog/index.php. Click on any product and see what I mean. Is there any way to fix this without reverting to a backup version? Thank you!!
×
×
  • Create New...