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.

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!

Previous Article Product Costing - Data Import - Create Products
Next Article Product Costing - Data Import - Validation Errors