Jump to content

Baybee

Members
  • Content count

    55
  • Joined

  • Last visited

Everything posted by Baybee

  1. I completely agree... as I said, I was just looking here for help and while I appreciate that pix tried, maybe the way it was tried wasnt too friendly. Anyways, as I said, I just wanted a little help from other users, as I know we are all users and not paid support. I've been running OSC for over 3 years, so I know. Baal you seem to be the one who was trying to actually help, and I thank you for that. It's still not working, so I guess I'll be re-entering all my products.
  2. Because I'm not going to use a straight OSCommerce store. I'm going to go with a CRELoaded version of OSCommerce and you just cant INJECT the database from OSC into CRE like that so wouldnt it be nice for EP to work properly? :-" I've already got one CRELoaded store going and have had far and few between issues and most of the "contribs" I need are already put into CRELoaded... so I'd like to us EP to export it and then IMPORT into the new CRELoaded store. Makes a little more sense now as to why I cant just export the db then import into the new store, eh? And I was asking for a little help with my EP not working not to be questioned as to why I am doing it. Thanks. Julie
  3. Baybee

    NEW! Complete Order Editing Tool!

    Still need some help with this one... Thanks! Julie
  4. I had done that, but here is what the URL for the downloading of the file says: http://mydomain.com/catalog/admin/easypopu...amp;dltype=full The one for the file creation is the same but this: download=tempfile&dltype=full Ok, now the Model/Attributes DL or file creation is not working either. I dont do Froogle, so that one I dont care about... I am wanting to create a new store, but want my products from this store so I dont have to completely re-enter over 1000 products again. That took me a lot of time to do. Thanks! Julie
  5. Yes. I am able to do the other functions except either complete download or complete file creation. The file can be downloaded from other functions or is created with other functions.
  6. I installed EP a week or so ago, and have done all the fidgeting with it I can think of to do. It will not do a complete file at all, not to download or even create one. It will do the others, but not a complete one. It goes to a Page can not be found after about 10 seconds.... I have it set to only pull 4 records in case it was a timeout issue, but that isnt it as it wont even pull 4. Please help. Thanks... Julie
  7. Baybee

    NEW! Complete Order Editing Tool!

    I had the Cvv2 contrib already installed, then I installed Order Editor 2.7.4 - I added the CVV2 to OE contrib as per the instructions given in this thread, but my CVV2 code is not being saved on a new order and I am not able to update it either. The cvv2 code is essential for my cc processing fuctions which I do manually. Thanks! Julie
  8. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Still no orders. I changed the file to the one in the latest version and the same thing is still occuring. Any new orders coming in are not seen in the admin.
  9. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Thanks Dynamo. I was afraid you were going to say that! :D I will just have to go through the new one and put in my changes from the old one. Thanks so much! Julie
  10. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Here is more information on my "orders not showing up" - When I login as the customer to review the order history, it's showing "0 of 0 orders" but showing for result pages: -4, -3, -2, -1, 0 . They still are not showing up in the admin/customers/orders view. Only new orders that I'm placing are not showing. No matter what payment method (I have have check/money order available too) the order is not showing up in either the admin or on the customers order history. I went in and checked all my edits to all the files, even completely redid all of them. I am using Seperate Pricing Per Customer (only other edits I see in any of the files I'm editing). Any help is greatly appreciated and needed here. Otherwise, I have to go back to IPN and then I'm wasting my money on WPP with paypal.
  11. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Ok, orders are showing in my new store. So I must have a code issue somewhere in my other store. What file should I be looking in for viewing orders in my admin area? All help is greatly appreciated, as I'm not *new new* but I'm not fluent in SQL/PHP yet.... so all your help is helping me learn too.... which is what I am trying to do also! :) Julie
  12. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Fixed it. :) But I really need to get this stuff working on my other store where the orders that come in are not showing in the admin area. I receive an email with the order and all that and the customer receives their notification, but the "processing" orders are not showing up at all. Thanks! Julie
  13. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Hi Dynamo, I see what you are saying. I see the problem too...... but I'm going to post it for you: <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://embraceableurns.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', 'https://www.siteground144.com/~embracea/'); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', true); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'embraceableurns.com'); define('HTTPS_COOKIE_DOMAIN', 'embraceableurns.com'); define('HTTP_COOKIE_PATH', '/urns/'); define('HTTPS_COOKIE_PATH', '/urns/'); It's the https cookie domain and path, huh? :) Also, what about the orders not showing up in the other stores admin? Thanks! Julie
  14. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Ok - I decided I wanted another store different from my main store for my urns. Anyways... I'm still having problems with the install of WPP on my 1st site which I've already posted about. So.... I install OSC fresh and new for my new store (which is an off spring of my first). First contrib I install is this one and I'm using a shared SSL certificate. First there is no EC button on the log in page. So, I try to log in after placing an item in my cart and clicking checkout. I click log in and *BAM* right back to the log in page and my cart is empty. So, since this was a fresh install, I just simply copied all files/folders over. Help please. Julie
  15. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Paul.. going to redirect you to Dynamo... because I could only tell you how to install the modification. I dont want to give you false information, so I'll let him answer you. I can tell you that I have the paypal express checkout button on mine for customers to use before logging in or creating an account. Sorry I cant be more helpful to you. Julie
  16. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Thanks!! Fixed the error but it's still not showing my "Processing" orders at all. Only orders showing are those that were there before the add on. But the orders are being saved because on the main admin screen it shows Orders Processing: 4 (which is how many I've done trying to test since the add on). Thanks!
  17. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    Hi - The files shown: /catalog/ec_process.php /catalog/includes/wpp_xml/ /catalog/includes/wpp_xml/doDirectPayment.xml /catalog/includes/wpp_xml/doExpressCheckout.xml /catalog/includes/wpp_xml/getExpressCheckoutDetails.xml /catalog/includes/wpp_xml/setExpressCheckout.xml /catalog/includes/wpp_xml/transactionSearch.xml /catalog/includes/languages/english/ec_process.php /catalog/includes/modules/payment/wpp_cert/ /catalog/includes/modules/payment/wpp_cert/.htaccess /catalog/includes/modules/payment/paypal_wpp.php These are new files/folders that are not currently in OSC. You have to make the folders and upload those files. If you have a stock version (not modified at all) you upload all the rest of the files too included in your package to the corresponding folders. If you have modified anything in your OSC, you'll need to do the changes to each file manually. Hope this helped. Julie
  18. Baybee

    PayPal WPP Direct Payments & Express Checkout Support

    I am getting the following error whenever I try to view "Processing" orders in my admin area or "All Orders". I can view past orders, but no new orders are showing. I have read through the topic here and see others have had the same issue, but I've done the suggestions I've seen and still receive the same error. The order processes, emails me the order, but doesnt show in my admin area. Here is the 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 '-20, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and s.orders_status_id = '2' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 [TEP STOP]
  19. Baybee

    Seperate Pricing Per Customer v3.5

    My Account, Checkout and Create An Account pages are not loading from the main page. If I click on Shopping Cart, that loads, but the other 2 normally go to the log in screen if not already logged in, and the log in screen is not loading when I click either My Account or Checkout from the main page. Any ideas? Doesnt give an error, just loads a blank white page. Thanks! Julie
  20. Baybee

    Seperate Pricing Per Customer v3.5

    Hey Jan, Can you post me your shopping_cart.php files (both of them) here so that I can compare them to mine for Salemaker to work with SPPC? I'd appreciate it. I can get it to work up to the point in the shopping cart. It continues to show the regular price instead of the sale price. There is a piece of coding I had to use instead of what was in Salemaker's install file (found the code here on the OSC forums). If you want, I can post you my shopping_cart.php files ... But, if you let me compare to yours I may be able to fix the issue. Thanks much! Julie
  21. Baybee

    Seperate Pricing Per Customer v3.5

    Hi Martin, Not sure if this mod works with EasyPopulate or not. I am changing over 1300 products one by one the old fashioned way. :) Julie
  22. Baybee

    Seperate Pricing Per Customer v3.5

    Ok, fixed all my errors. :D Now.... In catalog/includes/modules/new_products.php I want the sale prices to reflect in that box at the bottom of my main page. Right now all that is showing is the regular prices, it does not show sale prices when I have a sale going on. Also, I would like it to show the prices ranges for my "wholesale" group. It only shows the retail price only. In the product listing it shows: for product A $8.50-$12.00 instead of the regular single retail price. I'd like the new_products to show that for the wholesale people too and show sale prices for the retail group when I'm having a sale. I thought I'd had it doing that before. but it does not seem to be doing that now that I modified the file for SPPC. Thanks! Julie
  23. Baybee

    Seperate Pricing Per Customer v3.5

    Now I'm getting all kinds of errors. On left hand column: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wizlair/public_html/catalog/includes/functions/database.php on line 103 And also get the same error on all product listings.
  24. Baybee

    Seperate Pricing Per Customer v3.5

    Ok, so that entire code I posted as what I have needs to be replaced with the code you suggested? I just want to make sure than I am not screwing something up. :) Thanks for your help! Julie
  25. Baybee

    Seperate Pricing Per Customer v3.5

    In Priceformatter.php I dont have the code at all you are saying to replace: catalog/includes/classes/PriceFormatter.php Line 194-198 AND Line 248-252 (so has to be done twice!) **REPLACE** // now get the specials price for this customer_group and add it to product_info array $special_price_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = " . (int)$product_id . " and status ='1' and customers_group_id = '" . $customer_group_id . "'"); if ($specials_price = tep_db_fetch_array($special_price_query)) { $product_info['specials_new_products_price'] = $specials_price['specials_new_products_price']; Here is my Priceformatter.php file: <?php /* $Id: PriceFormatter.php,v 1.6 2003/06/25 08:29:26 petri Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ /* PriceFormatter.php - module to support quantity pricing Created 2003, Beezle Software based on some code mods by WasaLab Oy (Thanks!) */ class PriceFormatter { var $hiPrice; var $lowPrice; var $quantity; var $hasQuantityPrice; function PriceFormatter($prices=NULL) { $this->productsID = -1; $this->hasQuantityPrice=false; $this->hasSpecialPrice=false; $this->hiPrice=-1; $this->lowPrice=-1; for ($i=1; $i<=8; $i++){ $this->quantity[$i] = -1; $this->prices[$i] = -1; } $this->thePrice = -1; $this->specialPrice = -1; $this->qtyBlocks = 1; if($prices) $this->parse($prices); } function encode() { $str = $this->productsID . ":" . (($this->hasQuantityPrice == true) ? "1" : "0") . ":" . (($this->hasSpecialPrice == true) ? "1" : "0") . ":" . $this->quantity[1] . ":" . $this->quantity[2] . ":" . $this->quantity[3] . ":" . $this->quantity[4] . ":" . $this->quantity[5] . ":" . $this->quantity[6] . ":" . $this->quantity[7] . ":" . $this->quantity[8] . ":" . $this->price[1] . ":" . $this->price[2] . ":" . $this->price[3] . ":" . $this->price[4] . ":" . $this->price[5] . ":" . $this->price[6] . ":" . $this->price[7] . ":" . $this->price[8] . ":" . $this->thePrice . ":" . $this->specialPrice . ":" . $this->qtyBlocks . ":" . $this->taxClass; return $str; } function decode($str) { list($this->productsID, $this->hasQuantityPrice, $this->hasSpecialPrice, $this->quantity[1], $this->quantity[2], $this->quantity[3], $this->quantity[4], $this->quantity[5], $this->quantity[6], $this->quantity[7], $this->quantity[8], $this->price[1], $this->price[2], $this->price[3], $this->price[4], $this->price[5], $this->price[6], $this->price[7], $this->price[8], $this->thePrice, $this->specialPrice, $this->qtyBlocks, $this->taxClass) = explode(":", $str); $this->hasQuantityPrice = (($this->hasQuantityPrice == 1) ? true : false); $this->hasSpecialPrice = (($this->hasSpecialPrice == 1) ? true : false); } function parse($prices) { $this->productsID = $prices['products_id']; $this->hasQuantityPrice=false; $this->hasSpecialPrice=false; $this->quantity[1]=$prices['products_price1_qty']; $this->quantity[2]=$prices['products_price2_qty']; $this->quantity[3]=$prices['products_price3_qty']; $this->quantity[4]=$prices['products_price4_qty']; $this->quantity[5]=$prices['products_price5_qty']; $this->quantity[6]=$prices['products_price6_qty']; $this->quantity[7]=$prices['products_price7_qty']; $this->quantity[8]=$prices['products_price8_qty']; $this->thePrice=$prices['products_price']; $this->specialPrice=$prices['specials_new_products_price']; $this->hasSpecialPrice=tep_not_null($this->specialPrice); $this->price[1]=$prices['products_price1']; $this->price[2]=$prices['products_price2']; $this->price[3]=$prices['products_price3']; $this->price[4]=$prices['products_price4']; $this->price[5]=$prices['products_price5']; $this->price[6]=$prices['products_price6']; $this->price[7]=$prices['products_price7']; $this->price[8]=$prices['products_price8']; /* Change support special prices If any price level has a price greater than the special price lower it to the special price */ if ($this->hasSpecialPrice == true) { for($i=1; $i<=8; $i++) { if ($this->price[$i] > $this->specialPrice) $this->price[$i] = $this->specialPrice; } } //end changes to support special prices $this->qtyBlocks=$prices['products_qty_blocks']; $this->taxClass=$prices['products_tax_class_id']; if ($this->quantity[1] > 0) { $this->hasQuantityPrice = true; $this->hiPrice = $this->thePrice; $this->lowPrice = $this->thePrice; for($i=1; $i<=8; $i++) { if($this->quantity[$i] > 0) { if ($this->price[$i] > $this->hiPrice) { $this->hiPrice = $this->price[$i]; } if ($this->price[$i] < $this->lowPrice) { $this->lowPrice = $this->price[$i]; } } } } } function loadProduct($product_id, $language_id=1) { $sql="select pd.products_name, p.products_model, p.products_image, p.products_id," . " p.manufacturers_id, p.products_price, p.products_weight," . " p.products_price1,p.products_price2,p.products_price3,p.products_price4, p.products_price5,p.products_price6,p.products_price7,p.products_price8," . " p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri ce4_qty, p.products_price5_qty,p.products_price6_qty,p.products_price7_qty,p.products_pri ce8_qty," . " p.products_qty_blocks," . " p.products_tax_class_id," . " IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price," . " IF(s.status, s.specials_new_products_price, p.products_price) as final_price" . " from " . TABLE_PRODUCTS_DESCRIPTION . " pd," . " " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id," . " " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id" . " where p.products_status = '1'" . " and p.products_id = '" . (int)$product_id . "'" . " and pd.products_id = '" . (int)$product_id . "'" . " and pd.language_id = '". (int)$language_id ."'"; $product_info_query = tep_db_query($sql); $product_info = tep_db_fetch_array($product_info_query); $this->parse($product_info); return $product_info; } function computePrice($qty) { $qty = $this->adjustQty($qty); // Compute base price, taking into account the possibility of a special $price = ($this->hasSpecialPrice === TRUE) ? $this->specialPrice : $this->thePrice; for ($i=1; $i<=8; $i++) if (($this->quantity[$i] > 0) && ($qty >= $this->quantity[$i])) $price = $this->price[$i]; return $price; } function adjustQty($qty) { // Force QTY_BLOCKS granularity $qb = $this->getQtyBlocks(); if ($qty < 1) $qty = 1; if ($qb >= 1) { if ($qty < $qb) $qty = $qb; if (($qty % $qb) != 0) $qty += ($qb - ($qty % $qb)); } return $qty; } function getQtyBlocks() { return $this->qtyBlocks; } function getPrice() { return $this->thePrice; } function getLowPrice() { return $this->lowPrice; } function getHiPrice() { return $this->hiPrice; } function hasSpecialPrice() { return $this->hasSpecialPrice; } function hasQuantityPrice() { return $this->hasQuantityPrice; } function getPriceString($style='productPriceInBox') { global $currencies; if ($this->hasSpecialPrice == true) { $lc_text = '<table align="top" border="1" cellspacing="0" cellpadding="0">'; $lc_text .= '<tr><td align="center" class=' . $style. ' colspan="2">'; $lc_text .= ' <s>' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass)) . '</span> ' .'</td></tr>'; } else { $lc_text = '<table align="top" border="1" cellspacing="0" cellpadding="0">'; $lc_text .= '<tr><td align="center" class=' . $style. ' colspan="2">' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . '</td></tr>'; } // If you want to change the format of the price/quantity table // displayed on the product information page, here is where you do it. if($this->hasQuantityPrice == true) { for($i=1; $i<=8; $i++) { if($this->quantity[$i] > 0) { $lc_text .= '<tr><td class='.$style.'>' . $this->quantity[$i] .'+ </td><td class='.$style.'>' . $currencies->display_price($this->price[$i], tep_get_tax_rate($this->taxClass)) .'</td></tr>'; } } $lc_text .= '</table>'; } else { if ($this->hasSpecialPrice == true) { $lc_text = ' <s>' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass)) . '</span> '; } else { $lc_text = ' ' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . ' '; } } return $lc_text; } function getPriceStringShort() { global $currencies; if ($this->hasSpecialPrice == true) { $lc_text = ' <s>' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass)) . '</span> '; } else { if($this->hasQuantityPrice == true) { $lc_text = ' ' . $currencies->display_price($this->lowPrice, tep_get_tax_rate($this->taxClass)) . ' - ' . $currencies->display_price($this->hiPrice, tep_get_tax_rate($this->taxClass)) . ' '; } else { $lc_text = ' ' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . ' '; } } return $lc_text; } } ?>
×