Search the Community

Hi friends. i need to know how can i change ID numbers of manufacturers? Or can I do anything that manufacturers and features values shown in block layered with A-Z or 1-9 list. Problem: begin with C or D manufacturer ID number is after Z manufacturer and shown in block layered after Z. How to solve it? May be change ID numbers or other way. and feature values after 100 ml comes 35 ml and others. Because ID number of 35 ml is greater than 100 ml. how to solve it and how to change ID numbers. Please Help. Thanks very much.

I am trying to build a report which shows all products and its attributes, features and categories it belongs to. But query i wrote is taking lot of time. how do i improve this ? SELECT max(if((ps_attribute_group_lang.name like "Color"),ps_attribute_lang.name,'')) AS Color, max(if((ps_attribute_group_lang.name like "Size"),ps_attribute_lang.name,'')) AS Size, max(if((ps_feature_lang.name like "Brand"),ps_feature_value_lang.value,'')) AS Brand, max(if((ps_feature_lang.name like "Sub brand"),ps_feature_value_lang.value,'')) AS Subbrand, max(if((ps_feature_lang.name like "Occasion"),ps_feature_value_lang.value,'')) AS Occasion, max(if((ps_feature_lang.name like "Sleeves"),ps_feature_value_lang.value,'')) AS Sleeves, max(if((ps_feature_lang.name like "Cuffs"),ps_feature_value_lang.value,'')) AS Cuffs, max(if((ps_feature_lang.name like "Collar"),ps_feature_value_lang.value,'')) AS Collar, max(if((ps_feature_lang.name like "Neck"),ps_feature_value_lang.value,'')) AS Neck, max(if((ps_feature_lang.name like "Hood"),ps_feature_value_lang.value,'')) AS Hood, max(if((ps_feature_lang.name like "Shoulder"),ps_feature_value_lang.value,'')) AS Shoulder, max(if((ps_feature_lang.name like "Straps"),ps_feature_value_lang.value,'')) AS Straps, max(if((ps_feature_lang.name like "Trouser Front"),ps_feature_value_lang.value,'')) AS TrouserFront, max(if((ps_feature_lang.name like "Front Opening"),ps_feature_value_lang.value,'')) AS FrontOpening, max(if((ps_feature_lang.name like "Suit Front"),ps_feature_value_lang.value,'')) AS SuitFront, max(if((ps_feature_lang.name like "Fit"),ps_feature_value_lang.value,'')) AS Fit, max(if((ps_feature_lang.name like "Wash"),ps_feature_value_lang.value,'')) AS Wash, max(if((ps_feature_lang.name like "Length"),ps_feature_value_lang.value,'')) AS Length, max(if((ps_feature_lang.name like "Style"),ps_feature_value_lang.value,'')) AS Style, max(if((ps_feature_lang.name like "Pattern"),ps_feature_value_lang.value,'')) AS Pattern, max(if((ps_feature_lang.name like "Weatherproof"),ps_feature_value_lang.value,'')) AS Weatherproof, max(if((ps_feature_lang.name like "Fabric Type"),ps_feature_value_lang.value,'')) AS FabricType, max(if((ps_feature_lang.name like "Suit Type"),ps_feature_value_lang.value,'')) AS SuitType, max(if((ps_feature_lang.name like "Accessories"),ps_feature_value_lang.value,'')) AS Accessories, max(if((ps_feature_lang.name like "Fashion Accessories"),ps_feature_value_lang.value,'')) AS FashionAccessories, max(if((ps_feature_lang.name like "Shoe Type"),ps_feature_value_lang.value,'')) AS ShoeType, max(if((ps_feature_lang.name like "Bag Type"),ps_feature_value_lang.value,'')) AS BagType, max(if((ps_feature_lang.name like "Material"),ps_feature_value_lang.value,'')) AS Material, max(if((ps_feature_lang.name like "Ethnic Bottom Style "),ps_feature_value_lang.value,'')) AS EthnicBottomStyle, ps_product_attribute.id_product AS productid, `ps_product_lang`.`name` AS `productname`, `ps_product_attribute`.`ean13` AS `a_ean13`, `ps_category_lang`.`name` AS `categoryname`, `ps_product_attribute`.`id_product_attribute` AS `id_product_attribute`, `t_vendorproducts`.`a_vendorid` AS `vendorid`, round(`ps_product`.`price`,2) AS price from (((((((`ps_product_attribute` join `ps_product_lang` ON ((`ps_product_lang`.`id_product` = `ps_product_attribute`.`id_product`))) join `ps_product_attribute_combination` ON ((`ps_product_attribute_combination`.`id_product_attribute` = `ps_product_attribute`.`id_product_attribute`))) join `ps_attribute` ON ((`ps_attribute`.`id_attribute` = `ps_product_attribute_combination`.`id_attribute`))) join `ps_attribute_lang` ON ((`ps_attribute_lang`.`id_attribute` = `ps_product_attribute_combination`.`id_attribute`))) join `ps_attribute_group_lang` ON (((`ps_attribute`.`id_attribute_group` = `ps_attribute_group_lang`.`id_attribute_group`)))))) join ps_feature_product on ps_feature_product.id_product = ps_product_attribute.id_product join ps_feature_value_lang on ps_feature_value_lang.id_feature_value = ps_feature_product.id_feature_value join ps_feature_lang on ps_feature_product.id_feature = ps_feature_lang.id_feature join ps_product on ps_product.id_product = ps_product_attribute.id_product join ps_category cate1 on cate1.id_category = ps_product.id_category_default join ps_category cate2 on cate2.id_category = cate1.id_parent join ps_category_lang on ps_category_lang.id_category = cate1.id_category WHERE ps_product_lang.id_shop = 1 GROUP BY ps_product_attribute.ean13 ORDER BY productid

Hi, Does anyone know if you can add the Features of a product to the Short Description, so it shows in the product list page and the main product page? Thanks

If I create the predefined features FIRST then import the product csv with features as per normal, can ANYBODY CONFIRM for me that the features will go into the database as "predefined features" NOT "custom features" ??

Ik ben voor mijn webshop aan het testen met de module gelaagd navigatie block. Ik probeer voor 1 product meerdere productkenmerken in te vullen. Voorbeeld: Laptop beeldscherm 16", past op meerdere laptops. Ik wil dan een kenmerk maken, waarbij de klant kan selecteren welk type laptop hij/zij heeft. Hoe krijg ik dit voor elkaar? Het mooiste is dan om ook een extra tabblad te krijgen, met bijvoorbeeld 'Geschikt voor' oid. Bijvoorbeeld iets als de replacedirect(.nl) module waar de klant een klein wizardje kan doorlopen om het juiste product te vinden. Graag hoor ik jullie ideeën! Patrick

Prestashop 1.5.x blocklayered module configuration, features cannot be selected (not showing). The problem is with id_lang in administration (deleted default language id of admin). Go to Administration->Employees and resave yours admin profile. The lang_id will be set to right value and features will appear.

Ce module vous permet d'ajouter des images et des liens sur la page du produit. Vous pouvez ajouter autant de photos que vous souhaitez et spécifier des images différentes pour différentes langues. Vous pouvez également ajouter une image unique pour tous les produits ou plusieurs à la fois Vous pouvez montrer des images des expéditions, la livraison tardive, de garantie, téléphone, etc Caractéristiques: Multilingue Croix-navigateur lien http://catalogo-onli...s-produits.html

Hi, I'm looking for an existing functionality within PS 1.5.4.1. or an add-on/module to group product attributes and features into larger groups for filtering customer's search results. For example, my individual product come in a variety of shades of purple: lilac, aubergine, magenta, prune, but while I need this individual colours to be diplayed under each product in the colour picker, I need a generic PURPLE to come up for the purposes of filtering the search results. It should be possible to tag/group one colour into several groups, e.g., magenta could be grouped into PURPLE or PINK. I need the same function for sizes and denier. Thank you in advance for your help and replies!

Dear Administrators & Moderators, Would you mind adding a new section named "Wish List" (or similar) where we can post and find what "we" consider importante developments for the next version of PrestaShop? One I consider importante is to expand all fields in the Localization/Translations page, because we can use the "Ctrl+F" feature to find some words we are looking for. BRgds

Is there a way to make the features into text areas rather than text fields. We'd like to include some tables as a feature of each product. Once the text areas are populated, we'll add more tabs to the product display page. Currently, the feature fields won't take all the text. I'm not opposed to modifying the core tables if needed. Suggestions?

Hi!! I'm trying to display a product feature within the blockcart module with no success... I've already get it working in product listings and product page with this code: {foreach from=$product.features item=feature name=features} {if isset($feature.value)} {if ($feature.name|escape:'htmlall':'UTF-8'=='feature_name')} <p class="fabricante"><strong>{$feature.value|escape:'htmlall':'UTF-8'}</strong></p> {/if} {/if} {/foreach} If i write the same code in blockcart... doesn't work... Do I have to declare something new in blockcart.php? In that case, can anyone help, please? Thanks to all...

Hola a todos, he estado mirando en los foros y, la verdad no encuetro solución para esto.... Hay alguna manera de mostrar una característica concreta de un producto en el módulo blockcart (carrito desplegable). Lo he conseguido hacer en todos los listados y fichas de producto de la siguiente manera: {foreach from=$product.features item=feature name=features} {if isset($feature.value)} {if ($feature.name|escape:'htmlall':'UTF-8'=='Denominación de origen')} <p class="fabricante"><strong>{$feature.value|escape:'htmlall':'UTF-8'}</strong></p> {/if} {/if} {/foreach} Esto funciona correctamente en los listados, etc... pero no en el carrito... No sé si habrá que declarar algo nuevo en el php del carrito y si es asi... alguien puede decirme algo? Gracias de antemano. Un saludo

In order to have your features presented with linebreaks you should use "nl2br". At your theme folder, on your "product.tpl" file, replace <li><span>{$feature.name|escape:'htmlall':'UTF-8'}</span> {$feature.value|escape:'htmlall':'UTF-8'}</li> with <li><span>{$feature.name|escape:'htmlall':'UTF-8'}</span> {nl2br($feature.value|escape:'htmlall':'UTF-8')}</li>

Hi everyone, after hours of reading and trying to understand lots of code lines and make my own tries without any result, finally I have decided to share my problem with the community. The problem is the following: In my site, product features are VERY important, and I want them to show in almost any list of products, including blocknewproducts (got it!), homefeatured (got it too!), and blockbestsellers (here is the problem!). As you can see, the problem comes when I want to show product features on blockbestsellers. As far as I've seen, blocknewproducts and homefeatured get their product properties via Product.php, and blockbestsellers gets its product properties via ProductSale.php. In a very ridiculous way (I had to try it), I copy/pasted the code where Product.php gets the product features to ProductSale.php in override/classes. Something inside me told me it wouldn't work, but I did it anyway to be sure. Definitely I am not a PHP expert yet and I need some help with this. Maybe I am wrong and these .php files have nothing to do with this, I am not 100% sure of that. I didn't mention it yet, but I think it's clearly understood I copy/pasted the code who shows the feature products in the .tpl files. Well, that's all. If someone can help me with this I would appreciate it very much. Regards!

Hi all, Does anyone know how to import features details into database from excel or text file instead of insert one by one in the back end system? Please help Thank you

Hi, I have PrestaShop™ 1.4.7.3 and I add some new products to database (using simply the backend to add it). I add some features of that products and when I look at it on frotnend, there are these features twice! See img: As you can see, in the database there are features only once: So I look to the code. It is completely normal: {if $features} <!-- product's features --> <ul id="idTab2" class="bullet"> {foreach from=$features item=feature} <li><span>{$feature.name|escape:'htmlall':'UTF-8'}</span> {$feature.value|escape:'htmlall':'UTF-8'}</li> {/foreach} </ul> {/if} And I see some old products and features of products are there only once: I don't know why are features doubled, can somebody help me?

Amongst other thing.... if I can get some help with this i'd be ecstatic... lots more i need , (paid work if the right developer is interested) Soooo... A new feature for backend product features called "Feature sets" I want to have the ability to add a feature set, add Set1, Set 2 (etc) (each of the sets should contain the ability to add items;"Title"(s) along with checkbox(es) for a value thanks for reading, I look forward to hearing back

Hi guys, I'm on 1.5.0.17 and I've been trying to figure out how to import products with features. I've downloaded the example CSV but the imported products don't have features on the back end. I'm just hoping someone can explain to me in detail how the CSV should be set up to import products and feature values in one go. Thanks.

Начиная с версии 1.4.5.1 #################################### # v1.4.5.1 - 9352 (2011-10-14) # #################################### [*] MO : Block layered - Add meta title & url personalisation for attributes and features values [*] MO : Block layered - Add meta title & url personalisation for attributes groups and features Была добавлена возможность для характеристик добавлять значение URL и значение Meta title. Ситуация следующая. При изменении URL изменения происходит http://localhost/prestashop1490/category.php?id_......country1-china1 А вот при изменении Meta title никаких изменений не происходит Может кто сталкивался, подскажите что сделать чтобы Meta title всё же менялся.

Creating features with numbers in start (front), then to sort the data as I want. Example 1015.Country 1013.Manufacturer. In the derivation to the product's numbers were removed by adding this piece of code in / Classes / product.php It { if (! array_key_exists ($ id_product. '-'. $ id_lang, self :: $ _frontFeaturesCache)) { self :: $ _frontFeaturesCache [$ id_product. '-'. $ id_lang] = Db :: getInstance (_PS_USE_SQL_SLAVE_) -> ExecuteS (' SELECT name, value, pf.id_feature FROM '. _DB_PREFIX_.' Feature_product pf LEFT JOIN '. _DB_PREFIX_.' Feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = '. (Int) $ id_lang.') LEFT JOIN '. _DB_PREFIX_.' Feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = '. (Int) $ id_lang.') WHERE pf.id_product = '. (Int) $ id_product); } return self :: $ _frontFeaturesCache [$ id_product. '-'. $ id_lang]; } Me on it public static function getFrontFeaturesStatic ($ id_lang, $ id_product) { if (! array_key_exists ($ id_product. '-'. $ id_lang, self :: $ _frontFeaturesCache)) { self :: $ _frontFeaturesCache [$ id_product. '-'. $ id_lang] = Db :: getInstance (_PS_USE_SQL_SLAVE_) -> ExecuteS (' SELECT name, value, pf.id_feature FROM '. _DB_PREFIX_.' Feature_product pf LEFT JOIN '. _DB_PREFIX_.' Feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = '. (Int) $ id_lang.') LEFT JOIN '. _DB_PREFIX_.' Feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = '. (Int) $ id_lang.') WHERE pf.id_product = '. Intval ($ id_product).' ORDER BY `name` ASC '); } $ ResultsArray = array (); foreach (self :: $ _frontFeaturesCache [$ id_product. '-'. $ id_lang] AS $ row) { $ Row ['name'] = preg_replace ('/ ^ [0-9] + \. /','', $ Row ['name']); $ ResultsArray [] = $ row; } return $ resultsArray; } And the features of the numbers invisible And now the question, including filters (module blocklayered) And the derivation of features, they are listed with numbers, how to get rid do not know, a week and all the tormented i dont know. Help me.

Hi, I am trying out the Prestashop 1.5.0.15 version. I am trying the RMA features and have a question. When I return products from the front office, and accept the return from the back office, I get a credit slip. But the store credit isn't applied automatically on my next purchase and I can't even see an option of using it. Can anyone tell me how to use the credit please?

Since a version 1.4.5.1 #################################### # v1.4.5.1 - 9352(2011-10-14) # #################################### [*] MO : Block layered - Add meta title & url personalisation for attributes and features values [*] MO : Block layered - Add meta title & url personalisation for attributes groups and features Was added possibility for descriptions to add a value URL and value Meta title. A situation following. At the change of URL of change of происходит http://localhost/prestashop1490/category.php?id category=2#/country1 - china1 And at the change of Meta title no changes take place Prompt me that to do that Meta title however changed

Hi! I'm trying to import products from CSV. Everything is fine except features. How should be features marked in CSV file? Somehow the sample files in backoffice are not downloadable.So I can not look into it. But should the features be separated with "," like images? But how to declare what is the feature name and value?

Hi! I want in my home a carousel module that show a set of products based on a specific category or an attribute or a features. I would like the opportunity to choose in back office some products to display. Is there a module that do this? Thanks!

Hi all, Im a web designer in a pickle and could use some advice with a problem. I am designing a website for a client who sell various doors and accessories. For the doors, I need to add the following features/values for customers: door size, do you want rail track?, wall track or ceiling track, track size. Now, I know how to add the door size feature on with a list of options for the customer to choose from. My question/problem is that my second feature is a yes or no question. (do you want rail track) is the customer chooses yes, then the second feature will show (wall or ceiling track) and then finally based on that selection a list of wall of ceiling track sizes will appear. Question: with how I described the process, is this even possible to do in prestashop? My main concern was with the yes/no part.. I dont see any options in back-office to do this, so i assume there has to be customisation involved. I would appreciate if anyone can help with this problem, I dont need coding help or anything, I just need to understand if this is possible and if it is, what is the best way to go about this. Thanks in advance.