Jump to content


  • Content count

  • Joined

  • Last visited

About drazey45

  • Birthday 11/26/1962

Profile Information

  1. drazey45

    Special Price Per customer & EP Import

    O.K. So I found where I should have SPPC = true in the EP Configure settings (easypopulate.php) (I am using 2.76i EP). EP Config Settings are: Settings & Info EP vers: 2.76i-MS2 osCommerce Online Merchant v2.2 RC2a OS: HTTP: Apache/2.2.14 (Unix) mod_ssl/2.2.14 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/ mod_perl/2.0.4 Perl/v5.8.8 DB: MySQL 5.0.89-community PHP: 5.2.12 (Zend: 2.2.0) Temp Directory: /home/djsdemo/public_html/eshop/temp/ Temp Dir is Writable Magic Quotes is: off register_globals is: off Split files on: 300 records Model Num Size: 12 Price with tax: false Calc Precision: 2 Replace quotes: false Field seperator: comma Excel safe output: true Preserve tab/cr/lf: false Category depth: 7 Enable attributes: true SEF Froogle URLS: false Other Support: MVS Support: true Additional Images: false More Pics: false UltraPics Pics: false HTC: false SPPC: true Extra Fields: true PDF Upload: false I found where I need to use the v_customer_price_N and v_customer_group_id_N fields, but am a bit confused. If I have a "Retail", "Wholesale", and "Cost" Price for each product, does that mean that I have to have 3 separate input / import files corresponding to "Retail", "Wholesale", and "Cost"? , and how does that affect the v_product_price field, or better yet, what should I have in the v_product_price if I have 3 separate prices for each product? Thanks :-)
  2. I have osc 2.2 rc2 with EP and SPPC 4.2 installed, but I can not find anywhere how to format the input csv file for Multiple prices per product based on the Customer Group. Any help would be great, or to point me in the right direction to format the csv file correctly.
  3. Look in the Discount Coupon Contrib section, there is a fix specifically for this problem http://www.oscommerce.com/community/contributions,4269 Hope that helps! D. Razey
  4. Thanks for the info. That update is for PayPal IPN v2.2, I am running PayPal IPN v2.3.3. I made those chages in my paypal_ipn.php (for v2.3.3) and still had no effect. I STILL can not get the coupon discount amount to show up in the PayPal Checkout Process. One other note, when I apply shipping charges in osC, PayPal IPN is NOT showing the actual shipping charges, it does, however, give the correct amount with the shipping charges applied. The only way that I can get shipping charges to show up as a line item in paypal IPN is to turn on the "Shipping Preferences" in my PayPal Account. Very Frustrating .. Just wondering if there is anyone out there that is running PayPal IPN V2.3.3 that does have the IPN stuff working .. Thanks ahead of time :-) David
  5. Is there anyone that might be able to help me with this?? I'd like to go back to Paypal IPN, but can not get the discount code amount to show up when going to paypal. ANY help would be greatly appreciated.
  6. I switched back to PayPal Website Payments Standard, and now the actual "real" total does come across as correct, although with the standard vs paypal_ipn Paypal does not show "Per Item" line items, it just displays the "final" total after discounts coupon, shipping and low order fee. Does anyone else have DCC working with Paypal IPN v2.3.3?? or am I the only one that it's not working for???
  7. I rechecked my paypal_ipn.php file and the discount code is about in the same place as yours, I just don't have the //initialized for the email confirmation .. part in my paypal_ipn.php file. I guess my real question is if everything else seems to be working with the DCC (Discount Coupon Code), could there be another file that I either have the coding wrong or missing? All my Order status's and my order history do include the correct amounts with the Coupon applied. I'm very confused at this point, so ANY help would be greatly appreciated. Thanks, D. Razey
  8. I thought I would add in that if I have orders that total $30.00 or less I charge an additional fee. This fee IS showing up at paypal. Just the Discount Coupon stuff is not.
  9. I looked at my /catalog/languages/modules/payments/paypal_ipn.php and it did contain the code you put here. I'm adding a portion of my paypal_ipn.php file, perhaps I'm misisng something very minute. D. Razey //+1.4 $sql_data_array = array('orders_id' => $insert_id, 'orders_status_id' => $order->info['order_status'], 'date_added' => 'now()', 'customer_notified' => '0', 'comments' => $order->info['comments']); tep_db_perform(TABLE_ORDERS_STATUS_HISTORY, $sql_data_array); //-1.4 //kgt - discount coupons if( tep_session_is_registered( 'coupon' ) && $order->info['coupon'] != '' ) { $sql_data_array = array( 'coupons_id' => $order->info['coupon'], 'orders_id' => $order_id ); tep_db_perform( TABLE_DISCOUNT_COUPONS_TO_ORDERS, $sql_data_array ); } //end kgt - discount coupons for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { $sql_data_array = array('orders_id' => $insert_id, 'products_id' => tep_get_prid($order->products[$i]['id']), 'products_model' => $order->products[$i]['model'], 'products_name' => $order->products[$i]['name'], 'products_price' => $order->products[$i]['price'], 'final_price' => $order->products[$i]['final_price'], 'products_tax' => $order->products[$i]['tax'], 'products_quantity' => $order->products[$i]['qty']); tep_db_perform(TABLE_ORDERS_PRODUCTS, $sql_data_array);
  10. That's what I checked this afternoon, but now looking at what you have put here (MANY, MANY Thanks by the way), It looks a bit different. I will go back and compare this to what I have. Thanks Again !! D. Razey
  11. I have installed the Discount Coupon Code and ALL seems to be working with the exception of when the customer is transferred to PayPal (IPN) for final payment. PayPal is NOT showing the total WITH the Discount being applied. PayPal is ONLY showing the Order Total (no discount coupon listed anywhere). I am running PayPal IPN v2.3.3 with OSC 2rc2. I have downloaded the latest DCC available from the contributions area of DCC. Anyone have any ideas? this is causing a real problem for my site, as there are a great many customers that I give Discount's to based on Customer Name, Number, etc .. Thanks in Advance :-) D. Razey
  12. drazey45

    PayPal IPN v0.97 released

    I am relativly new to all of this and have just installed osc 2.2rc2 and am using Paypal IPN. I am not receiving any email notificationwhen an order is placed through paypal. I am not sure if I have the IPN URL setup correctly in paypal. Can someone or would someone (out of the kindness of your heart) help me with this? I don't really know what url to put on my paypal.com IPN URL section ... I currently have it set to use www.(my website).com/catalog/ext/modules/payment/paypal/standard_ipn.php Also, I am not sure what version of the paypal module I have installed. I've just recently downloaded the osc, so would assume I have the correct module version of paypal ?? Thanks in advance :-) David R.