Skip to main content

CSV Import / multi currency

More
11 years 7 months ago #190651 by Pajerchin
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.3.17

I Have two currency:
- EURO (default currency)
- CZK (second currency)

For product I define separate prices for EURO & CZK,
Example for Product 1:
EUR: 2.5
CZK: 10

Is there any way to import from CSV file both prices to the product?

This syntax imports only last currency (with err msg of course):
product_code,price_value,price_currency_id,price_value,price_currency_id
001,2.5,EUR,10,CZK

...so It seems it is impossible

But - If the product with both EUR & CZK & with separate defined EUR & CZK prices has been already created,
the solution could be correctly update at least one currency.
Unfortunatelly - after import:
product_code,product_name,price_value
001,Bread,2.5,EUR

- the CZK currency from the product is deleted! ...what is very bad for me

Any advices, please?

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

More
11 years 7 months ago #190679 by korzo
Replied by korzo on topic CSV Import / multi currency
Ahoj,

you need to put both values in the same column and separate them with |
Code:
"product_name","price_value","price_currency_id" "Bread","1.20|10","EUR|CZK" "Coffee","2|10","USD|CZK"

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

More
11 years 7 months ago #190777 by Pajerchin
Great! :woohoo:

Thanks a lot.

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

Time to create page: 0.188 seconds
Powered by Kunena Forum