Jump to content

14steve14

♥Ambassador
  • Content count

    5,703
  • Joined

  • Last visited

  • Days Won

    73

14steve14 last won the day on March 14

14steve14 had the most liked content!

Profile Information

  • Real Name
    Steve
  • Gender
    Male
  • Location
    Dorset UK

Recent Profile Visitors

137,578 profile views
  1. Again, thanks Jack. I hate SQL and never seem to get it to work without a jump start form someone that ids in the know.
  2. Jack, thanks for that. I used your addon on the last sti=ore I had, but not on the latest one. I don't want to delete them without first checking that everything is ok, and that they are not also on our mailchimp mailing list. If they are on our mailing list I was planning on sending them one last email to let them know what we were doing with their data and why we were doing it. Hopefully that may stir them into buying something again. If nothing else it will remove years worth of data from the database.
  3. Using Phoenix 1.7.11 I am trying to find a way of listing all customers who are signed up on my website, but who have not purchased anything in the last 6 years. This is something I am thinking about to comply with GDPR and not keeping data or information longer than we need to. It may also remove lots of unneeded customer info from the database I have SQL to find a list of customers listed by last order date but need a way to refine that list to show those that have never bought from a specific date. The SQL code I have is SELECT customers_name, o.customers_email_address, date_purchased FROM orders o ORDER BY date_purchased Is there any way of adapting that so that it shows customers with no orders after a certain date. One way I have thought of is to find the last order date for each customer, but have no idea if that is even possible in SQL
  4. 14steve14

    Fake accounts

    Dont download the top file, use the one below it and read the instructions included. For some reason someone didnt upload a full set of files to the addon just a fix file which sort of messes things up a bit and makes it hard to figure out what to download and install.
  5. 14steve14

    Updated Stripe payment module

    Have a read here. The first few posts explain how to setup Stripe. make you you have followed the instructions.
  6. 14steve14

    Stripe for osCommerce

    I would use the next one up Version 1.1.0r1 but use the correct code for your version. The files are clearly marked to what they will work with. As long as you have followed the setup procedure, are using the correct keys and have the webhook created in your Stripe account all should work. I cannot remember having anything different to do. If you are having problems it may pay to add a post in the support thread.
  7. 14steve14

    Stripe for osCommerce

    Are you using the correct version of the addon for your version of oscommerce?
  8. 14steve14

    Stripe v3 module for SCA

    I would imaging just the one in the includes/configure file. I use stripe and my is like this const DIR_FS_CATALOG = '/home/######/public_html/'; My proxy server settings are also empty because I dont use one so no need for anything , although if you do use a proxy then you will need to put something in there.
  9. 14steve14

    Stripe v3 module for SCA

    I had that happen to me and had to add a new card and delete the old one. If you speak to Stripe they will tell you its a security thing so cards cannot just be updated by anyone, which is good.
  10. Oscommerce has been in a mess for years. After HPDL left things, the community took over and for many years kept oscommerce afloat, and did indeed upgrade it and got it working far better than anyone else had been able to. Along came the new owners, kicked out the one version that was at least useable and have now left things in an even bigger mess than they were before then have not been seen for many months and no news. Now there are several people all touting and attempting to sell their own forked versions giving the impression that it is something new and something everyone should be using, whilst the community version is going from strength to strength doing its own thing under a new name and picking up new users daily. The best thing that could possibly happen now is that oscommerce were left to die a dignified death, as it probably should have done years ago.
  11. 14steve14

    New management and osCommerce v4

    The community had been supporting the updating of the original oscommerce code for many years as the owner did not so there was a modern version based on the code available. The new owners took would not allow that software to be talked about here, but others are talking about their own cobbled together bashed and hacked code which is not official so something is a bit funny.
  12. 14steve14

    New management and osCommerce v4

    The new owners got rid of the people that cared, and then thought they could do a better job. They had an oscommerce based product that they already believed was better than what was already available so they could have released that until they got v4 ready. Instead they came, they lied and they seem to have gone. Shame really as it was looking promising for a while.
  13. 14steve14

    New management and osCommerce v4

    I agree. You would have thought that many ecommerce platforms would be developed for the store owners, but many seem to be for the developers.
  14. 14steve14

    Royal Mail Click and Drop

    Sorry for the late reply. The only thing I have done was to get coded a button that when clicked opens a csv document with the required information that can be uploaded to the click and drop royal mail system. Its manual unfortunately but I am sure a developer here could come up with something for you.
  15. 14steve14

    New management and osCommerce v4

    @osCommerce-Official it sound as if you already have a product as you are posting screenshots from it in other threads, so why not release that. What is causing the wait until later this year for a release.
×