In "System, Import/Export, Dataflow Advanced Profiles" I have a profile for importing Cross-sell. It works fine; however when the cross-sell SKU contains space it is not imported. The product itself can contain SKU, but not the associated cross-sell item.
The .csv file looks like this:
store;sku;crosssell admin;DD IN;ES-1,DD OT,LB EB admin;DD OT;ES-1,ES-2,ES-3
...where the first item (DD IN) will only import ES-1 as cross-sell because the other two items fail due to spaces in SKU, while the second item (DD OT) will import all three cross-sell items (ES-1, ES-2, ES-3) because they don't contain space in SKU.
The profile execution log-window does not report any errors.
I've tried to put the sku's within single and/or double quotes, without luck.
Is there any way to bypass this issue?
The XML-script for importing the cross-sell looks like this:
<action type="dataflow/convert_adapter_io" method="load"> <var name="type">file</var> <var name="path">var/import</var> <var name="filename"><![CDATA[import_products_relations.csv]]></var> <var name="format"><![CDATA[csv]]></var> </action> <action type="dataflow/convert_parser_csv" method="parse"> <var name="delimiter"><![CDATA[;]]></var> <var name="enclose"><![CDATA["]]></var> <var name="fieldnames">true</var> <var name="store"><![CDATA]></var> <var name="number_of_records">1</var> <var name="decimal_separator"><![CDATA[.]]></var> <var name="adapter">catalog/convert_adapter_productimportrelations</var> <var name="method">parse</var> </action>
Any help appreciated. Thanks!