{"id":3040,"date":"2012-06-17T20:02:47","date_gmt":"2012-06-17T20:02:47","guid":{"rendered":"https:\/\/www.jose-aguilar.com\/blog\/?p=3040"},"modified":"2013-10-20T19:48:42","modified_gmt":"2013-10-20T19:48:42","slug":"importar-datos-con-excel-en-prestashop","status":"publish","type":"post","link":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/","title":{"rendered":"Importar datos con excel en Prestashop"},"content":{"rendered":"<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/prestashop1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft  wp-image-3639\" title=\"prestashop\" alt=\"\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/prestashop1-150x150.png\" width=\"84\" height=\"84\" srcset=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/prestashop1-150x150.png 150w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/prestashop1-80x80.png 80w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/prestashop1-180x180.png 180w\" sizes=\"auto, (max-width: 84px) 100vw, 84px\" \/><\/a>Prestashop dispone de una herramienta fundamental para importar datos de un excel en formato CSV.<\/p>\n<p>Si accedemos a la administraci\u00f3n de nuestra tienda y hacemos click en \u00abHerramientas\u00bb tenemos una opci\u00f3n que dice \u00abImportar\u00bb.<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/importar1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-3045\" title=\"importar\" alt=\"\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/importar1.png\" width=\"938\" height=\"39\" srcset=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/importar1.png 938w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/importar1-300x12.png 300w\" sizes=\"auto, (max-width: 938px) 100vw, 938px\" \/><\/a><\/p>\n<p>All\u00ed podremos ver los excels de ejemplo de los campos necesarios para realizar la importaci\u00f3n.<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/ejemplos_importacion.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3046\" title=\"ejemplos_importacion\" alt=\"\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/ejemplos_importacion.png\" width=\"304\" height=\"203\" srcset=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/ejemplos_importacion.png 304w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/ejemplos_importacion-300x200.png 300w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/a>Como vemos esta herramienta nos permite importar categor\u00edas, productos, combinaciones (atributos), clientes, direcciones, fabricantes y proveedores.<\/p>\n<p>En este art\u00edculo veremos como ejemplo la importaci\u00f3n de productos.<\/p>\n<p>La tarea compleja o m\u00e1s bien tediosa es la de rellenar los excels con la informaci\u00f3n necesaria ya que una vez tengamos el archivo rellenado solo tendremos que cargarlo.<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3047\" title=\"paso1\" alt=\"\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso1.png\" width=\"640\" height=\"184\" srcset=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso1.png 640w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso1-300x86.png 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a>Una vez cargada el siguiente paso es indicar los detalles de la importaci\u00f3n:<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3048\" title=\"paso2\" alt=\"\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso2.png\" width=\"592\" height=\"361\" srcset=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso2.png 592w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso2-300x182.png 300w\" sizes=\"auto, (max-width: 592px) 100vw, 592px\" \/><\/a>Simplemente tendremos que seleccionar que queremos importar, el archivo csv que contiene la informaci\u00f3n, el idioma, etc.<\/p>\n<p>Si hacemos click en el bot\u00f3n \u00abPr\u00f3ximo paso\u00bb veremos la siguiente pantalla:<\/p>\n<p><a href=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3049\" title=\"paso3\" alt=\"\" src=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso3.png\" width=\"946\" height=\"302\" srcset=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso3.png 946w, https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/06\/paso3-300x95.png 300w\" sizes=\"auto, (max-width: 946px) 100vw, 946px\" \/><\/a>En esta pantalla estamos visualizando el contenido del excel o mejor dicho las columnas que deberemos asociar con los campos de la base de datos del Prestashop.<\/p>\n<p>Cuando hayamos realizado todas las asociaciones simplemente debemos hacer click en \u00abImportar datos CSV\u00bb y en un momento tendremos todos nuestros productos en la base de datos.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Prestashop dispone de una herramienta fundamental para importar datos de un excel en formato CSV. Si accedemos a la administraci\u00f3n de nuestra tienda y hacemos click en \u00abHerramientas\u00bb tenemos una opci\u00f3n que dice \u00abImportar\u00bb. All\u00ed podremos ver los excels de ejemplo de los campos necesarios para realizar la importaci\u00f3n. Como vemos esta herramienta nos permite [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4967,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[103],"class_list":["post-3040","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-prestashop","tag-archivos"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Importar datos con excel en Prestashop - Jose Aguilar Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importar datos con excel en Prestashop - Jose Aguilar Blog\" \/>\n<meta property=\"og:description\" content=\"Prestashop dispone de una herramienta fundamental para importar datos de un excel en formato CSV. Si accedemos a la administraci\u00f3n de nuestra tienda y hacemos click en \u00abHerramientas\u00bb tenemos una opci\u00f3n que dice \u00abImportar\u00bb. All\u00ed podremos ver los excels de ejemplo de los campos necesarios para realizar la importaci\u00f3n. Como vemos esta herramienta nos permite [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/\" \/>\n<meta property=\"og:site_name\" content=\"Jose Aguilar Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/joseaguilarblog\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-17T20:02:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-10-20T19:48:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/09\/prestashop1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"250\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jose Aguilar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:site\" content=\"@JoseAguilarBlog\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jose Aguilar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/\",\"name\":\"Importar datos con excel en Prestashop - Jose Aguilar Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/09\/prestashop1.jpg\",\"datePublished\":\"2012-06-17T20:02:47+00:00\",\"dateModified\":\"2013-10-20T19:48:42+00:00\",\"author\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#primaryimage\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/09\/prestashop1.jpg\",\"contentUrl\":\"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/09\/prestashop1.jpg\",\"width\":250,\"height\":250},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/www.jose-aguilar.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importar datos con excel en Prestashop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#website\",\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/\",\"name\":\"Jose Aguilar Blog\",\"description\":\"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11\",\"name\":\"Jose Aguilar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g\",\"caption\":\"Jose Aguilar\"},\"description\":\"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.\",\"sameAs\":[\"https:\/\/plus.google.com\/114357189801512615537\"],\"url\":\"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importar datos con excel en Prestashop - Jose Aguilar Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"es_ES","og_type":"article","og_title":"Importar datos con excel en Prestashop - Jose Aguilar Blog","og_description":"Prestashop dispone de una herramienta fundamental para importar datos de un excel en formato CSV. Si accedemos a la administraci\u00f3n de nuestra tienda y hacemos click en \u00abHerramientas\u00bb tenemos una opci\u00f3n que dice \u00abImportar\u00bb. All\u00ed podremos ver los excels de ejemplo de los campos necesarios para realizar la importaci\u00f3n. Como vemos esta herramienta nos permite [&hellip;]","og_url":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/","og_site_name":"Jose Aguilar Blog","article_publisher":"https:\/\/www.facebook.com\/joseaguilarblog","article_published_time":"2012-06-17T20:02:47+00:00","article_modified_time":"2013-10-20T19:48:42+00:00","og_image":[{"width":250,"height":250,"url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/09\/prestashop1.jpg","type":"image\/jpeg"}],"author":"Jose Aguilar","twitter_card":"summary_large_image","twitter_creator":"@JoseAguilarBlog","twitter_site":"@JoseAguilarBlog","twitter_misc":{"Escrito por":"Jose Aguilar","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/","url":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/","name":"Importar datos con excel en Prestashop - Jose Aguilar Blog","isPartOf":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#primaryimage"},"image":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/09\/prestashop1.jpg","datePublished":"2012-06-17T20:02:47+00:00","dateModified":"2013-10-20T19:48:42+00:00","author":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11"},"breadcrumb":{"@id":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#primaryimage","url":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/09\/prestashop1.jpg","contentUrl":"https:\/\/www.jose-aguilar.com\/blog\/wp-content\/uploads\/2012\/09\/prestashop1.jpg","width":250,"height":250},{"@type":"BreadcrumbList","@id":"https:\/\/www.jose-aguilar.com\/blog\/importar-datos-con-excel-en-prestashop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/www.jose-aguilar.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Importar datos con excel en Prestashop"}]},{"@type":"WebSite","@id":"https:\/\/www.jose-aguilar.com\/blog\/#website","url":"https:\/\/www.jose-aguilar.com\/blog\/","name":"Jose Aguilar Blog","description":"Desarrollo Web con PrestaShop, WordPress, PHP, jQuery y Ajax","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.jose-aguilar.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/e6d485db1e1140866e95971d17105d11","name":"Jose Aguilar","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.jose-aguilar.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/abbfef5f1d75260c549d0f2c2842bb697ba1aadff3b2836b39d2590c8a625415?s=96&d=mm&r=g","caption":"Jose Aguilar"},"description":"Director ejecutivo y tecnol\u00f3gico en JA Modules. Experto programador PrestaShop y Experto programador WordPress.","sameAs":["https:\/\/plus.google.com\/114357189801512615537"],"url":"https:\/\/www.jose-aguilar.com\/blog\/author\/josea902\/"}]}},"_links":{"self":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/3040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/comments?post=3040"}],"version-history":[{"count":0,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/posts\/3040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media\/4967"}],"wp:attachment":[{"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/media?parent=3040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/categories?post=3040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jose-aguilar.com\/blog\/wp-json\/wp\/v2\/tags?post=3040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}