[Skip to main content](#vessel-content) # HikaShop Cron ## - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 11 months ago [\#336736](#336736) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336736 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* was created by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* -- url of the page with the problem -- : [ brachfeld.de](https://brachfeld.de) -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file [ brachfeld.de/Kiran/hika\_gesamt.csv](https://brachfeld.de/Kiran/hika_gesamt.csv) We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file [ brachfeld.de/Kiran/hika\_gesamt.csv](https://brachfeld.de/Kiran/hika_gesamt.csv) In plugin is adress: Kiran/hika_gesamt.csv Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 11 months ago [\#336743](#336743) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336743 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, This seems to indicate that it can't validate the new certificate for some reason (for example, the openssl PHP module is not enabled in the php.ini : [ faq.miniorange.com/knowledgebase/enable-php-openssl-extension/](https://faq.miniorange.com/knowledgebase/enable-php-openssl-extension/) ). Modifying the code of the plugin might help to circumvent this as per [ www.codegrepper.com/code-examples/php/ph...ts+disable+ssl+check](https://www.codegrepper.com/code-examples/php/php+file_get_contents+disable+ssl+check) You can try changing the line: Code: $contentFile = file_get_contents($path); to: Code: $arrContextOptions=array( "ssl"=>array( "verify_peer"=>false, "verify_peer_name"=>false, ), ); $contentFile = file_get_contents($path, false, $arrContextOptions); in the file plugins/hikashop/datafeed/datafeed.php PS: please do not post your message both by email and in the forum. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 11 months ago [\#336781](#336781) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336781 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Thanks Nicolas. But it doesn't help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 11 months ago [\#336803](#336803) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336803 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, Then replace the code: Code: $path = JURI::base() . $path; $path = str_replace('administrator', '', $path); by: Code: $path = JPATH_ROOT.DS.$path; That will force the plugin to read the file from the hard drive of the server instead of going through apache and thus it won't have to mess with the SSL certificate. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 11 months ago [\#336900](#336900) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336900 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* It doesn't help. I don't think, it is ssl problem. If I try in cron in "Create/edit your Cron task" to activate cron I get the message "hikashop connection denied". Rgds Robert - [ ![hikashop.png](/forum/attachment/53834) ](/forum/attachment/53834 "hikashop.png") [ ](/forum/attachment/53834?download=1 "hikashop.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 11 months ago [\#336905](#336905) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336905 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, That should not matter. The error "Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv" indicates that the cron is running, but just that the CSV file cannot be loaded by the plugin trying to import it. The last code modification I gave completely bypass apache and SSL needs. So I don't see how you could have the exact same error message. Could you please double check ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 11 months ago [\#336927](#336927) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336927 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Now I get this emal: HikaShop Cron ausgelöst am 2021-11-09 23:52 Could not find the file /var/www/vhosts/brachfeld.de/httpdocs/Kiran/hika_gesamt.csv Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 11 months ago [\#336933](#336933) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336933 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, As expected, it's not the same error. So it says it can't find the file. Can you confirm via FTP that the file is there ? It probably isn't. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 11 months ago [\#336965](#336965) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336965 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* [ brachfeld.de/de/Kiran/hika\_gesamt.csv](https://brachfeld.de/de/Kiran/hika_gesamt.csv) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 11 months ago [\#336968](#336968) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#336968 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, Can you provide a screenshot of your FTP client when you're looking at the folder where that file is located ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 11 months ago [\#337009](#337009) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337009 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* It doesn't send this Email any more. But the plugin doesn't update the products. The file exist in: brachfeld.de/Kiran/hika_gesamt.csv - [ ![hikashop-plugin.png](/forum/attachment/53864) ](/forum/attachment/53864 "...hop-plugin.png") [ ](/forum/attachment/53864?download=1 "...hop-plugin.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 11 months ago [\#337013](#337013) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337013 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, I don't see why it wouldn't work. Could you please provide a backend access and a FTP access via our contact form along with a link to this thread so that we can directly check at the situation ? [ www.hikashop.com/support/contact-us.html](https://www.hikashop.com/support/contact-us.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 11 months ago [\#337079](#337079) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337079 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, many thanks for your support, it was something wrong with CSV-file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 11 months ago [\#337190](#337190) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337190 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* By the way I found in the database in table hikashop_product 61.755 products, which is correct. But in hikashop_price 9.388.208, which is to much. Can I delete all and upload the new products as csv? Mass actions or delete in sql? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 11 months ago [\#337207](#337207) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337207 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, I would recommend to run that MySQL query in your PHPMyAdmin: Code: DELETE FROM #__hikashop_price WHERE price_product_id NOT IN (SELECT product_id FROM #__hikashop_product); (you need to replace #__ by your table prefix) That will delete all the price entries not linked to one of your products. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 10 months ago [\#337454](#337454) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337454 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Thanks Nicolas. Is't possible to run this code automaticaly every day or week? We have Linux on our server. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 10 months ago [\#337475](#337475) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337475 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, It's possible by setting up your crontab properly. Here is a tutorial on this: [ dsharpdotnet.wordpress.com/2013/07/04/ho...dical-mysql-queries/](https://dsharpdotnet.wordpress.com/2013/07/04/how-to-use-cronjob-to-execute-periodical-mysql-queries/) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 10 months ago [\#337681](#337681) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337681 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* New problem: If I upload the csv file it doesnt impot the prices. What is the problem? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86283 - Thank you received: 14263 - - 4 years 10 months ago [\#337698](#337698) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337698 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* Hi, First run the CSV via the normal import system in Products>Import. Once it works there, you can automate it with the plugin. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")** - [![info@brachfeld.de's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Topic Author - [ Offline](/forum/user/49006-info-brachfeld-de) Less More - Posts: 25 - Thank you received: 0 - - 4 years 10 months ago [\#337712](#337712) by [info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile") Replied by *[info@brachfeld.de](/forum/user/49006-info-brachfeld-de "View info@brachfeld.de's Profile")* on topic *[HikaShop Cron](/forum/37-import-export-csv-xls/903405-hikashop-cron#337712 "-- url of the page with the problem -- : brachfeld.de -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : HikaShop Cron ausgelöst am 2021-11-03 15:17 Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv We use Hikashop Products Cron Update Plugin. Yesteraday we upload new SSl Certificates and now we get this error: Could not retrieve the CSV file brachfeld.de/Kiran/hika_gesamt.csv In plugin is adress: Kiran/hika_gesamt.csv")* I did normal import, but still without prices. I attached the csv fille. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy85MDM0MDUtaGlrYXNob3AtY3Jvbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.651 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)