Search the Community

Olá, trago um manual em Português sobre o motor de template Smarty, usada pelo Prestashop e outros sistemas na internet, os famosos arquivos .tpl. O manual traz fundamentos básicos, um glossário de suas propriedades, e também uma listagem variada de exemplos. Bem útil para quem quer aprender a usar estruturas condicionais, associativas, indices e objetos do Smarty vinculadas a módulos instalados ou próprios. Aconselho a estudar a estrutura modular do Prestashop, os principais métodos de um módulo e o fluxo de dados até chegar na definição(assign) das variaveis smarty. Manual Smarty 2.6 PT-BR manual-pt_BR-2.6.pdf obs: os créditos foram mantidos no arquivo Para mais informações: http://www.smarty.net/ Espero ter ajudado.

Sou novo no fórum e também na utilização do PrestaShop. Hoje trabalho com uma ferramenta de e-commerce própria, que já têm 3 anos, mas desejo migrar para Presta pela questão das funcionalidades, flexibilidade e ótimas recomendações. Por este motivo preciso aprender a desenvolver em Presta, mas como meu inglês é horrível, pergunto se há documentação em português para a criação de template e módulo? Já agradeço a ajuda e no que eu conseguir auxiliar, fiquem a vontade em perguntar. Att., Maurício Santos

Hello, I'm looking for a manual to program with prestashop. There is a manual for beginer user but that isn't what I want. I want to customize some pages and use content from a module to another. Bonjour, je suis à la recherche d'un guide de développement prestashop. Le guide utilisateur est disponible mais pour aller plus loin c'est à dire ajouter des champs sur certaines pages produits... récupérer le contenu d'un module vers un autre , j'ai besoin de mieux connaitre les classes sur lesquels agir. je travaille avec la version 1.5 de prestashop. Merci

Hello, I have a dev version of my current shop wich i want to upgrade. The upgrade went succesful because i can login to backoffice etc page is showing,, some theme errors but that i have to fix.. but the outputed XML for the SQL queries showed some failed items. Now i wonder if this is good or not. Also I have to mention that i did 2 manual upgrades the first was in chrome but then power went off... so then i edited the config file again to 1.5.2 and run the manual update again showing this: <?xml version="1.0" encoding="UTF-8"?><action result="fail" error="34"> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[sET NAMES 'utf8']]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[/* PHP:outstanding_allow_amount1530(); */]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[/* PHP:blocknewsletter1530(); */]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[/* PHP:block_category_1521(); */]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[/* PHP:update_order_messages(); */]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[uPDATE `ps_order_state` SET `delivery` = 0 WHERE `id_order_state` = 3]]></sqlQuery> </request> <request result="fail" sqlfile="1.5.3.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_product_shop` ADD `id_product_redirected` int(10) unsigned NOT NULL default '0' AFTER `active`]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'id_product_redirected']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="fail" sqlfile="1.5.3.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_product` ADD `id_product_redirected` int(10) unsigned NOT NULL default '0' AFTER `active`]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'id_product_redirected']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[uPDATE `ps_order_state` SET `send_email` = 1 WHERE `id_order_state` = (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_OS_WS_PAYMENT' LIMIT 1)]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[uPDATE `ps_order_state_lang` SET `template` = 'payment' WHERE `id_order_state` = (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_OS_WS_PAYMENT' LIMIT 1)]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[DELETE FROM `ps_configuration` WHERE `name`= 'PS_HIGH_HTML_THEME_COMPRESSION']]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[iNSERT INTO `ps_configuration`(`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_MAIL_COLOR', '#db3484', NOW(), NOW())]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[ALTER TABLE `ps_order_cart_rule` CHANGE `name` `name` VARCHAR(254)]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[ALTER TABLE `ps_cart` CHANGE `delivery_option` `delivery_option` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL]]></sqlQuery> </request> <request result="fail" sqlfile="1.5.3.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_currency_shop` ADD `conversion_rate` DECIMAL( 13, 6 ) NOT NULL]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'conversion_rate']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[uPDATE `ps_currency_shop` a SET `conversion_rate` = (SELECT `conversion_rate` FROM `ps_currency` b WHERE a.id_currency = b.id_currency)]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[iNSERT INTO `ps_configuration`(`name`, `value`, `id_shop`, `id_shop_group`, `date_add`, `date_upd`) (SELECT 'PS_GIFT_WRAPPING_TAX_RULES_GROUP', b.`id_tax_rules_group`, a.`id_shop`, a.`id_shop_group`, NOW(), NOW() FROM `ps_configuration` a JOIN `ps_tax_rule` b ON (a.value = b.id_tax) WHERE a.name='PS_GIFT_WRAPPING_TAX' GROUP BY a.`id_shop`, a.`id_shop_group` )]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.0"> <sqlQuery><![CDATA[DELETE FROM `ps_configuration` WHERE name='PS_GIFT_WRAPPING_TAX']]></sqlQuery> </request> <request result="fail" sqlfile="1.5.3.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_cart_rule` ADD `highlight` tinyint(1) unsigned NOT NULL default 0 AFTER `gift_product_attribute`]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'highlight']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="ok" sqlfile="1.5.3.1"> <sqlQuery><![CDATA[sET NAMES 'utf8']]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.1"> <sqlQuery><![CDATA[/* PHP:p1531_redirect_type(); */]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.3.1"> <sqlQuery><![CDATA[ALTER TABLE `ps_cart` CHANGE `delivery_option` `delivery_option` TEXT NOT NULL]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[sET NAMES 'utf8']]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[/* PHP:update_customer_default_group(); */]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_meta` SET `page` = 'supplier' WHERE `page` = 'supply']]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[ALTER TABLE `ps_image_type` CHANGE `name` `name` VARCHAR( 64 ) NOT NULL]]></sqlQuery> </request> <request result="fail" sqlfile="1.5.4.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_customer` ADD `id_lang` INT UNSIGNED NULL AFTER `id_default_group`]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'id_lang']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_customer` SET id_lang = (SELECT `value` FROM `ps_configuration` WHERE name = 'PS_LANG_DEFAULT' LIMIT 1)]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_customer` c, `ps_orders` o SET c.id_lang = o.id_lang WHERE c.id_customer = o.id_customer]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_quick_access` SET `link` = 'index.php?controller=AdminCartRules&addcart_rule' WHERE `link` = 'index.php?tab=AdminDiscounts&adddiscount']]></sqlQuery> </request> <request result="fail" sqlfile="1.5.4.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_order_cart_rule` ADD `free_shipping` tinyint(1) NOT NULL DEFAULT 0 AFTER `value_tax_excl`]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'free_shipping']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_order_cart_rule` ocr, `ps_cart_rule` cr SET ocr.free_shipping = 1 WHERE ocr.id_cart_rule = cr.id_cart_rule AND cr.free_shipping = 1]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_orders` o, `ps_order_cart_rule` ocr SET o.`total_discounts` = o.total_discounts + o.`total_shipping_tax_incl`, o.`total_discounts_tax_incl` = o.`total_discounts_tax_incl` + o.`total_shipping_tax_incl`, o.`total_discounts_tax_excl` = o.`total_discounts_tax_excl` + o.`total_shipping_tax_excl` WHERE o.id_order = ocr.id_order AND ocr.free_shipping = 1]]></sqlQuery> </request> <request result="fail" sqlfile="1.5.4.0" > <sqlQuery><![CDATA[CREATE TABLE `ps_tab_module_preference` ( `id_tab_module_preference` int(11) NOT NULL auto_increment, `id_employee` int(11) NOT NULL, `id_tab` int(11) NOT NULL, `module` varchar(255) NOT NULL, PRIMARY KEY (`id_tab_module_preference`), UNIQUE KEY `employee_module` (`id_employee`, `id_tab`, `module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8]]></sqlQuery> <sqlMsgError><![CDATA[Table 'ps_tab_module_preference' already exists]]></sqlMsgError> <sqlNumberError><![CDATA[1050]]></sqlNumberError> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[/* PHP:add_new_tab(AdminMarketing, es:Marketing|it:Marketing|en:Marketing|de:Marketing|fr:Marketing, 1); */]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[ALTER TABLE `ps_stock_available` DROP INDEX `product_sqlstock`]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[ALTER TABLE `ps_stock_available` ADD UNIQUE `product_sqlstock` (`id_product`, `id_product_attribute`, `id_shop`, `id_shop_group`)]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE ps_configuration SET `value` = '8388608' WHERE `name` = 'PS_PRODUCT_PICTURE_MAX_SIZE' AND `value` <= '524288']]></sqlQuery> </request> <request result="fail" sqlfile="1.5.4.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_guest` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'mobile_theme']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="fail" sqlfile="1.5.4.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_orders` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0 AFTER `gift_message`]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'mobile_theme']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="fail" sqlfile="1.5.4.0" > <sqlQuery><![CDATA[ALTER TABLE `ps_cart` ADD `mobile_theme` tinyint(1) NOT NULL DEFAULT 0 AFTER `gift_message`]]></sqlQuery> <sqlMsgError><![CDATA[Duplicate column name 'mobile_theme']]></sqlMsgError> <sqlNumberError><![CDATA[1060]]></sqlNumberError> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[ALTER TABLE `ps_address` CHANGE `phone` `phone` varchar(32) default NULL]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[ALTER TABLE `ps_address` CHANGE `phone_mobile` `phone_mobile` varchar(32) default NULL]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[/* PHP:update_genders_images(); */]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_customer` SET `id_gender` = 1 WHERE `email` LIKE '[email protected]' AND `id_customer` = 1 AND `id_gender` = 4]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_cart_rule_carrier` crc INNER JOIN `ps_carrier` c ON crc.`id_carrier` = c.`id_carrier` SET crc.`id_carrier` = c.`id_reference`]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[uPDATE `ps_order_payment` SET `order_reference` = LPAD(order_reference, 9 , '0')]]></sqlQuery> </request> <request result="ok" sqlfile="1.5.4.0"> <sqlQuery><![CDATA[/* PHP:p1540_add_missing_columns(); */]]></sqlQuery> </request> </action> as you can see many items are OK but some also failed.. is this a problem and how can i fix it? should i run the queries in PHPmyAdmin?

Hello, I have the problem that my host has limited the number of fields to post in a form, so the BO translation won't work. (Error: 2218 for max_input_vars) How can I work around this? For some reason, my homefeatured displays "New items", and I would like it to display "Featured items", as it ought to. Anyone got an idea how and where to manually edit the language files? Thanks in advance for your help! Dan

Hola. Me gustaría saber que archivo hay que editar para modificar el nombre “News Product” que aparece en la página de inicio. Esta es mi web http://tiendapapelesycosas.hol.es. Gracias.

Hola. Quisiera saber como poder traducir algunos apartados y módulos de mi web manualmente, ya que automáticamente se deja cosas sin traducir. Esta es mi pagina web http://tiendapapelesycosas.hol.es Lo que quiero traducir es en el menú de arriba donde pone “HOME”, también quiero traducir donde pone “News Product”. También quiero traducir el texto que sale cuando te vas a registrar donde “Privacidad de los datos de los clientes” Otro problema que tengo es que el logo de arriba se me corta y ponga la medida que ponga siempre se me corta. Existe algún modo de modificar algún archivo y darle medidas? Gracias.

Hola Gente: les hago una consulta sencilla que no encontré como resolver. Hasta la version 1.4.x se podia ordenar a mano arrastrando desde el backoffice a los productos en la lista para ordenarlos de forma manual como uno queria que aparecieran en el front office. Esto como se hace en 1.5.x para ordenarlo? no quiero simplemente ordenar por precio, sino usar un criterio distinto de ordenamiento Alguien sabe como solucionar eso?? muchas gracias a todos!

I'm trying to do a manual upgrade from 1.4.6.2 to 1.5.2.0 and the first error of hundreds has to have something with the renaming of group_shop to shop_group. In 1.5.0.0.sql the upgrade script is trying to create group_shop like this: CREATE TABLE IF NOT EXISTS `PREFIX_group_shop` ( `id_group_shop` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8 NOT NULL, `share_customer` TINYINT(1) NOT NULL, `share_order` TINYINT(1) NOT NULL, `share_stock` TINYINT(1) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '1', `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id_group_shop`) ) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8; And on the next line it tries to insert some data: INSERT INTO `PREFIX_group_shop` (`id_group_shop`, `name`, `active`, `deleted`, `share_stock`, `share_customer`, `share_order`) VALUES (1, 'Default', 1, 0, 0, 0, 0); And I get this error: Unknown column 'id_group_shop' in 'field list' It looks like the 1.5.0.10.sql script is runned before the 1.5.0.0.sql script or something, because in 1.5.0.10.sql we have this: CREATE TABLE `PREFIX_group_shop` ( `id_group` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_group`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=ENGINE_TYPE DEFAULT CHARSET=utf8; That could explain why id_group_shop is not in field list.

Hola, Quiero hacer una actualización del 1.4.7 al 1.4.9 pero al finalizar la actualización tanto el frontend como el backend han perdido los CSS, js, etc. A mí lo más que me sorprende es que ocurra en el Backend. El objetivo de la actualización manual es limpiar un poco con la instalación nueva y sólo pasar lo necesario. gracias,

Where is the best place to start for me to build my own themes - can somebody point me to the URL with the kind of information I will need to do this please. Many thanks

Muchas gracias nadie. ¿Hay algún tutorial para eliminar el slider que ya está, e instalar el que me comentas (incluyendo si tiene que instalarse además el Módulo Flash Image Rotator, o sólo el nuevo slider)? Llevo ya días moviéndole a la tienda y ya está lista para subir mis productos, no quisiera cometer un error y tener que borrarla de nuevo. PD. Esto lo pregunté en otro tema, pero supongo que al ser un planteamiento de otra naturaleza, debe estar en un post diferente. Saludos a esta gran comunidad.

Buenas tardes, ¿Existe algún módulo que permita editar manualmente albaranes y facturas? Es decir, que no tengan que ser generadas sólo desde una compra a través del carrito de la página. A veces, puede llegarte un pedido a través de un correo electrónico o que un cliente tenga problemas para hacer el pedido online por la causa que sea y necesite hacerlo ya, y me gustaría poder enviar las facturas y albaranes con el mismo formato que las que se generan a través del carrito. Muchas gracias.