Jump to content
Latest News: (loading..)


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by BrockleyJohn

  1. First time I set the slider to min/max 229 all products were priced 219. Second time all products 259. Then set range 229 - max (300 and something) and got no products at all. Win 7, Firefox.
  2. Perhaps 'filtered category listing' would tell people straight away what it does. It's likely a feature that will be in great demand when it's working. For this reason the ajax needs to be totally secure othewise it will be easy for a hacker to trawl for sites using it... The price slider isn't behaving predictably at the moment - it changes which products are displayed but not within the range apparently set
  3. If you set the zone in the module, it has to match a tax zone in admin config that is set up for the UK - All zones. Admin > Locations / Taxes > Tax Zones I guess you already created one, but you need to go in to edit it and make sure it's set to all zones for the country.
  4. That's a problem with your shipping method. It looks like you're using one that's not working properly. Or you have failed to configure zones properly. What shipping do you want?
  5. The line that's now failing on BUS_ENABLE_DELETE must be add-on code. My guess is that the add-on needs an installation script running to add this constant and you've forgotten to do it on your current database.
  6. The stuff that only displays in list is hidden in grid by this rule: .grid-group-item .list-group-item-text { display: none; } If you set display for the whole of this class you will also see description in grid. To pick off individual bits to show, you'll need to be more specific, eg. for model .dl-horizontal.list-group-item-text { display: block; } in your user.css But if that ends up showing other stuff that you didn't want to, you'll have to add something so you can target it exactly. Either a simple change to the php that outputs the grid, or a fancy bit of javascript that avoids you changing core code.
  7. @fleeced Lee, this'll get you started. https://forums.oscommerce.com/topic/412428-addon-facebook-pixel/
  8. [Addon] Facebook Pixel

    Apps area: https://apps.oscommerce.com/Apps&ZT4uG&facebook-pixel
  9. [Addon] Facebook Pixel

    Facebook pixels feed tracking information from your site into Facebook. The feature bears some similarities to Google Analytics but typically gives you more information about the behaviour of individuals and more detailed demographics. The basic pixel gives information about page views. It can be extended with event tracking. This addon implements the basic pixel and purchase event tracking with no code changes required. Compatible with any osCommerce 2.3 version including 2.3.4BS Gold and Edge. Designed to be compatible with stores implementing multiple currencies with different formats. Download link to follow shortly...
  10. We can't help much with theme-specific questions, especially without even seeing the web page! All the blue options in the admin snapshot are part of the theme. It's a shame you didn't follow the advice to base your site on the community responsive versions of oscommerce 2.3.4 - we could help with that. I suggest you ask the theme author for guidance.
  11. I did a last-minute thing for Black Friday, and have the first cut as a complete module. This adds the facebook pixel to whichever pages you select, which gives you tracking of clicks through the ad to the site. I have yet to add event tracking into this (doing it properly needs some extension of the brand new data attributes in Edge) but this could be left for a version two - I just need to do some documentation and it's fit to upload as is if you're interested.
  12. Paypal Sandard - Customer receives message could not verify Paypal trans.

    @jordi "could not verify transaction" is not a bug, it is an error message. There are several things that can lead to it, and most of them are failures to configure the module properly. Reverting to an earlier version of the module using less verification is not a solution, it's really avoiding the problem that you hit by doing less checking. I have seen several kinds of attacks on websites payment modules over the years usually with the aim of hijacking payments but sometimes trying to steal goods. I think it 's best to set up as much automated checking as you can.
  13. https://stackoverflow.com/questions/2447791/define-vs-const basically, const uses namespaces but define can be conditional and use expressions const outside classes is 5.3+ const using arrays 5.6+ defines and arrays 5.7+ And I think language files are going ini format, aren't they?
  14. Paypal Issue Could not verify the PayPal transaction

    @tornrawks in my client's case they were using a sandbox merchant account that had an unconfirmed email address - I think it had been created via the 'fetch Sandbox credentials' dialogue from osc. The symptoms (customer being returned to the shopping cart with the error message) were the same. If you look at the Paypal log in admin, you'll see that there's a successful _notify-validate [IPN] and a failed _notify-synch On the way to a solution, different details to the error logging were thrown up with different aspects to the resolution without PDT set up at all, there was no response to the _notify-synch with apparently all the proper settings in the sandbox merchant account and the matching token in osc, but with an unconfirmed email address in the merchant account, error response 4010. Sandbox accounts don't send actual emails and I was unable to find a way of confirming it since it was not associated with a developer account. If you sign in to developer.paypal.com and create a sandbox account there it doesn't need confirming. through carelessness in going from one setup to the other I also made it throw a 4011 error when the PDT token in osc was different to the one in the paypal account Suggested approach to configuring paypal sandbox account for testing: Log in to developer.paypal.com and create two accounts to use: a business account (to represent your shop) and a personal account (to use for placing test orders) Log into sandbox.paypal.com with your new business account. Go into the settings / My selling preferences / Website preferences / set Return to my website On, return url to http://domain.com/checkout_process.php, Payment Data Transfer to On, Encrypted payments off after saving these settings, go back in to get the PDT token fetch the sandbox credentials into osc using the new business account paste the PDT token into the configuration NB when you go live you will need to replace the sandbox PDT token with one taken from the live paypal account
  15. Paypal Issue Could not verify the PayPal transaction

    @tornrawks there's a time limit on editing a post - after a while you can't. Order status Pending is what you normally get on an order that has been paid. By default, they get created in a Preparing state, and changed to Pending on receipt of payment. Paypal [Transactions] is a logging order history that shows you the IPN has worked. Does the customer end up back at the beginning of the checkout process with the message that's the subject of the thread: "Could not verify the PayPal transaction. Please try again."? If so, that is your actual issue. The return from pp is failing and not going to checkout_success.php I have just hit the same thing setting up pp standard in sandbox mode for a client and will let you know what was causing it for them when I have sorted it out. It's likely a configuration thing.
  16. try the addon support thread: http://forums.oscommerce.com/topic/383307-usps-rate-v4-intl-rate-v2-official-support-thread/
  17. This uses the hooks system and tabbed display of admin / orders implemented by the Paypal App. It adds a tab to admin / orders which lists all orders from the customer of the current order. The current order is highlighted. Clicking on one of the other orders will load it instead. Works for all orders, not just those paid by Paypal. COMPATIBILITY Compatible with the tabbed admin orders page of the Paypal App in any version of osCommerce (2.2RC2, 2.3.x). FILENAMES DEPRECATED - if your admin / orders page is not called orders.php you'll have to change the hard-coded name in the module. Not compatible with BS EDGE Hooks of 2016-10-03 (which don't cover admin). Uses tradition language defines, not Paypal App-style. INSTALLATION Just copy the 3 files to your store. No code changes and no admin install - it just works. DOWNLOAD from the addons area http://addons.oscommerce.com/info/9511 GITHUB also available in a branch on its own in a fork of gburton/Responsive-osCommerce at: https://github.com/BrockleyJohn/Responsive-osCommerce/tree/addon_customer_orders_tab
  18. Customer Orders Tab in Admin Orders (hook)

    @kennyk glad you found it useful and straightforward. Exactly which Admin Notes mod are you using? I'll take a look when I've got time.
  19. There isn't much magic in 98 - 97 = 1 Suggested reading and practice exercises: https://www.mathgoodies.com/lessons/percent/sale_price
  20. Discounts are the amount off the normal retail price (either amount or %) ie ((normal price - sale price) / normal price) * 100 Markups are the difference between cost and retail price as a percentage of the cost price. ((retail - cost) / cost) * 100 Margins are the difference between cost and retail price as a percentage of the sale price. ((retail - cost) / retail) * 100 Your sums seem to mix these up - I doubt that your accountant does. If he/she does, get a new accountant and report them. If the sale price has a discount of n% to find out the retail price: retail = (sale price / (100 - n)) * 100
  21. It's your maths that needs an apology not your English. If you take off 40% from a big number, you get a result that's 60% of the big number eg 60 from 100 If you add 40% to 60 you should get 1.4 x 60 which is 84 40% of 60 is less than 40% of 100
  22. [Addon] Store Times BS

    A rewrite of the Store Open/Closed addon. The closing of pages is an option so it could be used in a store that's open all the time , e.g. to display whether the customer service phone line is operating. Written for osc 2.3.4 BS Gold and upwards. Set store opening times and open and close checkout: - Set opening & closing time for each weekday – or set the day to closed - Define dates and ranges for holidays in the current year; choose to use European or US date format in admin settings - Set time zone of store to allow for server and store in different zones - Format for date displays in catalogue and admin are taken from language files to support multi-language/international stores - Option to close store checkout (or any other pages) by diverting to the Store Times page during closed hours - Store Times page displays shop hours and holidays - Header message displays store status - Dashboard module shows current status and allows admin to override it - On installation, picks up opening times and holidays from addon 8044 Store Open/Closed if available Download and github links to follow shortly.
  23. [Addon] Store Times BS

    @greasemonkey look what I found: A neat way to change PHP / MySQL timezones at the script level In a nutshell, if php is using the right timezone and handling daylight savings, just use the format of php date that expresses the offset from UTC to set the MySQL timezone: "SET `time_zone` = '".date('P')."'" Since MySQL always stores datetimes in UTC, your existing data will be magically corrected. So there are two statements for a complete solution date_default_timezone_set('America/Toronto'); tep_db_query("SET `time_zone` = '".date('P')."'");
  24. [Addon] Store Times BS

    Hmm, maybe your mysql time zone is out of step. If I remember correctly mysql stores everything as UTC and converts it on the way in and out. It also has two time zones, a global one and one for each session. SELECT @@global.time_zone, @@session.time_zone; will find out what they are set to (if it's SYSTEM, it's the system timezone) SET time_zone = timezone; will set it but in my (admittedly limited) experience the timezone table isn't often set up, so you probably can't use 'America/Toronto' and will have instead to express it as '-5:00' (your time relative to me as I live 5 miles due south of the Greenwich observatory!) If you go down this route it'll need a bit of research into daylight saving, I don't know if mysql adjusts for it or not if you do this - your setting code might need to.
  25. [Addon] Store Times BS

    @greasemonkey Scott, what server time issue do you want to fix? I gather there's a time difference between your server and your store but this addon isn't going to change the time on your orders etc. I think you should be able to sort that out by setting the correct time zone - the 'proper' way is in your php.ini Even if you are on shared hosting you can usually have your own version of php.ini somehow but in this case you'd probably need to get support to help you set it up - and if you want to change php version you'd need to redo it. That's the only option I can think of if you want to avoid changing any core code but if you're not being anal about that an easier option is to set it in the code - probably in your two application_top files. Your statement should be: date_default_timezone_set('America/Toronto'); preferably before anything much else happens.