Leaderboard
Popular Content
Showing content with the highest reputation since 03/29/2023 in all areas
-
Exciting Announcement! We are thrilled to introduce the brand new osCommerce YouTube channel, created exclusively for osCommerce enthusiasts like you! 🌟 Discover our channel: osCommerce YouTube Channel Join us as we embark on a journey to explore the world of osCommerce and unlock its full potential. Our channel is dedicated to providing you with valuable tutorials, insightful module descriptions, and helpful setup assistance. 🎥 Featured Video: Latest PayPal API 2.0 for osCommerce 2.2 and 2.3! 🆕 🔗 Watch the video here: PayPal API 2.0 for osCommerce In our first video, we dive into the exciting realm of the latest PayPal API 2.0 for older versions of osCommerce (2.2 and 2.3). Learn how to seamlessly integrate this powerful module into your osCommerce store. Stay tuned for step-by-step guidance and expert insights to enhance your PayPal integration. 📅 Upcoming Videos: Over the next two weeks, we have a lineup of videos related to this new PayPal integration that you won't want to miss! Stay connected with us to explore additional features, troubleshooting tips, and best practices. 🔔 Subscribe to our channel and hit the notification bell to stay updated on our latest releases! Don't forget to like, comment, and share your thoughts with our growing osCommerce community. Let's embark on this osCommerce adventure together and make your online business thrive! See you on the channel!4 points
-
Nginx setup for osc 4.12
osCommerce-Official and one other reacted to Webitbz for a topic
To get osCommerce 4.12 running on my Windows 11 WSL Ubuntu 22.04 NGINX 1.18.0 PHP 8.2 system I did following: First installed osCommerce on the server (on a demo virtual domain). Added nginx.conf file to the root of the osCommerce installation (see attached nginx.conf file). Created empty access/error log files. Adjusted vhost configuration for my test domain (see attached vhost.conf file). I might be an idea to add this nginx.conf to the core osCommerce distribution for easy setup nginx users. nginx.conf vhost.conf2 points -
Why doesn't PHP 8.0 work?
pandrei and one other reacted to jimdanforth for a topic
You have a nice life. I hopenyou are able to find what you need.2 points -
Why doesn't PHP 8.0 work?
Ken Shea and one other reacted to jimdanforth for a topic
Kinda demanding to come hear and get nasty for something you were given for free. Then when help was offered you were still rude. Personally, I would have just bounced you from the group and gone on with life. We have uncovered probelms and been able to resolve them with the teams support and Andrie has been very helpfull. I would suggest you back up just a bit and listen instead of complaining.2 points -
2 points
-
So I have now solved my shipping cost issues and want to share what I have done. My store in particular sells high end goods. So it was important for me to get the shipping costs correct. So Northern Ireland, Scotland, England & Wales have there own shipping costs. There are many ways to handle the shipping costs but there is nothing that can do it based on where the customer lives. This can be extended to the Highlands and Islands of Scotland also. Even a seperate one for Jersey, Guernsey if needed. Step 1 First step you need to visit settings>Locations>Geo Zones Step2 Create your Geo Zone Shipping Areas. In my case I create Scotland, Northern Ireland, and Free Shipping (This is the free shipping for the UK and Wales) So drilling down into the Northern Ireland Geo Zone I can enter all of the Counties Here Step 3 So now I want to create a new shipping module for Northern Ireland only and only for people that live in these counties So now we access via FTP or CPANEL of what ever you use Lib>Common>modules>ordershipping Here I will take a copy of flat.php and this will be the Northern Ireland shipping module I rename it to NI.php and modify the following important values: Class XX extends Moduleshipping { 'the XX has to be unique for any new shipping module' In this case I change it to NI The next important steps are anything that contains MODULE_SHIPPING_XXXXXXX. Rename XXXXXX to be your new shipping module name. In my case I have chosen NI. Change this for all values in the file. example class NI extends ModuleShipping { var $code, $title, $description, $icon, $enabled; protected $defaultTranslationArray = [ 'MODULE_SHIPPING_NI_TEXT_TITLE' => 'NI Rate', 'MODULE_SHIPPING_NI_TEXT_DESCRIPTION' => 'NI Rate', 'MODULE_SHIPPING_NI_TEXT_WAY' => 'Northern Ireland' ]; // class constructor function __construct() { parent::__construct(); $this->code = 'NI'; $this->title = MODULE_SHIPPING_NI_TEXT_TITLE; $this->description = MODULE_SHIPPING_NI_TEXT_DESCRIPTION; if (!defined('MODULE_SHIPPING_NI_STATUS')) { $this->enabled = false; return; } $this->sort_order = MODULE_SHIPPING_NI_SORT_ORDER; $this->icon = ''; $this->tax_class = MODULE_SHIPPING_NI_TAX_CLASS; $this->enabled = ((MODULE_SHIPPING_NI_STATUS == 'True') ? true : false); Step4 Once you have changed all of the values save your changes. Now move that file back into the Lib>Common>modules>ordershipping folder Step5 Now head to modules>shipping>offline and click show not installed. The file you created will be shown below. Click intsall The result is as follows Attach you new Geo Zone to it And make sure it is enabled for checkout etc... Now when a customer orders an item from my store they will be charged the correct shipping rate. This is how I am doing it and for me it works as I need it to work If a customer lives in Scotland lets say Aberdeen then when they enter the county the shipping will be applied or freeshipping for Bedfordshire Make sure you select United Kingdom in the settings Hope it helps2 points
-
Jesus, just spotted where I need to add it. Menus> Under menu select footer... Dohhhhh2 points
-
Try to change the same setting into the .user.ini file at the site root.2 points
-
@Ken_Shea, @jimdanforth, @CHD-UK after unzipping, upload the attached file to the site root and open this link in the browser: https://your_site/apply_migrations.php apply_migrations.php P.S. if you don't see the Finish in the end of the page, send me a screenshot or saved html page and log files from here lib/console/runtime/logs/*.log.2 points
-
Andy is right - the template key is working fine in the latest 4.11 version. It is right fix, we will include it in the next update. Thanks Andy, you are right again. Your fix will be included in the next update. It will be fixed in the update, which we are going to release this week.2 points
-
Just turn off Google recaptcha by running this SQL: UPDATE configuration SET configuration_value = 'False' WHERE configuration_key = 'PREFERRED_USE_RECAPTCHA' Or by adding this line in the admin/includes/local/configure.php: define('PREFERRED_USE_RECAPTCHA', 'false');2 points
-
ZoneTable - Need to duplicate shipping module
osCommerce-Official reacted to Jack_mcs for a topic
I haven't tried it but I think you would just need to create a copy of that file and edit it to change the name as needed, zones_alt. You may need to edit the language defines so it describes the new module correctly.1 point -
Error (#42S22) - An internal server error occured.
mendoh reacted to Ivan Holbi for a topic
Hi Mendoh, Please try the solution described in the link below. https://www.oscommerce.com/forums/topic/508432-how-to-upgrade-the-oscommerce-version-41256860-to-4_13_60075/?do=findComment&comment=1842984 Best regards, Ivan1 point -
Good morning @pandrei After some thought I decided that perhaps I should "Flush Cache". After my problem with the migration, that occured while you were out of the of the office, and I seemingly resolved it following your directions with the file you had posted here https://www.oscommerce.com/forums/topic/508432-how-to-upgrade-the-oscommerce-version-41256860-to-4_13_60075/#comment-1842984 At that time my Migration failure issue had been fixed as the solution you had offered showed that the migrations had been applied. This morning I wondered IF flushing the cache would make any difference. I selected EVERYTHING with the exception of "Logs" and performed the "Flush Cache" routine again. I was NOT expecting the results to be as extensive as the attached PDF content shows. Although I had done what you had posted in the above post and yes the migrations had shown that they had applied there must have been some parts that had not actually been performed. Performing the FLUSH CACHE this morning apparently applied ALL the parts needed as 1. The products can now be editted 2. The log ON/OFF error screens are no longer displayed. So, at this point, my issues seem to be RESOLVED. I want you to know that I truly appreciate all the work that you do behind the scenes in assisting everyone. IMHO, your assistance is invaluable, THANK YOU. BJ 20231118 Cache Control_Backend.pdf1 point
-
New clean install and links from Splash page not working.
pandrei reacted to andrethegiant for a topic
I am not overly technical, but have managed to do it, and its actually working... So for any other simpletons like myself that are struggling, this is what I did 1) Open the Terminal from within cPanel 2) Then type in the following to get you in the correct directory, obviously changing it to suit you. cd /home/cpanelusername/public_html/ 3) The command line then should change to say /public_html to show which directory you are in, then you need to type the following to add the watch SymLink ln -s ./ watch 4) Repeat for the others.1 point -
1 point
-
Hi BJ, It looks like once you enable "watermarking" for a "platform" / sales channel, then you are only able to bypass this setting if either the product has been marked as "no_watermark" (as you have discovered) or if the customer belongs to a group which by passes the watermark (not appropriate in your situation) As far as I can tell, the only option (out of the box) is that you go into the products individually, select the images TAB and then click the "don't apply watermark"... a bit tedious! So options are, 1) write a add-on which allows selecting of categories and toggling the watermark switch or 2) running some SQL to set the "no_watermark" flag based on the category name Option 2 is quick and easy so here's some SQL to get you started. This will set the "no_watermark" flag for all product images which are in the category named "Accessories" Make sure you test on a non-production database first to ensure you are happy with the way it functions before unleasing it ! Make sure you change the WHERE cd.categories_name="Accessories" on the last line to the correct categories name for your needs (Case sensitive) Change the first line to "SELECT * FROM `products_images_description`" to check the selection looks correct before executing UPDATE `products_images_description` SET no_watermark=1 WHERE language_id=0 AND products_images_id IN ( SELECT products_images_id FROM `products_images` pi LEFT JOIN `products_to_categories` p2c ON pi.products_id=p2c.products_id LEFT JOIN `categories_description` cd ON p2c.categories_id=cd.categories_id WHERE cd.categories_name="Accessories" AND cd.language_id=1);1 point
-
Creating a new payment module for Oscommerce
nordicsolution reacted to CHD-UK for a topic
Yes, you can create modules, use them or distribute them to clients quite easily. For more information you can check the WIKI here: https://www.oscommerce.com/wiki/Main_Page https://www.oscommerce.com/wiki/index.php?title=Creating_Payment_Module I know that there is a section for submitting your modules to the APP store - you can find links to this from your OSC Account dashboard (see image below) As for selling them, I believe that this is on the road map but I'm not sure how far along that is at the moment. You will need one of the core team to comment on that.1 point -
Failed to download application error
CHD-UK reacted to Ivan Holbi for a topic
Hi All, Thank you for drawing our attention to it. The issue per three posts above has been fixed. Best regards, Ivan1 point -
Hi @astecme, @pandrei I've had a look into this and as far as I can tell it is a JavaScript timing problem which occurs with the "Furniture", "Print Shop" & "B2B" themes. For me at least, The "Notify me when in stock" button works on the Watch theme! Until this is resolved, as a work around you can add the following code to xxx/lib/frontend/themes/basic/boxes/product/buttons.tpl Goto line 50 and insert: <script type="text/javascript"> tl('{Info::themeFile('/js/main.js')}' , function(){ $('#btn-notify').on('click', function() { alertMessage(` <div class="notify-form"> {Html::beginForm(Yii::$app->urlManager->createUrl('catalog/product-notify'), 'get')|strip} <div class="middle-form"> <div class="heading-3">{$smarty.const.BACK_IN_STOCK}</div> <div class="col-full"><label>{$smarty.const.TEXT_NAME}<input type="text" id="notify-name"></label></div> <div class="col-full"><label>{$smarty.const.ENTRY_EMAIL_ADDRESS}<input type="text" id="notify-email"></label></div> <div class="center-buttons"><button type="submit" class="btn">{$smarty.const.NOTIFY_ME}</button></div> </div> {Html::endForm()} </div>`); $('.notify-form').closest('.alert-message').removeClass('alert-message'); $('.notify-form form').on('submit', function(){ ajax_notify_product(); return false; }); }); }); </script> Should look like this Save and refresh your browser. You need to make sure you are displaying a product that has no stock (or just raise the "out of stock level limit" in the product "main details" tab) Let me know how you get on1 point
-
Hi @jessicana, Changing the text using the "Design & CMS -> Translation" option should not affect the icons as they are part of the template - it appears that somehow you may be missing the ::before psedo-element from your template. Check using the developer tools in your web browser. If it is missing - add it back in. Make sure you have "expert mode" selected before editing the theme Edit the theme, select the home page then hover over the item and click the green pencil In the popup window, make sure the HTML text is ##TEXT_SAFE_SECURE## then click "Widget Style" TAB Then click "Pseudo classes, :before" - Make sure the class is set to "local_shipping local_shipping3" (for the padclock icon) Alternatively - Depending on how much work you have done, you could try a reinstall of the theme - make sure you have a backup incase your translations are reset! or something - I've not tried this as I've not needed to do it1 point
-
Easy Populate V 3.0
Jack_mcs reacted to gsmiley007 for a topic
Thanks, Did the code changes. Did a reload of the page and the errors are gone. I only use 2 functions, csv file dump and restore. I did both a dump and restore and no error messages.1 point -
Thumbnails on ITEM PRODUCT display
Chadduck reacted to Ivan Holbi for a topic
1 point -
Back up theme and data base Admin>app Store> search Testimonials Select Install Once installed create menu (I put it in the header) Admin>Design&CMS>Menus Select Header Menu from the drop down list under Menus From the “Info Pages” left column drag the “Testimonials” to the right with in the Menu list. You can then slide those selections around to suit. Save after any changes If you want the title to be other then “Testimonials” click the pencil icon to the right and with in the Title enter what you want. Click Apply > Save That should do it, good luck I filled out a test Testimonial, received a email with a link to edit / approve / rank Check Pandrei post for further information.1 point
-
Why doesn't PHP 8.0 work?
Smoky Barnable reacted to InfoPulse for a topic
I'm not being nasty and I'm not complaining -- just pointing out the installer didn't work for me using PHP 8.0. And if it didn't work for me, it won't work for others. Could be just the installer that doesn't support 8.0 -- but if I or someone else doesn't post that there is a problem, how will it get fixed? I did quite a bit of searching in the Forum and elsewhere to see what the problem might be and couldn't find any answer -- why would you attack me for pointing out a problem? Are you trying to discourage people from pointing out problems? I do see that eventually support and custom extensions will be offered for money -- which we will gladly pay for as we've been using osCommerce for more than 40 stores since 2004 and are hoping to move them to osCommerce 4 starting within the next couple of months or so. So we are anxious for this to work -- but not at the expense of being treated like we're a pest and nasty for pointing out a problem.1 point -
USPS Rate V4, Intl Rate V2 (official support thread)
Tiff13 reacted to ozEworks Support for a topic
USPS Rate V4 Intl Rate V2 I am not sure the change recommended by Smokey is 100% correct as it is only first class parcel that is being change to Ground Advantage, Also I believe that module is missing Retail Ground ... at least the version one client's had did. Attached is our go at the changes for that module. usps.php1 point -
How To Add Link for Customer to Agree to Terms and Conditions before Checkout?
Smoky Barnable reacted to pandrei for a topic
If the update contains a modified file, it will ask you to force the update before which you can choose to ignore the update of that file. However, keep in mind that ignoring the update will result in an out-of-sync version, which can lead to loss of functionality. The correct course of action in this case is: 1) back up changed files 2) forced update 3) reapplying your changes1 point -
It's just information messages for import from internal osCommerce v3. Thanks. I see. I will contact you if testing needs your help.1 point
-
osCommerce 4.11 release
pandrei reacted to herbsandhelpers for a topic
Okay after carefully backing up my theme, holding my breath and pressing the force update button... It seems to have worked, seemed to go smoothly, says it's updated and I still have a functioning shop ... Hooray! Lorraine1 point -
1 point
-
Moving the county state up = success May look into that to move some of the text blocks to their normal place for US addresses.1 point
-
No doubt I'll be able to help1 point
-
Yeah, im sure you can do that! I think you need to set this up under product groups. Admin->Products -> Product Groups, click the insert button at the top, give it a name (eg. sunglasses) text box on the right and click save. Now click the "sunglasses" heading, then edit to assign all of the individual products to this group. I think when you view any of the "grouped" products, the entire group is displayed similar to how you requested. From memory, one of the other themes displays product groups similar to how you are asking but I cant recall at the moment, might be printshop (actually just tried and the furniture one looks ok too). Mine system is really slow at the moment with 10000 products in a single category so I'll need to tidy up and double check everything in the morning. Hopefully that should get you started...1 point
-
Not sure how you know all that Andy but glad you do, I would have had to just quit if it wasn't for your help, others of course as well have helped a lot and I don't mean to diminish that help but your's has been the big deal for getting V4 suitable. It's a shame all your instructive help in the many previous post prior to when OSC had membership issues is just gone and now no one is able to refer back to them, post's are still their but your replies ar gone, at least on my post.1 point
-
Got it Andy. Thank you Ken1 point
-
Hi Ken, For the background on the hover-box for the cart, it appears that you may have a "background-color" attribute missing. Goto the CSS editor and search for ".w-cart", then check the rules you have defined for ".cart-content" as shown below... You can change the "$background-colour-7;" to any of the colors already definded in your theme variables (see right hand side of the window), or alternatively use a color of your choice in # format eg. #90ee90;1 point
-
Hi Ken, Yes, you will need to add the line background-color: #90ee90; to the .w-account css file and then save it. You also need to edit the widget in the visual editor to remove the current background and font colours you have set. If we can get the changes to take, it should work just fine. Here are a few screen shots I've taken from prototyping the changes on your live website in my browser. This process may help in future as it will help you track down which parts of the theme to change. 1. In my web browser, I click f12 to get the developer tools, then click inspector. Select an element on the page using ctrl + shift + C (top corner icon) and choose the account box 2. The current styles are shown over to the right. You can see that both background-color and font color are set. So next I click the tickmarks next to background-color and color to disable these styles (this will be like us clearing them from the account widget) Next, I am clicking html document window to exand the A class to reveal the "::before" pseudo class, then click it to select and display the styles applied to it. You will see in the top right the ".w-account .my-acc-link::before" style. It currently has #0 for the colour and no background-colour set! (as per the browser window perview) - Will are going to test our changes here, then they will need to be duplicated into the themes css when we are happy. This one is fairly simple, we are just going to add a new entry for background-colour: #90ee90; You will see the icon spring to life - the preview is slight wrong colour because it is selected but de-selecting you will see it is as required Alternatively, it you are looking to blanket change all of the yellow to another colour, consider the styles button in the themse section. For the buttons, they are coloured using a variable named background-color-4 :: you will see this available down the right hand side when editing the CSS for the account widget. Just click to insert the colour-name, sort of like a short cut - everywhere that it appears will be replaced with the colour you define on the "styles tab" If you make changes on the styles tab you will need to flush the cache and rebuild the theme from the ADMIN menu. (Make sure the style rules have a ; at the end - missed it when taking this screen shot!! )1 point
-
Not real sure what you said but since you said it I agree 😄1 point
-
1 point
-
Andy, can't tell you how much time your instructions have continued to save me 🙂 Thank you1 point
-
google fonts GDPR user acceptance check
Smoky Barnable reacted to appshop-claus for a topic
A couple of months ago a german court decided that website owners whose pages load google fonts without prior acceptance by the visitor offend against GDPR and must pay compensation for immaterial damage (yes, it's mad) if brought to court. This is because for the download process your IP address is transmitted to the US and in contrary to european laws state institutions there can use this IP in reverse to get personal data from european providers and hosters. Therefore users must be able to reject the font loading or the fonts have to be loaded locally from a european server. I examined the given osComm templates and found that google fonts are loaded en masse. So I thought "lets comment out the loading code" and arrange the loading from my server or lets use substitute-fonts by the system. I failed by doing so because I could not find any (header-) code responsible for it. My guess now is that it must be found in the database. Before I start screwing around in the database my question: has anybody already solved this issue and can provide a plan? The second question: can the osComm developers either provide a GDPR fitting tool to let the visitors decide whether they want google fonts or not or just renounce the use of those fonts? Thanx and regards1 point -
Order Number start setting
Ken_Shea reacted to MrMayberry for a topic
I updated mine in the MySQL settings next invoice number. You can setup any format you would like. Example: 102023-1001 Let me know if I can help you out.1 point -
1525 - Incorrect DATETIME value: '' error
stitchontime reacted to Demitry for a topic
Go into catalog/includes/functions/banner.php and find tep_activate_banners() function. Change the $banners_query line to the following: $banners_query = tep_db_query("SELECT banners_id, date_scheduled FROM banners WHERE date_scheduled IS NOT NULL");1 point -
jQuery/Ajax Advanced Statistics for osCommerce 2.3
Smoky Barnable reacted to Ben23 for a topic
Hi I've just installed this module (on a modified 2.3.4+Bootstrap Gold) and I have to say it's a fantastic piece of work. Easy to install, looks spiffy, loads of features, and significantly higher code quality than the majority of OSC modules! Thankyou so much for all the work that's gone into it. I have a couple of minor bugs to report. The first one is with the Customer filter, which fails with the following error in the Apache log: PHP Fatal error: Call to undefined method mysqli_stmt::get_result() in /var/www/hht/hhtadmin/advanced_statistics/ajax_request.php on line 93 Looking at the documentation for that function at http://php.net/manual/en/mysqli-stmt.get-result.php, it says it's only available with mysqlnd. Since you claim at the top of this thread that mysqlnd should not be required, does this need rewriting to use a different method? Or is mysqlnd essential for this to work? I'm using PHP 5.4. The second concerns the menubar. At the moment, only the leftmost icon (which keeps changing - presumably this is intentional but it makes it harder to describe to users what they should be looking for) has a decent tooltip describing what it does. The rightmost one (which is showing as an "unknown character" glyph on my system) also has a tooltip but it is needlessly tall and narrow: see attached screenshot. The other three icons are not showing tooltips at all, thus they have no explanation what they do. And one further suggestion: It took me a while to figure out how to close the filter sidebar (by clicking outside it), so how about adding a Close button inside it just to avoid any frustration. Thanks again for your excellent work.1 point