Jump to content


  • Content count

  • Joined

  • Last visited

Profile Information

  • Real Name
    Andrew Hearn
  1. ahearn

    Official PayPal IPN Support Thread

    Is there a way to hard code a maximum price that the paypal payment option will be shown for? eg, because of fees, I'm wanting customers to pay by other means if the order total is above ?300? -and therefore not show the PayPal option? Thanks
  2. I've got problems with the admin side of this contrib (http://www.oscommerce.com/community/contributions,1888) Using the instructions I've replaced the code in admin/customers.php to be: $customers_query_raw = "select c.customers_id, s.sources_name, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from " . TABLE_CUSTOMERS . " c join " . TABLE_ADDRESS_BOOK . " a join " . TABLE_SOURCES. " s join " . TABLE_CUSTOMERS_INFO. " i on s.sources_id = c.entry_source_id and i.customers_info_id = c.customers_id and c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id " . $search . " order by i.customers_info_date_account_created desc, c.customers_lastname, c.customers_firstname"; But I get the following error: 1064 - You have an error in your SQL syntax near 'on s.sources_id = c.entry_source_id and i.customers_info_id = c.customers_id and' at line 1 select count(*) as total from customers c join address_book a join sources s join customers_info i on s.sources_id = c.entry_source_id and i.customers_info_id = c.customers_id and c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id The Customer side works (ie the database gets updated) I'm just not able to view the results in customer.php Any ideas? (on MS2) Thanks!
  3. Hi, I'm wanting to add the $the_title text which is used in my META headers, somewhere in my template? Is this possible? (I tried simple putting $the_title. but it jsut display the text $the_title) (I'm using the META tags contribution) Thanks!
  4. ahearn

    Products Attributes Sort v1.0

    Have other people got this working? I'm having problems. The admin IS working, as I can view my database and the Sort_Attribute is being updated OK. But the items in my select lists, are unchanged! I've updated the product_info as in the readme (basicly adding the "order by pa.attribute_sort". I'm running the "Product Attributes - Option Type Feature 1.6" mod, but don't think they should make a difference... Thanks for your hard work, as is a feature lots of people have been asking for!
  5. ahearn

    Recover Cart Sales

    This works really well! (using MS2) I did a reply to one of my test accounts, and the PS text came just after the Cart Contents, and before the "We are always interested in knowing what..." text. The Readme file said the PS mesage would be after the signature... (This was tested on a customer acount that had previosly made a purchase from the store)
  6. By default OSC sorts the attributes by Title, I've forced the order by numbering my titles eg in the Product Options, I've set the Option Name to be: 1. The First Option 2. The Second Option 3. The Third Option It will do for the time being, but still looking for a way to sort the items in the attribute. I've only got a small number of products, I guess larger shops won't find this usefull!
  7. I've got New Attribute Manager v4b working on 2.2 MS2, and I've got the 'Option Type Feature 1.6' installed. Looking for a way to sort the Attributes, and the items in the attributes (ie in the drop down select lists) now... Finding this a bit difficult though....
  8. I'd also like to know how to order the option. Many thanks!
  9. I've got this contribution working, thanks!... however If a product has not linked cross sell items, the product_info page still displays the title: "We Also Recommend:" with no other recomendations. How can I make it not display the X-Sell recommend box if there are no items cross linked? Thanks! (PS I'm using the one dated 11/14/2003)
  10. ahearn

    PWA combined with STS

    Do the same addition as above in: Order_Info_Process.php
  11. I have a product, and it requres the customer to give me additional information - this is requred information and must be given. The information is actually a phone number, but it may well be a different phone number than that of the contact details given. Has anyone modded the Option Type Feature so that a text field is 'required' and needs to be completed before the order can be placed? -or is there another way? Thanks!
  12. STS with PWA? Has anyone worked out what to edit to get STS working with the Purchase Without Account conttib? (http://www.oscommerce.com/community/contributions,355) At the moment, the PWA page (Order_Info.php) comes up with blank contents. Thanks
  13. ahearn

    PWA combined with STS

    I've got the same problem :( but can't fix it myself... any one else able to help us out? THANKS!