Importing CSV to update quantities results in zero stock amounts

  • Posts: 59
  • Thank you received: 2
4 years 3 months ago #322282

-- url of the page with the problem -- : avonrivercomputers.com.au/mantest
-- HikaShop version -- : 4.3.0
-- Joomla version -- : 3.9.20
-- PHP version -- : 7.3
-- Browser(s) name and version -- : Vivaldi 2.8
-- Error-message(debug-mod must be tuned on) -- : No error message

Trying to get the mass action working to update stock quantities from a CSV file. I select the CSV file with the quantity updates and select to upload and I have verified and it gives me a valid file. All good so far. I have selected Save the products on Mass Action CSV import checkbox is ticked. I have set the limitations to 5000, well above the actual number of products. I have set the actions to Display the results and ticked Product code, product name and product quantity and if I process this, it displays the product code, name and quantity exactly as I want. When I select the And update the values, product quantity=int is where it all falls apart. The values get updated to zero and even if the values do not change, ie they are the same value in Hikashop as the CSV, Hikashop get updated to 0. I have read the docs, tutorial and also tried searching the forums and I believe that what I am doing is correct so the crux of my question is that how can it be that when I display, the result it is correct but when I try to update with the same result, it gives me a zero where the quantity has a number. Any pointers would be greatly appreciated, thanks.

Please Log in or Create an account to join the conversation.

  • Posts: 82683
  • Thank you received: 13337
  • MODERATOR
4 years 3 months ago #322306

Hi,

You say "And update the values, product quantity=int is where it all falls apart".
So it would mean that you have an action "update the values" on the "product_quantity" column.
This is not necessary.
No action in the mass action is necessary to update the product data with the data from the CSV. It will be updated automatically.
I suppose that you have a wrong value in the action "update the values" and thus it uses 0 and updates the quantity to 0 because of that action.
Remove the action, and only keep the filter of the CSV file and process the mass action and it should directly update the quantity.

Please Log in or Create an account to join the conversation.

Time to create page: 0.057 seconds
Powered by Kunena Forum