- Posts: 29
- Thank you received: 0
CSV Import / multi currency
11 years 7 months ago #190651
by Pajerchin
CSV Import / multi currency was created 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?
-- 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.
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 |
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.
11 years 7 months ago #190777
by Pajerchin
Replied by Pajerchin on topic CSV Import / multi currency
Great! :woohoo:
Thanks a lot.
Thanks a lot.
Please Log in or Create an account to join the conversation.
Time to create page: 0.188 seconds