- Posts: 56
- Thank you received: 0
CSV upload for translations: Which columns?
14 years 2 weeks ago #72528
by dforrest
HikaShop Business 2.3.2 on Joomla 1.5.26 + JoomFish 2.1.6 - Multilingual site
CSV upload for translations: Which columns? was created by dforrest
I've seen that uploading a CSV file of a whole shop together with two language translations can be problematic. So I am planning on uploading translations one language at a time. This will be helpful as I will have more language translations of this site in the future.
My question is, what columns should I upload in a translation file?
For instance, would this work: product_name, product_name|en-GB, product_description, product_description|en_GB, product_page_title, product_page_title|en-GB, categories, categories|en-GB ?
Would I need to include columns like product_ID, product_parent_ID, product_code so that these texts get attached to the right product, category or variant in the database?
I'm never quite certain which columns I need to include in an upload and which (if any) I can leave out safely. Most of my partial uploads (only a few columns or products) have caused me as many problems as they've solved.
Thanks for any wise advice.
My question is, what columns should I upload in a translation file?
For instance, would this work: product_name, product_name|en-GB, product_description, product_description|en_GB, product_page_title, product_page_title|en-GB, categories, categories|en-GB ?
Would I need to include columns like product_ID, product_parent_ID, product_code so that these texts get attached to the right product, category or variant in the database?
I'm never quite certain which columns I need to include in an upload and which (if any) I can leave out safely. Most of my partial uploads (only a few columns or products) have caused me as many problems as they've solved.
Thanks for any wise advice.
HikaShop Business 2.3.2 on Joomla 1.5.26 + JoomFish 2.1.6 - Multilingual site
Please Log in or Create an account to join the conversation.
14 years 2 weeks ago #72815
by nicolas
Replied by nicolas on topic Re: CSV upload for translations: Which columns?
You can't translate categories via CSV imports.
Only products information is supported.
So "categories, categories|en-GB" won't be possible.
Otherwise, for the other columns, that's exactly that.
You can simply specify the product_code for each product.
Only products information is supported.
So "categories, categories|en-GB" won't be possible.
Otherwise, for the other columns, that's exactly that.
You can simply specify the product_code for each product.
The following user(s) said Thank You: dforrest
Please Log in or Create an account to join the conversation.
14 years 2 weeks ago #72855
by dforrest
HikaShop Business 2.3.2 on Joomla 1.5.26 + JoomFish 2.1.6 - Multilingual site
Replied by dforrest on topic Re: CSV upload for translations: Which columns?
OK, this is good to know.
So for all CSV imports, I will leave out the rows of the CSV export file for what I call the "mother row" that only has the text "product category" and the row for each category.
I will include only the rows for the products and variants.
These will be in the format:
product_code; [productorvariant_info]; productorvariant_info]|xx-XX
(xx-XX = language code)
Thanks, this clarifies things a lot.
So for all CSV imports, I will leave out the rows of the CSV export file for what I call the "mother row" that only has the text "product category" and the row for each category.
I will include only the rows for the products and variants.
These will be in the format:
product_code; [productorvariant_info]; productorvariant_info]|xx-XX
(xx-XX = language code)
Thanks, this clarifies things a lot.
HikaShop Business 2.3.2 on Joomla 1.5.26 + JoomFish 2.1.6 - Multilingual site
Please Log in or Create an account to join the conversation.
Time to create page: 0.049 seconds