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:

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 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[0]]></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>

Any help appreciated. Thanks!

  • Does admin;DD IN;DD OT,ES-1,LB EB import the first cross-sell ? Does admin;DD IN;DD OT works ? – Christophe Ferreboeuf Jul 9 at 8:43
  • In the example .csv above; the first line will only import the first cross-sell item, while the second line will import all three cross-sell items. So it seems like cross-sell items with space in the SKU is ignored. – Espen Jul 9 at 9:21
  • Can you still try what I am asking ? It can lead to a solution but I do not have time to try it myself. – Christophe Ferreboeuf Jul 9 at 11:07
  • Ah sorry @Christophe, I misunderstood you. admin;DD IN;DD OT,ES-1,LB EB imports the second cross-sell item (ES-1) only, admin;DD IN;DD OT does not import anything. Any cross-sell item with space in SKU seems to be ignored, others are imported (regradless of order) – Espen Jul 9 at 12:23
  • if you change parse by any other method of app/code/core/Mage/Dataflow/Model/Convert/Parser/Csv.php (maybe getCsvString for the method). Sorry, that's my final guess, I miss knowledge of this functionality. – Christophe Ferreboeuf Jul 9 at 13:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.