Solution: http://www.prestashop.com/forums/topic/271091-images-not-showing-after-upgrading-1550
Preferences > Images
1) Set Use the legacy image filesystem to YES
2) Click Move images
Wait for the process to complete.
3) Set Use the legacy image filesystem back to NO
Should solve the problem of missing images.
DB tables created with a collation different than the database collation
http://www.prestashop.com/forums/topic/363458-fresh-install-doesnt-prestashop-respect-the-existing-database-collation/
Solution: http://forge.prestashop.com/browse/PSCSX-3486
Two good sites to optimize large animated gif files
https://compressor.io/compress
http://ezgif.com/optimize
Apply Quantity Discounts across all products in a category
Prestashop 1.2 – 1.3 Source: http://www.prestashop.com/forums/topic/75558-mod-quantity-discounts-for-all-the-products-in-the-same-default-category/
Prestashop 1.4 – 1.6 Source: http://www.prestashop.com/forums/topic/140803-free-module-category-quantity-discount-apply-quantity-discounts-across-all-products-in-a-category/
Quantity discount is calculated based on the price of product. For promotion mechanics below, if we use the built-in sale price function for 1 product, the quantity discount will be calculated based on the discounted price of 1 product.
Purchase 1 items 10% off
Purchase 2 items 15% off
Purchase 3 items 20 % off
Purchase 4 items 25 % off
Purchase 5 items 30% off
Purchase 6 items 35% off
So we disable the admin check for minimum more than 1 quantity in order to allow creating quantity discount % for purchase of 1 product.
change: admin/tabs/AdminProducts.php
elseif (!($quantity_discount = intval(Tools::getValue(‘quantity_discount’))) OR $quantity_discount <= 1) $this->_errors[] = Tools::displayError(‘quantity is required and must be superior of 1’);
to
elseif (!($quantity_discount = intval(Tools::getValue(‘quantity_discount’))) OR $quantity_discount <= 0) $this->_errors[] = Tools::displayError(‘quantity is required and must be superior of 0’);
10–35 gsm tissue paper
35–70 gsm lighter textweight
70–100 gsm medium textweight
100–120 gsm heavy textweight/light cardstock
120-150 gsm regular cardstock
150-200 gsm heavy cardstock
>200 gsm super heavy cardstock
Source: https://answers.yahoo.com/question/index?qid=20080715103223AARVYHb
Microsoft excel can’t seem to export csv with double quotes anymore =_=, can’t import csv directly using phpmyadmin.
Found this really site that helps to make the conversion from csv to mysql statements.
http://www.convertcsv.com/csv-to-sql.htm
http://stackoverflow.com/questions/6115612/how-to-convert-an-entire-mysql-database-characterset-and-collation-to-utf-8
Use the ALTER DATABASE and ALTER TABLE commands.
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
If not possible,
Export structure and data with phpmyadmin
Custom – display all possible options
Database system or older MySQL server to maximize output compatibility with: MYSQL40
Syntax to use when inserting data: include column names in every INSERT statement (Example: INSERT INTO tbl_name (col_A,col_B,col_C) VALUES (1,2,3))
After export, remove all TYPE=InnoDB from the text file (.sql)
Create new database in utf8_unicode_ci;
Import the .sql file and tables created will inherit utf8_unicode_ci.
Source: http://www.theexceladdict.com/_t/t031008.htm
Change number to text
Format Cells > Number > Custom > 0
Suppose you receive a list of data that contains blank rows that you want to remove without affecting the order of the list. This technique will allow you to delete all rows that have blank cells in a particular column. Here’s the fastest way to do it.
Source: http://www.prestashop.com/forums/topic/9473-module-force-currency/
Note: Error in amount shown in store owner email but is correct in customer email. Use with caution.
in init.php before:
$currency = Tools::setCurrency();
add:
$cookie->id_currency = intval(Configuration::get(‘PS_CURRENCY_FRONT_DEFAULT’));
in admin/tabs/AdminCurrencies.php after:
‘PS_CURRENCY_DEFAULT’ => array(‘title’ => $this->l(‘Default currency:’), ‘desc’ => $this->l(‘The default currency used in shop’), ‘cast’ => ‘intval’, ‘type’ => ‘select’, ‘identifier’ => ‘id_currency’, ‘list’ => Currency::getCurrencies()),
add:
‘PS_CURRENCY_FRONT_DEFAULT’ => array(‘title’ => $this->l(‘Default currency front:’), ‘desc’ => $this->l(‘The default currency used in front shop’), ‘cast’ => ‘intval’, ‘type’ => ‘select’, ‘identifier’ => ‘id_currency’, ‘list’ => Currency::getCurrencies()),
Next go to admin->payment->currencies and set up your default shop currency. Customer CAN change the currency if needed.
Go to the plugin page hosted at wordpress.org
https://wordpress.org/plugins
Click on the Developer tab and you’ll find the list of previous releases.
