Jump to content

remyessers

Members
  • Posts

    23
  • Joined

  • Last visited

Profile Information

  • Activity
    Developer

Recent Profile Visitors

2,210,252 profile views

remyessers's Achievements

Newbie

Newbie (1/14)

4

Reputation

  1. Hi, I have a problem with the Klarna module provided by Prestashop (version 1.7.4 of the module) I'm using it on PS 1.5.4.1 An invoice is created at Klarna Online, as soon as I set my order on "shipped". When I open this order later, a second invoice is created at Klarna Online. Every time I open this order, it creates an extra invoice in Klarna Online. When I check the source code, it adds the invoice via this code (I think): <!-- Admin order hook --> <!-- article added: Array ( [goods] => Array ( [artno] => 1113 [title] => Multishine hanglamp koper - Zuiver - Kleur : Koper [price] => 16900 [vat] => 21 [discount] => 0 [flags] => 32 ) [qty] => 1 ) end article added --> <!-- article added: Array ( [goods] => Array ( [artno] => [title] => sint75 [price] => -1268 [vat] => 21 [discount] => 0 [flags] => 32 ) [qty] => 1 ) end article added --> <!-- article added: Array ( [goods] => Array ( [artno] => 19 [title] => GLS / DHL [price] => 0 [vat] => 0 [discount] => 0 [flags] => 40 ) [qty] => 1 ) end article added --> <!-- billing address array: KlarnaAddr Object ( [email:protected] => private [telno:protected] => private [cellno:protected] => private [fname:protected] => private [lname:protected] => private [company:protected] => [careof:protected] => [street:protected] => private [zip:protected] => private [city:protected] => private [country:protected] => private [houseNo:protected] => private [houseExt:protected] => [isCompany] => ) end billing address array --> <!-- shipping address array: KlarnaAddr Object ( [email:protected] => private [telno:protected] => private [cellno:protected] => private [fname:protected] => private [lname:protected] => private [company:protected] => [careof:protected] => [street:protected] => private [zip:protected] => private [city:protected] => private [country:protected] => private [houseNo:protected] => private [houseExt:protected] => [isCompany] => ) end shipping address array --> <!-- digest() using hash: sha512 end digest() using hash --> <!-- activate_reservation: Array ( [0] => 1068783302 [1] => [2] => 09011970 [3] => 0 [4] => [5] => [6] => 2647 [7] => [8] => Array ( [email] => private [telno] => private [cellno] => private [fname] => private [lname] => private [company] => [careof] => [street] => private [house_number] => private [house_extension] => [zip] => private [city] => private [country] => private ) [9] => Array ( [email] => private [telno] => private [cellno] => private [fname] => private [lname] => private [company] => [careof] => [street] => private [house_number] => private [house_extension] => [zip] => private [city] => private [country] => private ) [10] => 0.0.0.0 [11] => 0 [12] => 2 [13] => 154 [14] => 101 [15] => 23653 [16] => qnatQQK6mIiwT0br0s/i5NDZ8mH62Q5D9xt3TPP/3GTTGsFR+61epv/bUvoGsJLH51MwpyvJ0p0WlELGSl1pIQ== [17] => 7 [18] => -1 [19] => Array ( [0] => Array ( [goods] => Array ( [artno] => 1113 [title] => Multishine hanglamp koper - Zuiver - Kleur : Koper [price] => 16900 [vat] => 21 [discount] => 0 [flags] => 32 ) [qty] => 1 ) [1] => Array ( [goods] => Array ( [artno] => [title] => sint75 [price] => -1268 [vat] => 21 [discount] => 0 [flags] => 32 ) [qty] => 1 ) [2] => Array ( [goods] => Array ( [artno] => 19 [title] => GLS / DHL [price] => 0 [vat] => 0 [discount] => 0 [flags] => 40 ) [qty] => 1 ) ) [20] => [21] => Array ( [delay_adjust] => 1 ) [22] => Array ( ) [23] => Array ( ) [24] => Array ( ) [25] => Array ( ) ) end activate_reservation --> <!-- digest() using hash: sha512 end digest() using hash --> <!-- candice report: ****|activate_reservation|0|567|0|https://payment.klarna.com:443 end candice report --> <!-- activate_reservation result: Array ( [0] => no_risk [1] => 513122365343236180 ) end activate_reservation result --> I removed some details of the customer for privacy issues. I think this code creates the invoices? Reported the problem at Klarna and they said it's a PS issue and they can't solve it. Anyone else has this problem too? Best regards, Remy
  2. Hi, On my product page I've listed all my available colors in a list like this: Chair X - RED Chair X - Blue Chair X - Green I would like to place an add to cart link after the color on the product page. I've found the follow code where 630 is my product ID: <a class="exclusive_small ajax_add_to_cart_button" title="{l s='Add to cart'}" onclick="ajaxCart.add(630, null, true, null, 1, null)">Add Me</a> How can I change the code so it adds the correct attribute to the cart? Now it adds the default color combination to my cart. Anyone can point me in the right direction? Best regards, Remy p.s. I'm using PS 1.5.4.1
  3. Hi, I'm using prestashop 1.5.4.1 and I've a problem with layered navigation module. When I open an URL from layered navigation (to simulate the google spider) it adds ?selected_filters behind the URLS. That is correct, except that the filter doesn't work anymore. So if I open http://robin-test.nl/62-design-eetkamerstoelen?selected_filters=merk-zuiver it should filter my products on "Merk = Zuiver". Now it opens all my products. That's a big problem for me! On my old ps 1.5.3 it worked perfectly. If i'd open http://robin-test.nl/62-design-eetkamerstoelen?selected_filters=merk-zuiver it shows me 17 products instead of all products (95). Hopefully I've explained it clearly. Anyone can help me? Best regards, Remy
  4. Hi, I'm looking for the possibiliy of adding individual out of stock text for each of my product combinations. Let's say I've a chair in 3 different colors, I want to be able to add the following out of stock text: White: Out of stock, back in 3 weeks Black: Out of stock, back in 6 weeks Green: Out of stock, back in 9 weeks I update my stock with a csv file, I import it daily. The quantity for each combination is updated correctly. I assume I have to add an extra database field in the ps_product_attribute table. How can I display this field correctly on the product page? Any ideas? I'm using PS 1.5.3
  5. Also when I look in source code, it shows the correct price: <p id="old_price"><span id="old_price_display">€ 99.00</span>incl. btw</p> <span itemprop="price" id="our_price_display">€ 89.00</span> So perhaps it's a javascript error?
  6. Hi Paul, thanks for your reply. Actually, it does happen when I set a default combination... It only shows the correct price if I uncheck "Leave base price" , but I can't uncheck this if I use e.g. a category price rule...
  7. The product price with discount shows as zero when a product has combinations on the product page. On the product list the price shows correctly. See this link: http://robin-design.nl/vloerlampen/443-bended-trileg-vloerlamp-zwart-metalen-driepoot.html This product has one combination, but is just an example. If a product has attributes and I apply a specific price discount, the price shows up as 0.00, except if I uncheck "Leave base price" I've seen a few more topics about this issue, but none of them helped for me. Perhaps anyone knows the issue? I use prestashop 1.5.3
  8. Hi, What I'm building at this moment is a 3d model / configurator for a product of ours, sort of like iTailor.com or https://www.mixeeme.com/littlefolk/new. I'm building this with PHP + JS + X3DOM. What I'm looking for is the Software of Prestashop (shopping cart, account history, payment modules etc.) combined with this custom build product. So I want an add to cart button on the custom product page which will add the customized product to the shopping cart, which is ofcourse not custom made but from Prestashop. This way I can use all the benefits of Prestashop combined with my own custom product. Any tips, examples, directions for me on how to achieve this? Best regards, Remy
  9. Thanks! It works great. Ive got one more problem, perhaps you can help me with that too.. The attribute-images are sometimes 2 different formats. One is base-directory/id_product-id_image/product-name.jpg: base-directory/'.$rowattr['id_product'].'-'.$rowattr['id_image'].'-relatedproducts/'.$rowattr['link_rewrite'].'.jpg'; The second one is the same format but without id_product, so like: base-directory/id_image/product-name.jpg: base-directory/'.$rowattr['id_image'].'-relatedproducts/'.$rowattr['link_rewrite'].'.jpg'; I want the image to appear inside the span tag: <span class="squareAttrSpe" id="'.$rowattr['id_image'].''.$rowattr['link_rewrite'].'" style="background:'.$rowattr['attribute_color'].'" ><img src="imglocation"/></span> Is there a check to see if image exist? If not, use the other format?
  10. Hi, Im using a module to display the available colors from a product on the product-list. It uses this code to select the colors and display a <span> tag on my product on the list: $attributesGroups = Db::getInstance()->ExecuteS(' SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, pa.* FROM `'._DB_PREFIX_.'product_attribute` pa LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `'._DB_PREFIX_.'attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `'._DB_PREFIX_.'attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON a.`id_attribute` = al.`id_attribute` LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON ag.`id_attribute_group` = agl.`id_attribute_group` WHERE pa.`id_product` = '.$idP.' AND al.`id_lang` = '.$id_lang.' AND ag.`id_attribute_group` in ('.$lstM2P.') AND agl.`id_lang` = '.$id_lang.' ORDER BY agl.`public_name`, al.`name`'); if (Db::getInstance()->numRows()){ $vir = 0; $previous2 = ''; $previous = ''; foreach ($attributesGroups AS $k => $rowattr){ $attribuut = $rowattr['id_product_attribute']; if($rowattr['public_group_name'] != $previous2){ $vir = 0; } if ($rowattr['attribute_name'] != $previous) { if($rowattr['is_color_group'] && $rowattr['attribute_color']){ if(Attribute::checkAttributeQty($rowattr['id_product_attribute'],1)>=0){ $attributs[$rowattr['public_group_name']][] = ' <span class="squareAttrSpe" id="1" style="background:'.$rowattr['attribute_color'].'" > </span>'; } As you can see, it already fetches the id_product_attribute ($rowattr['id_product_attribute']). I want to extend the query to join the table ps_product_attribute_image on id_product_attribute, but I don't know how to build that query. Does anybody with a bit of Mysql knowledge know the correct line? Best regards, Remy
  11. How can you get the id_product_attribute for each product color? I mean the one which is related to quantity, specific price etc. How do I get this variable?
  12. Yes, but the other code I placed in blocklayered.php. So if you use layered navigation, you should place the other code right after $products = Product::getProductsProperties((int)$cookie->id_lang, $products);
  13. It works for 1.5.3, the version I'm using. But it shows all the available colors of a product, it doesn't changes the product cover image. That would be the best thing!
  14. I use this code on my product list: {foreach from=$product.colors key=id_attribute item=color} <div style="background: {$color.value}; display: block; float: left; width: 10px; height: 10px; margin: 2px 2px 2px 2px; border: 1px solid #D0D3D8;"></div> {/foreach} Works like a charm. But I need the id_product_attribute, the one which corresponds to the specific price, quantities etc. How do I get that id? My code in blocklayered.php, corresponding to the color picker is: //START color picker foreach ($products as $key => $product_item) { $product = new Product($product_item['id_product'], false, $cookie->id_lang); $colors = array(); $attributes_groups = $product->getAttributesGroups($cookie->id_lang); if (is_array($attributes_groups) && $attributes_groups) { foreach ($attributes_groups as $k => $row) { // color management if ((isset($row['attribute_color']) && $row['attribute_color']) || (file_exists(_PS_COL_IMG_DIR_.$row['id_attribute'].'.jpg'))) { $colors[$row['id_attribute']]['value'] = $row['attribute_color']; $colors[$row['id_attribute']]['name'] = $row['attribute_name']; } } $products[$key]['colors'] = $colors; } } //END color picker Can anyone help me?
  15. Thanks for your reply and pointing me in a direction. I'm no Javascript programmer, so to write a function like this is a bridge too far for me.. Perhaps there's a module or someting? Does anyone know more about this?
×
×
  • Create New...

Important Information

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