Hello Folks,
I need to move some data from some non-inventory items to some inventory items, so my plan is to export the results of a search to get the data out of the non-inventory items, which would include the internal ID, then edit the exported file to replace the internal IDs with the ID's of the inventory items, and do a CSV import to add the data to the inventory items.
The export side seems fine, and I've created a 1-record test file to test the import. One issue - easy to work around but irritating, is that Netsuite uses different field names on import and export, so fields aren't all automatically mapped on the import.
The issue I'm struggling with is importing data into a custom image field. Both the inventory & non-inventory items have the same set of custom image fields (I guess that goes without saying), and I've exported them from the non-inventory items. Note that I've also exported the standard product image & thumbnail fields too.
On the import, the standard fields seem to import OK, but I get an error message "Invalid custitem_alt_image_1 reference key" for the custom image fileds. The exported data just gives a relative path whereas the standard images have a full path, so I tried adding the full path info into the custom images, but the error message was the same.
Has anyone had success importing custom image fields?
Also, I don't see where I'm meant to specify that the Internal ID should be used as a key field on the import - or is just including it in the import map enough?
Thanks!
-Mark