Mass Action - update product from CSV

  • Posts: 2
  • Thank you received: 0
10 years 1 month ago #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.

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

  • Posts: 193
  • Thank you received: 76
10 years 1 month ago #181307

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.

Attachments:

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

  • Posts: 13201
  • Thank you received: 2322
10 years 4 weeks ago #181322

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 or Create an account to join the conversation.

Time to create page: 0.078 seconds
Powered by Kunena Forum