Jump to content

frankl

♥Ambassador
  • Content count

    894
  • Joined

  • Last visited

  • Days Won

    44

Reputation Activity

  1. Like
    frankl got a reaction from greasemonkey in RMA Returns System for osC2.3.4BS   
    Everything good. Business has been huge the past 12 months so I haven't had time to play with osC. Hope you are well.
  2. Like
    frankl got a reaction from greasemonkey in RMA Returns System for osC2.3.4BS   
    Everything good. Business has been huge the past 12 months so I haven't had time to play with osC. Hope you are well.
  3. Like
    frankl got a reaction from raiwa in RMA Returns System for osC2.3.4BS   
    Hey Lee, I'm in the middle of wrangling a Magento 2 site we inherited over to osC so I won't be doing anything like that for a while. I haven't even had time to download Phoenix yet, way too busy. Sorry.
  4. Like
    frankl reacted to 14steve14 in Product Page Layout   
    have been having a bit of a play with this on a new version of Frozen. I thought others may like to see the results. There have been no core file changes, and apart from a bit of padding in the button code nothing has been changed. The layout is created by using the method that Gary explained further up the thread. The product price will be played with later as I need to convert some code to make the layout different as I need to show customers the savings on the actual price and the buying price.
    The description is under the image disclaimer, as will be the cross sell products, recently viewed and the reviews and what ever else will be tagged onto the end of the page. These may even be placed inside Garys 28 days of code tabs so will have to see what looks best.
     

  5. Like
    frankl got a reaction from azpro in iDeal via ideal-checkout   
    @azpro Mijn ouders zijn Nederlands, ze emigreerden hier in 1959. Daarom is mijn Nederlands slecht 😀
  6. Like
    frankl reacted to burt in Product Page Layout   
    @rulegacy Did you try the way I suggested.  I've just done that on a test site and it worked well.
    @14steve14 My way you'd just add the Tabs module as the very last sort order (eg 1000) and set width to 12. 
    I don't understand why people are advocating core code changes when it can be done with none?
  7. Like
    frankl reacted to burt in Product Page Layout   
    Totally do-able, it is exactly as @raiwa says.
    Gallery 10 6
    Name 20 6
    Model 30 3
    Price 40 3
    Attributes 50 6
    Buy 60 3
    Reviews 70 3
    Description 80 6
    You are constrained by the DEPTH of the Gallery, so place a minimum height on this using CSS which would be placed in user.css
    @media only screen and (min-width : 768px) {   div.cm-pi-gallery {     min-height: 1000px;   } } Change the min-height on this to better reflect your needs.
    You will then also need to amend tpl_ files for product_info, at the very least;
    remove clearfix from reviews button tpl restyle price as it would look weird as a h* Prior to the extra tpl_ change for price, you would end up with something like:

    Of course, how this would look in XS...is debatable, and that is why you can micromanage the layout using those tpl_ files if you so wish.  My system for these modules uses only the SM layer.... however, that micro-management is where things get really complicated really quickly and hence why I did not put that level of management into Core.
     
  8. Like
    frankl got a reaction from oscMarket in BS Slick Image Gallery Question - 2.3.4.1 CE Compatible Image Gallery Module for Product Info   
    I haven't played with this addon, I'm merely relaying a message.
    What happens if you comment out that line entirely?
     
  9. Thanks
    frankl got a reaction from oscMarket in BS Slick Image Gallery Question - 2.3.4.1 CE Compatible Image Gallery Module for Product Info   
    In that case try this:
    Replace:
     
    $slicks[] = array('image' => $product_info['products_image'], 'htmlcontent' => null ); with:
     
    $slicks[] = array(); on line 42
  10. Like
    frankl got a reaction from Bobber in BS Slick Image Gallery Question - 2.3.4.1 CE Compatible Image Gallery Module for Product Info   
    Apparently this is the solution:
    Just replace:
     
    $slicks[] = array('image' => $product_info['products_image'], 'htmlcontent' => null ); with:
     
    $slicks[] = ''; on line 42
  11. Like
    frankl reacted to burt in Best practice to replace Admin module(s)   
    Thought about this a bit more.  I recently made for a client a system of assigning "best" products in a category and manufactuer/brand. 
    I could have put that into the admin/categories.php page, but that page is kind of complicated...  
    Instead I put it in it's own page:

    What you see there (admin side):
    New box module & language file for "best products" sidebox [2 files] New box module & language file for "in brand" link in that sidebox [2 files] ditto "in category" link [2 files] New page & language file for assigning products to categories [2 files] New page & language file for assigning products to manufacturers [2 files] Shop side:
    new module for index_products which looks for assigned products and displays them appropriately  [2 files] All of the above is a long winded way of saying what you could do is leave the base functionality alone and instead have an extra page just doing the bits you want to add.  Although this is 12 extra files, there is no touching of core code and the amount of time spent creating those 12 files is perhaps a few minutes more than trying to implement it all in admin/categories.php
  12. Like
    frankl got a reaction from Tsimi in Advanced Specials   
    https://apps.oscommerce.com/Gsxm9&advanced-special-offers-and-discounts-fo
    Let me know if you have any problems.
  13. Like
    frankl reacted to burt in Who in the EU has heard of GDPR and will it affect you   
    @14steve14
    Obviously with a backup done first!!  This first query is the "Master Blaster"...
    delete from customers where customers_id not in (select customers_id from orders) and customers_newsletter = 0 that will remove all customers that have never made an order AND are not a subscriber.
    You then need to clean out other tables, and we know that any ID that does not exist in the customers table, should not exist anywhere else;
    delete from action_recorder where user_id NOT IN (select customers_id from customers); delete from address_book where customers_id NOT IN (select customers_id from customers); delete from customers_basket where customers_id NOT IN (select customers_id from customers); delete from customers_basket_attributes where customers_id NOT IN (select customers_id from customers); delete from customers_info where customers_info_id NOT IN (select customers_id from customers); delete from products_notifications where customers_id NOT IN (select customers_id from customers); delete from whos_online where customer_id NOT IN (select customers_id from customers); delete from reviews where customer_id NOT IN (select customers_id from customers); delete from reviews_description where reviews_id NOT IN (select reviews_id from reviews);  
    And that should do it. But all of this is UNTESTED...
  14. Thanks
    frankl got a reaction from raiwa in Anyone made a module for Afterpay or Zippay (Australia)   
    @raiwa
    I could never get the API to connect, and didn't get any help from Zippay.
  15. Like
    frankl got a reaction from burt in Addon installer concept   
    @piernas You touched on this a little, but the sad thing is that 2.4 makes addons ultra easy to install and uninstall. It almost makes me cry to see the wasted opportunity there.
  16. Like
    frankl got a reaction from burt in Addon installer concept   
    @piernas You touched on this a little, but the sad thing is that 2.4 makes addons ultra easy to install and uninstall. It almost makes me cry to see the wasted opportunity there.
  17. Like
    frankl reacted to piernas in Addon installer concept   
    Now that oscommerce community version allows more an more addons with no core code changes I feel an uploader/installer would make things simpler and also help a lot those newcomers that does not have the knowledge to ftp files.
    We don't have a repository adapted to it, but we could ideate a simple system that allows to upload a zip file by browser, uncomprees it, do some preliminar checks like if the addon is currently installed and is compatible with the system and with copying files/making registry entries when user press "install".
    Been playing with the idea of something like the paypal app updater and came up with this:

    Would like to get feedback from developers about it. It would need, of course, that developers agree with packaging the addons with a certain structure and provide with a file that performs the tasks.
    Do you consider interesting to make a similar system?
     
  18. Like
    frankl reacted to piernas in Shipping table is now a real table :)   
    Today I decided I got angry for the last time updating a table rate based module. Afer several tryouts to change the shipping rates just to see I had a typo in the values string  -damned colons- and having to manually calculate the net prices for each row from the gross that came from the table provided by the courier... I had enough and modified the table rate module to show a real table where you can see what you're doing. Uses some javascript to update net/gross, add or remove rows and do some basic checks.
    It can be adapted to any other module that uses the same system.
    Note: The net pice is caclulated based on the tax class from the module. It will apply only to the countries in the module's zone and it's not savet to database but calculated on the fly. For this column to work you need to set up the tax rate first, save and enter the module configuration again.
    Here is the file: https://apps.oscommerce.com/wyYLv&sgipping-table-module-update
    @burt you can replace the stock one if you consider it fits the community project.

  19. Like
    frankl reacted to BrockleyJohn in [Addon] Google Customer Reviews GCR & Seller Ratings   
    OK folks - version 1.1 is now in the apps area.
    I've added an option to send products for review and a check on whether your database has the products_gtin field in it. One changed file, which is now self-updating once you've copied it in so no messing about un/re-installing.

  20. Like
    frankl reacted to Roaddoctor in [Addon] Google Customer Reviews GCR & Seller Ratings   
    Google updated the code to include Products as an optional field which I believe will extend to product reviews, not just site reviews.  What is needed to get those GTIN submitted?
    <script src="https://apis.google.com/js/platform.js?onload=renderOptIn" async defer></script> <script> window.renderOptIn = function() { window.gapi.load('surveyoptin', function() { window.gapi.surveyoptin.render( { // REQUIRED FIELDS "merchant_id": xxxxxxx, "order_id": "ORDER_ID", "email": "CUSTOMER_EMAIL", "delivery_country": "COUNTRY_CODE", "estimated_delivery_date": "YYYY-MM-DD", // OPTIONAL FIELDS "products": [{"gtin":"GTIN1"}, {"gtin":"GTIN2"}] }); }); } </script>  
  21. Like
    frankl got a reaction from mcmannehan in ULTIMATE Seo Urls 5 - by FWR Media   
    @Psytanium
    I found this on the forum a long time ago:
     
    In includes/modules/ultimate_seo_urls5/page_modules/index.php find
    if ( false === $text_array ) { and change it to
    // Change to fix PHP Warning:  Invalid argument supplied for foreach() in /home/user/public_html/includes/modules/ultimate_seo_urls5/page_modules/index.php on line 111       //if ( false === $text_array ) {       if ( false == $text_array ) {  
    I haven't had any problems since then.
  22. Like
    frankl reacted to PiLLaO in Contribution: Auto Backup Database   
    Uploaded new update, replace mysql functions by mysqli functions to works with v2.3.4
    https://apps.oscommerce.com/1F1Uz&autobackup-database-in-admin
  23. Like
    frankl got a reaction from Smoky Barnable in RMA Returns System for osC2.3.4BS   
    https://apps.oscommerce.com/m2hDP&rma-returns-system-for-osc2-3-4bs
     
    Full product returns system for osCommerce.
    Features
    ·         No core file changes needed, just upload to your store. ·         One click install. ·         Works with PHP 7.1 and Edge ·         Create returns from admin, or allow customers to create their own, or both. ·         You choose which order statuses orders must be at for customers to return items. ·         You choose how many days after ordering customers can return items from an order. ·         Includes issuing of discount coupons direct from the returns admin page*. ·         Includes Paypal refunds direct from the returns admin page**. Partial refunds OK. ·         If you require serial numbers to be entered this can be turned on in admin. You can also make serial numbers optional or compulsory. ·         Return items to inventory if you desire, just tick a box on the returns admin page. ·         Set a default restocking fee, and inform the customer when they fill in the return request. ·         Terms and conditions can be shown to customers before they fill in a return request, if so they must agree to continue. They can also have the terms and conditions emailed to their email address. ·         One click comments when updating orders. ·         Unlimited number of return reasons. ·         Unlimited number of refund methods. ·         Only logged in customers can create a return request. ·         Search for RMAs in admin by RMA Number, customer name, or order id ·         Will not create duplicate RMA request numbers.
  24. Like
    frankl reacted to Dan Cole in Newsletters Subscribers Manager - Oscommerce 2.3 & 2.2   
    In an effort to improve customer engagement I developed an Anniversary Email a few years ago which has been working well.  Customers have been pretty impressed by it and it generates additional sales.  As they say an image it worth a thousand words so here is the email so you can see what I've been doing. 

    Over the years I've noticed a bit of a glitch with the database query when we reach year end and since I was upgrading the mailing to use @tgely Gergely's HTML Emails I thought I would see if I could sort out the query.   For some reason the query isn't spanning the calendar year so doesn't include records for the previous year when the date range spans the year end.  I've tried reworking the query several times but I can seem to figure it out...it's kicking my butt.   Does anyone @bruyndoncx perhaps, have any idea how I can rework the query to get it to work on a consistent basis.  Here is the query I'm working with.
    SELECT c.customers_firstname, c.customers_lastname, c.customers_id, c.customers_email_address, c.customers_dob, date_format(c.customers_dob, '%M %D') as date_of_birth, CURDATE(), (YEAR(CURDATE())-YEAR(c.customers_dob)) - (RIGHT(CURDATE(),5) < RIGHT(c.customers_dob,5)) AS number_of_years FROM customers c WHERE concat(year(now()), '', date_format(c.customers_dob,'%m%d')) < date_format(DATE_ADD(now(), INTERVAL 7 DAY),'%Y%m%d') AND concat(year(now()), '', date_format(c.customers_dob,'%m%d')) > date_format(SUBDATE(now(), INTERVAL 3 DAY),'%Y%m%d') AND c.customers_newsletter = '1' AND c.customers_dob != '0000-00-00 00:00:00' AND c.customers_email_address NOT LIKE 'MOPS%' ORDER BY date_of_birth Dan
     
     
  25. Like
    frankl reacted to bruyndoncx in [Contribution] Products Specifications   
    To list specifications by specifications group, you don't need a group by statement as you are not performing any aggregate functions for the particular group.
    You just need to add the specification group name (or sort order if you have any) to the order by clause (and make sure the table is joined in the whole construction)
     
    Then when outputting results, just show the specification group name if it is different from the previous one for the spec/value combo.
     
    HTH
×