kenkomuri
Members-
Posts
114 -
Joined
-
Last visited
Profile Information
-
Location
Mexico
-
Activity
Project Owner
kenkomuri's Achievements
Newbie (1/14)
2
Reputation
-
Buen día, Los puntos del módulo de fidelidad se encuentran siempre en estado "en espera de validación" aún cuando cambia el estado a Enviado que se supone debe de cambiar el estado de los puntos a disponibles. Como alternativa he creado 2 queries en SQL: #Acreditar UPDATE pr_loyalty as lo INNER JOIN pr_orders as ord ON lo.id_order = ord.id_order SET lo.id_loyalty_state = 2 WHERE ord.current_state = 4 AND (lo.id_loyalty_state = 3 OR lo.id_loyalty_state = 1); COMMIT; #Cancelar UPDATE pr_loyalty as lo INNER JOIN pr_orders as ord ON lo.id_order = ord.id_order SET lo.id_loyalty_state = 3 WHERE ord.current_state = 6 AND (lo.id_loyalty_state = 2 OR lo.id_loyalty_state = 1); COMMIT; Sin embargo necesito crear un archivo php para dejarlo corriendo ambos en un cronjob y allí es dónde no he podido? Qué me recomiendan?
-
Left Column not displayed in mobile version
kenkomuri replied to kenkomuri's topic in 1.6.1.x [Current]
Yes, the modules are enabled in all devices. What else could do? -
Hi, I have the default template and the left column is showed in the computer version not in the mobile. URL: kenkomuri.com Prestashop 1.6.1.4 Hope you can help me, Thanks, Fer
-
Same problem. The left column are not displayed at homepage in mobile version URL: kenkomuri.com
-
Mail Alerts not showing on product page
kenkomuri replied to VajdaShark's topic in Ecommerce x PrestaShop [ARCHIVE BOARD]
I have the same issue when product has combinations. Any idea? -
Me gustaría saber si ustedes saben cual sería el código SQL para poder extraer las ventas y el inventario por cada combinación de cada producto, en caso de no tener combinación que coloque la misma información por producto. Yo tengo el siguiente para extraer las ventas: SELECT n.product_reference AS Referencia, n.`product_name` AS Producto, SUM(n.`product_quantity`) AS Cantidad, date_format(o.date_add, '%m/%Y') AS Fecha FROM `pr_orders` o LEFT JOIN `pr_order_detail` n ON n.`id_order` = o.`id_order` WHERE o.date_add BETWEEN '2015-09-01' AND '2016-01-31' AND o.current_state in (4,5) GROUP BY Producto, Referencia, Fecha ORDER BY Fecha, Referencia, Producto Me gustaría colocar una columna por cada mes y que juntara los productos por el id de combinación y no por el código de la combinación, esto debido a que pudo ser cambiado. Al lado de las ventas colocar el inventario para que quede con la estructura: Producto | Combinacion | Mes 1 | Mes 2 | Mes 3 | Inventario Muchas gracias por su ayuda,
- 3 replies
-
- ventas
- inventario
-
(and 1 more)
Tagged with:
-
Image thumbnails missing from BO products list.
kenkomuri replied to Flipmode's topic in Configuring and using PrestaShop
I have a similar problem but the image is wrong. Is the image that used to be there but I updated all the images and no changes were reflected in the thumbnail in the product list.- 17 replies
-
- back office
- images
-
(and 2 more)
Tagged with:
-
Im using the latest version of Prestashop 1.6.1.4 and I am using USD as default currency in the backend (Importe products with cost in USD) of the store but I would like to use MXN (mexican peso) in the front end. Also I would like that PayPal module takes the MXN as input but in the website where is displayed the amount of the order is changed to USD taking into account the currency rate of Prestashop NOT PayPal.
-
Different default currency for front and back offices?
kenkomuri replied to tazan's topic in Configuring and using PrestaShop
I need to do the same -
Hi buddies, I have uninstalled the default cross selling module after some issues with it. I have tried to reinstall it but an error appears, it seems is corrupted. Does anybody has the module for PS 1.6.1.1? Is there another free cross selling module available? Thank you
-
Is possible to avoid the error with debug mode enabled?
-
Hi folks, I have a issue with prestashop 1.6.1.1 since my upgrade from 1.5. The images of the categories are displayed in the category/subcategory page and used as background. This causes the description can not be shown as the font is white also the background. I tried to delete the image category/subcategory but when I go to the parent category the image is not displayed. My goal is to show the description in the category/subcategory without deleting the small subcategories thumbnails. Thank you
-
Buen día, Me he dado cuenta que en ocasiones el precio que muestra en USD es erroneo. Por ejemplo en la imagen aparecen 108.93 USD cuando deberían ser 14.88 USD tal cual aparece en el carrito al hacer el check out mostrado en la segunda imagen. Incorrecto en la página del producto Correcto en el carrito