Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Posts posted by 14steve14

  1. I updated this module earlier today and on testing both live and test there is the following error

    1054 - Unknown column 'billing_nif' in 'field list'

    I have tried uninstalling and reinstalling the module but still get the same error even after clearing the computer and server cache.

    To get everything back working correctly I reverted back to a copy of a backup of the includes/modules/payment/strip_sca.php file.

    Has anyone else seen this error?


  2. For the first time last month my sales through Stripe exceeded those through PayPal. The only problem with Stripe was that they kept your money for up to 7 days, but for some customers its down to three now just in case of chargebacks. On the one occasion I have to contact them for payment suppport they were reallt efficient and helpful. Not too sure that their charges are negotiable though unless you have a huge volume.

  3. 10 hours ago, Fredi said:

    Nobody deals with this module, so I will look for other options.

    Again moving on and hoping someone else has done something rather than you doing it.

    I give up some people just are not prepared to improve things and want it doing for them.

  4. 1 hour ago, Fredi said:

    Hi Steve!
    If I were a coder, then I would have done it without your conversion.
    I am not a coder. You know it. And every time you offer me to code. You're doing fine! But about coding, better give your advice to coders.

    Or please you encode.  :biggrin: :biggrin: :biggrin:

    Well pay a coder to do it then the same as we all have to instead of waiting for someone else to do it. Its easy for you and others to sit there and make these sort of comments that something would be good for your site, but there are only a few of us actually investing in the code and supporting the forward movement of oscommerce as you are fully aware.

  5. What ever you change that text to, make sure that it complies with local legislation. If you are in the EU then you have to be careful what buttons say as you have to make people aware that the next step of the procedure is to checkout and pay for the order.

  6. Or as most business will do suck up the costs. I am not too sure that the Consumer Contract Regulations allow for withholding part of a payment, but there may be  clause in there somewhere. I know several business that in calculating final selling prices of goods add in a percentage for returns, so this will just get added in to that.

    Stripe and other payment processors are also doing the same. I also think ebay are doing the same with their fees. Its not their fault the customer cancels or returns products so why should they give their costs back. Luckily I am in a low return business. Got to feel sorry for clothes or shoes sellers.

  7. Hopefully you or your hosts will have a backup of everything to a point before you started any updates. I would like to think that you have the store backed up before you started so just delete all the file son the server and replace with the backup. Then get your hosts, or you use your backup of the database and restore that.

    Once you have done that everything should be working as it was, then you can either leave well alone if you are unsure of what you are doing and get someone that is sure of what they are doing to complete the update.

  8. There used to be a computer creator addon that has not been updated for many years. I used it on a custom computer store that I used to run. It did exactly what you are looking for, and it would only allow options if the products were already in stock. At the time all those years ago people used it for many other things, including a custom shed website. Probably need too much work now to get it working on Phoenix.

    Its here https://apps.oscommerce.com/5NEUS&custom-computer-creator

    or there was another one that I never really got to work https://apps.oscommerce.com/FwS4E&pc-pro-creator

  9. Thanks @Jack_mcs Jack.  I will look at both of those.

    I tried doing a catalogue a few years ago and it was a nightmare from the very start so binned the idea. I got software to link into the database but it meant rewriting all the product descriptions as they were sill cut-off to a certain length. Apart from that it was not too bad but expensive to print and could not be converted into a PDF for download. Restrictions on the software without paying a small fortune and an arm and leg to get the full version.

  10. Thanks for all the hints and tips. I have decided that with over 3500 products, a page of products is not that good and looks horrible. I have decided to search for an admin addon and create a downloadable sheet that customers can save and use if they want. Seems easier and saves server resources. The stock taking addon looks to do something that can be saved and converted to a PDF that looks much better.

  11. 1 hour ago, raiwa said:


    I agree that it's not possible to satisfy all needs.

    But in real store life, most admins use order finished statuses which are different from payment received. Like: "shipped"", "delivered", "shipped by x", "shipped by y"

    All mine end up as Shipped or Download Available. Anything other that those can be deleted as they are not completed. The incomplete ones remain as the recover carts still register them. After a set time they are deleted.

  12. I am after a bit of help again. I have searched the addons area and cannot really find anything suitable that actually works. I have tried 3 or 4 from the addons section including some early versions.

    Does anyone know of a good simple price list addon that creates a page listing all the in stock products in the store with their name, model number and price. Not wanting image or anything too complicated. I cant find anything that is basic and easy to alter or change to work with Phoenix Would be nice if customers could save a file copy of the list and a print facility would be good but not a requirement nif its hard to do.

    Any help on getting something sorted for Phoenix would be appreciated. I am prepared to alter code to get an old addon working with Phoenix if that's what it takes.

  13. 13 hours ago, Smoky Barnable said:

    I think this was caused by a network communication/timeout error since it only happened once in thousands of orders, so I'm not too concerned with it.

    On another note, I was quite pleased when looking in my admin total revenue box that my sales had increased dramatically over the last few months. However it seemed too high....I realized today that the total revenue is not being reported correctly because it's treating orders with a status of Preparing [Stripe SCA] as completed purchases. These are customers that have not completed payment but are being counted as sales in the total revenue module. As a temporary solution, I patched the query to ignore orders with a status of  "Preparing [Stripe SCA]". I also changed this in all code that generates sales reports. I don't know if there is a better solution, but this really skewed my perception of how my business was performing the last few months and as such is quite an important issue in my opinion. I do understand that this can be avoided by manually deleting incomplete orders but I don't consider this a viable solution.

    I had exactly the same happen with all my payment methods. (Stripe and Paypal) Unpaid or uncompleted orders remain at the Preparing stage but still count towards any totals in the store. I just deleted all these orders and the totals were corrected. You also have to watch that if you send a refund or partial refund that does not get deducted in any of the payment reports either.

  14. What are all the setting you have in your admin - paypal- settings. I expect one of them is wrong. In the app can you access your balance?

    or you have changed the name of your admin folder and upgraded without installing the file in the correct place.

  15. 41 minutes ago, hungryfrank said:

    considering that two of the best  coders in the site helped,  this could become the source of information when u google it if it become useful in its own context.

    look at Burt he has put so much effort in making the bootstrap version for the community. be generous with your knowledge.

    Don't you ever shut up and not have the last word.. I will ask @burt or any other other mods to remove all your irrelevant posts as its doing nothing for this thread and will only stop others finding the information they are looking for. Hopefully it will be deleted from where I posted the image near the top.

  16. For those that cannot work out where the buttons are by looking at the images, they are in the product cards modules that are shown on the index page. Because it's on the index page that means that the file can be found in the index section of the content modules. As its altering the design, the template file is the one to alter. 

    There are other similar files in the index nested content block and also just in the includes folder. There are also similar display layouts in some addons such as recently viewed, also purchased, cross sell addons and there must be more.

    Hopefully that answers those that need the additional direction. I have no plans to release the full code as it's best not to alter the core code, and I am looking into adding to the user.css files to create the same effect which will save the hassle of changing core code files.

    Matter closed or post will be deleted or moderated to remove the off topic posts.

  17. 53 minutes ago, hungryfrank said:

    so if someone wants to make it look like what you did can do it also.

    this is how a community behaves a cult is different story. 

    of course u don't have to and that is also your right

    anyhow the page that has to be edited is


    now that wasn't so hard


    Well copy the code that is there. I posted the code for the buttons I had and the way to solve it was posted so the way to achieve the look of the buttons is there already. 

    Reading the bootstrap pages helped me figure out how to space the buttons using padding. It also helped be get the buttons to equally spread across the full width of the content box. What it didn't help with was how to alter the osc core code. In fact just buy using one extra bit that I could not figure out where to place and it did what I wanted. After trying it on two different lines I decided against the idea and put it back to what I already had, so the code is already posted. 

  18. 4 hours ago, hungryfrank said:

    a step by step instruction would be nice and Valquiria  can put a link in her topic.


    For what purpose? That page uses mostly standard code with a few additions to create centring and padding, and possible a bit of a margin in places. It is something specific that I wanted on my site. All the information can be found by reading and learning about BS and the different parts and shortcuts available. It could also be done by changing the user.css files but it was easier when testing to modify the core code. The only trouble with modifying the core code it needed lots of files changed where as it would only take a few changes to the css and the same effect can be achieved on all pages that use that code.

    All that information on bootstrap can be found here https://getbootstrap.com/.

    14 hours ago, valquiria23 said:

    It looks very pretty, good job!

    Thanks. Its getting there.

  19. For now have made a decision. No doubt it will change later. Changed it to look like this. The button widths now define the width of the module boxes now that the border has been removed (actually changed to white in the user.css file) It looked a bit silly when the buttons were stacked and some products had one button and others two.

    Thank @burt and @JcMagpie for your help and guidance. Now just got all the other files to change so they all look the same.



  20. I want to see what the index page looks like with full width buy and view buttons. Lots of sites I look at now have this feature. I know it will mean altering core code. I also know I have several files to alter plus others addons that I have added. I have already added a gap between the two buttons and centred them hence a few minor code differences.

    This is the code that currently positions the buttons in the boxes.

    <div class="btn-group" role="group">
                echo tep_draw_button(IS_PRODUCT_BUTTON_VIEW, '', tep_href_link('product_info.php', tep_get_all_get_params(array('action', 'products_id', 'sort', 'cPath')) . 'products_id=' . (int)$card_products['products_id']), NULL, NULL, 'btn-info btn-product-listing btn-view mx-1') . PHP_EOL;
                $has_attributes = (tep_has_product_attributes((int)$card_products['products_id']) === true) ? '1' : '0';
                if ($has_attributes == 0) echo tep_draw_button(IS_PRODUCT_BUTTON_BUY, '', tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'products_id', 'sort', 'cPath')) . 'action=buy_now&products_id=' . (int)$card_products['products_id']), NULL, array('params' => 'data-has-attributes="' . $has_attributes . '" data-in-stock="' . (int)$card_products['in_stock'] . '" data-product-id="' . (int)$card_products['products_id'] . '"'), 'btn-warning btn-product-listing btn-buy ml-3') . PHP_EOL;

    I have changed the first line to be

    <div class="btn-group d-flex" role="group">

    Which makes the single buttons full width, which is good, or spreads the two buttons equally across the box, but where to put the break to get one above the other. I have tried all sorts and nothing seems to work. Is there a rights way to achieve this.

    Edit. Forgot to add using Phoenix version but code looks similar to other earlier versions.