To make product management on Zwing Console more flexible, the The Product Import feature now allows you to add and update product information from a single CSV file. Just follow the tips mentioned below., 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.
Expand |
---|
title | 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.
Info |
---|
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.
Warning |
---|
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
...