Zedonkopedia

Product Costing - Data Import - Create Products

Create products in bulk using the import template. Mandatory fields for creating new products are STYLE, FABRIC, COLOUR, MANUFACTURER, SIZE CATEGORY, and any PRODUCT CATEGORIES that have been marked as mandatory

From Product Costings dropdown menu select [Data Import]
Select [Download Template] to download .csv template file

All mandatory columns need to be completed on the .csv template in order to create products

The mandatory fields to create a Product are Style, Fabric, Colour, Size Category (the name of the category from your settings), Manufacturer and Product Category (if you have these set as mandatory in your settings. You only need to populate the columns you want to use - delete the others. To create new Products DO NOT POPULATE Product ID

Complete .csv file

1. To create new products, leave Product ID blank (Zedonk will generate a Product ID by combining Style, Fabric and Colour

2. Enter your STYLE FABRIC COLOUR - you can copy and paste from another document N.B.50 characters limit for style 20 for fabric 30 for colour

3. Enter relevant PRODUCT CATEGORY  - from the selection you have entered in Product Settings - Product Categories

4. Enter Description N.B. 50 character limit

5. Enter Size Category - from the selection you have entered in Product Settings - Size Categories

6. Enter Manufacturer  - from the selection you have entered in Manufacturers

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

You can enter data for all the columns on the template

You do not have to populate all columns for every product - you can select what you add for each product ( you can do a bulk update later)

A couple more things to note ...

FIRST/MAKE COST - enter NAME not SYMBOL

If you are not sure - check General Settings - Bank Details

In any column where a drop down exists in Zedonk you MUST enter one of those options i.e. CUSTOMS TYPE

If you are not sure - check CUSTOMS TYPES in Product Settings - Customs Types or leave blank and update later

If you do not enter anything in MANUFACTURING TYPE it will use your default type as per your Product Settings - Default Manufacturing Type

When finished save .csv file.

From Product Costings dropdown menu select [Data Import]

The import is seasonal so be sure you are in the correct season before doing your import

Drag and Drop .csv file to import data back it into Zedonk

You see this screen - READ BEFORE TAKING ACTION and then click on SELECT FILE

Select [Next]
You see all columns that will be imported - you can untick any but must leave mandatory columns as stated
Uploaded .csv is now validated and is ready for import

For more information on any validation errors received

Now you see all Product Costings you are about to import

You have a further chance to untick any records you do not want to create - when you are ready click IMPORT DATA

Select [Import Data] if all looks correct

Confirm action OK

SUCCESS!

Your products are now created and ready to use.....
Previous Article Product Costing - Print Product Labels
Next Article Product Costing - Data Import - Update Products