[Skip to main content](#vessel-content) # auto-import csv file every 10 minutes ## - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 5 months ago [\#107033](#107033) by [jesper](/forum/user/8151-jesper "View jesper's Profile") Replied by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* on topic *[Re: auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#107033 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* i have changed the case.. itemId:product_code;Item:product_name;ItemWebDescription:product_description;StockActual:product_quantity;Price:price_value;CreateDateTime:product_created; but it still gives the error Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 13 years 5 months ago [\#107054](#107054) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Re: auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#107054 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* Hi, These columns don't exist, you have to use the columns used by HikaShop else it won't work. You can export your current products to a csv file to see how it's formatted, and see which columns are authorized. Here is some documentation about csv import: [ www.hikashop.com/fr/support/documentatio...shop-import.html#csv](http://www.hikashop.com/fr/support/documentation/73-hikashop-import.html#csv) The following user(s) said Thank You: [jesper](/forum/user/8151-jesper "View jesper's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 5 months ago [\#107056](#107056) by [jesper](/forum/user/8151-jesper "View jesper's Profile") Replied by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* on topic *[auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#107056 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* So i have misunderstood the purpose of the field column names ? I though it was some sort of translation line from one name to hikashop names for the columns If that is not the purpose on the Hikashop Products Cron Update Plugin then what is its purpose ? But that is properly not possible from the provider... i have to write a conversion part into the script then... - [ ![screen.png](/forum/attachment/10379) ](/forum/attachment/10379 "screen.png") [ ](/forum/attachment/10379?download=1 "screen.png") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 13 years 5 months ago [\#107079](#107079) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#107079 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* Xavier was talking about the import interface. The cron plugin goal is indeed to update the products data with CSV automatically and the column names field allows you to associate the columns of the CSV with the columns in hikashop. I checked the code and actually the column names field should only contain lower case names. Please put everything in lower case in there and that should be better. The following user(s) said Thank You: [jesper](/forum/user/8151-jesper "View jesper's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jesper](/forum/user/8151-jesper "View jesper's Profile")** - [![jesper's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/dog.png)](/forum/user/8151-jesper "View jesper's Profile") - [ Offline](/forum/user/8151-jesper) Less More - Posts: 171 - Thank you received: 4 - - 13 years 5 months ago [\#107081](#107081) by [jesper](/forum/user/8151-jesper "View jesper's Profile") Replied by *[jesper](/forum/user/8151-jesper "View jesper's Profile")* on topic *[auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#107081 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* ah thanx.. that was the problem...i though i should write them as in the file.. now it seems to work ![:)](/media/kunena/emoticons/3.png ":)") it would be good if you could make this plugin be able to get wildcards as filenames like "uploadfolder/*.cvs" or just "uploadfolder/*" and it would parse all files in that folder mathing the wildcards defined. but thats not needed right now for me ![;)](/media/kunena/emoticons/24.png ";)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") - [ Offline](/forum/user/8351-verzevoul) Less More - Posts: 1195 - Thank you received: 13 - - 12 years 9 months ago [\#143321](#143321) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#143321 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* Hello Nikolas! I m trying to do the same here but I m not sure if I understood well. 1. Using the Hikashop Products Cron Update Plugin, is all I need to do the job, or do I have to create a cron task in the configuration too? I m asking because I saw the field frequency. 2. Is it ok to put my file on the public_html of my website with these info in my plugin? [ ![h72bb1d2.jpg](/forum/attachment/15205) ](/forum/attachment/15205 "h72bb1d2.jpg") 3. when I have 10 in frequency it means 10sec. Am I right? - [ ![h72bb1d2.jpg](/forum/attachment/15205) ](/forum/attachment/15205 "h72bb1d2.jpg") [ ](/forum/attachment/15205?download=1 "h72bb1d2.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")** - [![verzevoul's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/8351-verzevoul "View verzevoul's Profile") - [ Offline](/forum/user/8351-verzevoul) Less More - Posts: 1195 - Thank you received: 13 - - 12 years 9 months ago [\#143332](#143332) by [verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile") Replied by *[verzevoul](/forum/user/8351-verzevoul "View verzevoul's Profile")* on topic *[auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#143332 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* Ok. I answered in all question by doing some more testing so 1. Using the Hikashop Products Cron Update Plugin, is all I need to do the job, or do I have to create a cron task in the configuration too? Its no. I need to use the cron in the configuration too, to trigger the url. So why does the Frequency field is needed, since we use the cron task to do the job? 2. Is it ok to put my file on the public_html of my website with these info in my plugin? Its yes 3. when I have 10 in frequency it means 10sec. Am I right? I dont know since I use the cron to trigger the url. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 12 years 9 months ago [\#143516](#143516) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#143516 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* Glad to see you solved this and thanks for sharing your answers! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[river](/forum/user/9591-river "View river's Profile")** - [![river's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9591.gif)](/forum/user/9591-river "View river's Profile") - [ Offline](/forum/user/9591-river) Less More - Posts: 344 - Thank you received: 3 - - 10 years 11 months ago [\#222641](#222641) by [river](/forum/user/9591-river "View river's Profile") Replied by *[river](/forum/user/9591-river "View river's Profile")* on topic *[auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#222641 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* Does the plugin used in this thread work with joomla 3.4.5 and Hikashop 2.6 ? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) 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?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86541 - Thank you received: 14304 - - 10 years 11 months ago [\#222650](#222650) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[auto-import csv file every 10 minutes](/forum/4-how-to/6817-auto-import-csv-file-every-10-minutes?start=40#222650 "Can anyone suggest how to auto import a csv file every ten minutes using a cron job or any other way?")* Hi, Yes, the plugin is included in HikaShop 2.6 and works fine. You just have to configure your cron in the HikaShop configuration and then the HikaShop product update cron plugin via the Joomla plugins manager. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzY4MTctYXV0by1pbXBvcnQtY3N2LWZpbGUtZXZlcnktMTAtbWludXRlcz9zdGFydD00MCZ0bXBsPW1hcmtkb3du) 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.101 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)