Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

PropioWeb

Members
  • Content count

    304
  • Joined

  • Last visited

Everything posted by PropioWeb

  1. PropioWeb

    [Contribution] - USPS Methods

    UPDATE: Not sure what the difference is between the last 2 versions I mentioned but I went back one version, 6.3, and its working fine now. Just thought I'd let you all know if someone else had the same issue.
  2. PropioWeb

    [Contribution] - USPS Methods

    I've tried both USPS Methods 6.3.1 (latest) and the one linked here from github, 7.0.1, and with both I have the same issue. Even though I am selecting the cheapest option, parcel post, when I get to the confirmation page it changes to the most expensive option, priority express. I don't understand why.
  3. PropioWeb

    Google Analytics module

    I am on the same boat as many who have posted in this thread. I followed the instructions to the T, turned on the ecommerce options in analytics and everything is installed correctly on the site yet Google is not collecting any data from my store. Why is no one answering the posts from people such as myself? Could someone who's figure this out please help us. My Analytics Output <script src="https://ssl.google-analytics.com/urchin.js" type="text/javascript"> </script> <script type="text/javascript"> _uacct="UA-XXXXXX-1" urchinTracker(); </script> <script type="text/javascript"> var pageTracker = _gat._getTracker("UA-XXXXXX-1"); pageTracker._addTrans( "22870"," ","8.10","0.19","4.92","Holyoke","Massachusetts","United States" ); pageTracker._addItem( "22870","10075","Calendario 2011 MANANTIAL DE VIDA (Textos para cada día)","Agendas","2.99","1"); pageTracker._trackTrans(); </script>
  4. When I searched for this contribution it did not come up under any of the searches but then with a Google search it came up. I believe it is because it is not title correctly but I digress. This is a great contribution that allows users to filter the Latest Products and Product Specials by Category via a dropdown box. Many a customers have mentioned having to scroll through hundreds of products before finding what they wanted within these two pages so this contribution solves that. If the customer knows the category it will only show new or products on special for that category they chose. Well this is a great concept except it is not working with osCommerce 2.2 MS2. I'm not a php or MySQL guru but I believe the database calls are not working. See the contribution here: http://addons.oscommerce.com/info/5785 Here's a live site with the drop down not working properly: http://www.jehovanisi.com/products_new.php Could you guys take a look at the code for products_new and let me know why the database is not connecting correctly? ------------------------ Install Products_new.php ------------------------ ---------------- On about line 45 ---------------- Find: <?php echo HEADING_TITLE; ?> immidiately after insert: </td> <td class="pageHeading" align="right"> <FORM> <?php $cat_id1=0; $chkSub1 = 0; $conn1 = mysql_connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD) or die ('Error connecting to mysql'); mysql_select_db(DB_DATABASE); if (isset($categories_id)){ if (!empty($categories_id) && $categories_id!=""){ $rst = mysql_query("SELECT parent_id FROM categories WHERE categories_id = ".$categories_id); if(mysql_num_rows($rst) > 0){ $rparent = mysql_fetch_object($rst); if($rparent->parent_id > 0){ $cat_id1 = $rparent->parent_id; } else{ $cat_id1 = $categories_id; } } else{ $cat_id1 = $categories_id; } } else{ $cat_id1 = $categories_id; } } else{ $cat_id1 = $categories_id; } if (isset($categories_id)){ if (empty($categories_id) && $categories_id==""){ //$result = mysql_query("SELECT CD.*, C.* FROM categories AS C, categories_description AS CD WHERE CD.language_id=1 AND C.categories_id = CD.categories_id AND C.parent_id=0"); $result = mysql_query("select distinct CD.categories_id, CD.categories_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, categories AS C, categories_description AS CD, products_to_categories as pc where CD.language_id=1 AND p.products_status = '1' AND C.categories_id = CD.categories_id AND C.parent_id=0 and p.products_id = pc.products_id and pc.categories_id = C.categories_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); } else{ //$result = mysql_query("SELECT CD.*, C.* FROM categories AS C, categories_description AS CD WHERE CD.language_id=1 AND C.categories_id = CD.categories_id AND C.parent_id=$cat_id1"); $result = mysql_query("select distinct CD.categories_id, CD.categories_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, categories AS C, categories_description AS CD, products_to_categories as pc where CD.language_id=1 AND p.products_status = '1' AND C.categories_id = CD.categories_id AND C.parent_id=$cat_id1 and p.products_id = pc.products_id and pc.categories_id = C.categories_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); $chkSub1 = 1; } } else{ //$result = mysql_query("SELECT CD.*, C.* FROM categories AS C, categories_description AS CD WHERE CD.language_id=1 AND C.categories_id = CD.categories_id AND C.parent_id=0"); $result = mysql_query("select distinct CD.categories_id, CD.categories_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, categories AS C, categories_description AS CD, products_to_categories as pc where CD.language_id=1 AND p.products_status = '1' AND C.categories_id = CD.categories_id AND C.parent_id=0 and p.products_id = pc.products_id and pc.categories_id = C.categories_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); } //print("<br><br>select distinct CD.categories_id, CD.categories_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, categories AS C, categories_description AS CD, products_to_categories as pc where CD.language_id=1 AND p.products_status = '1' AND C.categories_id = CD.categories_id AND C.parent_id=0 and p.products_id = pc.products_id and pc.categories_id = C.categories_id and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"); //$result = mysql_query("SELECT CD.*, C.* FROM categories AS C, categories_description AS CD WHERE CD.language_id=1 AND C.categories_id = CD.categories_id AND C.parent_id=0"); ?> <SELECT NAME="clicklist"style="background-color:#F0F1F4" onChange="location.href=this.form.clicklist.options[this.form.clicklist.selectedIndex].value"> <?php if ($chkSub1 == 1){ ?> <OPTION>Sub-categories <?php } else{ ?> <OPTION>Select by category <?php } ?> <option>---------------------- <?php while ($row = mysql_fetch_object($result)) { print('<option value="products_new.php?categories_id='.$row->categories_id.'&inc_subcat=1&manufacturers_id">'.$row->categories_name); } mysql_free_result($result); ?> <option value="products_new.php?categories_id=&inc_subcat=1&manufacturers_id">View All </SELECT NAME></form></div> ----- Find: ----- <?php $products_new_array = array(); $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; $products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW); if (($products_new_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?> ----------------- And replace with: ----------------- <?php $products_new_array = array(); if (isset($categories_id)){ if (empty($categories_id) && $categories_id==""){ $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; } else{ $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " pcat, " . TABLE_CATEGORIES . " cat where p.products_status = '1' and p.products_id = pcat.products_id and pcat.categories_id = cat.categories_id and ((cat.categories_id = " . $categories_id . " or cat.parent_id = " . $categories_id . ")) and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; } } else{ $products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added DESC, pd.products_name"; } $products_new_split = new splitPageResults($products_new_query_raw, MAX_DISPLAY_PRODUCTS_NEW); if (($products_new_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) { ?>
  5. PropioWeb

    ### POINTS AND REWARDS MODULE V1.00 ###

    I setup my sort order as follows and points are still able to be redeemed for shipping and tax. Points Redemptions Discount Coupon Gift Card USPS Shipping USPS Insurance Sub-Total Tax Total The only thing being charged is USPS Insurance. See here: http://clip2net.com/clip/m7120/1257883015-clip-20kb.jpg Customers should always pay for shipping and tax. Why is this not working?
  6. PropioWeb

    ### POINTS AND REWARDS MODULE V1.00 ###

    I didn't see this in the configuration file but I don't think it should be happening. Customers are able to pay for shipping and tax using their points. If this is a default feature of the contribution how do I turn it off? If it's not why are customers able to do this? Does it have to do with the sort order? Right now the only thing they don't pay for is if they opt for shipping insurance.
  7. PropioWeb

    Forum of "Upload and discplay video extract"

    Found the issue with the video not showing on the other browsers. In the instructions the enbeding of the player in the products_info page looks like this: <object width="300" height="220" type="application/x-shockwave-flash" data="playervideo.swf?url=images/<?php echo $product_info['products_pdfupload']; ?>&autoplay=false"> <param name="movie" value="playervideo.swf?url=images/<?php echo $product_info['products_pdfupload']; ?>&autoplay=false"/> </object> And I just made sure everything was on one line. Like this: <object width="409" height="300" type="application/x-shockwave-flash" data="playervideo.swf?url=images/<?php echo $product_info['products_pdfupload'];?>&autoplay=false&menu=false"> <param name="movie" value="playervideo.swf?url=images/<?php echo $product_info['products_pdfupload'];?>&autoplay=false&menu=false"/> </object>
  8. PropioWeb

    Forum of "Upload and discplay video extract"

    I don't understand why but the player can be seen in IE7 but not in Firefox 3 or any other browser for that matter. What is the deal? Any help would be appreciated.
  9. PropioWeb

    Quantity Price Breaks

    Hey Guys, Quik question. I want to be able to print or echo the price breaks for each product on the shopping cart page. I'll explain. Product Name Widget #1 (Save more when you Buy: 4 = $15.95 | Buy: 10 = $12.95) $19.95 How do I go about defining that so I can add it to the shopping cart? Any ideas or help in the right direction would be greatly appreciated. Thanks
  10. PropioWeb

    [Contribution] STS v4

    I want to pass on a variable to the shopping cart that is available in the product_info.php.html template but I can't seem to do it. I am using STS v4.1. I created a shopping_cart.php.html file but that did not work. I just get a broken page. I would really appreciate some help with this. THe variable is price breaks and I want to show them under the product name in the shopping cart.
  11. One of our vendors does not allow us to freely show price breaks of their products because of several reason which are not important what is important is trying to hide them in the product info page and showing them at the checkout page. If we can hide them on the product info page then we can add a note on that products page to "Add to cart to see Price Breaks" We are trying to use a CSS class but because the STS template system and the nature of how osC works a CSS class would hide all product price breaks and that's not what we want. So we devised a plan to make a php call in the template that would only be triggered if the query was on that page. I'll explain We add the following code to the template file class="<?echo("$hidden_class"); ?>" Then in the admin area we would add the following code to trigger that class to be filled: <?php $hidden_class = "hidden_price"; ?> The problem is we have not been able to get this to work by adding the second piece of code in the description of the product. It seems osC is parsing the code as regular text instead of PHP. At this point we are completely out of ideas on how to hide just certain price breaks. Any help would be greatly appreciated. Thanks in advance.
  12. Well I figured it out. Turns out it was the simplest thing, isn't it always? There was another module installed, that I was not aware of, that controlled which payment options are available to different groups. Man that was a relief. Time was of the essence.
  13. I don't understand what is going on here. When logged in with a a registered account I see this: When I Purchase Without Account I see this: Any help? I'm at my wit's end on this. The client needs this installed by the 18th of December. Time is ticking. The cart is heavily modified but it has to do with knowing where the user is shipping to. Nothing to do payment type. Thanks in advance.
  14. PropioWeb

    PayPal WPP Direct Payments & Express Checkout Support

    I assume that because you are now able to turn off paypal express in the admin, PayPal no longer requires that button on the pages. If so, is there a way to install this module without all the added functionality. We just want it to process the credit cards. That's it, no express checkout needed. I thought I could get it to work by just making the core changes said in the instruction, but for some reason I do not see the Credit Card fields on the payment page. See below. I saw it for one transaction then it disappeared. Can you guys login and go through the checkout and let me know if you see the fields? There's already something in the cart to test with. The shop is live so please no orders. The cart is also heavily modified so if it asks for your zipcode just enter it. It's part of the modification. newenglandspirits.com/login.php user: web@stevens470.com pw: 123456
  15. PropioWeb

    PayPal WPP Direct Payments & Express Checkout Support

    Ok, I'm having all kinds of issues with this module and I'm at my wits end. Lets see if anyone here can help, I would really appreciate it. I am Running Ver: paypal_wpp_1.0.2 Php 5 on an Apache Shared Server My Diagnostics: Basic Tests Using at least PHP 4.3.0? Yes Does your store have an SSL certificate installed and working? Yes Is cURL installed? Yes Does cURL work? (Simple HTTPS test) Yes API Certificate installed? Yes API Certificate directory protected? Yes API Username in place? Yes API Password in place? Yes Database update in place? Yes Payment class modifications in place? Yes Bug in checkout_process.php fixed? [Read More] Yes XML Document "doDirectPayment.xml" exists? Yes XML Document "doExpressCheckout.xml" exists? Yes XML Document "getExpressCheckoutDetails.xml" exists? Yes XML Document "setExpressCheckout.xml" exists? Yes XML Document "transactionSearch.xml" exists? Yes XML Document "doCapture.xml" exists? Yes XML Document "getTransactionDetails.xml" exists? Yes XML Document "refundTransaction.xml" exists? Yes Advanced Diagnostics Able to connect to PayPal through cURL? Yes Received a valid response? Yes Did PayPal respond without errors? (If not, errors are below) No Internal Error (10001) Internal Error Ok, I am getting the same errors whether it's a live certificate or sandbox. I did read that PayPal has to help the Internal Error (1001), I will submit a ticket for that. But what really is bugging me and it might just be related to the internal error is that I keep getting two warning of files missing that I KNOW are there. When I click on the Express Checkout Button I get: PayPal WPP installation incomplete! There should be XML files located in /includes/wpp_xml/ ! (setExpressCheckout.xml) And when I go to the orders page in the admin I get: Warning: include(home/xxx/public_html/includes/configure.php) [function.include]: failed to open stream: No such file or directory in /home/xxx/public_html/admin/orders.php on line 16 Warning: include() [function.include]: Failed opening 'home/xxx/public_html/includes/configure.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/xxx/public_html/admin/orders.php on line 16 I have quadruple checked and those files are where they are supposed to be, why the heck are these errors coming up? Again, any help would be awesome. Thanks in advance. :rolleyes:
  16. PropioWeb

    USPS Shipping Insurance

    I use paypal_ipn.php
  17. PropioWeb

    USPS Shipping Insurance

    Hey Scott, I have the same PayPal issue but I cannot figure out where to add the code on the paypal file. It's just too much going on in there and I'm not too PHP savvy. A little help from anyone would be great.
  18. PropioWeb

    Official PayPal IPN Support Thread

    Well this is odd. I've run several test of the above statement and every time the status in osCommerce always goes from Preparing to Pending without having to click on the button on the last PayPal page. This means a customer would not have to click that button in order for my client to know that the PP payment has gone through. Why then did this one customers payment not change the status? Is it a fluke? I hate this.
  19. PropioWeb

    Official PayPal IPN Support Thread

    Hi Guys, not sure if this has been fixed but my client does not like the fact that the customer has to click a button on the very last page after payment has been received in order for osC to know that the order is complete. A customer called the store saying that he had payed for his items weeks ago yet had not received his order. When they checked his status was still set to Preparing [PayPal IPN] even though his payment had gone through. I know some sites that take PP that after the payment has been completed automatically redirect you back to the shop, has this been implemented in PayPal IPN or something to that effect? Thanks
  20. PropioWeb

    PayPal IPN v0.97 released

    I installed PayPal IPN over a year ago and the following just started happening and I'm not sure if it's something I did. My client will get maybe 8 or 10 paypal orders a day and from those at least one will not have the shipping charges included. I have not made any changes to the payment modules but I did work on the USPS module which entailed modifying the modules.php file in the admin dir.
  21. PropioWeb

    Western Union & payPal IPN

    I installed the latest western union payment module but for some reason when I activate it PayPal IPN goes Bye Bye. Once I've deactivated Wester Union PayPal IPN comes back. Has this happened to anyone else and if so did you fix it and how? Thanks in Advance, --Sammy
  22. PropioWeb

    Easy Discount

    Yes it does. Read through the rest of the thread and you should see something that you can modify to your
  23. PropioWeb

    Easy Discount

    Does this look right? I don't want to make it go live and break the site. There are people always on it. // 50% discount on USPS First Class and Priority Shipping if ($cart->delivery(First Class, Priority)) { $easy_discount->add('HalfShip','50% off Shipping',$cart->show_total()*0.5); } else { $easy_discount->remove('HalfShip'); }
  24. PropioWeb

    Easy Discount

    Actually it's supposed to be 50% off USPS First Class and Priority Mail Only there are other options that cannot be discounted.
×