Skip to Content
This question has been flagged
6 Replies
5759 Views
Avatar
Edward Knoch

I'm trying to import a 1:Many record set for optional product ids - I've used the template with the IDs Directly and also with the optional_product_id as a text field. I get the error in the subject on import. All the records exist in the system and I'm just trying to update instead of having to use the interface to load hundreds of "optional" products. 

ID

Name

sale_delay

hs_code

optional_product_ids/id

__export__.product_template_1164_0c349081

NIO-LIC-ATC

0

__export__.product_template_1165_7fcd6492

NIO-LIC-PRC

0

__export__.product_template_1166_24028929

NIO-LIC-SPOTTER

0

__export__.product_template_1167_c5736f7e

NIO-LIC-SPOTTER-3D

0

__export__.product_template_1168_e7fd9615

NIO-SERVER

14

8517.62.0050

__export__.product_template_1164_0c349081

__export__.product_template_1165_7fcd6492

__export__.product_template_1166_24028929

__export__.product_template_1167_c5736f7e

__export__.product_template_1263_159504b6

__export__.product_template_1258_91d31cac

__export__.product_template_1259_ae690298

__export__.product_template_1260_bcd5d739

__export__.product_template_1264_f1639735

__export__.product_template_1169_2fed0f62

NIO-SW

14

8517.62.0050

__export__.product_template_1164_0c349081

__export__.product_template_1165_7fcd6492

__export__.product_template_1166_24028929

__export__.product_template_1167_c5736f7e

__export__.product_template_1263_159504b6

__export__.product_template_1258_91d31cac

__export__.product_template_1259_ae690298

__export__.product_template_1260_bcd5d739

__export__.product_template_1264_f1639735

__export__.product_template_1171_b99e418e

ICC-ENC-FBG

14

__export__.product_template_1170_4c737e90

ICC-ENC-STL

14

Can Anyone assist?
Avatar
Discard
Avatar
Paresh Wagh
Best Answer

Hi Ed:

Put the ids of the optional products in a single cell in the same row as the product to which they correspond. Separate the ids of the optional products by commas and change the column heading to optional_product_ids (remove the /id).

Avatar
Discard
Avatar
Edward Knoch
Author Best Answer

Paresh - thank you for your answer - it is exactly what I needed. The documentation (and export feature) exports the content spanning rows and says that it is acceptable for re-import, but it's not - your suggestion worked beautifully.  

Thank you,

Ed

Avatar
Discard
Ermin Trevisan

Please upvote the answer and mark it as answered then.

Edward Knoch
Author

I tried to, but I don't have enough Karma points to upvote this - I wish I could. New user and all that.

Avatar
Gan
Best Answer

Hi Ed,

I noticed that there is bug when it comes to importing data via excel. However, there's no issue when import is done using csv.

Hope this helps.

Avatar
Discard
Avatar
Mindaugas
Best Answer

import/update using only external id and update field. also, before that (export one more time external id).

Avatar
Discard