You can select products, select data fields, export them and then amend data and import back into Zedonk.
You can update the following product details with the Data Import tool: Style, Fabric, Colour, Category 1, Category 2, Category 3, Category 4, Category 5, Description, Size Category, Manufacturer, MID Code, First/Make Currency Name, First/Make Cost, Lead Time, Minimums, Manufacturer Comments, Pack Type, Customs Type, Textile Content, Sales Order Notes, HTS Code, Intrastat Code, Weight (KG), Retail Markup, Wholesale Markup, Manufacturing Type, Production Notes, Labels.
If you need to update Freight Cost, Import Duty Cost % and Miscellaneous Cost, please use the Bulk Action in the Product Costings.
Ensure any data fields you wish to amend are visible on Product Costing List View
Click on the LAYOUT/FILTER symbol and select Select/Move/Filter
In the example below, all product records with 'Dress' assigned as Product Category 1 will have the textile content updated.
1. Tick TEXTILE CONTENT and
2. Move the column up using the move symbol
Now filter by CATEGORY 1 - start typing and the option will appear
When finished click OK
Once selected, click [x Selected]
Now your filtered records are selected and you can export them.
Click [Export CSV] to download .csv file of data on screen
Open the exported file to make any amendments required
Only keep and populate the columns you want to use. Blank values are imported and may overwrite your data.
You can change data in any column, except the Product ID column. Even when you are updating the Style, Fabric and/or Colour fields, the original Product ID value needs to be entered in the Product ID column.
Do not use currency symbols, there is a separate column to identify currency for the cost you import/update. Enter ISO 4217 currency codes in the currency column (for example, EUR, GBP, USD).
In the example below I want to add '100% Cotton' to all blank values in the TEXTILE CONTENT field and change '100% SILK' to '90% SILK 10% VISCOSE'.
You can use filters to isolate records you want to change
Remove all filters and save your file ready for import.
From Product Costing 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
1. If you have ADDED or AMENDED data in STYLE and/or FABRIC and/or COLOUR fields you will need to MANUALLY tick the columns to import
2. All other columns will be imported including those you have ADDED/AMEDED
Click [Next]
Your import has been validated - click OK
You can now see onscreen Product Costing data you are about to import for review
1. Action = tells you if this record is UPDATE or NO CHANGE
2. Fields in GREEN are those that are about to be UDPATED - 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]
Confirm action OK
Success!
