Zedonkopedia

Product Costing - Data Import - Update Products

You can select products, select data fields, export them and then amend data and import back into Zedonk

Ensure any data fields you wish to amend are visible on Product Costing List View

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

In the example below, all records for products with Product Category / Dress will have the textile content updated

Click Select/Move/Filter button

1. Tick TEXTILE CONTENT and

2. Move the column up using the move symbol

Now filter by CATEGORY - start typing and the option 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 to make any amendments required

You can change data in any column EXCEPT PRODUCT ID - DO NOT TOUCH THIS even if you are changing Style, Fabric and/or Colour 

Do not use these symbols: £, €, ¥, §    (excel replaces them with other characters when saving as CSV).

I want to add 100% Cotton to all blank TEXTILE CONTENT field and

Change 100% SILK to 90% SILK 10% VISCOSE

You can use Filters to isolate records you want to change - N.B. New Entries are CASE SENsITIvE

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!
Previous Article Product Costing - Data Import - Create Products
Next Article Product Costing - Data Import - Validation Errors