Hello Roland,
I’m trying to import a file which contains the stock values to update in the product table.
I have read in the forum that I only need to import the 2 following fields :
- Product_sku
- Product_in_stock
So I have created my template in which I have defined 2 the 3 following template fields :
[table]
[tr]
[td]Template[/td]
[td]Field name[/td]
[td]Your field[/td]
[/tr]
[tr]
[td]Import Stocks - ws_lag [/td]
[td]product_sku[/td]
[td]N° article[/td]
[/tr]
[tr]
[td]Import Stocks - ws_lag [/td]
[td]product_in_stock[/td]
[td]Qté stock[/td]
[/tr]
[/table]
When I’m trying to import the data in order to update the stock level for the 2 products and I show the Import preview, I can see that the data which are imported for the product_in_stock field are the data which belongs to the “Pharmacode” field of my Import file :
[table]
[tr]
[td]product_sku[/td]
[td]product_in_stock[/td]
[/tr]
[tr]
[td]10192605[/td]
[td] 1379591 (should be 125)[/td]
[/tr]
[tr]
[td]10192644[/td]
[td] 1379645 (should be 250)[/td]
[/tr]
[/table]
I guess that the Import template should skip the “Pharmacode”, “EAN” and “Designation” fields of the Import file (please see Import file structure and date below).
I hardly tried to find an answer in the forum in order to manage to do it myself, but since I haven’t found a way, I would appreciate, if you could help me in this matter.
Thank you in advance
Cheers,
Marc
Hello Marc,
I have read in the forum that I only need to import the 2 following fields
Correct.
I guess that the Import template should skip the “Pharmacode”, “EAN” and “Designation” fields of the Import file (please see Import file structure and date below).
You must define all fields in your template. The fields you don't want to import you can choose the skip field for that. So the fields must have the same order as in your file.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
Thank you for your time and explaination. I have already read in one post that I could choose the skip field for that.
You mean that I need to define my five fields which are in the Import file as template fields ? And for the three one I don't want to import to choose the "skip field"? If yes, where can I choose the skip field, in which field of the Edit template field ?
Thanks in advance for your reply, because I'm trying since over 4 hours without success.
Cheers,
Marc
Hello Marc,
You mean that I need to define my five fields which are in the Import file as template fields ?
Correct.
And for the three one I don't want to import to choose the "skip field"?
Correct.
If yes, where can I choose the skip field, in which field of the Edit template field ?
Choosing the skip field is the same as choosing the product_sku field. You can add it by either clicking New or Quick Add. Don't you see the skip field there?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks Roland but I don't see the skip field in the Quick Add list, if I understand correctely ;-)
Hey Marc,
What have you chosen under Operations in the template?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hey,
Should I choose Component : Virtuemart and Operation : Product ? I guess it is !
Correct :)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hey Roland,
Yes it is ! It works I could update my stocks. I'm starting to understand the logic of your marvelous extension.
Thanks,
Marc
Log in to reply to this topic.