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.

You can enter 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 add Freight Cost, Import Duty Cost % and Miscellaneous Cost, please use the Bulk Action in the Product Costings.

From Product Costings dropdown menu, select [Data Import]

Click the green [Download Template] button to download the CSV template file

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

The mandatory fields to create a Product are Style, Fabric, Colour, Size Category, Manufacturer and Product Category (only 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 the Product ID column.

Populate the downloaded CSV file

  1. To create new products, leave the Product ID column blank (Zedonk will generate a Product ID by combining Style, Fabric and Colour)
  2. Enter your Style, Fabric and Colour (note the character limit - 50 for Style, 20 for Fabric, 30 for Colour)
  3. Enter the relevant Product Category - from the selection you have entered in the Product Settings - Product Categories
  4. Enter the Description (note the character limit - 50)
  5. Enter the Size Category - from the selection you have entered in the Product Settings - Size Categories
  6. Enter the Manufacturer - from the selection you have entered in the Manufacturers

Please do not use the following 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

  1. For the First Make/Cost Currency, enter the currency name in the ISO code (for example, EUR, GBP, USD). If you are unsure about the currency name, you can check General Settings - Bank Details.
  2. In any column where a drop-down exists in Zedonk, you must enter one of the available options, i.e. CUSTOMS TYPE. If you are unsure about the available options, check CUSTOMS TYPES in Product Settings - Customs Types, or leave blank and update later.
  3. If you do not enter anything in MANUFACTURING TYPE, it will use your default type as per your Product Settings - Default Manufacturing Type.

Save the populated 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 the populated CSV file or click [+ Select File]

Click [Next]

Confirm columns that will be imported

You can untick any, but you must leave the mandatory columns.

Once the file is validated, you will see Validation Results

You can see all the Product Costings you are about to import

If you encounter any errors, click the red ERROR button to see the details. Please note that you cannot proceed with the data import if you have not corrected all error messages.

Click [Import Data]

Confirm the Import Data action by clicking [OK]

Success!

Your products have been created

Previous Article Product Costing - Print Product Labels
Next Article Product Costing - Data Import - Update Products