Search the Community

Buenas, tengo un problema y espero que puedan ayudarme. Actualmente estoy trabajando con Prestashop 1.6 y necesito saber como puedo poner que la referencia id sea igual al pedido id. El caso es que con el siguiente código se pone igual, pero el problema es que cuando elimino el pedido la referencia se pierde. Necesito que cuando se haga un nuevo pedido la referencia siga siendo la misma que el id pedido. Ese es el código que hace que la referencia sea igual al pedido: $last_id = Db::getInstance()->getValue(' SELECT MAX(id_order) FROM '._DB_PREFIX_.'orders'); return str_pad((int)$last_id + 1, 9, '000000000', STR_PAD_LEFT); Ahora necesito saber lo siguiente. Adjunto pantallazos para que vean. Espero que puedan ayudarme. Gracias

I am trying to insert the Order ID (not reference) {id_order} and Product ID {id_product} into my email confirmation. Neither one is being processed when the email is being sent. In both cases just the variable is showing in the email. Any ideas?

Hello everyone, First, I apologize for the long post, but I believe this requires details. I am having these problems with shopping carts, on both PS 1.6.09 and 1.5.6 (I have two different stores): 1- when a customer (new or old) logs in, an empty ghost cart is created automatically in BO (showing 0.00 RON/EUR value). These empty shopping carts have the "delete" option, but I don't think that creating empty carts at login is normal behavior. 2- after placing an order, the shopping cart is converted into an order and it's visible in "orders" section, but it also remains in the "customers/shopping carts" section, without the "delete" option there. 3- in 1.5.6 only, I have enabled the guest check-out option. In this store I have guest shopping carts that have not been transformed into orders but are still in in the "customers/shopping carts" section and do not have the "delete" option. 4- I have noticed that the Shopping Cart ID's are not in order, but are in a random order, on both 1.6.09 and 1.5.6. Whereas the Orders ID's are in the right order. Does anyone encountered these issues and managed to fix them? What would be the appropriate way of fixing these issues, without re-installing PS from scratch? I also mention: - On both stores BO's I have been using the "database optimization" module from https://mypresta.eu/modules/administration-tools/database-optimization.html, but I have stopped using it after I had issues with the shopping cart in FO (users could not add products to cart, or had products in cart that were not added by them). - I checked and fixed the database with Prestashop Cleaner official module and the FO shopping carts issues were fixed, but I still have the above issues in BO. - Both stores use non-default themes. Can anyone give me a hint where should I look in order to fix these problems? Thank you. http://coloranti-naturali.ro http://www.cake-bake.eu

Hi everybody. I installed modrefchange in order to turn order reference from alphabetical to numerical, but it doesn't work; it says "data updated", though. I use Prestashop 1.6.0.9. I installed the module in another site I manage and worked perfectly.

I created a payment module for credit card processing. I have a problem where my customer is receiving a email confirming their order before they have entered their credit card information. This has caused a bit of confusion for the customer. The current process is as follows: User chooses payment method User confirms that they want to use this payment method Module runs validateOrder because one of the variable required by the payment gateway is order id. Email gets sent to user saying that their order has been confirmed User gets redirected to payment gateways site If user inputs everything correctly on the site, the user will be redirected back to my site I change the status of the order based on whether the users transaction has been approved or not. My questions are : Is it possible to get the order id before I validate order? (I can see how this may not make sense with multiple transactions happening at the same time) if not, can I prevent the order from sending a order confirmed email until step 4? Your help is greatly appreciated.

how to enable order id in numbers? we prefer to order id in number not alphabets is there any option ? Thanks

Hello, Can someone please help me with how I can pass the order ID, order total, and zip code through my bizrate code? Thanks!

To replace uppercase in the Order reference and replace with numbers (id_order as in older versions) I made this simple code override in /override/classes/order/Order.php: <?php class Order extends OrderCore { public function getUniqReference() { $query = new DbQuery(); $query->select('MIN(id_order) as min, MAX(id_order) as max'); $query->from('orders'); $query->where('id_cart = '.(int)$this->id_cart); $query->orderBy('id_order'); $order = Db::getInstance()->getRow($query); /*if ($order['min'] == $order['max']) return $this->reference; else return $this->reference.'#'.($this->id + 1 - $order['min']);*/ return sprintf('%06d', $this->id); } public static function getUniqReferenceOf($id_order) { $order = new Order($id_order); return $order->getUniqReference(); } } To return to the original letters designation, you must remove comment from 'if' and add comment to //return sprintf('%06d', $this->id); .

we have recently migrated to prestashop and want to add a manual payment system for customers to pay cash at a paypoint out let, I have managed to set up the payment system but need to be able to add a reference to the payment, in our old system i was set up to automatically add the order ID to the payment. I am having a few problems because i can't figure out the command for the order ID or Reference. We need to add the order id in the url below where the red part is, https://www.credecard.com/uk/Barcode/BarcodeDistribute.aspx?seq=29568929&ref=order-detail&validitydays=365&validitymonths=0&enc=0 Can anyone help Thanks In Advance

I am trying to insert the tracking code of an affiliate I am abuot to start working with. They have their own system and publishers, but I need to insert their tracking code in my site. I have two questions: Where should I insert the code? Is it at the end of the order_confirmation.tpl? How can I make variable oder values and id's? I include here the code for your review. <iframe src="https://www.xxxxxxx.com/scripts/check_sale.php?ordervalue=0&order_id=2&advertiser_id=926" scrolling="no" frameborder="0" width="1" height="1"></iframe> Any help would be extremelly appreciated guys!!! Thanks a lot in advance Rasmy

Hi, when a user buys a product as a guest it is usefull after the confirmation dialog to show the order reference, not the order id which is only internal... You can see that if you go to buy as guest and then select one of: bank wire, COD, or cheque. The text displays the id no which is something like #00000013 and not the reference no which is like YUIWGEHJKJ/ I found that this info is in order-confirmation.tpl in line 42 but how can I show the reference number? I tried with: {$reference_order}, {$reference} but with no luck..

Hello all I need to start the order id from a specific and custom number. For example I don't want my first order start from 1, but from, say, 255344... I don't seem to find anywhere to do this. I know that i can do this for Invoice (starting from a custom number) anyone got this to work? I appreciate any help... Ed

Greetings. Don't know if this is the right place, but i have this problem i need solved. In the email the customer recieve upon paying ( order confirm email ), where they can see what they bought and for how much.. in there i need to change the order id so it will show the cart id... i figured how to do this in mailalerts ( the one i recieve when they buy ). And in the backoffice so those order id's are the cart id's aswell... but on the customers order confirm, i can't figure out how to do it.. please help.. Greets Martin

Hi all, I have a client who is persistent about getting the invoice ID number and order ID number removed from customer correspondence, namely the PDF Invoice and Order Email - How would I go about this? Any info is greatly appreciated!

Hi, I'm trying to add the order id on the email order confirmation subject that its sent to a customer. I want the subject to be like "Subject [order id]". I've tried adding '['.$order->id.']'. Edit: I added that to PaymentModule.php and seems to work. Now I need to add it to the order statuses like "Waiting for payment" or "Payment accepted" but I have no idea of where to put it because I don't see anything related to that in the files. Any ideas?