- Posts: 1184
- Thank you received: 13
Import csv update quantity
2 years 7 months ago #359194
by verzevoul
Import csv update quantity was created by verzevoul
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.
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!
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.
Code:
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.
2 years 7 months ago #359195
by nicolas
Replied by nicolas on topic Import csv update quantity
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.
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.
2 years 7 months ago - 2 years 7 months ago #359206
by verzevoul
Replied by verzevoul on topic Import csv update quantity
Nikolas
00-00-0013;78.000
is 78 items
will it be imported like this ?
00-00-0013;78.000
is 78 items
will it be imported like this ?
Last edit: 2 years 7 months ago by verzevoul.
Please Log in or Create an account to join the conversation.
2 years 7 months ago #359218
by verzevoul
Replied by verzevoul on topic Import csv update quantity
Hello again.
My csv file is in home directory not in the public_html
Can you give me the syntax to add my path?
Thanks
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
Please Log in or Create an account to join the conversation.
2 years 7 months ago #359222
by nicolas
Replied by nicolas on topic Import csv update quantity
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.
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.
2 years 7 months ago #359233
by verzevoul
Replied by verzevoul on topic Import csv update quantity
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?
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?
Please Log in or Create an account to join the conversation.
2 years 7 months ago #359243
by nicolas
Replied by nicolas on topic Import csv update quantity
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.
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.
2 years 7 months ago #359245
by verzevoul
Replied by verzevoul on topic Import csv update quantity
Ι don t want to add products. Only update quanity.
Products are ready in the db
Products are ready in the db
Please Log in or Create an account to join the conversation.
2 years 7 months ago #359246
by verzevoul
Replied by verzevoul on topic Import csv update quantity
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
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
Please Log in or Create an account to join the conversation.
2 years 7 months ago #359249
by nicolas
Replied by nicolas on topic Import csv update quantity
Hi,
As I said, I tried both importing new products AND updating them. And both worked. So what I said still stands.
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.243 seconds