Zedonkopedia

Raw Materials - Data Import - Update Raw Materials

You can update Raw Materials in bulk using .csv export/import

Ensure any data fields you wish to amend are visible on Raw Materials by Colour List View

Click on LAYOUT/FILTER symbol and select Select/Move/Filter

In the example below, all records will have the composition and width size updated

When finished click OK

Select all records to update, from the [X Selected] dropdown click [Export CSV]
Open the file and make necessary amendments

Ensure to leave 'Match On - Raw Material ID' and 'Match On - Colour' columns unchanged

Save file as .csv for import

From Raw Materials dropdown select [Data Import]
From this page, you will need to download the import template, click [Download]
Then copy and paste the data from your amended CSV to this new template, referencing the relevant columns

 You will need to ensure the 'Match On - Raw Material ID' and 'Match On - Colour' columns contain data of the existing raw material articles you are wanting to update. This allows Zedonk to 'LookUp' the existing records and perform the updates present in existing columns

Select your finished .csv file or drag and drop it, click [Next] to proceed
You see the validation screen to review headers

Click [Next] to proceed

Your import has been validated

Pop up shows a summary of the import

Any amendments will be highlighted in green to review

Once confirmed, click [Import Data] to continue, from Import Data pop up click [OK] to update
Success!

Your Raw Materials have now been updated!

Previous Article Raw Materials - Data Import
Next Article Raw Materials - Bulk Action