CSV Import / multi currency

  • Posts: 29
  • Thank you received: 0
  • Hikaserial Subscription Hikashop Business
9 years 9 months ago #190651

-- 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.

  • Posts: 193
  • Thank you received: 76
9 years 9 months ago #190679

Ahoj,

you need to put both values in the same column and separate them with |

"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.

  • Posts: 29
  • Thank you received: 0
  • Hikaserial Subscription Hikashop Business
9 years 9 months ago #190777

Great! :woohoo:

Thanks a lot.

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

Time to create page: 0.043 seconds
Powered by Kunena Forum