Support is online

Custom Values not imported right #7148

Open Jantjuhhh opened this topic Wednesday, 18 February 2015 · 4 replies
Author

Hello Roland, I am trying to import a file with custom values but i cant get it to work properly. I have a custom value with multiple options, but when i am trying to import it which it does i suddenly 2 custom values in the product page. Can you help me with that?

Support

Hello,

The CSV file you posted is invalid. You are using ; as your field delimiter but also using the ; in your product descriptions. If you do that, the CSV file cannot be read correctly. You will need to enclose your descriptions with " (double-quotes). This way reading the CSV file can be done correctly.

Fix that first and then see how the import goes.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

I did what you suggested, replaced the ; with , and enclosed the descriptions with ". What i did then before I imported the file is that i first made the custom value "Maat" that contains the the values"XL,L and so on. Still i get multiple fields in the product page.

Support

Hello,

The file is not good. Let's look at the first line:

"category_path,""product_s_desc"",""product_sku"",""product_name"",""product_price"",""slug"",""file_url"",""file_url_thumb"",""manufacturer_name"",""product_desc"",""custom_param"",""custom_price"",""custom_title"",""custom_value""";;;;;

You have two double quotes, the commas are in the wrong place and empty fields at the end. This line should look like this:

"category_path","product_s_desc","product_sku","product_name","product_price","slug","file_url","file_url_thumb","manufacturer_name","product_desc","custom_param","custom_price","custom_title","custom_value"

This is a valid CSV file.

See if you can update your file to match the valid structure and I will check it again.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Problem solved, i made a mistake in the custom field :blush: thanx Rolandd

Log in to reply to this topic.