Updating Product Inventory Levels?

-- 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

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

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