mytwocentimes

8 months later and I'm still looking for a solution to using the ps_warehouse_product_location.location field in a Delivery Slip. Soon - I should upgrade to a current version of Prestashop ... but that may wait till Christmas

Went directly to the database via PHPMYADMIN panel - I don't recall the exact table, but it is one of the ORDER tables

@tigmo --- you do understand what I was trying to do ... and I AM A TWIT thank you for your instructions ONE LESS THING I HAVE TO DO IN MYPHPADMIN

@porpoise - I am new to this whole prestashop thing, but LOCALIZATION >> TAXES >> enable tax and set the "based on" drop-down to "Destination" hope this helps EDIT: sorry - I reread your post - and what I wrote makes no sense - apologies and good luck finding a solution ---> though I wonder how you go about collecting VAT from clients beyond your company's country borders ? seems odd

SOLUTION: go to the ps_attribute table in your database and you can re-sequence the attributes as you like by changing the integer in the "position" field. Why I needed to do this ? Prestashop 1.5.2 a. I had entered sizes XS, SM, MD, LG, XL, XXL in that order when setting up an attribute group. Later I needed to add a JR size. When reviewing the new product, I could not get the attribute to display from smallest to largest. I tried a few things. No luck. b. I did not want to spend money on a paid module that does MANY GREAT things *and* allows me to sort the attributes how I like. --> ps_attribute has three (3) fields - "position" seems to control how the attribute displays in the list

Oh, how sad for me ... my system as follows: Server information: Linux #1 SMP Mon Aug 23 11:13:12 CEST 2010 i686 Server software version: Apache PHP version: 5.2.17 Memory limit: 128M Max execution time: 10 Database information MySQL version: 5.5.27-log MySQL engine: InnoDB Tables prefix: ps_ Store information Prestashop version: 1.5.2.0 I just tried your demo's - they have a lot of functionality - wish it were a 1.5.2 demo :-( thanks for trying to help - is there an easy way to call the data directly from the database ?

@tuk66 - I have tried them all - they give somehow the information available in the ps_order_detail table - these are not the product "price" field from the ps_product table. Why? Because I use that price to indicate the after-tax-suggested-retail-price, I then set specific prices for special groups (retail shops). When a shop buys something, the price that gets put into the order_detail is the specific price. Shops want to see the MSRP *and* their unit_price thanks if you can help - no worries if it is too much work

@tuk66 that is a cool thing you have done :-) Would there be a similar way to get the MSRP (product price *not* the unit cost) into the invoice or is that a bigger job ?

OK - I understand better - have you gone into LOCALIZATION >> COUNTRY >> EDIT and turned ON the "Display tax label (e.g. "Tax incl."):" parameter ? Otherwise - if you need to hack "display_tax_label" will show you the various files that deal with it

How can I show MSRP (MRP) on invoices ?

This [HERE] may help I'm nothing more than a hack and my solutions are ugly - good luck

Hope this helps I added weight - carrier to invoice I put a toggle in to flip between two types of invoicing (in France and ex-France) BUT IF YOU KNOW WHAT VARIABLES ARE AVAILABLE that would be nice ALSO - how do I put the MSRP into the invoice per product ?? {* * 2007-2012 PrestaShop * * NOTICE OF LICENSE * * This source file is subject to the Academic Free License (AFL 3.0) * that is bundled with this package in the file LICENSE.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/afl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to [email protected] so we can send you a copy immediately. * * DISCLAIMER * * Do not edit or add to this file if you wish to upgrade PrestaShop to newer * versions in the future. If you wish to customize PrestaShop for your * needs please refer to http://www.prestashop.com for more information. * * @author PrestaShop SA <[email protected]> * @copyright 2007-2012 PrestaShop SA * @version Release: $Revision: 6753 $ * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) * International Registered Trademark & Property of PrestaShop SA *} <div style="font-size: 8pt; color: #444"> <table> <tr><td> </td></tr> </table> <!-- ADDRESSES --> <table style="width: 100%"> <tr> <td style="width: 15%"></td> <td style="width: 85%"> {if !empty($delivery_address)} <table style="width: 100%"> <tr> <td style="width: 50%"> <span style="font-weight: bold; font-size: 10pt; color: #9E9F9E">{l s='Delivery Address' pdf='true'}</span><br /> {$delivery_address} </td> <td style="width: 50%"> <span style="font-weight: bold; font-size: 10pt; color: #9E9F9E">{l s='Billing Address' pdf='true'}</span><br /> {$invoice_address} </td> </tr> </table> {else} <table style="width: 100%"> <tr> <td style="width: 50%"> <span style="font-weight: bold; font-size: 10pt; color: #9E9F9E">{l s='Billing & Delivery Address.' pdf='true'}</span><br /> {$invoice_address} </td> <td style="width: 50%"> </td> </tr> </table> {/if} </td> </tr> </table> <!-- / ADDRESSES --> <div style="line-height: 1pt"> </div> {if $customer->company or $customer->siret or $customer->ape} <table style="width: 100%"> <tr> <td style="width: 15%"></td> <td style="width: 85%"> {if $customer->company} <b>{l s='Tax Nr:'}</b> {$customer->company} {/if} {if $customer->siret} <br /> <b>{l s='SIRET:'}</b> {$customer->siret} {/if} {if $customer->ape} <br /> <b>{l s='APE:'}</b> {$customer->ape} {/if} </td> <!-- <td style="width: 15%"></td> --> </tr> </table> <!-- / B2B --> {/if} <div style="line-height: 1pt"> </div> <!-- PRODUCTS TAB --> <table style="width: 100%"> <tr> <td style="width: 15%; padding-right: 7px; text-align: right; vertical-align: top; font-size: 7pt;"> <!-- CUSTOMER INFORMATIONS --> <b>{l s='Order Number:' pdf='true'}</b><br /> {$order->getUniqReference()}<br /> <br /> <b>{l s='Order Date:' pdf='true'}</b><br /> {$order->date_add|date_format:"%m-%d-%Y"}<br /> <br /> <b>{l s='Invoice Date:' pdf='true'}</b><br /> {$order->invoice_date|date_format:"%m-%d-%Y"}<br /> <br /> <b>{l s='Shipping Date:' pdf='true'}</b><br /> {$order->delivery_date|date_format:"%m-%d-%Y"}<br /> <br /> <b>{l s='Payment Method:' pdf='true'}</b><br /> <table style="width: 100%;"> {foreach from=$order_invoice->getOrderPaymentCollection() item=payment} <tr> <td style="width: 100%">{$payment->payment_method}</td> </tr> <tr> <td style="width: 100%">{displayPrice price=$payment->amount currency=$order->id_currency}</td> </tr> {foreachelse} <tr> <td>{l s='No payment'}</td> </tr> {/foreach} </table> <br /> <br /> <b>Net Weight: </b><br /> {round($order->getTotalWeight(),1)} kg<br /> <b>Gross Weight: </b><br /> {round($order->getTotalWeight()*1.2,1)} kg<br /> <b>Carrier: </b><br /> {$order_invoice->getCarrier($order_invoice->id)->name} <br /> <!-- / CUSTOMER INFORMATIONS --> </td> <td style="width: 85%; text-align: right"> <table style="width: 100%; font-size: 7pt;"> <tr style="line-height:4px;"> <td style="text-align: left; background-color: #4D4D4D; color: #FFF; padding-left: 10px; font-weight: bold; width: 12%">{l s='Reference' pdf='true'}</td> <td style="text-align: left; background-color: #4D4D4D; color: #FFF; padding-left: 10px; font-weight: bold; width: 38%">{l s='Product' pdf='true'}</td> <td style="background-color: #4D4D4D; color: #FFF; text-align: right; font-weight: bold; width: 12%">{l s='HS Code' pdf='true'}</td> <td style="background-color: #4D4D4D; color: #FFF; text-align: right; font-weight: bold; width: 7%">{l s='Origin' pdf='true'}</td> <!-- unit price tax excluded is mandatory --> {if !$tax_excluded_display} <td style="background-color: #4D4D4D; color: #FFF; text-align: right; font-weight: bold; width: 10%">{l s='Unit Price' pdf='true'} <br />{l s='(Tax Excl.)' pdf='true'}</td> {/if} <td style="background-color: #4D4D4D; color: #FFF; text-align: right; font-weight: bold; width: 10%">{l s='Unit Price' pdf='true'}</td> <td style="background-color: #4D4D4D; color: #FFF; text-align: center; font-weight: bold; width: 5%">{l s='Qty' pdf='true'}</td> <td style="background-color: #4D4D4D; color: #FFF; text-align: center; font-weight: bold; width: 5%">{l s='Kg' pdf='true'}</td> <td style="background-color: #4D4D4D; color: #FFF; text-align: right; font-weight: bold; width: 11%">{l s='Total' pdf='true'}</td> </tr> {foreach $order_details as $order_detail} {cycle values='#FFF,#DDD' assign=bgcolor} <tr style="line-height:6px;background-color:{$bgcolor};"> <td style="text-align: left; width: 12%">{$order_detail.product_reference}</td> <td style="text-align: left; width: 38%">{$order_detail.product_name}</td> <td style="text-align: right; width: 12%"> {$order_detail.ean13}</td> <td style="text-align: right; width: 7%"> {$order_detail.upc}</td> <!-- unit price tax excluded is mandatory --> {if !$tax_excluded_display} <td style="text-align: right; width: 10%"> {displayPrice currency=$order->id_currency price=$order_detail.unit_price_tax_excl} </td> {/if} <td style="text-align: right; width: 10%"> {if $tax_excluded_display} {displayPrice currency=$order->id_currency price=$order_detail.unit_price_tax_excl} {else} {displayPrice currency=$order->id_currency price=$order_detail.unit_price_tax_incl} {/if} </td> <td style="text-align: center; width: 5%">{$order_detail.product_quantity}</td> <td style="text-align: center; width: 5%">{round($order_detail.product_weight*$order_detail.product_quantity,1)}</td> <td style="text-align: right; width: 11%"> {if $tax_excluded_display} {displayPrice currency=$order->id_currency price=$order_detail.total_price_tax_excl} {else} {displayPrice currency=$order->id_currency price=$order_detail.total_price_tax_incl} {/if} </td> </tr> {foreach $order_detail.customizedDatas as $customization} <tr style="line-height:6px;background-color:{$bgcolor}; "> <td style="line-height:3px; text-align: left; width: 60%; vertical-align: top"> {foreach $customization.datas as $customization_types} <blockquote> {foreach $customization_types as $customization_infos name=custo_foreach} {$customization_infos.name}: {$customization_infos.value} {if !$smarty.foreach.custo_foreach.last}<br /> {else} <div style="line-height:0.4pt"> </div> {/if} {/foreach} </blockquote> {/foreach} </td> <td style="text-align: right; width: 15%"></td> <td style="text-align: center; width: 10%; vertical-align: top">({$customization.quantity})</td> <td style="width: 15%; text-align: right;"></td> </tr> {/foreach} {/foreach} </table> <table style="width: 100%"> {if (($order_invoice->total_paid_tax_incl - $order_invoice->total_paid_tax_excl) > 0)} <tr style="line-height:5px;"> <td style="width: 85%; text-align: right; font-weight: bold">{l s='Product Total (Tax Excl.)' pdf='true'}</td> <td style="width: 15%; text-align: right;">{displayPrice currency=$order->id_currency price=$order_invoice->total_products}</td> </tr> <tr style="line-height:5px;"> <td style="width: 85%; text-align: right; font-weight: bold">{l s='Product Total (Tax Incl.)' pdf='true'}</td> <td style="width: 15%; text-align: right;">{displayPrice currency=$order->id_currency price=$order_invoice->total_products_wt}</td> </tr> {else} <tr style="line-height:5px;"> <td style="width: 85%; text-align: right; font-weight: bold">{l s='Product Total' pdf='true'}</td> <td style="width: 15%; text-align: right;">{displayPrice currency=$order->id_currency price=$order_invoice->total_products}</td> </tr> {/if} {if $order_invoice->total_discount_tax_incl > 0} <tr style="line-height:5px;"> <td style="text-align: right; font-weight: bold">{l s='Total Vouchers' pdf='true'}</td> <td style="width: 15%; text-align: right;">-{displayPrice currency=$order->id_currency price=$order_invoice->total_discount_tax_incl}</td> </tr> {/if} {if $order_invoice->total_wrapping_tax_incl > 0} <tr style="line-height:5px;"> <td style="text-align: right; font-weight: bold">{l s='Wrapping Cost' pdf='true'}</td> <td style="width: 15%; text-align: right;"> {if $tax_excluded_display} {displayPrice currency=$order->id_currency price=$order_invoice->total_wrapping_tax_excl} {else} {displayPrice currency=$order->id_currency price=$order_invoice->total_wrapping_tax_incl} {/if} </td> </tr> {/if} {if $order_invoice->total_shipping_tax_incl > 0} <tr style="line-height:5px;"> <td style="text-align: right; font-weight: bold">{l s='Shipping Cost' pdf='true'}</td> <td style="width: 15%; text-align: right;"> {if $tax_excluded_display} {displayPrice currency=$order->id_currency price=$order_invoice->total_shipping_tax_excl} {else} {displayPrice currency=$order->id_currency price=$order_invoice->total_shipping_tax_incl} {/if} </td> </tr> {/if} {if ($order_invoice->total_paid_tax_incl - $order_invoice->total_paid_tax_excl) > 0} <tr style="line-height:5px;"> <td style="text-align: right; font-weight: bold">{l s='Total Tax' pdf='true'}</td> <td style="width: 15%; text-align: right;">{displayPrice currency=$order->id_currency price=($order_invoice->total_paid_tax_incl - $order_invoice->total_paid_tax_excl)}</td> </tr> {/if} <tr style="line-height:5px;"> <td style="text-align: right; font-weight: bold">{l s='Total' pdf='true'}</td> <td style="width: 15%; text-align: right;">{displayPrice currency=$order->id_currency price=$order_invoice->total_paid_tax_incl}</td> </tr> {if $order_invoice->getRestPaid()} <tr style="line-height:5px;color:red;"> <td style="text-align: right; font-weight: bold">{l s='Remaining Amount Due' pdf='true'}</td> <td style="width: 15%; text-align: right;">{displayPrice currency=$order->id_currency price=$order_invoice->getRestPaid()}</td> </tr> {/if} </table> </td> </tr> </table> <!-- / PRODUCTS TAB --> <!-- / Export vs France language --> <table style="width: 100%"> <tr> <td style="width: 15%"></td> {if $customer->siret} <td border="1" style="width: 85%; font-size: 8pt"> <b>TVA à votre charge : Article 283.1 du CGI</b> <br /> </td> {else} <td border="1" style="width: 85%; font-size: 8pt"><br /> <b>Hors TVA, conformément à l’article 262 à 262 TER du CGI</b><br /> <br /> Echéance 10jours<br /> Conditions de livraison : DDP<br /> <br /> Notre répondant fiscal en France :<br /> LA LA LA YA YA YA<br /> FR 123 123 123<br /> 2 rue du Moo<br /> 92299 Neuf<br /> </td> {/if} </tr> </table> <!-- / Export vs France Language --> <div style="line-height: 1pt"> </div> {if (($order_invoice->total_paid_tax_incl - $order_invoice->total_paid_tax_excl) > 0)} {$tax_tab} {else} {/if} {if isset($order_invoice->note) && $order_invoice->note} <div style="line-height: 1pt"> </div> <table style="width: 100%"> <tr> <td style="width: 15%"></td> <td style="width: 85%">{$order_invoice->note|nl2br}</td> </tr> </table> {/if} {if isset($HOOK_DISPLAY_PDF)} <div style="line-height: 1pt"> </div> <table style="width: 100%"> <tr> <td style="width: 15%"></td> <td style="width: 85%">{$HOOK_DISPLAY_PDF}</td> </tr> </table> {/if} </div>

/pdf/invoice.tpl /pdf/invoice-b2b.tpl Good luck

For me ... and maybe I can help ... can you write in your original language ... I have difficulty understanding well your problem

My 13th Status is "Authorization accepted from PayPal"