Jump to content

pantarra

Members
  • Content count

    51
  • Joined

  • Last visited

Profile Information

  • Real Name
    Gina

Recent Profile Visitors

5,731 profile views
  1. pantarra

    ot_membership

    can I get help installing I will pay email me gpn0711@gmail.com
  2. pantarra

    Quantity Price Breaks

    does anyone have a working version of this great module? I have it working but the attrabutes is not working.. Id gladly pay for a working version lets talk I need it soon
  3. pantarra

    Quantity Price Breaks

    Does anyone have a working version of this Module for 2.31? I cant get this module to work on 2.2 . error mysite.com/admin/categories.php Fatal error: Call to undefined function tep_hide_session_id() in /home/web/public_html/mysite.com/admin/categories.php on line 917 Error: mysite.com/admin/discount_categories.php 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 '-20, 20' at line 1 select dc.discount_categories_id, dc.discount_categories_name from discount_categories dc order by dc.discount_categories_name ASC limit -20, 20 Please Help Im lsot on this Ive searched forum
  4. pantarra

    Quantity Discounts

    Thank You
  5. pantarra

    Quantity Discounts

    is there a module that gives a discount depending on quantity I tried this module Quantity Discounts Module for osCommerce 2.2 and 2.3 Version 1.0.2 but I need a quanity discount for each product and there are many products
  6. after reading last post aboyt Paypal I re re re installed its still not working for me when swicthing over to pay pal it appears while Processing Order, Please Wait this is where the error is then i get The link you have used to enter the PayPal system contains an incorrectly formatted item amount. yet paypal express works but pp standard dosnt work
  7. for me the standard paypal works fine without the 1 page checkout ( I turn off 1 page checkout and also have 2 versions install 1 with your addon 1 without) standard paypal check works fine when 1 page checkout isnt install or when I turn off 1 page checkout yet paypal express works for me but its display in paypal dosnt work for me but when I turn on 1 page checkout I get that error The link you have used to enter the PayPal system contains an incorrectly formatted item amount. im using the paypal addon thats part of OSCs 2.31 installation, Paypal is I think the #1 method of paying online, I would never put my CC number anywhere especially on ebay or and shopping cart Thanks again your addon looks great
  8. thank you for your help I reinstalled everything from scratch I have no other addons when I use paypal express it works fine, but i need customer to be loged in so paypal express dosnt work for me when I use paypal standard I still get this message from paypal The link you have used to enter the PayPal system contains an incorrectly formatted item amount. although paypal express works paypal shows the transaction on paypal looks like this Pay Rent OnlinePay Rent Online $575.00 Item number: 29 Item price: $1.00 <======I dont want this showing Quantity: 575 <======I dont want this showing when I use paypal standard without 1 page checkout payment goes threw paypal displays this which I prefer, notice item price and quanity Tenants Payments OnlineTenants Payments Online $575.00 Item price: $575.00 Quantity: 1 when I use your excellent mod with no addons I get the error above, I have the OCS product set to $1.00 and use the quanity to adjust the rent amount to whatever the renters rent is.. Id love to have your addon working but I have to use only paypal standard not paypay express paypal express works paypal standarrd dosnt work Please help Thank You so much
  9. Paypal express works but I need user to be loged in is there away to take off paypal express button from the shopping cart.php page? everything would work then
  10. thank you for your help I reinstalled everything from scratch I have no other addons when I use paypal express it works fin, but i need customer to be loged in so paypal express dosnt work for me when I use paypal standard I still get this message from paypal The link you have used to enter the PayPal system contains an incorrectly formatted item amount. thanks agin for your help
  11. Thanks so much for this addon , really nice work but my problem im getting a error from paypal The link you have used to enter the PayPal system contains an incorrectly formatted item amount. im using paypal payments standard also the Quantity field ( im using OSC for paying rent online and setting the amount of rent as the quantity the price $1.00) every time I try to input say 300 I can only input 1 number at a time, this may be confusing to tenant also since im not shipping a product I dont want any shipping I tried taking out shipping methods and I get error Shipping selection error you must select shipping method, but when I turn on shipping with zero amount no error but I prefer not to show shipping Thank you so much for this excellent addon
  12. I have a rental property and Id like to let tenants pay their rent online theres different prices for apartments and Id like tenant to enter amount to pay is there a addon to allow this? Thank you
  13. pantarra

    help installing paypal pro

    were having problems with paypal pro contrib would anyone be interrested in helping me setup this payment system I will pay for help please email me gn@artastic.com
  14. pantarra

    Export orders shows blank page

    I have the page loading but now I get this database error 1054 - Unknown column 'customers_fax' in 'field list' select 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, customers_dummy_account, customers_id, customers_fax, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, 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_expires, currency, currency_value, date_purchased, orders_status, last_modified from orders where orders_id = '1' please help thanks <?php/* $Id: order.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ class order { var $info, $totals, $products, $customer, $delivery; function order($order_id) { $this->info = array(); $this->totals = array(); $this->products = array(); $this->customer = array(); $this->delivery = array(); $this->query($order_id); } function query($order_id) { // PWA BOF // added customers_dummy_account $order_query = tep_db_query("select 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, customers_dummy_account, customers_id, customers_fax, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, 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_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); // PWA EOF $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); while ($totals = tep_db_fetch_array($totals_query)) { $this->totals[] = array('title' => $totals['title'], 'text' => $totals['text']); } $this->info = array('order_id' => $order_id, 'currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'date_purchased' => $order['date_purchased'], 'orders_status' => $order['orders_status'], 'last_modified' => $order['last_modified'], 'total' => strip_tags($order_total['text']), 'shipping_method' => ((substr($shipping_method['title'], -1) == ':') ? substr(strip_tags($shipping_method['title']), 0, -1) : strip_tags($shipping_method['title'])), 'shipping_cost' => strip_tags($shipping_method['value'])); $this->customer = array('id' => $order['customers_id'], 'name' => $order['customers_name'], 'company' => $order['customers_company'], 'street_address' => $order['customers_street_address'], 'suburb' => $order['customers_suburb'], 'city' => $order['customers_city'], 'postcode' => $order['customers_postcode'], 'state' => $order['customers_state'], 'country' => $order['customers_country'], 'format_id' => $order['customers_address_format_id'], 'telephone' => $order['customers_telephone'], 'email_address' => $order['customers_email_address'], 'fax' => $order['customers_fax'], // PWA BOF 'is_dummy_account' => $order['customers_dummy_account']); // PWA EOF $this->delivery = array('name' => $order['delivery_name'], 'company' => $order['delivery_company'], 'street_address' => $order['delivery_street_address'], 'suburb' => $order['delivery_suburb'], 'city' => $order['delivery_city'], 'postcode' => $order['delivery_postcode'], 'state' => $order['delivery_state'], 'country' => $order['delivery_country'], 'format_id' => $order['delivery_address_format_id']); $this->billing = array('name' => $order['billing_name'], 'company' => $order['billing_company'], 'street_address' => $order['billing_street_address'], 'suburb' => $order['billing_suburb'], 'city' => $order['billing_city'], 'postcode' => $order['billing_postcode'], 'state' => $order['billing_state'], 'country' => $order['billing_country'], 'format_id' => $order['billing_address_format_id']); $index = 0; $orders_products_query = tep_db_query("select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price, products_returned, products_id from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'id' => $orders_products['products_id'], 'return' => $orders_products['products_returned'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); $subindex = 0; $attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'"); if (tep_db_num_rows($attributes_query)) { while ($attributes = tep_db_fetch_array($attributes_query)) { $this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price']); $subindex++; } } $index++; } } } ?> [code]
  15. can anyone help me? I have a heavily mod OSC and for some reason export oders dosnt work the one part of the install I had trouble with is the orders.php modifications below please help thanks <?php /* $Id: order.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ class order { var $info, $totals, $products, $customer, $delivery; function order($order_id) { $this->info = array(); $this->totals = array(); $this->products = array(); $this->customer = array(); $this->delivery = array(); $this->query($order_id); } function query($order_id) { // PWA BOF // added customers_dummy_account $order_query = tep_db_query("select 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, customers_dummy_account, customers_id, customers_fax, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, 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_expires, currency, currency_value, date_purchased, orders_status, last_modified from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); // PWA EOF $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); while ($totals = tep_db_fetch_array($totals_query)) { $this->totals[] = array('title' => $totals['title'], 'text' => $totals['text']); } $this->info = array('order_id' => $order_id, 'currency' => $order['currency'], 'currency_value' => $order['currency_value'], 'payment_method' => $order['payment_method'], 'cc_type' => $order['cc_type'], 'cc_owner' => $order['cc_owner'], 'cc_number' => $order['cc_number'], 'cc_expires' => $order['cc_expires'], 'date_purchased' => $order['date_purchased'], 'orders_status' => $order['orders_status'], 'last_modified' => $order['last_modified']); 'total' => strip_tags($order_total['text']), 'shipping_method' => ((substr($shipping_method['title'], -1) == ':') ? substr(strip_tags($shipping_method['title']), 0, -1) : strip_tags($shipping_method['title'])), 'shipping_cost' => strip_tags($shipping_method['value'])); $this->customer = array('id' => $order['customers_id'], 'name' => $order['customers_name'], 'company' => $order['customers_company'], 'street_address' => $order['customers_street_address'], 'suburb' => $order['customers_suburb'], 'city' => $order['customers_city'], 'postcode' => $order['customers_postcode'], 'state' => $order['customers_state'], 'country' => $order['customers_country'], 'format_id' => $order['customers_address_format_id'], 'telephone' => $order['customers_telephone'], 'email_address' => $order['customers_email_address'], 'fax' => $order['customers_fax']) // PWA BOF 'is_dummy_account' => $order['customers_dummy_account']); // PWA EOF $this->delivery = array('name' => $order['delivery_name'], 'company' => $order['delivery_company'], 'street_address' => $order['delivery_street_address'], 'suburb' => $order['delivery_suburb'], 'city' => $order['delivery_city'], 'postcode' => $order['delivery_postcode'], 'state' => $order['delivery_state'], 'country' => $order['delivery_country'], 'format_id' => $order['delivery_address_format_id']); $this->billing = array('name' => $order['billing_name'], 'company' => $order['billing_company'], 'street_address' => $order['billing_street_address'], 'suburb' => $order['billing_suburb'], 'city' => $order['billing_city'], 'postcode' => $order['billing_postcode'], 'state' => $order['billing_state'], 'country' => $order['billing_country'], 'format_id' => $order['billing_address_format_id']); $index = 0; $orders_products_query = tep_db_query("select orders_products_id, products_name, products_warehouse_location , products_model, products_price, products_tax, products_quantity, final_price, products_returned, products_id from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); while ($orders_products = tep_db_fetch_array($orders_products_query)) { $this->products[$index] = array('qty' => $orders_products['products_quantity'], 'name' => $orders_products['products_name'], 'id' => $orders_products['products_id'], 'return' => $orders_products['products_returned'], 'model' => $orders_products['products_model'], 'tax' => $orders_products['products_tax'], 'price' => $orders_products['products_price'], 'final_price' => $orders_products['final_price']); 'products_warehouse_location' => $orders_products['products_warehouse_location']); $subindex = 0; $attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from " . TABLE_ORDERS_PRODUCTS_ATTRIBUTES . " where orders_id = '" . (int)$order_id . "' and orders_products_id = '" . (int)$orders_products['orders_products_id'] . "'"); if (tep_db_num_rows($attributes_query)) { while ($attributes = tep_db_fetch_array($attributes_query)) { $this->products[$index]['attributes'][$subindex] = array('option' => $attributes['products_options'], 'value' => $attributes['products_options_values'], 'prefix' => $attributes['price_prefix'], 'price' => $attributes['options_values_price']); $subindex++; } } $index++; } } } ?>
×