Categories
View Replies (3)

Resolved Import prices from GTIN (EAN,ISBN)

  1. matteobodi
    matteobodi
  2. RO CSVI
  3. Wednesday, 11 March 2015
  4.  Subscribe via email
Hello,

I know the question sounds strange, but let me explain my problem.
My virtuemart should import the prices from a software that works with a main article ( ex: 0020) with colors (lex: 01 black; 02 Navy) and sizes ( ex. L and XL).
The software export a price ONLY for the article 0020, no price for variations.

In virtuemart there is no handling of variation, so I've created as many articles as the variations are:
0020|01|L
0020|01|XL
0020|02|L
0020|02|XL

and so on.

Now I should import prices, and the softare gives me different prices for different clients. ( 0020 for client X is 10 EUR, 0020 for client Z is 12 EUR).

Now the question:

I would like to set a EAN ( or custom field) number that is the same for every similar product, so all the variations:
0020|01|L
0020|01|XL
0020|02|L
0020|02|XL
have the EAN 0020.

And from that fiend import the prices...

wow... I hope that was clear, or do you have another solution?

Thanks
Matteo
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Matteo,

I would like to set a EAN ( or custom field) ... And from that fiend import the prices...
You can use the EAN code for updating but it needs to be unique of course. If it is not unique, CSVI will only update the first one it finds and this doesn't have to be the same record because it depends on what the database returns. As you already mentioned, the EAN code would not be unique, so this is not going to work.

Have you looked at the Generic Child Variant? This takes the price from the parent product and you can still have separate products for each variant. Thus by updating the parent only, you would update the children as well. Perhaps that is a solution. You can try this out by manually creating 1 such product and see if it suits your needs.
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
matteobodi
matteobodi
Accepted Answer Pending Moderation
Yes, it's actually my problem, it updates only the first record it founds.

But my system it's quite complicate, I cannot work with Generic child variant.

It would be possible in some way to say to CSVI to update the price of every field it founds with the same MPN number?
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
It would be possible in some way to say to CSVI to update the price of every field it founds with the same MPN number?
Only if you code it.

CSVI works based on a unique identifier to update a product, as every product is unique so should be it's identifier.

Perhaps the new Multi Variant in VirtueMart is something for you?
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
  • Page :
  • 1


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