Nixnix

That's great! May I ask, which version of PrestaShop are you using? In your PrestaShop General Preferences, how have you set your "round mode" and "round type"? Which version of PayPal are you using? Thank you!

Hallo zusammen, ich habe eine Frage zum Thema Checkbox-Integration wegen Datenschutz, und zwar: https://www.onlinehaendler-news.de/recht/rechtsfragen/11215-email-adresse-kunden-transportunternehmen-weitergeben.html Unsere Kunden werden direkt vom Paketdienstleister kontaktiert (mit einen Paketverfolgungslink). Wir brauchen, neben die AGB, einen Opt-In Check-Box wie z.B.: "Ich stimme zu, dass meine Mailadresse zwecks meiner Information über den Versandstatus an UPS weitergegeben wird". Ich frage mich, wie kann ich sowas in der Art in PrestaShop (1.6.1.4) integrieren? Es ist, glaube ich, keine Standardfunktion. Besten Dank.

Hi rtkjeldsen, I'm bumping your thread, because I would like something like this as well. Physical vouchers are a very good thing in some branches of trade, and I sadly didn't find any module or solution for PrestaShop... One question I have is: If the customer buys product X (any normal product) and then also buys a gift voucher, can they be delivered to different addresses? Because maybe the customer wants product X for herself and then send a gift voucher to somebody else. A way would be to add a separate address field for this specific product, but I couldn't find a solution for this. I would also like the possibility to get an email notification when this particular product is bought, a separate "heads up" mail to the shop admin, to know a special product has been sold. Another thought: I suppose gift vouchers should always have 0% tax, since the products which are later bought for the voucher all have tax on them? Otherwise tax would be doubled. Can anyone share some insights? Is anyone already doing this? How?

Sorry for bumping this old threat but your advise is excellent and I wanted to say thanks! I have a question though - I want to export all categories and include their text descriptions, but they are in html format with some language specific html characters (such as é) and hence the semi-colon character completely garbles up the exported file since semicolon seems to be the csv cell separator. How can I export it with another character as cell delimiter? Thanks!

Thanks rocky! Neat. Is there a reasonably easy way to insert a regular product listing here instead of this? The reason I ask is because my theme already put the "same category" on the product page but a bit further down on the page, and it would be nice to have a regular product category list (the sold out products complete parent category) displayed directly below the error message.

I tried these changes on 1.6.0.9 but it didn't work for me. I saw someone had uploaded the changed files for 1.6.0.6 in another (Polish) thread but those files are no longer available for download. Does anyone know how to achieve this on 1.6.0.9? That version is already quite old but we can not upgrade at the moment and this would be a great feature for our customers.

We use our invoices as picking lists. By us, in 95% of the cases, only 1 item per product is purchased, and when it's two or more, it happens that we oversee it. I wanted to highlight the quantity field (similar to how it is highlighted in the backoffice order page). I did it this way: Open /themes/pdf/invoice.tpl Find {$order_detail.product_quantity} replace it with: {if $order_detail.product_quantity > 1} <div style="color: #ffffff; background-color: #000000"> {$order_detail.product_quantity} </div> {else} {$order_detail.product_quantity} {/if} Stupid simple, of course. This creates a black background with white text for any items with 2 or more purchased. Maybe there is a nicer way to do this and to present it in a prettier way, for those into design (those 's are nasty, I know). But it works and I just thought I would share it. It would be neat if this was the default behaviour of PrestaShop, or at least available as an option for delivery slips and invoices.

For reference, I added: {if $order->recyclable} <b>Recycling</b> {/if}<br /> {if $order->total_wrapping > 0} <b>Gift</b> {/if} Into invoice.tpl, and it seems to work fine. Thank you tuk66!

Hallo. Ich hoffe ich bin in dieses Unterforum richtig. Wenn wir Prestashop für Onlineverkauf benutzen aber auch in ein physisches Ladengeschäft, wie können wir täglich ein Z-Bon erstellen (fürs Finanzamt erforderlich)? Ins Ladengeschäft geht es ja um Bargeld. Wir drucken eine Quittung pro Kauf im Laden aus und der Drucker öffnet automatisch unser Kassenlade, aber bei so eine Lösung gibt es kein Z-Bon-Funktion wie auf eine alte klassische manuelle Kassenlade. Hier mehr zum Thema, auf Englisch (da deutsch nicht meine Muttersprache ist): https://www.prestashop.com/forums/topic/504337-physical-store-how-to-print-daily-sales-report-receipt/ Erfahrungen jemand? Vielen Dank im Voraus.

Hello community and developers. How do you print a daily sales report in Prestashop? In physical stores in Germany which use a cash register, a daily so called "Z-Bon" (Z-receipt) is absolutely mandatory. I am sure this is the case all over the world. This is a receipt which every cash register in every store has to have, and it has to be printed daily when the business day is over. These receipts have to be kept for 10 years - in paper form or digitally - in case the tax office asks to know (which they will). We are selling both online and in a physical store. The online part is no problem and for physical store customers we use a Prestashop module which has a generic Prestashop user ("Store-User") so our coworkers doing the finances can easily define which purchase was online and which was in the store. All purchases, in the store and online, are regular orders in our Prestashop Orders section. The Store-User can pay via either cash or credit card (our store clerk picks this when creating the order). The module just creates a specially designed receipt that we print with a receipt printer which in return opens our cash drawer in the store (for online orders we print a regular A4 size invoice). This is so that we don't need to print an invoice or picking list for each customer in the store, store customers just want a small receipt. The thing is, we need Prestashop to daily print a report with the following from only the store customer purchases: 1) Name of our company 2) Daily store turnover (excl. VAT and incl. VAT) 3) Z-Number (A unique daily number for each daily total receipt, each day this number increases by 1) 4) Sum of cancelled purchases and returns 5) Way of payment (cash, credit card) 6) Number of store customers (may be a continous number, or reset daily) These six points are absolutely mandatory by the tax office in Germany. How would we best go about doing this? Thousands of merchants must have had the need for this already as many have both a store and an online shop, so is this functionality already built into Prestashop but we didn't find it? Sorry for the long post. Thanks in advance.

Hello. I have a question about the options gift wrapping and recycled packaging. We use both these options, but they are quite easy to miss during the packing process. We only use invoices (not delivery slips) and now we have to look at the order page in the backoffice and manually write a note by hand if for example the customer chose recycled packaging. I would like to put this information somewhere on the invoice. How would I go about doing that? Optimally, I would just want a small code such as for example "G Y/N" (for gift) and "R Y/N" (for recycled) printed somewhere on the invoice with Y or N depending on the customer's choice. We use PS 1.6.0.9. Thank you.

Can anyone share some insight on this? Is it even technically possible to do what vekia suggests in post #2? Or are there any other solutions, such as a temporary reservation somehow? For example: Add to cart reserves it for 15 minutes. Especially during special sales we have noticed it is not unusual to happen and it is always very bad to let a customer know we can not deliver what they legitimately ordered (when the software is to blame...).

obewanz, did you ever find a solution to this nasty bug? Is it related to 1.6.0.9 only? Anyone know of a fix?

Hi. We use a CMS-page with content_only for some some special information on our web page. It looks fine in desktop view. However, on mobile (for example screen width 320px) the text does not fit and it horizontally flows outside the popup. Please see attached image for example. Having a vertical scrollbar is fine, but the text doesn't fit horizontally as you can see. How can I force the content to fit the width when the user has a lower resolution screen? It would be neat with just some small css trick that I can just put inline in a div container (since this only affects one page). The only way I can make it look "OK" in mobile view is to put all the CMS-page text content in a div and use style="max-width:65%;". Makes the desktop view look too thin though. Thank you in advance.

I should add that when I look at Preview in tinyMCE editor, it actually looks fine. But when I load a page the entire badge gets misplaced. It also seems to automatically cover 100% width below my page.

Hello community. I am trying to integrate Trusted Shops Review Sticker, as described here (scroll down to the Review Sticker part): http://www.trustedshops.co.uk/support/show-customer-reviews/ However, regardless of where I put my code, the Trusted Shops Review Sticker badge appears below my entire website. I use the tinyMCE editor and my HTMLpurifier etc is set to off. One place I have tried to put the code is in a contentBox (http://contentbox.org/) which is hooked to my right sidebar (using the skyscraper_vertical variant, see Trusted Shops code for explanation). But the Trusted Shops badge always appears at the bottom, below my normal footer area. Did anyone integrate this successfully? Any ideas what I'm doing wrong here?

Hi honeybeetdm, thanks for your input. This however - I assume - disables the function of guest-purchases, which is important to us. If you don't need that, it indeed seems like a good workaround for the smartblog bug...

I just realized we have the same problem, but the other way around (only updates for guest visitors). Since your page seems to update the smartblog homelatest module now, how did you solve it? If I clear the Prestashop cache it updates, but that's a short term solution...

Thanks, but with this query I get a red warning in PS 1.6.0.9:

Thanks tuk66! That's awesome! I just noticed there is a lot of products with blank id_product in my new exported list. How can I add Product Name to this query, to get a clue what these empty rows might be?

Sorry to bump this thread, but does anyone know how to export a product list with warehouse location included? We still, months later, receive orders where Prestashop splits our orders into two (creating a customer support mess and confused customers) because some products have a warehouse location, and some don't. And there is no way for us to see out entire catalog with warehouse location info. I tried this SQL query variant: SELECT * FROM ps_warehouse_product_location WHERE ps_warehouse_product_location.id_warehouse_product_location But it seems to just show the stuff which already has a location. I'm not experienced with database things, as you see.

Here is the solution to this error: https://github.com/smartdatasoft/smartblog/issues/20 The variable 'content' is very generic and the Smartblog developer should change it. But until then, this works.

For anyone who may be interested: Future versions of the Amazzing Filter module will apparently have this feature built in. I can confirm Jon's opinion: Very high quality module and professional support. Highly recommended.

Cool, thanks PhpMadman! Is there any way we can also export the entire catalog of products with warehouse_location included, so we can easily double check that everything really is assigned a location? When I do a normal product export there is barely any information but I guess it would be possible with a sql query. I just don't know how.

Nice! Can anyone advise; how can I make an SQL query to activate Advanced Stock Management for all products at once? We are manually assigning warehouse location for each product now (and clicking this checkbox for each product) and when we currently get orders, the orders get split up in Prestashop (customer makes 1 order, we get 2 invoices: one for the ones with advanced stock management and one for those without it). So we just quickly want to activate it for everything on the fly. Thanks in advance.