Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Mort-lemur last won the day on May 23 2018

Mort-lemur had the most liked content!

Profile Information

  • Real Name
  • Gender
  • Location

Recent Profile Visitors

77,487 profile views
  1. Mort-lemur

    Products with no Orders

    Just uploaded as an update to the contribution here: https://apps.oscommerce.com/jVxEK in case anyone else will find a use for this. Thanks All
  2. Mort-lemur

    Products with no Orders

    .....Well that was easier than I thought I now have a new field that shows how many have been ordered since day 1 against each product:
  3. Mort-lemur

    Products with no Orders

    @raiwa Thank you so much - the SQL has highlighted that I have 900 + products that have never been ordered in the last ten or so years - some are new items so can stay for now - the others I will delete. I downloaded @Tsimi s Multiple Products Manager contribution from here : https://apps.oscommerce.com/jVxEK What I need to do now is modify the Multiple Products Manager Page to display the number of items ordered against each product, then I will be able to speed down each category choosing products to keep or delete..... Scratches head....
  4. Mort-lemur

    Products with no Orders

    Hi All, My stores have been running 10+ years now and have 1000's of products. I'm now looking to streamline the stores and remove all products that over the years have had minimul or zero sales. Is anyone aware of a contribution or Sql commend that will help to identify items with a total sales of say <= 2 and then easily delete them? Many Thanks :)
  5. This subject has got us all racing round (again) making changes to our websites to comply (or at least what we understand as complying). I seem to remember us all doing this with the cookie law..... This makes some interesting reading: http://barker.co.uk/cookielaw So lets do all we can but not get too paranoid........
  6. @puddlec Thanks for the link. A lot of my customers are old farmers who do not use the internet - so email etc is out of the question. The link ou provided gives details on recording verbal consent - which I will do in the order comments box when compiling their order. Anyone got any further comments?
  7. OK I think I am almost there, apart from one little thing that does not seem to have been covered. Scenario is that a customer places an order by phone and we then enter his order on our website (manual order maker and order editor) this allows us to produce the invoice and process his order as a normal web order - problem is that he will not have seen our privacy policy or any of our GDPR statements. The only way I can see round this is to read each customer a rather long and boring statement such as Any comments or alternative solutions would be welcome....
  8. @14steve14 Thanks for the info on the analytics opt-out tool - I have now added a link to the privacy policy to point to this. I have MATC installed at the checkout confirmation page which I point with links to the Privacy Policy and the Conditions of the website plus I have added text to the create account pages with links to our privacy policy. I also have the system set up to attach a pdf version of our terms and conditions, shipping terms and privacy policy to all customer order confirmation emails Many Thanks
  9. OK I think I have done all I need to do?? Stopped using Google Analytics and deleted the code (I dont use it much anyway) Revised my privacy statement using the examples shown here: https://ico.org.uk/for-organisations/guide-to-data-protection/privacy-notices-transparency-and-control/privacy-notices-in-practice/ Added an option in the "My Account" section for customers to delete their account Unsubscibed ALL customers from the mailing list Sent email to all customers explaining about GDPR, Giving them links to our privacy policy, delete account function and telling them how to re-subscribe if they so wish Added a mondial popup to the site informing visitors about our revised privacy policy.
  10. Im taking a more proactive / drastic approach on this.... I intend unsubscribing everyone at a database level, then sending the email informing them that if they want to receive newsletters then to re-subscribe. I will also include a link to our revised privacy policy and a link to the account deletion page.
  11. Another scenario that I have been considering is that when a customer places an order by phone - we then enter his details on our site...... Im considering having a printed statement to read out to them regarding data collection etc.
  12. I guess we are al going to have to cease using Recover Carts Modules?
  13. Mort-lemur

    PayPal App for osCommerce Online Merchant

    Please ignore my post above - while I was writing the post it seemed to rectify itself ??!!?? Very odd but everything seems to be working as it should now. Many Thanks
  14. Mort-lemur

    PayPal App for osCommerce Online Merchant

    I have just installed the paypal app on my 2 sites - the first one went without issue and works as it should. However, I have installed on the second site and everything works as it should in Admin. BUT when a customer tries to add something to the shopping cart (or view the cart) just a white screen is displayed. The error in my error log is: PHP Fatal error: Cannot redeclare class paypal_express in /home/myaccount/public_html/includes/modules/payment/paypal_express.php on line 17 Line 17 of paypal_express.php is as follows: class paypal_express { Any pointers on this would be greatly appreciated as my site is essentially now losing orders. Many Thanks
  15. Just about sums up 2016: