Search the Community

Hi , I would like set Default: Allow orders as selected value for all the products in my online shop. I just enable the stock management in prestashop, and found that half of my products is defaulted to "deny order" and another half is defaulted to Default: Allow orders . Is there any way to update the table column to solve this issue? kindly please provide guidance sql guidance update these column. version : PrestaShop™ 1.5.6.0

Hola Comunidad Prestashop!, Actualmente tengo una tienda prestashop, hasta ahora todo ha funcionado de maravilla y si tengo un error siempre consigo las soluciones en su foro, pero actualmente quisiera aportar una inquietud que tengo ya que quiero IMPRIMIR los invoices por orden de ubicación de mis productos me explico, Actualmente la ubicación de mis productos están en la tabla: 'ps_product' columna 'supplier_reference' y 'location' el cual se muestra justo al lado de columna 'reference' del producto en todas mis facturas, anexo una fotografía para dar a entender, Donde la referencia del artículo es 1511133, y la ubicación es: 0A16JB1, yo quiero que mis facturas a la hora de imprimirlo masivamente por estado NO se generen por FECHA o el orden que esto esté llevando, quiero que esta función me genere el archivo invoices.pdf ordenado por la ubicación de mis artículos, la opción que uso para generar masivamente los invoices es esta: He intentado hacer muchos cambios y todos sin éxitos, he visto otros hilos que hablan del mismo tema y creo que están desactualizados, a continuación anexaré los datos de mi prestashop, Agradecido por el foro y sus integrantes por mi anterior post que junto a ustedes hemos podido resolver la anterior incidencia, aquí un nuevo reto!, espero vuestras respuestas.

I recently upgraded to 1.5.4 and discovered a bug regarding the "Reference" that you edit on the Product Information tab. Specifically, if your product has combinations and you edit Reference in the back end the changes don't get made in the front end on your product page. For example, when duplicating a product with combinations the Reference is copied and a Reference field can be found in these two sql tables: ps_product ps_product_attribute However, when you edit Reference for the product under the Catalog > Products > Edit > Information Tab the Reference field is only updated in the ps_product table and it is not updated in the ps_product_attribute table. Therefore all the combinations on your Product page include the incorrect duplicated Reference and that also ends up incorrectly in the shopping cart. The same problem even exists when you create a new product with combinations instead of duplicating one. If you later decide to change the Reference it is only updated in the ps_product table and is not updated in the ps_product_attribute table. So somewhere in the back end coding a change needs to be made to not only update the Reference field in the ps_product table but also in the ps_product_attribute table by finding all attributes associated with a specific Product ID. I'm hoping someone's noticed this before me and knows a solution but I couldn't find anything when searching the forums. Btw, a similar problem exists with the Quantity field also not being updated in the ps_product_attribute table but I'll leave that for another post.

Hi, just upgraded my shop (in test) to version 1.6. All went smooth but when wanting to view the produtcts in the backoffice, Prestashop throws me an error in the face about table 'ps_product' not found. Yes I cleared my history and cookies. Yes I tried it in a different browser. Below the SQL statement after switching on debug mode. Anyone a clue? Thanks in advance!!

Ciao, ho aggiunto due nuovi campi nella tabella ps_product, che devo gestire da back office ( vedi file allegato), sono due % che applicate al prezzo di acquisto dovrebbero calcolarmi in automatico il prezzo di vendita senza tasse. % sconto su prezzo acquisto % ricarico Non conoscendo bene il linguaggio java non so come devo scrivere la funzione per il calcolo e dove la devo richiamare per proporre in automatico il valore. var price_whls = parseFloat(document.getElementById('wholesale_price').value.replace(/,/g, '.')); var disco_whls = parseFloat(document.getElementById('discount_whls').value.replace(/,/g, '.')); var mark_perc = parseFloat(document.getElementById('markup').value.replace(/,/g, '.')); var prix1 = price_whls/100 * disco_whls; var pr1x2 = price_whls - prix1; var prix3 = prix2/100 * mark_perc; var price_fin = prix2 + prix3; il valore della var price_fin è il valore finale che deve essere memorizzato nella variabile price: prezzo di vendita senza iva. Qualcuno di voi potrebbe aiutarmi a scrivere correttamente la funzione? Versione PS: 1.5.6.0 Vi ringrazio in anticipo ! Angela back_office.bmp

Bonjour à tous, D'abord un grand Merci à l'équipe prestashop pour son formidable travail et aux membres actifs du forum qui aident les autodidactes comme nous à résoudre leurs petits et gros tracas Prestashopiens ! Notre boutique est en production suite à MAJ de 1.4.11 vers 1.5.5. avec 1-click-upgrade. Actuellement en mode maintenance, car nous souhaitions corriger les "petits bugs" liés aux réductions par quantité sur certains produits avant de ré-ouvrir la boutique. Il est malheureusement impossible d'enregistrer quelque modification que ce soit sur les fiches produit, le message suivant apparaît : Une erreur s'est produite pendant la mise à jour de l'objet. product () Après recherches sur le web, nous avons essayé les solutions les plus proposées et cohérentes : Sur le forum anglais ils conseillent d'aller sous MYSQL: Yes, use MyPHPAdmin, go to your database, choose SQL tab and paste this: alter table ps_product add column redirect_type int (10) ; alter table ps_product_shop add column redirect_type int (10) ; then click GO button on the bottom right. Sur le forum français, openpresta conseille, également sous MySQL : ALTER TABLE `ps_product` ADD `id_product_redirected` INT NOT NULL ALTER TABLE `ps_product_shop` ADD `id_product_redirected` INT NOT NULL Ces deux manipulations n'ont apportées aucune solution sur cette version (cache vidé entre chaque phase de test). Nous joignons des impressions écran de PHPmyadmin pour que vous puissiez voir la configuration actuelle des tables ps_product et ps_product_shop En espérant qu'une âme charitable puisse rapidement nous venir en aide ;-) Merci de votre attention et bonne journée !

Bonjour, Désolé d'ouvrir un nouveau sujet juste pour ça mais, que contient exactement la colonne id_attribute de la table ps_product_attribute_combination ? Merci d'avance.

Hi, Server information Prestashop version: 1.4.6.2 > friendly URL enabled Server information: Linux #1 SMP Wed Jul 20 19:47:12 MSD 2011 x86_64 Server software version: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 PHP version: 5.2.17 MySQL version: 5.1.56 In Phpmyadmin some table sizes: ps_product_lang: 183 Mb / Rows:213,519 ps_search_index: 143 Mb / Rows:3,205,165 ps_product_tag: 71 MB / Rows:610,164 ps_search_word: 64 MB / Rows:665,284 ps_category_product: 18 Mb / Rows:186,405 ps_product: 15 Mb / Rows:37,352 For instance, ps_product_lang: in Prestashop I activated two languages in back office. Others disabled. 37.000 products published in one language. As you see, the table size 183 Mb. and runs 213,519 rows. ps_search_index, table 143 Mb and have more than 3 million rows I think in e-commerce, 37.000 product is not a big number for Prestashop. But website working too slow, giving 500 internal server errors (mostly importing .csv), Server Overload, cpu has been maxed out, reached 100% of the memory errors... They occured maybe because of these table sizes, cache sizes ... Do you think these table sizes normal? Could someone inform me whats wrong about these tables? Regards Aybars Note:In my website Prestashop collecting everything.Sample; my tools/smarty/cache folder 8.7 Gb. After cleaning up, a few days later its again 8,9,10 ... gigabyte. ((( (Force compile: No / Cache: Yes / Use cache: No)

Hello. I managed to update my shop from PS 1.3.6 to 1.4.5.1, everything went better than expected except for a custom report that I made, it shows some information about the current product list, like the product name, price, condition, quantity and some other information. One of them is "Reduction Price" that get the data from reduction_price field on ps_product table, but after upgrading to 1.4.5.1 I noticed that this field doesn't exist anymore and neither the field on the product edit page. This feature doesn't exists anymore or it's in another table? It has something to do with ps_group_reduction_cache table?