Improved Product Import

The Product Import feature now allows you to add and update product information from a single CSV file, making product management on Zwing Console more flexible.

To access this feature go to Products & Catalogue → Products → More → Import

Additionally, you can also download a sample CSV template that you can add data to. and then import the same for a hassle-free process.

Template Description

Mandatory fields

Column	Description
product_code	Internal product code in Zwing Leave blank for new products, fill existing product code to update product parameters.
ref_product_code	External reference code for product
name	Product name
short_desc	Short description for the product
long_desc	Long description for the product
sku_code	Internal SKU code in Zwing Leave blank for new products, enter existing product code to update product parameters.
ref_sku_code	External reference code for SKU
selling_uom_type	Sale unit of measurement Enter PIECE for a product sold as a unit piece.
purchase_uom_type	Purchase unit of measurement Enter PIECE for a product purchased as a unit piece.
selling_uom_code	Code for sale unit of measurement PCS is the code for the Piece UOM
purchase_uom_code	Code for purchase unit of measurement
uom_factor	Selling unit factor of Purchase unit
brand_name	Brand of the product
department	Department of the product
category_#	Category and sub-categories of the product # represents level of the category, based on your selection while downloading the template. Category 1 is mandatory, while level 2 and more are optional.
hsn_code	HSN code of the product
tax_type	Tax included in or excluded from the product’s price Enter INC for Inclusive or EXC for exclusive.
tax_cat_code
barcode_1
barcode_#	Barcodes of the product # represents number of barcode
unit_mrp
unit_rsp
unit_ssp
item_attributes_name_#
item_attributes_value_#
variant_attributes_name_#
variant_attributes_value_#
allow_tracking_inventory
batch_tracking
serial_tracking
allow_negative_inventory
negative_inventory_use_policy_module
allow_price_override
price_override_variance_percent
price_override_use_policy_module
allow_manual_dsicount
manual_discount_variance
manual_discount_use_policy_module
product_media__media_type
product_media__media_name
product_media__media_extension
product_media__base_folder_path

How to Add New Products using CSV

While creating a CSV file for import, ensure you leave the product_code and sku_code columns empty for the product rows that you wish to create as new in Zwing.

These are internal codes generated in Zwing when a new product is created and cannot be modified. They should only be used when referencing existing products.

How to Update Existing Products using CSV

While creating a CSV file for import, fill the product_code or sku_code columns with the respective Product Code or SKU Code of any product already created in Zwing, the information of which you seek to update. If correct, any other values in the columns excluding these two will replace existing product information for the corresponding parameter.

If the Product code or SKU code values don't match any existing product, it would result in an error.

Example

On importing the above the CSV file, the following things would happen

Row 2 with Product Code 120010 and SKU Code DEF0045 will have only its Short Description and Ref SKU Code replaced with the contents of the respective columns.
Row 3 and 4 will create two new products.
Row 5 with Product Code 120013 will have only its Ref Product Code and Name replaced with contents in of the respective columns.