Note: You can select manufacturers, select data fields, export them and then amend data and import to Zedonk.
Ensure any data fields you wish to amend are visible on the Manufacturer List View
Click the Layout/Filter icon, then Select/Move/Filter.
In the example below, all records for manufacturers with Manufacturer Category WOVEN will have the category updated.
Click the Select/Move/Filter button.
Tick the Category tickbox
Now filter by CATEGORY - start typing and the options will appear. Select categories (the 'No Filter' field will change to 'Is Filter').
When finished click OK.
Once selected, click [Selected]
Click [Export CSV] to download a CSV file of data on screen
Open the CSV file to make any amendments required
You can change data in any column EXCEPT MANUFACTURER.
Do not use these symbols: £, €, ¥, § (Excel replaces them with other characters when saving as CSV).
In the example below, I want to add WOVEN to all blank CATEGORY fields and change the Currency of BRAND 1 from GBP to EUR.
You can use Filters to isolate records you want to change - new entries are CASE SENsITIvE.
Remove all filters and save your file ready for import.
From Manufacturer dropdown menu select [Data Import]
Select file or drag and drop the amended CSV file and click [Next]
Remove if you've chosen the incorrect file.
You see the Validation screen to review data
- If you untick any columns they won't be imported
- INVALID columns won't be imported (the column header is not recognised)
- Only VALID columns will be imported including those you have ADDED/AMENDED
Click [Next]
You can now see Manufacturer data you are about to import for review
- Action - tells you if this record is UPDATE or NO CHANGE
- Fields in GREEN are about to be UPDATED. You can click on these and see what the field was BEFORE import and what it will be AFTER import
When you are ready click [Import Data]
Click OK.