| | |
|---|
| 1 | product_code | Internal product code in Zwing Leave blank for new products, enter existing product code to update product parameters. |
| 2 | ref_product_code | External reference code for product |
| 3 | name | Product name |
| 4 | short_desc | Short description for the product |
| 5 | long_desc | Long description for the product |
| 6 | sku_code | Internal SKU code in Zwing Leave blank for new products, enter existing product code to update product parameters. |
| 7 | ref_sku_code | External reference code for SKU |
| 8 | selling_uom_type | Sale unit of measurement Enter PIECE for a product sold as a unit piece. |
| 9 | purchase_uom_type | Purchase unit of measurement Enter PIECE for a product purchased as a unit piece. |
| 10 | selling_uom_code | Code for sale unit of measurement |
| 11 | purchase_uom_code | Code for purchase unit of measurement |
| 12 | uom_factor | Selling unit factor of Purchase unit Enter 1 if the purchase and selling UOM are the same. |
| 13 | brand_name | Brand of the product |
| 14 | department | Department of the product |
| 15 | 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. |
| 16 | hsn_code | HSN code of the product |
| 17 | tax_type | Type based on whether tax is included in or excluded from the product’s price Enter INC for inclusive or EXC for exclusive. |
| 18 | tax_cat_code | Code of the applicable Tax Category in Zwing |
| 19 | barcode_# | Barcode(s) of the product # represents number of barcodes, based on your selection while downloading the template. Barcode 1 is mandatory, while the rest are optional. |
| 20 | unit_mrp | Maximum Retail Price of the product |
| 21 | unit_rsp | Retail Selling Price of the product |
| 22 | unit_ssp | Special Selling Price of the product If you wish to add multiple prices for a product, we recommend using the Retail Pricebook feature. |
| 23 | item_attributes_name_# | Name of the common attribute(s) of the product # represents number of item attributes, based on your selection while downloading the template. Example: Country of Origin |
| 24 | item_attributes_value_# | Value or description of the common attribute(s) of the product # represents number of item attributes, based on your selection while downloading the template. Example: India |
| 25 | variant_attributes_name_# | Name of the variant attribute(s) of the product # represents number of variant attributes, based on your selection while downloading the template. Example: Color |
| 26 | variant_attributes_value_# | Value of the variant attribute(s) of the product # represents number of variant attributes, based on your selection while downloading the template. Example: Green |
| 27 | allow_tracking_inventory | Used to determine whether to track inventory for the product or not. Enter 1 or leave blank to allow inventory tracking. Enter 0 if you do not wish to track inventory for the product. |
| 28 | batch_tracking | If inventory tracking is set to on, this determines whether the product is tracked using batch numbers or not. Enter 1 to allow batch tracking. Enter 0 or leave blank if you do not wish to track inventory using batches. |
| 29 | serial_tracking | If inventory tracking is set to on, this determines whether the product is tracked using serial numbers or not. Enter 1 to allow serial tracking. Enter 0 or leave blank if you do not wish to track inventory using serial. |
| 30 | allow_negative_inventory | If inventory tracking is set to on, this determines whether the product’s inventory can be less than zero or not. Enter 1 to allow negative inventory. Enter 0 or leave blank to prevent negative inventory. |
| 31 | negative_inventory_use_policy_module | Used to determine whether policy-level negative inventory setting can overrule product-level negative inventory setting (See 30). Enter 1 to allow policy-level setting to overrule product-level setting. Enter 0 or leave blank to retain product-level setting. |
| 32 | allow_price_override | Used to determine whether Price Override is allowed on the product or not. Enter 1 to allow price override. Enter 0 or leave blank to disable price override. |
| 33 | price_override_variance_percent | If price override is set to on, determines the limit of permissible change in price. If set to 5% for a product priced ₹100.00, the override price can only be within ₹95.00 to ₹105.00 |
| 34 | price_override_use_policy_module | Used to determine whether policy-level price override setting can overrule product-level negative inventory setting (See 33). Enter 1 to allow policy-level setting to overrule product-level setting. Enter 0 or leave blank to retain product-level setting. |
| 35 | allow_manual_discount | Used to determine whether Manual Discount is allowed on the product or not. Enter 1 to allow manual discount. Enter 0 or leave blank to disable manual discount. |
| 36 | manual_discount_variance | If manual discount is set to on, determines the limit of the manual discount applied on the product. If set to 5% for a product priced ₹100.00, the manual discount cannot be more than ₹5 |
| 37 | manual_discount_use_policy_module | Used to determine whether policy-level manual discount setting can overrule product-level negative inventory setting (See 36). Enter 1 to allow policy-level setting to overrule product-level setting. Enter 0 or leave blank to retain product-level setting. |
| 38 | product_media__media_type | Â |
| 39 | product_media__media_name | Â |
| 40 | product_media__media_extension | Â |
| 41 | product_media__base_folder_path | Â |
