[clintm@cfh.ca]

I have a CSV file with the Cash Sale Internal ID, LineID and Country.

InternalID__Line ID___Country

286045______3______Rwanda

286045______4______Burundi

290014______1______Rwanda

290813______9______Cambodia

290813______8______Peru

290813_____11______Uganda

290813_____12______Uganda

290813______2______Ethiopia

290814______1______Ethiopia

290820______5______Uganda

290822______2______Uganda

Is it possible to update the line items above with the new Country data using Import CSV?
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

RE: Update Country on Transaction Line

Yes, but you have to use the “replace all line items” option (i forget the exact name). This means you’ll be wiping out all your line items. Hence, you must reimport the entire order’s line items, not just the line you want to modify. The CSV assistant is less than adequate when you want to make edits on lines.

[clintm@cfh.ca]

RE: Update Country on Transaction Line

Thanks Oliver. I didn’t think it would be easy. I might just script something to do it.

[Author]

Posts