{"id":98216,"date":"2017-10-04T13:56:43","date_gmt":"2017-10-04T13:56:43","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=98216"},"modified":"2019-12-31T04:12:03","modified_gmt":"2019-12-31T04:12:03","slug":"opencart-marketplace-version2-product-mass-upload-xls-file-demo","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/","title":{"rendered":"Opencart Marketplace Version2 Product Mass Upload XLS File Demo"},"content":{"rendered":"<p>This post will show you how to <strong>add<\/strong> and <strong>update<\/strong> products<strong> in mass<\/strong> using the <strong>XLS file<\/strong> and will provide you an overview of the structure of the XLS file.<\/p>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">Features<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<div>\n<ul>\n<li>You can add multiple options, special, discounts, custom fields for the multiple products.<\/li>\n<li>You can add the product description, attributes in multiple languages.<\/li>\n<li>Back up files can also be used as Demo XLS file to add the products in bulk.<\/li>\n<li>Image path should be correct else the image will not get uploaded.<\/li>\n<li>Export products in Bulk\/Selective.<\/li>\n<li>The files which are exported can be imported.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">Mass Upload Products (XLS File)<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<p>For importing products via the XLS file<strong> \u2013<\/strong><\/p>\n<ul>\n<li>The<strong> Data flow profile<\/strong> could be selected as created in the admin panel.<\/li>\n<li>Just select the File type as \u201c<strong>XLS<\/strong>\u201c.<\/li>\n<li>Then select to Add New <strong>Upload New product.<\/strong><\/li>\n<li><strong>Upload the XLS file<\/strong> having the Product Information.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-215046\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-xls.png\" alt=\"Marketplace-Mass-Upload-xls\" width=\"1241\" height=\"514\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-xls.png 1241w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-xls-300x124.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-xls-1200x497.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-xls-250x104.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-xls-768x318.png 768w\" sizes=\"(max-width: 1241px) 100vw, 1241px\" loading=\"lazy\" \/><\/p>\n<ul>\n<li>You can create a new <b>XLS\u00a0<\/b>for uploading new products very easily. In XLS file, the first row defines the column name.<\/li>\n<li>You can write it in both small or capital letter and also in multi-languages. You can write anything in the column name, but you have to match this correctly in the later steps.<img decoding=\"async\" class=\"alignnone  wp-image-216065\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-1.png\" alt=\"xls-1\" width=\"1322\" height=\"94\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-1.png 1232w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-1-300x21.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-1-1200x86.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-1-250x18.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-1-768x55.png 768w\" sizes=\"(max-width: 1322px) 100vw, 1322px\" loading=\"lazy\" \/><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">Defining Description, Meta-Description, Keywords, &amp; Title<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<p>You can add a description of multi-language using <strong>tab name<\/strong>, <strong>separator<\/strong>, <strong>field name<\/strong>, and <strong>language<\/strong>. Like description:name:English. Here, the description is tab name, the name is the field name and English is a language.<\/p>\n<p><a href=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/XLS1.png\"><img decoding=\"async\" class=\"alignnone wp-image-98287 size-full\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/XLS1.png\" alt=\"xls\" width=\"1031\" height=\"222\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/XLS1.png 1031w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/XLS1-250x54.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/XLS1-300x65.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/XLS1-768x165.png 768w\" sizes=\"(max-width: 1031px) 100vw, 1031px\" loading=\"lazy\" \/><\/a><\/p>\n<p>Adding the &#8211; <strong>meta-description<\/strong>, <strong>meta-keywords<\/strong>, and <strong>meta-title<\/strong>.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-216108\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_metadetails.png\" alt=\"xls_metadetails\" width=\"761\" height=\"126\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_metadetails.png 761w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_metadetails-300x50.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_metadetails-250x41.png 250w\" sizes=\"(max-width: 761px) 100vw, 761px\" loading=\"lazy\" \/><\/p>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<h3 class=\"panel-title\"><span style=\"color: inherit; font-size: 1.56em;\">How To &#8211; Define Attributes<\/span><\/h3>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-body\">\n<p>You can <strong>add attributes<\/strong> in <strong>multi-language<\/strong>, using the <strong>field name<\/strong> and <strong>attribute name<\/strong>.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-216070\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_attribute.png\" alt=\"xls_attribute\" width=\"447\" height=\"127\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_attribute.png 447w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_attribute-300x85.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_attribute-250x71.png 250w\" sizes=\"(max-width: 447px) 100vw, 447px\" loading=\"lazy\" \/><\/p>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Define Options<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<p>You can <strong>add multiple options<\/strong> to <strong>a single product<\/strong> and also<strong> multiple values for an option<\/strong>. Option <strong>name<\/strong>, <strong>type<\/strong>, <strong>value<\/strong> are essential for<strong> adding an option <\/strong>in the product. Option type must be in small letter and also in any language.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-216073\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option.png\" alt=\"xls_option\" width=\"1212\" height=\"147\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option.png 1212w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-300x36.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-1200x146.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-250x30.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-768x93.png 768w\" sizes=\"(max-width: 1212px) 100vw, 1212px\" loading=\"lazy\" \/><\/p>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Define Special Entry For Product<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">You can <strong>add multiple special entries<\/strong> for a single product using the <strong>model<\/strong> field in each row.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-216076\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_special.png\" alt=\"xls_special\" width=\"909\" height=\"152\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_special.png 909w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_special-300x50.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_special-250x42.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_special-768x128.png 768w\" sizes=\"(max-width: 909px) 100vw, 909px\" loading=\"lazy\" \/><\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Define Discount Entry For Product<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<div>You can<strong> add multiple discount entry<\/strong> for the single or multiple products using the <strong>model<\/strong> field as shown below in the snapshot.<\/div>\n<div><img decoding=\"async\" class=\"alignnone size-full wp-image-216081\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount.png\" alt=\"xls-discount\" width=\"805\" height=\"127\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount.png 805w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount-300x47.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount-250x39.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount-768x121.png 768w\" sizes=\"(max-width: 805px) 100vw, 805px\" loading=\"lazy\" \/><\/div>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Define Product SubImage(Thumbnail)<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">You can add multiple sub-images for the single product using tab name, separator, field name. Like product images:image. In your XLS image path looks like this catalog\/folder_name\/file_name.png(extension).<br \/>\n<img decoding=\"async\" class=\"alignnone  wp-image-216123\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_image.png\" alt=\"xls_image\" width=\"529\" height=\"172\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_image.png 507w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_image-300x98.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_image-250x81.png 250w\" sizes=\"(max-width: 529px) 100vw, 529px\" loading=\"lazy\" \/><\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Define Custom Field<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<p>You can add multiple custom fields for the single product. For adding the custom field in XLS file &#8211; name, type, and value is mandatory. Custom field type must be in small letter and custom field value must be same as the product option created in the admin side.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-216113\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_custom.png\" alt=\"xls_custom\" width=\"704\" height=\"146\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_custom.png 704w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_custom-300x62.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_custom-250x52.png 250w\" sizes=\"(max-width: 704px) 100vw, 704px\" loading=\"lazy\" \/><\/p>\n<p><b>**Note<\/b> &#8211; <b>Custom field<\/b> is applicable for <b>OC version 2.0.X<\/b><\/p>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Update Products(XLS)<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<p>Select \u201c<strong>Update Old Product&#8217;s<\/strong>\u201d as shown in the below screenshot and enter valid parameters.<\/p>\n<p>The seller can select the data flow profile, select seller, file type(as CSV), update old product and upload zip file like in case of Upload new Products.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-215051\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-update-xls.png\" alt=\"Marketplace-Mass-Upload-update-xls\" width=\"1241\" height=\"514\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-update-xls.png 1241w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-update-xls-300x124.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-update-xls-1200x497.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-update-xls-250x104.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Marketplace-Mass-Upload-update-xls-768x318.png 768w\" sizes=\"(max-width: 1241px) 100vw, 1241px\" loading=\"lazy\" \/><\/p>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Update Attributes in XLS File<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<p>If you want to update an attribute in the existing product then, you have to add product id and model:name combination. The first row defines column field.<br \/>\n<img decoding=\"async\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_attribute.png\" alt=\"xls_attribute\" loading=\"lazy\" \/><\/p>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Update Option in XLS File<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<p>You can update multiple options for a single product and also update multiple values of an option for a single product. Option name, type, value are essential for updating an option. When you will update an option, the previous option will be deleted and the newly updated option will be applied.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-216118\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-1.png\" alt=\"xls_option-1\" width=\"1212\" height=\"147\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-1.png 1212w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-1-300x36.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-1-1200x146.png 1200w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-1-250x30.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls_option-1-768x93.png 768w\" sizes=\"(max-width: 1212px) 100vw, 1212px\" loading=\"lazy\" \/><\/p>\n<\/div>\n<\/div>\n<div class=\"panel panel-primary\">\n<div class=\"panel-heading\">\n<div>\n<h3 class=\"panel-title\">How To &#8211; Update Discount Entry in XLS File<\/h3>\n<\/div>\n<\/div>\n<div class=\"panel-body\">\n<p>If you want to update discount entries in the existing product then, you have to add product id and model:name combination in XLS file structure. Like below screenshot.<br \/>\n<img decoding=\"async\" class=\"alignnone size-full wp-image-216119\" src=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount-1.png\" alt=\"xls-discount-1\" width=\"805\" height=\"127\" srcset=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount-1.png 805w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount-1-300x47.png 300w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount-1-250x39.png 250w, https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/xls-discount-1-768x121.png 768w\" sizes=\"(max-width: 805px) 100vw, 805px\" loading=\"lazy\" \/><\/p>\n<\/div>\n<\/div>\n<p>That&#8217;s all for the <strong>Opencart Marketplace Version2 Product Mass Upload XLS File Demo<\/strong>. Still, have issues or want to give your suggestions to make this module better just raise a ticket at\u00a0<a href=\"http:\/\/webkul.uvdesk.com\/\" rel=\"noopener noreferrer\">webkul.uvdesk.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post will show you how to add and update products in mass using the XLS file and will provide you an overview of the structure of the XLS file. Features You can add multiple options, special, discounts, custom fields for the multiple products. You can add the product description, attributes in multiple languages. Back <a href=\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/\">[&#8230;]<\/a><\/p>\n","protected":false},"author":152,"featured_media":98241,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1552,5556,1551],"tags":[5557,5558],"class_list":["post-98216","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mass-upload-2","category-mass-upload-xls-file","category-opencart-marketplace-product-mass-upload","tag-mass-upload-xls-demo","tag-opencart-marketplace-product-mass-upload-xls-file-demo"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Opencart Marketplace Version2 Product Mass Upload XLS File Demo - Webkul Blog<\/title>\n<meta name=\"description\" content=\"In this doc, you will get to know about what XLS structure should be and will show you how to add and update products in mass using the XLS file.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Opencart Marketplace Version2 Product Mass Upload XLS File Demo - Webkul Blog\" \/>\n<meta property=\"og:description\" content=\"In this doc, you will get to know about what XLS structure should be and will show you how to add and update products in mass using the XLS file.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-10-04T13:56:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-31T04:12:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png\" \/>\n\t<meta property=\"og:image:width\" content=\"825\" \/>\n\t<meta property=\"og:image:height\" content=\"260\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Kajal Sharma\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kajal Sharma\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/\"},\"author\":{\"name\":\"Kajal Sharma\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/eeac324d79cd929a522950586c3d26bc\"},\"headline\":\"Opencart Marketplace Version2 Product Mass Upload XLS File Demo\",\"datePublished\":\"2017-10-04T13:56:43+00:00\",\"dateModified\":\"2019-12-31T04:12:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/\"},\"wordCount\":698,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png\",\"keywords\":[\"Mass upload xls demo\",\"Opencart Marketplace Product Mass Upload XLS File Demo\"],\"articleSection\":[\"Mass Upload\",\"Mass Upload XLS file\",\"Opencart Marketplace Product Mass Upload\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/\",\"url\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/\",\"name\":\"Opencart Marketplace Version2 Product Mass Upload XLS File Demo - Webkul Blog\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png\",\"datePublished\":\"2017-10-04T13:56:43+00:00\",\"dateModified\":\"2019-12-31T04:12:03+00:00\",\"description\":\"In this doc, you will get to know about what XLS structure should be and will show you how to add and update products in mass using the XLS file.\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#primaryimage\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png\",\"width\":825,\"height\":260},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Opencart Marketplace Version2 Product Mass Upload XLS File Demo\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/eeac324d79cd929a522950586c3d26bc\",\"name\":\"Kajal Sharma\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0d2cd60d1df5bcebcbac2ccff8f759366c837d2468ff65a57d369d8c42b7d6f3?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0d2cd60d1df5bcebcbac2ccff8f759366c837d2468ff65a57d369d8c42b7d6f3?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"caption\":\"Kajal Sharma\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/kajalsharma-magento920\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Opencart Marketplace Version2 Product Mass Upload XLS File Demo - Webkul Blog","description":"In this doc, you will get to know about what XLS structure should be and will show you how to add and update products in mass using the XLS file.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/","og_locale":"en_US","og_type":"article","og_title":"Opencart Marketplace Version2 Product Mass Upload XLS File Demo - Webkul Blog","og_description":"In this doc, you will get to know about what XLS structure should be and will show you how to add and update products in mass using the XLS file.","og_url":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2017-10-04T13:56:43+00:00","article_modified_time":"2019-12-31T04:12:03+00:00","og_image":[{"width":825,"height":260,"url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png","type":"image\/png"}],"author":"Kajal Sharma","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Kajal Sharma","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/"},"author":{"name":"Kajal Sharma","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/eeac324d79cd929a522950586c3d26bc"},"headline":"Opencart Marketplace Version2 Product Mass Upload XLS File Demo","datePublished":"2017-10-04T13:56:43+00:00","dateModified":"2019-12-31T04:12:03+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/"},"wordCount":698,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"image":{"@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#primaryimage"},"thumbnailUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png","keywords":["Mass upload xls demo","Opencart Marketplace Product Mass Upload XLS File Demo"],"articleSection":["Mass Upload","Mass Upload XLS file","Opencart Marketplace Product Mass Upload"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/","url":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/","name":"Opencart Marketplace Version2 Product Mass Upload XLS File Demo - Webkul Blog","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#primaryimage"},"image":{"@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#primaryimage"},"thumbnailUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png","datePublished":"2017-10-04T13:56:43+00:00","dateModified":"2019-12-31T04:12:03+00:00","description":"In this doc, you will get to know about what XLS structure should be and will show you how to add and update products in mass using the XLS file.","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#primaryimage","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2017\/10\/Opencart-Marketplace-Product-Mass-Upload-Blog-Banner.png","width":825,"height":260},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/opencart-marketplace-version2-product-mass-upload-xls-file-demo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Opencart Marketplace Version2 Product Mass Upload XLS File Demo"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/eeac324d79cd929a522950586c3d26bc","name":"Kajal Sharma","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0d2cd60d1df5bcebcbac2ccff8f759366c837d2468ff65a57d369d8c42b7d6f3?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0d2cd60d1df5bcebcbac2ccff8f759366c837d2468ff65a57d369d8c42b7d6f3?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","caption":"Kajal Sharma"},"url":"https:\/\/webkul.com\/blog\/author\/kajalsharma-magento920\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/98216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=98216"}],"version-history":[{"count":25,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/98216\/revisions"}],"predecessor-version":[{"id":218246,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/98216\/revisions\/218246"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media\/98241"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=98216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=98216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=98216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}