Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ascelon

Archived
  • Posts

    3
  • Joined

  • Last visited

Profile Information

  • Real Name
    Alex

ascelon's Achievements

  1. Well I tried leaving order.php unmodified and it appeared to fix the balance issue. I am not sure specifically what caused the problem as I am still trying to find it. However, I know reverting to the unmodified order.php file allowed me to import orders. Another question: Is there a way to re-export all of the orders? I am looking for a counter, or something, that I can reset that will allow me to try testing the export function on a full scale rather than one new order at a time (if that makes sense).
  2. function query($order_id) { global $languages_id; $order_id = tep_db_prepare_input($order_id); $order_query = tep_db_query("select customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_telephone, delivery_fax, delivery_email_address, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_telephone, billing_fax, billing_email_address, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_ccv, cc_expires, currency, currency_value, date_purchased, orders_status, ipaddy, ipisp, last_modified, payment_id,cc_start,cc_issue from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); $order = tep_db_fetch_array($order_query); $totals_query = tep_db_query("select title, text from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' order by sort_order"); $order_total_query = tep_db_query("select text from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' and class = 'ot_total'"); $order_total = tep_db_fetch_array($order_total_query); $shipping_method_query = tep_db_query("select title,value from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "' and class = 'ot_shipping'"); $shipping_method = tep_db_fetch_array($shipping_method_query); The issue could very well be the fact that I am adapting this to creloaded. Although I found most of the find/additions to be where the readme suggested to look.
  3. Any update on the balancing issue? Everything else seems to import correct, but everytime a customer is imported I am prompted with "The transaction is not in balance. Make sure the amounts in the detail area on the form for this transaction equal the amount at the top of the form." I am flat out confused as to what this means or what this is referring to. I have read through this thread several times searching for an answer and cannot figure it out :-/. I double checked the strip_tags in order.php and it is definitely there.
×
×
  • Create New...