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

78,178 profile views
  1. Mort-lemur

    Increase Shipping Weights via SQL

    Thanks Gary, worked a treat
  2. Mort-lemur

    Increase Shipping Weights via SQL

  3. Hi Everyone, Hope everyone is keeping safe and well in these scary times. Im looking to run an sql to increase the shipping weight of products if under 1kg to 1.1kg leaving all other weights unchanged. Could do with some help as I dont want to destroy my database Many Thanks
  4. 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
  5. 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:
  6. 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....
  7. 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 :)
  8. 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........
  9. @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?
  10. 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....
  11. @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
  12. 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.
  13. 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.
  14. 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.
  15. I guess we are al going to have to cease using Recover Carts Modules?