You can select manufacturers, select data fields, export them and then amend data and import to Zedonk.
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.
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.
Remove if you've chosen the incorrect file.
- 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
- 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
Click OK.
