Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

kenkja

Pioneers
  • Posts

    256
  • Joined

  • Last visited

Posts posted by kenkja

  1. Hi Jim

     

    No worries, thanks for the confirmation.

     

    I do optimize the database quite frequently, but am on a shared server, so don't know how much others are interfering or how much is actually my site slowing down the server.

     

    sooner or later will have to upgrade as we've only added about 5% of the products we want to

     

    regards

     

    Ken

  2. @@kymation

     

    Hi Jim

     

    Quick question about featured products and scroller, both work fine, but are very unresponsive when changing thro admin so I get around the issue by changing the products required in configuration table.

     

    Could this be something to with the fact that I have more than 30000 products so the drop down boxes are taking a lot of time to populate ?

     

    Regards

     

    Ken

  3. @@pweden

     

    The Paypal page I'm taken to is nothing like the screenshot, you've posted, it is identical the one that 14steve14 described above.

     

    Before you tried installing the add on in this string, did your paypal page have the option for payment by credit card.

     

    Are we understanding the process you've gone through correctly -

     

    1. You have a Paypal Business/premier or above account using Website Payments standard

    2. You've installed Website payments standard via your admin

    3. On a v2.3.1 site, which had no other alterations to the paypal website payment standard files

    4. You then tried to add the better description add on and things have then gone downhill.

     

    because the add on should only affect the descriptions of the products bought on the left hand side of your screenshot not the payment options

     

    ken

  4. Hi Chris

     

    Thanks for the link, but I'm still a bit unsure about it as the installation file tells me in part 2 find 2, to locate the second occurence of

     

    <?php
     } else {
    ?>
    			  <tr>
    			    <td class="main" colspan="3"><?php echo '<b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td>
    			  </tr>
    <?php
     }
     for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {
    

     

    within catalog/checkout_confirmation.php but I can only find 1 instance of this code block.

     

    Ken

  5. I have just done a test purchase up to and including the point where a standard v2.3.1 passes the user over to paypal, the options given for payment were "Have a Paypal Account -. Log in" or "Don't have a Paypal Account - pay with debit/credit card. The changes in the add-on will not change these options, without the add-on on left of the paypal checkout page you'll see your site name and transaction totals, I think net shipping and total, if you find a way of successfully introducing this add on you'll see at least three lines of the products the customer has bought on this page, but the right side of the page will not change, as it is definitely controlled by your Paypal Preferences.

     

    I know my reply is frustrating for you, but I'm not a programmer, and at least as I understand what you are saying paypal is allowing users to pay by both methods

     

    Try doing a test purchase yourself, when you get to the payment method section, does it show underneath Payment Method "PayPal (Including Debit and Credit Cards), if so I think you have your paypal set up accept both PayPal account payments and PayPal as a payment gateway

     

    Ken

  6. I'm hoping to make this into add on, I would be grateful if some of you you are better than me at coding/add-ons would have a look, test it and suggest where I could improve the installation file

     

    Below is my draft of the installation file

     

    *********************************************

    All Credit goes to Chritian at Hockrockhosting.com

     

    and to

     

    PiLLaO/reflex-ocasion

     

    *********************************************

    As always backup your database and files

    *********************************************

     

     

    This add on is intending to provide users of v2.31 and paypal standard with a more complete description of any sales which have taken place..

     

    At present v2.3.1 only passes to PayPal standard, the details of who has been paid, the total goods quantity, shipping and total price.

     

    I can not gaurantee that this will show show any more than 3 lines on your primary e-mail addess, as this is eactly what it shows my Just Host e-mail account, however I have opted for a second e-mail to be directed to our Microsoft Live e-mail account which shows full details of the order.

     

    So just try it and see if works for you

     

     

    As always backup your database and files:

    ************************************************************************

    Instructions to manually alfter yor files

    ************************************************************************

     

    There are no files to upload, just modifiications of 2 files, I suggest you make a copy of both files by adding "bak" just before the .php of each of these so that at least you original files are retained.

     

    *************************************************************************

     

    Files to alter

     

    catalog/includes/modules/payment/paypal_standard.php

    catalog/checkout_confirmation.php

     

    *************************************************************************

     

    So here are the alterations to make

     

     

    1- Open catalog/includes/modules/payment/paypal_standard.php

     

    Find:

    -----

    'item_name' => STORE_NAME,

     

    Replace with this:

    ------------------

    'item_name' => $_SESSION['FixOrder'],

     

     

     

    2- Open catalog/checkout_confirmation.php

     

    (2A)

     

    Find:

    -----

    require('includes/application_top.php');

     

    Add after:

    ----------

    $_SESSION['FixOrder'] = "";

     

    (2B)

     

    Find: (it should be in standard v2.3.1. install around line 159)

    -----

    <?php

    } else {

    ?>

    <tr>

    <td class="main" colspan="3"><?php echo '<b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td>

    </tr>

    <?php

    }

     

     

    Add after:

    ----------

    $_SESSION['FixOrder'] = $_SESSION['FixOrder'] . $order->products[$i]['name'] . " x " . $order->products[$i]['qty'] . " ";

     

    (2C)

     

    Find:

    -----

    if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {

    for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {

    echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>';

    }

    }

     

    Replace with this:

    ------------------

    if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) {

    for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) {

    echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>';

    $_SESSION['FixOrder'] = $_SESSION['FixOrder'] . "(". $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] .")";

    }

    }

    $_SESSION['FixOrder'] = $_SESSION['FixOrder'] ." | ";

     

    ************************************************************************

    That's all

    ************************************************************************

     

    Thanks ken

  7. Hi 14steve14

     

    I recently managed to delete all my oscommerce files after a cPanel FTP create/delete account issue. Thankfully I have them the site back now but courtesy I an old backup. Yeah yeah I know I started doing alterations without backing u, I am a fool.

     

    Anyway my v2.3.1, is now working as its supposed to do, so I set about making the paypal better description alterations as you suggested in #10 above.

     

    I think I've got yellow after me recent loss of site episode, given that I have managed to make this work before ( It may have been luck not good judgement), but the install instructions are

     

    1- Open catalog/modules/payment/paypal_standard.php - I presume this means catalog/includes/modules/paypal_standard.php

     

    2- Open catalog/checkout_confirmation.php - and make 3 alterations, the second of which occurs after the second occuence of

     

    <?php

    } else {

    ?>

    <tr>

    <td class="main" colspan="3"><?php echo '<b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></td>

    </tr>

    <?php

    }

    for ($i=0, $n=sizeof($order->products); $i<$n; $i++) {

     

    But I can only find 1 occurence of this on or around line 159, are there really there really two occurances of this passages of code in v2.3.1 or am I just going mad.

     

    Ken

  8. Hi Heather, sorry for the delay in replying.

     

    I got the fact that the re-captcha was optional, and did at first want to leave it out just because I was approaching it from a user (with lack of understanding) point of view, but having read further understood from the web owner point of view its defintely needed.

     

    Thanks for your note of how to achieve a balance between the two positions

     

    Ken

  9. Hi All,

     

    This seems to be just the add on I'm looking for, but, and you knew that was coming.

     

    As a relative newcomer to owning a website, I've always been really quite annoyed by reCaptcha becuase I never really understood what its purpose is, until reading the add on install.txt(s)

     

    So in the past I have, quite a number of times, just quitted a contact us because i had to enter a reCaptcha code, which honestly just seemed to be a pointless irritant, my guess is if I've felt that way then so have/will others.

     

    Is it possible to add an explanation of why the reCaptcha is necessary, say

     

    "We've added this function to purely stop automated spam e-mailers, if you go complete the reCaptcha section, we will know that you really did want to contact us and we will deal with your enquiry as soon as is possible"

     

    Ken

  10. Hello Jim

     

    I have your module working correctly but have also installed Mindsparx Star Product, which again works as expected but I can not control the position of where it appears on the front page, at present it appears below the front page modules I have installed, here's the code extract from my index.php

     

    } else { // default page
    // Start Modular Front Page
     ?>
     <div class="contentContainer">
     <?php echo $oscTemplate->getBlocks('front_page'); ?>
     </div>
     <?php
    // End Modular Front Page
    // STAR PRODUCT PIMPED START...
        if (SHOW_STARPRODUCT=="true") {
       include(DIR_WS_MODULES . FILENAME_STAR_PRODUCT); }
    // STAR PRODUCT PIMPED END...
    
     }
    

     

    I think I may have answered my own question in writing the post, Is it really just as simple as

     

    } else { // default page
    // STAR PRODUCT PIMPED START...
        if (SHOW_STARPRODUCT=="true") {
       include(DIR_WS_MODULES . FILENAME_STAR_PRODUCT); }
    // STAR PRODUCT PIMPED END...
    // Start Modular Front Page
     ?>
     <div class="contentContainer">
     <?php echo $oscTemplate->getBlocks('front_page'); ?>
     </div>
     <?php
    // End Modular Front Page
    
     }
    

     

    Ken

  11. Hello Chris,

     

    I've been trying to deal with the same thorny problem that Varina has or had, without a great deal of success.

     

    To date I found your advice to be absolutely bang on, so decided will make the jump to website payments pro.

     

    On v2.3.1 the list of payment modules includes 3 for WPP, Direct Payments, Payflow Direct Payments and Payflow Express Checkout.

     

    The later 2 seem to be dependant on each other being installed and the first dependant on express checkout being installed, which hopefully won't be a problem, but do both pairs give the itemized listing.

  12. Hello Jetta

     

    I read with great interest your add on support thread, regarding my v2.3.1 site

     

    For some time now I have been trying to establish a way of checking out without creating an account and more recently trying to send more info to paypal (my only payment option is paypal website standard)

     

    Just to add a bit of background, I've searched the forums for "checkout without account" and other variations of this and mostly the searches always appear to come back to some form of simple checkout and I probably should have gone with the flow but found most of the threads I landed on, had to many issues raised or did not (for me) fully explain that they were "trying to" or could achieve checkout without account.

     

    Mostly it seemed that simplicity was the deal, my friends tell me I have "aspergers", they are probably right as i could never connect the search to results.

     

    Anyway recently, I've been trying to overcome the the lack of info about a sale included on Paypals confirmation of sale e-mail and also when logged on to paypal the info provided shows no details of the products actually purchased, and added to my site "Better Descripion for PayPal Payment standard" (http://addons.oscommerce.com/info/6783), which adds to the PayPal Confirmation of sale e-mail and to the transaction description within your paypal account - the product name and quantity.

     

    The add-on relates to some fancy php concerning FixOrder, and searching for FixOrder brought me to your thread.

     

    God this is long winded, even I think my friends are right now !!!

     

    Anyway, what I wanted in the e-mail from paypal was "Product_model" ,"Product_name" , "Product_price" , "Product_tax", " Product_inctax_price" , "product_Qty" , "effectively qty X inctax price" , for every product line which had been purchased.

     

    Nb. I know that some of my field names may not actually be in osc but i think you'll understand the drift.

     

    Thats the scene set, I search for "FixOrder" and find your conversation with Varina.

     

    So,

     

    1. I think you contribution allows purchase without account

     

    2. Can it be adapted to send more info to paypal

     

    regards

     

    ken

  13. Hello All,

     

    In the absence of any posts, I thought I'd give it go and try out my idea of adapting http://addons.oscommerce.com/info/6783 , as above, I changed the additional line in part 2(2) which adapts checkout_confirmation.php from

     

    $_SESSION['FixOrder'] =  $_SESSION['FixOrder'] . $order->products[$i]['name'] . " x " . $order->products[$i]['qty'] . " ";
    

     

    to

     

    $_SESSION['FixOrder'] =  $_SESSION['FixOrder'] . $order->products[$i]['model'] . $order->products[$i]['name'] . " x " . $order->products[$i]['qty'] . " ";
    

     

    Unfortunately all this did was alter the e-mail from paypal to include the product name twice, clearly I'm barking up the wrong tree with the last post, so don't try it

     

    regards

     

    ken

  14. Thanks to Steve, I have installed the add-on onto my v2.3.1 install and it certainly goes someway to achieving the result desired, now the paypal confirmation e-mail shows for example

     ------ Payment details -------------- Description: M01613001 CILINDER NUT x 1 | T0305015 5X15 DACROMET ALLEN BOLT x 1 |
    Unit price: 1.14 GBP
    Quantity: 1
    Amount: 1.14 GBP
    Postage: 3.95 GBP
    Total: 5.09 GBP 

    Good start, but I'd like to take this a few steps further if possible, such that the e-mail would show

     

     --- Payment details ------
    
    Description:
    "Product_model" M01613001 CILINDER NUT x 1 "Product_Price" "Qty X Product_Price"
    "Product_model" T0305015 5X15 DACROMET ALLEN BOLT x 1 "Qty X Product_Price"
    "Order Value before Shipping"
    Postage: 3.95 GBP
    Total: 5.09 GBP
    

     

    Now I can here you all asking why not go to the admin, all these details are there and you'd be absolutely correct. However, I have Sara's admin IP restriction, (see

     

     http://www.oscommerce.com/forums/topic/313323-how-to-secure-your-oscommerce-22-site/page__st__560 

     

    ) in place and my partner who works from a different location is not all that computer literate, does not have fixed IP and gets totally lost when I tell him how to reset his IP address, hence i'm trying to make it a simple as possible for him so that he can either check the paypal account or the paypal email account to see full details of any orders. As I understand the add-on (and my understanding of php is not that great), part 2 (2)

     

     Find: (Put the entire sentence because there are two equal sentences, the last) ----- <?php
     } else {
    ?><TR><TD class=main colspan="3"><?php echo '<b>' . HEADING_PRODUCTS . '</b> <a href="' . tep_href_link(FILENAME_SHOPPING_CART) . '"><span class="orderEdit">(' . TEXT_EDIT . ')</span></a>'; ?></TD></TR><?php
     }
     for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { Add after: ---------- $_SESSION['FixOrder'] = $_SESSION['FixOrder'] . $order->products[$i]['name'] . " x " . $order->products[$i]['qty'] . " ";
    

     

    Creates the detail for the new information for the description and the separator " | " is created by the third alteration. This is where lack of knowledge of php comes in, i think I need to alter the last line of part 2 (2)

     

     $_SESSION['FixOrder'] = $_SESSION['FixOrder'] . $order->products[$i]['model'] . " " . $order->products[$i]['name'] . " x " . $order->products[$i]['qty'] . $order->products[$i]['price'] . "a formula to calculate qty x price" . " "; 

     

    and to replace the separator in part 3 with a line return <BR>

     

    but as I don't really understand what, for example "$order->products[$i]['name']" in part 2(2) of the add in, means or is calling on, I'm unsure if the "model" or "price" statements are actually what I need.

     

    Any clues would be gratefully appreciated.

     

    regards Ken

     

    Nb Sorry if this whole most end up a mess, it seemed okay at first but when I tried to edit it, there where no carriage returns, I've tried to put them back, but I'm also not very good at forums

×
×
  • Create New...