Jump to content

raymancz

Members
  • Posts

    6
  • Joined

  • Last visited

raymancz's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. Zkuste aj toto u mne to vyresilo problem o kterem tu pisete (nejprve v PS 1.4.9, pak i v PS 1.5.5.) /classes/Mail.php -------------------- riadok 96: if (!isset($from_name) || !Validate::isMailName($from_name)) OLD: $from_name = $configuration['PS_SHOP_NAME']; NEW: $from_name = "JmenoVasehoEshopu.cz"; http://forum.c4.cz/prestashop-spatny-odesilatel-v-mailu-zakaznikum-t3015.html
  2. Hi... I also had a problem with a Czech diacritics when I opened the csv in MS Excel! If I did the same csv file opened in OpenOffice, all diacritics are fine You need to edit the CSV file in OpenOffice, save the changes so that you save the document in CSV filter setting (UTF8 character set, field delimiter, and text delimiter ") After importing back into PrestaShop is ok accents ray
  3. Hi all, I have this script on SQL query to the database .. is with this in phpMyAdmin export all products in prestashop which must be placed into. CSV file with the following settings: UTF-8 fields enclosed by (") quotation marks, and separate fields (,) comma. The prestashop 1.4.9 I exported 6650 products. The prestashop 1.5.4.0 I exported all too I have a question for you. Can this script somehow edit, enhance, and to he could export the product image?? Code for Prestashop 1.4.9 SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category) LEFT JOIN ps_category c ON (cp.id_category = c.id_category) LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product) WHERE pl.id_lang = 1 AND cl.id_lang = 1 GROUP BY p.id_product Code for Prestashop 1.5.4 SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition, p.id_shop_default FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category) LEFT JOIN ps_category c ON (cp.id_category = c.id_category) LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product) WHERE pl.id_lang = 1 AND cl.id_lang = 1 AND p.id_shop_default = 1 AND c.id_shop_default = 1 GROUP BY p.id_product On the web I found that this can handle the command, but I can not work with it: concat(ifnull(conf.value,' '), '/img/p/', c.id_product, '.jpg') as url_image Thanks for the idea, Rayman
  4. I have this script on SQL query to the database .. is with this in phpMyAdmin export all products in prestashop which must be placed into. CSV file with the following settings: UTF-8 fields enclosed by (") quotation marks, and separate fields (,) comma. The prestashop 1.4.9 I exported 6650 products. The prestashop 1.5.4.0 I exported all too I have a question for you. Can this script somehow edit, enhance, and to he could export the product image?? Code for Prestashop 1.4.9 SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition, p.id_shop_default FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category) LEFT JOIN ps_category c ON (cp.id_category = c.id_category) LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product) WHERE pl.id_lang = 1 AND cl.id_lang = 1 GROUP BY p.id_product On the web I found that this can handle the command: concat(ifnull(conf.value,' '), '/img/p/', c.id_product, '.jpg') as url_image Code for Prestashop 1.5.4 SELECT p.id_product, p.active, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.price, p.id_tax_rules_group, p.wholesale_price, p.reference, p.supplier_reference, p.id_supplier, p.id_manufacturer, p.upc, p.ecotax, p.weight, p.quantity, pl.description_short, pl.description, pl.meta_title, pl.meta_keywords, pl.meta_description, pl.link_rewrite, pl.available_now, pl.available_later, p.available_for_order, p.date_add, p.show_price, p.online_only, p.condition FROM ps_product p LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product) LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product) LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category) LEFT JOIN ps_category c ON (cp.id_category = c.id_category) LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product) WHERE pl.id_lang = 1 AND cl.id_lang = 1 AND p.id_shop_default = 1 AND c.id_shop_default = 1 GROUP BY p.id_product Thanks for the idea, Rayman
  5. This is cool I work in prestashop 1.4.3, 1.4.7 and 1.5.1 for the first test MS Excel has no problem ) thx
  6. cvs order export must be opened in open office with UTF-8 really - thanx @Falgener
  7. Hi, I just have got donated version of export_orders_nvn, but in export its does not show Czech characters right. Can u help me pls? Thanx
  8. zdravim... muze byt problem na hostingu se souborem .htaccess, nektere hostingy jej generuji pri zalozeni a nektere prestoze na serveru je, ho ignoruji, dokud se nepovoli v adminu hostingu na serveru.. predevcirem jsem to resil take pak jsem souboru nastavil prava 777 a vygeneroval v adminu Prestashopu ten spravny ktery smeruje odkazy tam kam ma..
  9. zdravím, už jste počeštil?? budto bude nutne lokalizovat celou sablonu do cs.php v jejim adresari anebo jde o samotne moduly dostupne v prestashop, ty se prelozi v lokalizaci v nastaveni.. nebo si muzete pridat modul do nejz vlozite vse potrebne, napr. i odkazy atd... http://www.premium-templates.eu/cs/free-prestashop-modules-and-templates/28-footer-editor.html
  10. Zdravím, jde o problem hostingu, to je zrejme... kby jsem mohl pomoci, staci mi verze prestashopu a ja vam dodam cs.php jazykovy balicek s aktualnim prekladem.. suhosin.post.max_vars= znaci velikost POST pole pri odesilani na server, ti co jej spravuji jen povoli v php.ini v konfiguraci serveru vyssi maximalni hotnotu POST
  11. Nevim zda se ptam zde na spravnem miste. Mame eshop od zacatku naplneny exportem zbozi z osCommerce 2.2. Tam jsme meli v jako vychozi menu nastavenou v SK. V BO stale zadavame ceny v korunackach (lebo asi stejnak padne euri). Vi nekdo z Vas jakym zpusobem lze nastavit Prestashop 1.4.3 tak aby ve FO pri prvnim ukazanim shopu bola vychozi cena v euri??? pricemz zakladni cena v BO je v SKK (aj tak ma zostat)... http://shop.mihi.sk dakujem
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More