Jump to content

emagiero

Members
  • Posts

    7
  • Joined

  • Last visited

Everything posted by emagiero

  1. Hi guys, Because i've searched for a module that can help me calculate store profit and i didn't find anything i started to write some sql lines. Is my first time when i play with sql and i've managed to do this : select ps_order_detail.id_order, ps_order_detail.product_id, ps_order_detail.product_name, ps_order_detail.product_quantity, ps_product.price, ps_product.wholesale_price, ps_order_detail.product_quantity * ps_product.price - ps_order_detail.product_quantity * ps_product.wholesale_price AS PROFIT from ps_orders inner join ps_order_detail inner join ps_product on ps_orders.id_order = ps_order_detail.id_order and ps_product.id_product = ps_order_detail.product_id order by id_order asc This returns a table that i can import to excel, and there i can calculate the profit. The problem is that is not the real profit, because it doesn't include the price discounts or the price reduction. Can anybody help me with this? (I have prestashop 1.4.6.2) Thank you.
  2. Worked for me on Prestashop 1.4.6.2 . I'm not sure if this is SEO friendly though...
  3. Yes, it works and is very fast. I used excel to arrange the list and in a few seconds i imported 1200 emails.
  4. I had the same problem you have. When a client orders a free virtual product, the status of the order is Payment Accepted. I modified the payment accepted settings and because of that the download link was not showing after a completed order. Check if you have checked the second option in the Paypent Accepted Status. It should be Allow customer to view invoice PDF or something like that. After you check that option, the download product should be visible after the order is complete.
  5. In /tools/swift/Swift/Message.php at line 623 replace $this->getReference("parent", $old_branch)->removeChild($id); with if($this->getReference("parent", $old_branch)->hasChild($id)){ $this->getReference("parent", $old_branch)->removeChild($id); } I have prestashop PrestaShop™ 1.4.6.2 and it works
  6. In order-address.tpl comment this: {* <p class="checkbox" {if $cart->isVirtualCart()}style="display:none;"{/if}> <input type="checkbox" name="same" id="addressesAreEquals" value="1" onclick="updateAddressesDisplay();{if $opc}updateAddressSelection();{/if}" {if $cart->id_address_invoice == $cart->id_address_delivery || $addresses|@count == 1}checked="checked"{/if} /> <label for="addressesAreEquals">{l s='Use the same address for billing.'}</label> </p> <p id="address_invoice_form" class="select" {if $cart->id_address_invoice == $cart->id_address_delivery}style="display: none;"{/if}> {if $addresses|@count > 1} <label for="id_address_invoice" class="strong">{l s='Choose a billing address:'}</label> <select name="id_address_invoice" id="id_address_invoice" class="address_select" onchange="updateAddressesDisplay();{if $opc}updateAddressSelection();{/if}"> {section loop=$addresses step=-1 name=address} <option value="{$addresses[address].id_address|intval}" {if $addresses[address].id_address == $cart->id_address_invoice && $cart->id_address_delivery != $cart->id_address_invoice}selected="selected"{/if}>{$addresses[address].alias|escape:'htmlall':'UTF-8'}</option> {/section} </select> {else} <a style="margin-left: 221px;" href="{$link->getPageLink('address.php', true)}?back={$back_order_page}?step=1&select_address=1{if $back}&mod={$back}{/if}" title="{l s='Add'}" class="button_large">{l s='Add a new address'}</a> {/if} *} and this: {* <ul class="address alternate_item {if $cart->isVirtualCart()}full_width{/if}" id="address_invoice"> *} In order-detail.tpl comment this: {* <ul class="address alternate_item {if $order->isVirtual()}full_width{/if}"> <li class="address_title">{l s='Delivery'}</li> {foreach from=$dlv_adr_fields name=dlv_loop item=field_item} {if $field_item eq "company" && isset($address_delivery->company)}<li class="address_company">{$address_delivery->company|escape:'htmlall':'UTF-8'}</li> {elseif $field_item eq "address2" && $address_delivery->address2}<li class="address_address2">{$address_delivery->address2|escape:'htmlall':'UTF-8'}</li> {elseif $field_item eq "phone_mobile" && $address_delivery->phone_mobile}<li class="address_phone_mobile">{$address_delivery->phone_mobile|escape:'htmlall':'UTF-8'}</li> {else} {assign var=address_words value=" "|explode:$field_item} <li>{foreach from=$address_words item=word_item name="word_loop"}{if !$smarty.foreach.word_loop.first} {/if}<span class="address_{$word_item}">{$deliveryAddressFormatedValues[$word_item]|escape:'htmlall':'UTF-8'}</span>{/foreach}</li> {/if} {/foreach} </ul> }* In order-opc-new-account.tpl comment: {* <p class="checkbox is_customer_param"> <input type="checkbox" name="invoice_address" id="invoice_address" /> <label for="invoice_address"><b>{l s='Please use another address for invoice'}</b></label> </p> *}
  7. In order-address.tpl comment this: {* <p class="checkbox" {if $cart->isVirtualCart()}style="display:none;"{/if}> <input type="checkbox" name="same" id="addressesAreEquals" value="1" onclick="updateAddressesDisplay();{if $opc}updateAddressSelection();{/if}" {if $cart->id_address_invoice == $cart->id_address_delivery || $addresses|@count == 1}checked="checked"{/if} /> <label for="addressesAreEquals">{l s='Use the same address for billing.'}</label> </p> <p id="address_invoice_form" class="select" {if $cart->id_address_invoice == $cart->id_address_delivery}style="display: none;"{/if}> {if $addresses|@count > 1} <label for="id_address_invoice" class="strong">{l s='Choose a billing address:'}</label> <select name="id_address_invoice" id="id_address_invoice" class="address_select" onchange="updateAddressesDisplay();{if $opc}updateAddressSelection();{/if}"> {section loop=$addresses step=-1 name=address} <option value="{$addresses[address].id_address|intval}" {if $addresses[address].id_address == $cart->id_address_invoice && $cart->id_address_delivery != $cart->id_address_invoice}selected="selected"{/if}>{$addresses[address].alias|escape:'htmlall':'UTF-8'}</option> {/section} </select> {else} <a style="margin-left: 221px;" href="{$link->getPageLink('address.php', true)}?back={$back_order_page}?step=1&select_address=1{if $back}&mod={$back}{/if}" title="{l s='Add'}" class="button_large">{l s='Add a new address'}</a> {/if} *} and this: {* <ul class="address alternate_item {if $cart->isVirtualCart()}full_width{/if}" id="address_invoice"> *} In order-detail.tpl comment this: {* <ul class="address alternate_item {if $order->isVirtual()}full_width{/if}"> <li class="address_title">{l s='Delivery'}</li> {foreach from=$dlv_adr_fields name=dlv_loop item=field_item} {if $field_item eq "company" && isset($address_delivery->company)}<li class="address_company">{$address_delivery->company|escape:'htmlall':'UTF-8'}</li> {elseif $field_item eq "address2" && $address_delivery->address2}<li class="address_address2">{$address_delivery->address2|escape:'htmlall':'UTF-8'}</li> {elseif $field_item eq "phone_mobile" && $address_delivery->phone_mobile}<li class="address_phone_mobile">{$address_delivery->phone_mobile|escape:'htmlall':'UTF-8'}</li> {else} {assign var=address_words value=" "|explode:$field_item} <li>{foreach from=$address_words item=word_item name="word_loop"}{if !$smarty.foreach.word_loop.first} {/if}<span class="address_{$word_item}">{$deliveryAddressFormatedValues[$word_item]|escape:'htmlall':'UTF-8'}</span>{/foreach}</li> {/if} {/foreach} </ul> }* In order-opc-new-account.tpl comment: {* <p class="checkbox is_customer_param"> <input type="checkbox" name="invoice_address" id="invoice_address" /> <label for="invoice_address"><b>{l s='Please use another address for invoice'}</b></label> </p> *}
×
×
  • Create New...

Important Information

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