[Skip to main content](#vessel-content) # Updating Product Inventory Levels? ## - **[blueagle1829](/forum/user/5850-blueagle1829 "View blueagle1829's Profile")** - [![blueagle1829's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/5850-blueagle1829 "View blueagle1829's Profile") Topic Author - [ Offline](/forum/user/5850-blueagle1829) Less More - Posts: 60 - Thank you received: 3 - - 12 years 2 months ago [\#167906](#167906) by [blueagle1829](/forum/user/5850-blueagle1829 "View blueagle1829's Profile") *[Updating Product Inventory Levels?](/forum/44-mass-actions/870443-updating-product-inventory-levels#167906 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.28 All, I'm hoping that someone can help me with automatically updating inventory levels inside HikaShop based off of sales in a brick and mortar location. My company uses "PawnMasters" software for sales inside the store. It tracks the inventory levels for each product, and it has the capability of exporting a list of the product_id and quantity to a CSV file as often as I'd like. My goal is to be able to use that file to import and update the product quantities inside HikaShop using a combination of "Mass actions", "cron" tasks, and/or the import tool while selecting the option to "Update the product quantity instead of replacing it." For instance, could I use the Mass actions function Trigger = Every hours Filters = Product columns product_quantity Action = Update values product_quantity where not null Does anyone have any experience with this that might could provide some help? Thoughts? Thanks in advance!")* was created by *[blueagle1829](/forum/user/5850-blueagle1829 "View blueagle1829's Profile")* -- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.28 All, I'm hoping that someone can help me with automatically updating inventory levels inside HikaShop based off of sales in a brick and mortar location. My company uses "PawnMasters" software for sales inside the store. It tracks the inventory levels for each product, and it has the capability of exporting a list of the product_id and quantity to a CSV file as often as I'd like. My goal is to be able to use that file to import and update the product quantities inside HikaShop using a combination of "Mass actions", "cron" tasks, and/or the import tool while selecting the option to "Update the product quantity instead of replacing it." For instance, could I use the Mass actions function Trigger = Every hours Filters = Product columns product_quantity Action = Update values product_quantity where not null Does anyone have any experience with this that might could provide some help? Thoughts? Thanks in advance! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzA0NDMtdXBkYXRpbmctcHJvZHVjdC1pbnZlbnRvcnktbGV2ZWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 12 years 2 months ago [\#167939](#167939) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Updating Product Inventory Levels?](/forum/44-mass-actions/870443-updating-product-inventory-levels#167939 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.28 All, I'm hoping that someone can help me with automatically updating inventory levels inside HikaShop based off of sales in a brick and mortar location. My company uses "PawnMasters" software for sales inside the store. It tracks the inventory levels for each product, and it has the capability of exporting a list of the product_id and quantity to a CSV file as often as I'd like. My goal is to be able to use that file to import and update the product quantities inside HikaShop using a combination of "Mass actions", "cron" tasks, and/or the import tool while selecting the option to "Update the product quantity instead of replacing it." For instance, could I use the Mass actions function Trigger = Every hours Filters = Product columns product_quantity Action = Update values product_quantity where not null Does anyone have any experience with this that might could provide some help? Thoughts? Thanks in advance!")* Hi, CSV import via the mass actions system is possible but it requires your CSV to be exactly with the format compatible with HikaShop. If your CSV isn't (for example, if it has different column names), you can use the products cron update plugin to import the CSV with column names translation. You can read more about it on our documentation: [ www.hikashop.com/support/support/documen...hop-import.html#cron](http://www.hikashop.com/support/support/documentation/73-hikashop-import.html#cron) The following user(s) said Thank You: [blueagle1829](/forum/user/5850-blueagle1829 "View blueagle1829's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzA0NDMtdXBkYXRpbmctcHJvZHVjdC1pbnZlbnRvcnktbGV2ZWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile")** - [![smithshop123's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17903-smithshop123 "View smithshop123's Profile") - [ Offline](/forum/user/17903-smithshop123) Less More - Posts: 212 - Thank you received: 17 - - 7 years 3 months ago [\#309213](#309213) by [smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile") Replied by *[smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile")* on topic *[Updating Product Inventory Levels?](/forum/44-mass-actions/870443-updating-product-inventory-levels#309213 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.28 All, I'm hoping that someone can help me with automatically updating inventory levels inside HikaShop based off of sales in a brick and mortar location. My company uses "PawnMasters" software for sales inside the store. It tracks the inventory levels for each product, and it has the capability of exporting a list of the product_id and quantity to a CSV file as often as I'd like. My goal is to be able to use that file to import and update the product quantities inside HikaShop using a combination of "Mass actions", "cron" tasks, and/or the import tool while selecting the option to "Update the product quantity instead of replacing it." For instance, could I use the Mass actions function Trigger = Every hours Filters = Product columns product_quantity Action = Update values product_quantity where not null Does anyone have any experience with this that might could provide some help? Thoughts? Thanks in advance!")* > nicolas wrote: Hi, > > CSV import via the mass actions system is possible but it requires your CSV to be exactly with the format compatible with HikaShop. > If your CSV isn't (for example, if it has different column names), you can use the products cron update plugin to import the CSV with column names translation. You can read more about it on our documentation: > [ www.hikashop.com/support/support/documen...hop-import.html#cron](http://www.hikashop.com/support/support/documentation/73-hikashop-import.html#cron) Hi, I want to do this as well but need to know the minimum amount of information required to update my stock numbers and leave all other data untouched. So, can I just upload a file with the product_code and the product_quantity information? Do I need to sort this in a specific order or will the upload work it out from the product_code? Thanks and I am happy to do it differently if there's a better way. Regards, Ian and Stu Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzA0NDMtdXBkYXRpbmctcHJvZHVjdC1pbnZlbnRvcnktbGV2ZWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 7 years 3 months ago [\#309220](#309220) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Updating Product Inventory Levels?](/forum/44-mass-actions/870443-updating-product-inventory-levels#309220 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.28 All, I'm hoping that someone can help me with automatically updating inventory levels inside HikaShop based off of sales in a brick and mortar location. My company uses "PawnMasters" software for sales inside the store. It tracks the inventory levels for each product, and it has the capability of exporting a list of the product_id and quantity to a CSV file as often as I'd like. My goal is to be able to use that file to import and update the product quantities inside HikaShop using a combination of "Mass actions", "cron" tasks, and/or the import tool while selecting the option to "Update the product quantity instead of replacing it." For instance, could I use the Mass actions function Trigger = Every hours Filters = Product columns product_quantity Action = Update values product_quantity where not null Does anyone have any experience with this that might could provide some help? Thoughts? Thanks in advance!")* Hi, Do you have variants in your products ? If you do, you need to specify the product_code, the product_parent_id (with the code of the parent) and one column per characteristic with the corresponding values. You would also need to place your main product rows before the variant rows in the CSV. If you don't have variants, the product_code column is the only requirement. I would recommend to also fill the "categories" column with the name of the category so that the products go in the correct category if it's new products. For products already there, that's not necessary. The following user(s) said Thank You: [smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzA0NDMtdXBkYXRpbmctcHJvZHVjdC1pbnZlbnRvcnktbGV2ZWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile")** - [![smithshop123's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17903-smithshop123 "View smithshop123's Profile") - [ Offline](/forum/user/17903-smithshop123) Less More - Posts: 212 - Thank you received: 17 - - 7 years 3 months ago [\#309254](#309254) by [smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile") Replied by *[smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile")* on topic *[Updating Product Inventory Levels?](/forum/44-mass-actions/870443-updating-product-inventory-levels#309254 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.28 All, I'm hoping that someone can help me with automatically updating inventory levels inside HikaShop based off of sales in a brick and mortar location. My company uses "PawnMasters" software for sales inside the store. It tracks the inventory levels for each product, and it has the capability of exporting a list of the product_id and quantity to a CSV file as often as I'd like. My goal is to be able to use that file to import and update the product quantities inside HikaShop using a combination of "Mass actions", "cron" tasks, and/or the import tool while selecting the option to "Update the product quantity instead of replacing it." For instance, could I use the Mass actions function Trigger = Every hours Filters = Product columns product_quantity Action = Update values product_quantity where not null Does anyone have any experience with this that might could provide some help? Thoughts? Thanks in advance!")* Thanks. No variants. So can I just have two columns product_code,product quantity 123456,2 etc,etc Or do I need to include the empty set of commas for the other fields on our site, ,,,,product_code,,,,product_quantity,,, ,,,,123456,,,,2,,, ,,,,etc,,,,etc,,, Thanks, Ian and Stu Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzA0NDMtdXBkYXRpbmctcHJvZHVjdC1pbnZlbnRvcnktbGV2ZWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 7 years 3 months ago [\#309257](#309257) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Updating Product Inventory Levels?](/forum/44-mass-actions/870443-updating-product-inventory-levels#309257 "-- HikaShop version -- : 2.3.2 -- Joomla version -- : 3.3.3 -- PHP version -- : 5.3.28 All, I'm hoping that someone can help me with automatically updating inventory levels inside HikaShop based off of sales in a brick and mortar location. My company uses "PawnMasters" software for sales inside the store. It tracks the inventory levels for each product, and it has the capability of exporting a list of the product_id and quantity to a CSV file as often as I'd like. My goal is to be able to use that file to import and update the product quantities inside HikaShop using a combination of "Mass actions", "cron" tasks, and/or the import tool while selecting the option to "Update the product quantity instead of replacing it." For instance, could I use the Mass actions function Trigger = Every hours Filters = Product columns product_quantity Action = Update values product_quantity where not null Does anyone have any experience with this that might could provide some help? Thoughts? Thanks in advance!")* Hi, Just two columns then. The following user(s) said Thank You: [smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy84NzA0NDMtdXBkYXRpbmctcHJvZHVjdC1pbnZlbnRvcnktbGV2ZWxzP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) 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.067 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)