Forums › Cached › CSV Import
This topic contains 2 replies, has 0 voices, and was last updated by clintm@cfh.ca 14 years, 3 months ago.
-
AuthorPosts
-
clintm@cfh.ca- Contributions: 0
- Level 1
- ☆
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- Contributions: 0
- Level 1
- ☆
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- Contributions: 0
- Level 1
- ☆
RE: Update Country on Transaction Line
Thanks Oliver. I didn’t think it would be easy. I might just script something to do it.
-
AuthorPosts
You must be logged in to reply to this topic.