[Skip to main content](#vessel-content) # Mass Action - update product from CSV ## - **[Melekaiah](/forum/user/33165-melekaiah "View Melekaiah's Profile")** - [![Melekaiah's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/33165-melekaiah "View Melekaiah's Profile") Topic Author - [ Offline](/forum/user/33165-melekaiah) Less More - Posts: 2 - Thank you received: 0 - - 11 years 11 months ago [\#181297](#181297) by [Melekaiah](/forum/user/33165-melekaiah "View Melekaiah's Profile") *[Mass Action - update product from CSV](/forum/44-mass-actions/873271-mass-action-update-product-from-csv#181297 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : None Im trying to set up an automated import of product updated information: but im a little confused of how to do it. I set up a mass action to export only the necessary columns to a products.csv file. Which worked great. What i have done now is set up a new mass action with filter csv. and have the correct location of file. DO i need to manually set up an "change value" action for each field i want updated? For each field i want updated. do i leave the box for the value blank? and let the filter do that? or do i set operation? for example. I want to set all prices to NULL, not 0. but price_value only allows an INT type rather than a string type. and i cant leave the fielt for int blank. Is there possibilty to add an action that just takes all the values from the file and overwrites the values in the database? Thanks.")* was created by *[Melekaiah](/forum/user/33165-melekaiah "View Melekaiah's Profile")* -- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : None Im trying to set up an automated import of product updated information: but im a little confused of how to do it. I set up a mass action to export only the necessary columns to a products.csv file. Which worked great. What i have done now is set up a new mass action with filter csv. and have the correct location of file. DO i need to manually set up an "change value" action for each field i want updated? For each field i want updated. do i leave the box for the value blank? and let the filter do that? or do i set operation? for example. I want to set all prices to NULL, not 0. but price_value only allows an INT type rather than a string type. and i cant leave the fielt for int blank. Is there possibilty to add an action that just takes all the values from the file and overwrites the values in the database? Thanks. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzMyNzEtbWFzcy1hY3Rpb24tdXBkYXRlLXByb2R1Y3QtZnJvbS1jc3Y/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[korzo](/forum/user/34428-korzo "View korzo's Profile")** - [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile") - [ Offline](/forum/user/34428-korzo) Less More - Posts: 193 - Thank you received: 76 - - 11 years 11 months ago [\#181307](#181307) by [korzo](/forum/user/34428-korzo "View korzo's Profile") Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Mass Action - update product from CSV](/forum/44-mass-actions/873271-mass-action-update-product-from-csv#181307 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : None Im trying to set up an automated import of product updated information: but im a little confused of how to do it. I set up a mass action to export only the necessary columns to a products.csv file. Which worked great. What i have done now is set up a new mass action with filter csv. and have the correct location of file. DO i need to manually set up an "change value" action for each field i want updated? For each field i want updated. do i leave the box for the value blank? and let the filter do that? or do i set operation? for example. I want to set all prices to NULL, not 0. but price_value only allows an INT type rather than a string type. and i cant leave the fielt for int blank. Is there possibilty to add an action that just takes all the values from the file and overwrites the values in the database? Thanks.")* Yes. On the screenshot is my mass action to import products from csv every hour. CSV file is uploaded by ERP and there are only 3 columns: product_code, product_quantity, product_price. Mass action is triggered by cron. - [ ![Mass_actions.jpg](/forum/attachment/20919) ](/forum/attachment/20919 "Mass_actions.jpg") [ ](/forum/attachment/20919?download=1 "Mass_actions.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzMyNzEtbWFzcy1hY3Rpb24tdXBkYXRlLXByb2R1Y3QtZnJvbS1jc3Y/dG1wbD1tYXJrZG93bg==) 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) - 11 years 11 months ago [\#181322](#181322) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Mass Action - update product from CSV](/forum/44-mass-actions/873271-mass-action-update-product-from-csv#181322 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.6 -- Browser(s) name and version -- : Chrome -- Error-message(debug-mod must be tuned on) -- : None Im trying to set up an automated import of product updated information: but im a little confused of how to do it. I set up a mass action to export only the necessary columns to a products.csv file. Which worked great. What i have done now is set up a new mass action with filter csv. and have the correct location of file. DO i need to manually set up an "change value" action for each field i want updated? For each field i want updated. do i leave the box for the value blank? and let the filter do that? or do i set operation? for example. I want to set all prices to NULL, not 0. but price_value only allows an INT type rather than a string type. and i cant leave the fielt for int blank. Is there possibilty to add an action that just takes all the values from the file and overwrites the values in the database? Thanks.")* Hi, You have the choice, you can set the desired values in the csv file directly, so these values will be used to update the product data. Or remove the fields and add a "update value" action. Regarding the prices, you can't set them to NULL the database column is set to have Decimal content, so it's not possible to set NULL value. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzMyNzEtbWFzcy1hY3Rpb24tdXBkYXRlLXByb2R1Y3QtZnJvbS1jc3Y/dG1wbD1tYXJrZG93bg==) 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.239 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)