Own assignment: Exchanging information

You want to import a file into PlentyONE. but it lists information differently than PlentyONE does? No need to modify the file by hand! You can use the "Own Assignment" function to swap out one piece of information for another.

Note: When this video was produced, the import tool was called ElasticSync. This name is now outdated and the menu has gone through a few visual changes. However, the general content of the video still remains valid.

Transcript

You received a new file, chock-full of information! But, wait a minute. The data isn’t quite right. Some pieces of information need to be swapped out for others.

Let me show you what I mean. Imagine you’ve got a spreadsheet filled with customer information. In one of the columns, you’ve got the country where your customer lives.

But there’s just one little problem. Your spreadsheet uses country names like the United Kingdom, whereas PlentyONE uses its own unique IDs for each country. If you try to import these names, then PlentyONE won’t know what country you’re talking about. No problem! ElasticSync can help you sort out the confusion.

This video builds on what you’ve already learned in our basic instructional video and looks at this option here, which lets you swap out one piece of information for another. In other words, you can use this "own assignment" option to teach PlentyONE which country is which.

First, use the "type" field to tell PlentyONE which column of your file lists the countries. Then use the from field to enter country names as they’re displayed in your CSV file. And use the to field to enter the same countries, as they’re identified in plentymarkets.

Proceed the same way to match all the rest of the countries in your CSV file with all the corresponding country IDs in plentymarkets. Finally, use this field here to tell PlentyONE what it should do, if it comes across an empty row in your file. In this case, you’ll need to tell PlentyONE which country it should use by default.

That’s the idea here. Just tell PlentyONE which country it should use by default.

Good job! You’ve swapped out the information in your file and now you’re ready to import all of this data into plentymarkets!