Saturday, March 24, 2012

PrestaShop module - Agile PrestaShop Showcase module 1.0 released has released a new module - Agile PrestaShop showcase manager module. This module will help PrestaShop owner to promote their online store and your business by displaying showcases.

Agile Prestashop Showcases manager module

Main features
- Customer can list or submit his business or website as showcase at your online PrestaShop store, as long as they have purchased your products or service from you PrestaShop store.
- There will be latest showcase block to display on left column or right column based on your configuration of the Agile PrestaShop showcases manager module.
- There is a showcase list will list all showcase submitted with brief information
- The showcases list can be easily filtered out by products or services that provided at your Prestashop store.
- Each showcase will need admin to approve it  before it will be appear on front store.
- You can set a limit the number of showcases to be submitted by one customer to prevent spam.
- There is also a capcha to verify customer input to prevent spam post of showcases
- Admin is able to modify each field data of each the showcase at back office admin tab
- The following information is included in the showcase

site name/business
website url
website screen image
country/region (display with a flag and name
description of site/business
products or services used (multiple selection)
comment/reviews about the products used
For more information, please visit the product page - Agile PrestaShop Showcase Manager
You can see live demo and purchase this module at

Here are some screenshots
Showcase submit form

Showcase detailed

Showcase details at back office

Showcase approval and list at back office

Showcase list and latest showcase block

Saturday, March 10, 2012

PrestaShop Tips - Order date is empty at back office with error - Undefined index: date_format_full

If you have installed the latest version of PrestaShop 1.4.7, you may encounter following issue.

1. At back office Orders tab you will find the order date are empty in the list
2. At order details page, all date fields are left as empty
3. If you set "display_errors" to "on" in /config/, you will find following errors

Notice: Undefined index: date_format_full in ....\www\prestashop\christophe\classes\Tools.php on line 495

If this issue happened at your store, it indicated that your store was not installed correctly. Some data fields in database are missed. See below highlighted in red.

How to fix the problem?
In order to fix this problem you will need to add those missing field to database.

You can run following scripts to fix the issue.

ALTER TABLE `ps_lang` ADD `date_format_lite` char(32) NOT NULL DEFAULT 'Y-m-d' AFTER language_code;
ALTER TABLE `ps_lang` ADD `date_format_full` char(32) NOT NULL DEFAULT 'Y-m-d H:i:s' AFTER date_format_lite;
UPDATE `ps_lang` SET `date_format_lite` = 'd/m/Y' WHERE `iso_code` IN ('fr', 'es', 'it');
UPDATE `ps_lang` SET `date_format_full` = 'd/m/Y H:i:s' WHERE `iso_code` IN ('fr', 'es', 'it');
UPDATE `ps_lang` SET `date_format_lite` = 'd.m.Y' WHERE `iso_code` = 'de';
UPDATE `ps_lang` SET `date_format_full` = 'd.m.Y H:i:s' WHERE `iso_code` = 'de';
UPDATE `ps_lang` SET `date_format_lite` = 'm/d/Y' WHERE `iso_code` = 'en';
UPDATE `ps_lang` SET `date_format_full` = 'm/d/Y H:i:s' WHERE `iso_code`= 'en';

After you run the script. the problem should be fixed.