Import csv update quantity

  • Posts: 1055
  • Thank you received: 11
  • Hikashop Business
9 months 2 days ago #359194

Hello!
I have a task to update the quantity field every XX hours.
I think I did it in the past with csv in a location that hikashop imported somehow and updated the quantities
My csv is like.

product_code;product_quantity;
00-00-0013;78.000
00-00-0014;162.000
00-00-0015;86.000
00-00-0020;269.823
00-00-0030;178.000
00-00-0032;142.000

1. is it ok to have 78.000 as quantity? Will hikashop understand that the number is 78?
2. Can you pls remind me the steps because I didn t finf anything in the forum?

Thanks!

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

  • Posts: 82863
  • Thank you received: 13370
  • MODERATOR
9 months 2 days ago #359195

Hi,

1. Yes, that should not be a problem.

2. You want to create a mass action in the menu System>Mass actions.
In it, you want a filter "CSV products" with your file added and the checkbox "Save the products on Mass Action csv import." checked.
Then, click on the "process" button and it should do it.

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

  • Posts: 1055
  • Thank you received: 11
  • Hikashop Business
9 months 2 days ago #359206

Nikolas
00-00-0013;78.000
is 78 items

will it be imported like this ?

Last edit: 9 months 2 days ago by verzevoul.

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

  • Posts: 1055
  • Thank you received: 11
  • Hikashop Business
9 months 2 days ago #359218

Hello again.
My csv file is in home directory not in the public_html

This message contains confidential information

Can you give me the syntax to add my path?

Thanks

Attachments:

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

  • Posts: 82863
  • Thank you received: 13370
  • MODERATOR
9 months 1 day ago #359222

Hi,

You're missing the / before the "home" at the beginning of your full path.
However, Joomla might not allow you to provide a path outside the Joomla root folder.

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

  • Posts: 1055
  • Thank you received: 11
  • Hikashop Business
9 months 1 day ago #359233

You right I added the / and I got
Message
Successfully Saved
Products imported.
But quantity are not changed
This is the file I imported if you can check please.
Can I see a log somehow to understand why it didn t really worked?

Attachments:

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

  • Posts: 82863
  • Thank you received: 13370
  • MODERATOR
9 months 1 day ago #359243

Hi,

The products were added on my local website when importing the file that way.
And after this, when I changed the stock of some of the products in that CSV and run the mass action again, the stock was updated.
So to me, it looks like it's working as it should:
i.imgur.com/2JmOyBu.png

You can't see a log. If there is a problem, it should appear directly on the screen as an error message.

Now, if you have a plugin or another mass action which somehow reverts the change during the update, it's possible that nothing happens while not outputting any error, since it's functioning as expected.

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

  • Posts: 1055
  • Thank you received: 11
  • Hikashop Business
9 months 1 day ago #359245

Ι don t want to add products. Only update quanity.
Products are ready in the db

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

  • Posts: 1055
  • Thank you received: 11
  • Hikashop Business
9 months 1 day ago #359246

My file has
product_code;product_quantity;
99-00-0519;4
99-00-0520;4
99-00-0521;88
99-00-0522;6

And you can see the attachment before and after running the action

Attachments:

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

  • Posts: 82863
  • Thank you received: 13370
  • MODERATOR
9 months 1 day ago #359249

Hi,

As I said, I tried both importing new products AND updating them. And both worked. So what I said still stands.

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

Time to create page: 0.074 seconds
Powered by Kunena Forum