Categories
View Replies (8)

Resolved [SOLVED] Import Stocks and skip Import file fields

  1. webcouleur
    webcouleur
  2. RO CSVI
  3. Thursday, 20 August 2015
  4.  Subscribe via email
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 :

1. Product_sku
2. 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
0
Responses (8)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
webcouleur
webcouleur
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
webcouleur
webcouleur
Accepted Answer Pending Moderation
Thanks Roland but I don't see the skip field in the Quick Add list, if I understand correctely ;-)
  1. more than a month ago
  2. RO CSVI
  3. # 4
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
webcouleur
webcouleur
Accepted Answer Pending Moderation
Hey,
Should I choose Component : Virtuemart and Operation : Product ? I guess it is !
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Correct :)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
webcouleur
webcouleur
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 8
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!