Jump to content
Latest News: (loading..)

bruyndoncx

♥Ambassador
  • Content count

    3,791
  • Joined

  • Last visited

  • Days Won

    33

Everything posted by bruyndoncx

  1. bruyndoncx

    Display all products of subcategories in main category

    looks like you found it
  2. bruyndoncx

    Display all products of subcategories in main category

    yes you can, should be documented on here , basically you want the nested look like the products - i did on mine, but i am far ftom standard
  3. bruyndoncx

    Optimizing db query to speed up orders.php

    always use inner joins unles you really are in a situation that the joining table does not have matching records, it makes a bbiigg difference. For orders, they will have matching order total and status records, so no need to use an outer join.
  4. bruyndoncx

    Optimizing db query to speed up orders.php

    the left join can just be join i think, totals and status always being populated. perhaps updating statistics for the table might help and possible another index. I will have a look at my site to see how it is different from the differen stock versions ... Sorry guys but you are hammering too much ! this is a screw 😎
  5. it just works from your full size images, creating the necessary images on the fly, but you do need to define which sizes you want. It was very easy for me to get it going, perhaps your colorbox now interferes with it ...
  6. http://adaptive-images.com has minimal impact . it only needs addition of one javascript in the head. i think it fits with the modular BS approach. i have it running since ages ...
  7. I have previously installed the CE version configuration table into it's own new table and left my existing config alone. Then I uploaded the files into a separate directory and started to see where things went wrong and how to move my config over to the CE version or what alter table statements were needed to get my products, categories etc in sync ... It is less risky to fix things like this one by one, rather than start all over ... It will take time and perseverence
  8. custom myeach function ? https://stackoverflow.com/questions/46492621/how-to-resolve-this-deprecated-function-each-php
  9. Hmmm ... another question for you guyst ... which features will help you sell more or more profitably and will allow you to sponsor some development to get your wishlist implemented ?
  10. bruyndoncx

    Horizontal Megamenu

    the sort order is missing from your configuration, probably you need to add the field into your product listing first for it to be available as sort option under mega menu.
  11. Will v2.4 still have the language directories and files in it, or will the setup/maintenance of language constants be database based. I somehow recal it having a database based design at some point ? The roadmap doesn't mention anything about this.
  12. bruyndoncx

    Upgrade, or change cart?

    My deciding factor would be if there is a migration path from old osCommerce to new , being it osCommerce or to alternative cart. Granted the big changes, some re-learning would be needed either way. Then the question is , in new oscommerce or alternative cart, if you have the same freedom and easy of making changes at minimal cost.
  13. I just have a thumbbar category with an extra manufacturer filter and the first not in stock piece customized to distinguish temporarily not in stock vs completely sold out. Google hj3460 and you should find an example it in the listings (at least it is pretty high up on my google search)
  14. I'm addicted to Burts code. Whenever he puts something out in the dark winter days, I need to have it :D and I'm not even running the BS version. But since it is coded up nicely, I can also adapt it easily to my needs.
  15. bruyndoncx

    Geotargeting

    I really prefer a separate country and language selection like all big brands do nowadays
  16. I wondered if there are any and it made me smile :D
    https://remoteok.io/remote-oscommerce-jobs

    1. Show previous comments  1 more
    2. burt

      burt

      Someones got a secret webcam installed at my place!

    3. MrPhil

      MrPhil

      I've got my laptop's webcam turned off, but just in case someone manages to bypass that and turn it on, I have it (and the microphone) covered with a piece of electrical tape! Me, paranoid? Who sent you?

    4. bruyndoncx

      bruyndoncx

      Just because you are schisofrenic doesn't mean the world is not after you to get you ! :dry:

  17. @tgely ping me again in 3 months ... overwhelmed with work (store shutdown and warehouse move, another part time job with office move, and private house move ...) no time to tinker now.
  18. I attended local seminar about GDPR by our accounting firm and their security and audit department. Basically GDPR lays out common sense for security measures to protect the privacy of personall data of your customers. Plus you need to document who the consumer can contact for personal data (verification, correction or removal) Adres information that you keep with the orders in the accounts is not sensitive data. If you start to profile and keep track of the age of their kids and stuff then you can become in the grey area of things. If you have a doctors practice with medical records that is a big difference from an ecommerce operation. So you need to do common sense to ensure data theft is not possible (securing logins, pasword policy, no usb stick backups, servers behind lock). Make sure that (paper) processes are documented and paper records are destroyed so that private and sensitive personal data can not end up in the wrong hands. Also in a bigger setting with sensitive data, staff should only have access to the (sensitive) data that they need to know. Eg the janitor should not be able to access medical records to be blunt about it ... :D I personally think it is a good effort to raise the awareness, it is just peoples reaction is over the top if they don't understand the concept of sensitive data and overall risk mitigation. Edit: big caveat, if you sell personal data then you are in trouble :D
  19. how about spelling out the where clause with numerics without the year and adding the specific year end and year begin as extra where or where statements besides the typical date ranage ? (%c and %d) not using any year reference in the where clause. Sorry, I'm still pretty busy, might have some time tonight ...
  20. bruyndoncx

    Google Shopping for Clothing INTEGRATION

    a GTIN is an EAN and burt has code for that added in the responsive version if I remember well. Should not be too hard to find that piece of code and apply it to your 2.3.3 as the responsive bootstrap version has not really touched on the admin side of things.
  21. bruyndoncx

    Clearance Price addon

    As for storewide discounts, I have a category discount setup on our shop. We are in clearance mode for the physical shop - I defined different % for the top level categories. Modified the product page to show the discounted price. Only drawback is that it is not shown on the listing, nor in the shopping cart. Not perfect, but workable till I have a products class implemented with all the pricing logic.
  22. bruyndoncx

    Build a LAMP Stack for OSC

    forgot to mention, that RPI is just on the local network. It is an easy way for a unix environment where you have full control vs a cheap host.
  23. bruyndoncx

    Build a LAMP Stack for OSC

    on the other hand, it is a great piece of info to show off what you can and are knowledgeable about. The kind of thing I like to do on a raspberry pi just for the fun of it :D
  24. This contribution allows you to: * List products (alphabetically) for selected category displaying the special price and implied discount * Add a % discount to all products in selected category * Add, change or remove a special price for an individual product in the selected category It is multilangual, conforming to osCommerce TABLE conventions and only makes changes in the admin. This is an easy install, just a few files to edit and load of main php and language files. It is based on the specials admin contribution (206) Demo with screenshots included in the package
×