Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mort-lemur

Members
  • Posts

    2,443
  • Joined

  • Last visited

  • Days Won

    35

Everything posted by Mort-lemur

  1. Hi, I will be closing one of our 2.3.4 websites shortly and concentrating our other 2.3.4 website. I would like somehow to add a redirect from the closing store to the live store and display a message for a few seconds prior to the redirect happening. I know that a 301 redirect would be the best way to add the redirect, but my understanding is that you cant add a message to a 301? I also need to keep access available to my admin area for a while to continue to view orders for items still under warranty. What would the best way to do this please?
  2. OK a quick update on this one. We now have a fully functional epdq payment module installed thanks to @BrockleyJohn so we are once again able to take card payments via our website. Although we use OSC 2.3.4 I believe there is a module available for other versions. Thank you John for your work on this.
  3. @Jack_mcs I have eventually found a solution that works, thanks to a post on stackoverflow where someone else could not run a .php file via cron. The solution that works for me is as follows: (probably a very messy solution) 1. I moved the googlefeeder.php file to the root and commented out chdir('../'); 2. Created a file called googlefeeder_test.php in the root containing the following code: echo file_get_contents('https://mysite.co.uk/googlefeeder.php?noftp=1/'); 3. Set a cron job with the following code: php /home/myusername/public_html/googlefeeder_test.php This runs the googlefeeder.php code as a URL and updates the data-feed file without uploading to google, as google merchant center is set to retrieve this file once per day. This still has me puzzled though as I have no problem running googlesitemap as a cron but googlefeeder just would not run. Thank you for the help.
  4. @Jack_mcs my googlefeeder.php is already in my admin folder on my 2.3.4 site and runs fine from my admin google base commands - its when trying to run a cron I get the error emails. Many Thanks
  5. The email I receive from cron job is a few errors such as: [mysite@myserver ~]$ php /home/username/public_html/adminname/googlefeeder.php PHP Warning: include(includes/configure.php): failed to open stream: No such file or directory in /home/username/public_html/adminname/includes/application_top.php on line 28 googlefeeder.php invokes admin/includes/application_top.php but then does not seem to be finding includes/configure.php or includes/configure_options.php although these files exist. The googlefeeder runs as it should when called up in a browser tab. Im stumped....
  6. @Jack_mcs sorry to be a pain, but I now seem to have another problem - in that I cannot seem to run googlefeeder.php as a cron job from within my admin folder (my hosting provider is struggling to be able to resolve as well) Will googlefeeder.php run from the root (ie. public_html) folder, as I have cron jobs that run fine from there. Many Thanks
  7. I think I found what the problem was - in the section on merchant center where I set up the Fetch for the .txt file I had not set the default currency to GBP. Feeds now seem to be being added to google again, and I have set a cron to update the .txt file twice daily.
  8. Enabled it - still not adding the currency code to the .txt file
  9. apparently not - I have ensured that currency is set to GBP in googlefeeder.php and turned the line of code above to "1" and the output is still without the "GBP" suffix on the price.
  10. @Jack_mcs It looks like my main problem is that the datafeed is providing the price as a single numeric eg. "10.99" where google is looking for 10.99 GBP. Would this be because I have the line in googlefeeder.php set as follows? define('OPTIONS_ENABLED_CURRENCY', 0);
  11. OK not as simple as I thought..... Google did not seem to like the .csv file, so pointed it instead to the .txt file, which gave a successful upload. However, it does not seem to pick up the price or currency fields from the .txt file as per the screenshot below:
  12. @Jack_mcs I think for the time being I will get round this by the following: 1) Create (but don't upload) datafeed 2) From google merchant center add the path to where the file is located eg: https://wwwmysite.co.uk/feeds/name_of_file.csv Set for google to retrieve the file daily Can you see any problems with this? Many Thanks
  13. @Jack_mcs Hi Jack, Just had the following reminder from google: Is there any update to googlefeeder on the horizon? Many Thanks
  14. Hi, We have been using EPDQ without problem for the last few years. However, last year Barclays changed their requirements meaning that the current integration no longer worked and we had to pause taking online payments using EPDQ. The old EPDQ add-on developers are no longer around, and I was wondering if anyone was using EPDQ successfully at the moment? using the following Barclays requirements: <form method="post" action="https://mdepayments.epdq.co.uk/ncol/test/orderstandard_utf8.asp" id=form1 name=form1> <!-- general parameters: see Form parameters --> <input type="hidden" name="PSPID" value=""> <input type="hidden" name="ORDERID" value=""> <input type="hidden" name="AMOUNT" value=""> <input type="hidden" name="CURRENCY" value=""> <input type="hidden" name="LANGUAGE" value=""> <input type="hidden" name="CN" value=""> <input type="hidden" name="EMAIL" value=""> <input type="hidden" name="OWNERZIP" value=""> <input type="hidden" name="OWNERADDRESS" value=""> <input type="hidden" name="OWNERCTY" value=""> <input type="hidden" name="OWNERTOWN" value=""> <input type="hidden" name="OWNERTELNO" value=""> <!-- check before the payment: see Security: Check before the payment --> <input type="hidden" name="SHASIGN" value=""> <!-- layout information: see Look and feel of the payment page --> <input type="hidden" name="TITLE" value=""> <input type="hidden" name="BGCOLOR" value=""> <input type="hidden" name="TXTCOLOR" value=""> <input type="hidden" name="TBLBGCOLOR" value=""> <input type="hidden" name="TBLTXTCOLOR" value=""> <input type="hidden" name="BUTTONBGCOLOR" value=""> <input type="hidden" name="BUTTONTXTCOLOR" value=""> <input type="hidden" name="LOGO" value=""> <input type="hidden" name="FONTTYPE" value=""> <!-- post payment redirection: see Transaction feedback to the customer --> <input type="hidden" name="ACCEPTURL" value=""> <input type="hidden" name="DECLINEURL" value=""> <input type="hidden" name="EXCEPTIONURL" value=""> <input type="hidden" name="CANCELURL" value=""> <input type="submit" value="" id=submit2 name=submit2> </form> Any help would be greatly appreciated.
  15. Hi Jack, Looks like Google are making changes to how files are transferred, I received the following today: What changes would be needed to the Google feeder files so that they will still work (Site is running on 2.3.4) Many Thanks
  16. Thank You, Indeed the plain text tab of the email was empty. However, I also had to disable "Use MIME HTML When Sending Emails" in Settings - Configuration - E-Mail Options for it to send in the plain text version. as the HTML version is still adding in all the data as shown above. Thanks
  17. I have been looking at the functionality of the Voucher and Credit system on V4 which seems to work well. However, the email sent to customers is not formatted correctly (ie in plain english) as it shows all the HTML tags etc as the sample below, Where are these emails generated and is there a template that can be altered to suit? Many Thanks
  18. I'm taking a look at OSC V4 on a test server running php 8 I have copied the "watch" theme and am trying to edit the copied theme. However, I am getting the following error when trying to replace an image: Fatal error: Uncaught mysqli_sql_exception: No such file or directory in /home/sfftest1/public_html/includes/functions/database.php:25 Stack trace: #0 /home/sfftest1/public_html/includes/functions/database.php(25): mysqli_connect() #1 /home/sfftest1/public_html/includes/configure.php(26): tep_db_connect() #2 /home/sfftest1/public_html/includes/application_top.php(90): require('/home/sfftest1/...') #3 /home/sfftest1/public_html/index.php(25): require('/home/sfftest1/...') #4 {main} thrown in /home/sfftest1/public_html/includes/functions/database.php on line 25 Any idea what the problem could be? Thanks
  19. @pandrei Thank you. First I am asking the hosting company if there is anything stopping any files being unpacked or run - as during the installation process on the server, the "unpacking files" page went on forever and I had to stop it (after around 3 hours) and manually unzip the files - so I have a feeling that some files may be missing. Will update when they get back to me - I have wiped the server and left it in a ready to install condition for them to look at. Many Thanks
  20. Hi - I am now trying to work with this on an apache server running php 8 with a plesk control panel. But I am still having issues being unable to upload category images - the error log gives me the following: [error][yii\base\InvalidArgumentException] yii\base\InvalidArgumentException: common\models\CategoriesPlatformSettings has no relation named "imageMap". in /var/www/vhosts/mysite.co.uk/httpdocs/lib/vendor/yiisoft/yii2/db/BaseActiveRecord.php:1247 I have deleted OSC and reinstalled several times but still the same.
  21. @pandrei Thank You. Using xampp was too slow and clunky, so now I have switched to a server running php 8. Do the above changes only apply to xampp installations, or should they be applied regardless? as I am still having problems with category images on the live server.
  22. Ok - so I am playing with V4 on xampp, and have discovered an issue - when I add a new category and try to assign images to that category pressing the "save" button does not actually save the images to the category - in fact it does nothing. - I have a feeling that this is something to do with me running OSC on xampp. The error shown in the log is as follows: 2022-12-22 18:49:41 [127.0.0.1][-][oa4cntjlgne9a243317l955ga3][error][yii\base\ErrorException:2] yii\base\ErrorException: mkdir(): No such file or directory in C:\xampp\htdocs\catalog\lib\backend\design\Uploads.php:35 Stack trace: #0 C:\xampp\htdocs\catalog\lib\common\classes\TlErrorHandler.php(51): yii\base\ErrorHandler->handleError(2, 'mkdir(): No suc...', 'C:\\xampp\\htdocs...', 35) #1 [internal function]: common\classes\TlErrorHandler->handleError(2, 'mkdir(): No suc...', 'C:\\xampp\\htdocs...', 35) #2 C:\xampp\htdocs\catalog\lib\backend\design\Uploads.php(35): mkdir('C:/xampp/htdocs...', 511) #3 C:\xampp\htdocs\catalog\lib\backend\controllers\CategoriesController.php(5306): backend\design\Uploads::move('PC150111.JPG', 'images/categori...', true) #4 [internal function]: backend\controllers\CategoriesController->actionCategorySubmit() #5 C:\xampp\htdocs\catalog\lib\vendor\yiisoft\yii2\base\InlineAction.php(57): call_user_func_array(Array, Array) #6 C:\xampp\htdocs\catalog\lib\vendor\yiisoft\yii2\base\Controller.php(178): yii\base\InlineAction->runWithParams(Array) #7 C:\xampp\htdocs\catalog\lib\vendor\yiisoft\yii2\base\Module.php(552): yii\base\Controller->runAction('category-submit', Array) #8 C:\xampp\htdocs\catalog\lib\vendor\yiisoft\yii2\web\Application.php(103): yii\base\Module->runAction('categories/cate...', Array) #9 C:\xampp\htdocs\catalog\lib\vendor\yiisoft\yii2\base\Application.php(384): yii\web\Application->handleRequest(Object(yii\web\Request)) #10 C:\xampp\htdocs\catalog\lib\backend\web\index.php(29): yii\base\Application->run() #11 C:\xampp\htdocs\catalog\admin\index.php(15): require('C:\\xampp\\htdocs...') #12 {main} Any suggestions would be appreciated. Thanks
  23. Hi, I have been running a couple of OSC 2.3.4 stores for around 12 years and have been very happy with the system, but they are running on php 6.x which must have a limited lifespan now. So decided to have a look at the new revamped OSC 4 and have installed it locally on an xampp system The front end looks good - But what the hell! the admin side is so complex - like something from a software developers frenzied nightmare...... For example. previously I could add products on a single page - but now there are 11 tabbed pages for each product - I have no idea what some of the things are that I am being asked to enter. The same applies to adding a new category. I have no idea after a couple of days looking on how to add category menus or even if drop down or slide out category menus are possible. Maybe I'm missing something somewhere - but it all seems to be over complex and trying to include every possible field that a shop owner could want. Is there anywhere that I could gain enlightenment, as a simple shop owner, to work this system?
  24. Download and install Xampp from here: https://www.apachefriends.org/download.html The version I used was windows with php 8.1.12 It will install in the directory c:\xampp In c:\xampp\htdocs create the directory “catalog” Download the latest version of OSC4 from here: https://www.oscommerce.com/ Once downloaded unzip the files to c:\xampp\htdocs\catalog Start the xampp control panel and start Apache, MySql & Mercury In xampp control panel click on MySql admin tab – this will open xampp PhpMyAdmin where you need to create a new database and password. In your browser, navigate to localhost/catalog – This should start the installation process for OSC4 Initially the installation will fail due to a couple of services needed as follows: First PHP GD: See this link for the solution: https://www.geeksforgeeks.org/how-to-install-php-gd-in-xampp/ Second PHP Extension intl: See this limk for the solution: https://stackoverflow.com/questions/33869521/how-can-i-enable-php-extension-intl The installation may fail again when trying to install the database due to password issues – If so you may need to hard code your database password into the catalog/admin/includes/configure.php file at around line 52 The installation should now continue and complete (unless I forgot a step / adjustment somewhere….) Ok so now you can go to the browser and using localhost/catalog open your new website. BUT….. More changes are required to enable your access to your Admin / Backend as follows: Firstly from a post by @pandrei a change needed to: xampp/htdocs/catalog/admin/includes/local/configure.php and remove extra slash in these constants: define('DIR_WS_ADMIN', '//oscommerce/store/admin/'); define('DIR_WS_CATALOG', '//oscommerce/store'); Change to: define('DIR_WS_ADMIN', '/oscommerce/store/admin/'); define('DIR_WS_CATALOG', '/oscommerce/store'); You can now navigate to localhost/catalog/admin but the login will fail, as the Mercury email programme needs to be set up as follows: First make sure you have an email account and password set up (I created a gmail.com email account just for this purpose) Then you need to configure Mercury to send mails, there is lots of info out there, but this link is one of the most straightforward: https://www.geeksforgeeks.org/how-to-configure-xampp-to-send-mail-from-localhost-using-php/ Next you need to make a change via the xampp mercury control panel, just a case of unchecking a box, which this link explains: https://stackoverflow.com/questions/6809369/warning-mail-function-mail-smtp-server-response-553-we-do-not-relay-non-l You should now be able to login to your Admin / Backend – Simples! Disclaimer: As I did the install a few days ago I may have forgotten a step or change needed, so don’t blame me if it does not work or if you waste hours of time….. If it fails post here and I (or somebody who actually knows what they are doing) will try and help.
  25. That will not be a problem - But first I need to spend a couple of days making sure its working on xampp as it should as I think there may be some minor issues.
×
×
  • Create New...