Update quatity via CVS file

  • Posts: 198
  • Thank you received: 7
3 years 5 months ago #333048

-- HikaShop version -- : 4.4.0
-- Joomla version -- : 3.9.29
-- PHP version -- : 7.4.16
-- Browser(s) name and version -- : Chrome 91.0.4472.77

Hi is it possible to update only the quantity for a product?

The SKU code for the export file is leading.

Can you give me some pointers to get this done?

(

File Attachment:

File Name: Exampleimp...et01.csv
File Size:1 KB


Kind regards René

Attachments:

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
3 years 5 months ago #333056

Hi,

You should first open the CSV file with Excel or LibreOffice Calc and remove the columns you don't need to keep only the SKU and the quantity columns. Then, change the title of these columns to product_code and product_quantity.
Then, go in the menu System>Mass actions of HikaShop and click on the "new" button.
There, select the "product" data, and add a filter "CSV products". In it, upload the CSV file and check the "Save the products on Mass Action csv import." checkbox.
Once done, click on the "process" button at the top and it will run the import and update the quantity of the products in the CSV file.

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

  • Posts: 198
  • Thank you received: 7
3 years 5 months ago #333084

Thanks for explaining Nicolas.

Have a great day.

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

Time to create page: 0.058 seconds
Powered by Kunena Forum