[Skip to main content](#vessel-content) # Product(s) added automatically after validation ## - **[willix](/forum/user/31079-willix "View willix's Profile")** - [![willix's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31079-willix "View willix's Profile") Topic Author - [ Offline](/forum/user/31079-willix) Less More - Posts: 2 - Thank you received: 0 - - 8 years 1 week ago [\#299117](#299117) by [willix](/forum/user/31079-willix "View willix's Profile") *[Product(s) added automatically after validation](/forum/35-orders-management/895964-product-s-added-automatically-after-validation#299117 "-- url of the page with the problem -- : www.dev.pfwilly.com/vente-en-ligne/e-commerce.html -- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox/safari/IE Hello, I work since about 1 year with an ecommerce based on hikashop 3.5.1 without problem but suddenly some clients contacted me because one or two products are added automatically after the validation. Even in the email (see attachment), you can see I've order just two products (47€ + 1,5€) but two others items has been added by the system and there is a difference between the subtotal and the total. Except upgrade sometimes Joomla, I don't touch anything. I tried also to copy the website to a development directory where I upgrade hika to v4 and also Joomla but the result is the same. I spent long hours to research the origin of the problem but I don't understand. Could you help me? Thanks in advance, William. Ps : sorry for my english ...")* was created by *[willix](/forum/user/31079-willix "View willix's Profile")* -- url of the page with the problem -- : [ www.dev.pfwilly.com/vente-en-ligne/e-commerce.html](http://www.dev.pfwilly.com/vente-en-ligne/e-commerce.html) -- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox/safari/IE Hello, I work since about 1 year with an ecommerce based on hikashop 3.5.1 without problem but suddenly some clients contacted me because one or two products are added automatically after the validation. Even in the email (see attachment), you can see I've order just two products (47€ + 1,5€) but two others items has been added by the system and there is a difference between the subtotal and the total. Except upgrade sometimes Joomla, I don't touch anything. I tried also to copy the website to a development directory where I upgrade hika to v4 and also Joomla but the result is the same. I spent long hours to research the origin of the problem but I don't understand. Could you help me? Thanks in advance, William. Ps : sorry for my english ... *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NTk2NC1wcm9kdWN0LXMtYWRkZWQtYXV0b21hdGljYWxseS1hZnRlci12YWxpZGF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86292 - Thank you received: 14271 - - 8 years 1 week ago [\#299119](#299119) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Product(s) added automatically after validation](/forum/35-orders-management/895964-product-s-added-automatically-after-validation#299119 "-- url of the page with the problem -- : www.dev.pfwilly.com/vente-en-ligne/e-commerce.html -- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox/safari/IE Hello, I work since about 1 year with an ecommerce based on hikashop 3.5.1 without problem but suddenly some clients contacted me because one or two products are added automatically after the validation. Even in the email (see attachment), you can see I've order just two products (47€ + 1,5€) but two others items has been added by the system and there is a difference between the subtotal and the total. Except upgrade sometimes Joomla, I don't touch anything. I tried also to copy the website to a development directory where I upgrade hika to v4 and also Joomla but the result is the same. I spent long hours to research the origin of the problem but I don't understand. Could you help me? Thanks in advance, William. Ps : sorry for my english ...")* Hi, What you're describing is typical of someone deleting orders in the hikashop_order table without deleting the links to the products in the hikashop_order_product table in the database. Then, the auto increment is reset to the highest order id remaining in the hikashop_order table, and next time an order is created with the id of a previous order, the products from the deleted order with the same id will be seen by HikaShop as linked to the new order. The proof of that is that the grand total is calculated by HikaShop just before the order is created by HikaShop, while the subtotal is calculated dynamically when the order details is being displayed, which explains the inconsistency between the two amounts. So updating won't change anything to that and there is no bug. The issue is that previous orders were not deleted properly by the person who did that. Normally, when you delete an order using the delete button of the orders listing, it will delete both the order and the link with the products so that this cannot happen. The following user(s) said Thank You: [willix](/forum/user/31079-willix "View willix's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NTk2NC1wcm9kdWN0LXMtYWRkZWQtYXV0b21hdGljYWxseS1hZnRlci12YWxpZGF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[willix](/forum/user/31079-willix "View willix's Profile")** - [![willix's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31079-willix "View willix's Profile") Topic Author - [ Offline](/forum/user/31079-willix) Less More - Posts: 2 - Thank you received: 0 - - 8 years 5 days ago [\#299474](#299474) by [willix](/forum/user/31079-willix "View willix's Profile") Replied by *[willix](/forum/user/31079-willix "View willix's Profile")* on topic *[Product(s) added automatically after validation](/forum/35-orders-management/895964-product-s-added-automatically-after-validation#299474 "-- url of the page with the problem -- : www.dev.pfwilly.com/vente-en-ligne/e-commerce.html -- HikaShop version -- : 4.0.0 -- Joomla version -- : 3.8.13 -- PHP version -- : 7.1.22 -- Browser(s) name and version -- : Firefox/safari/IE Hello, I work since about 1 year with an ecommerce based on hikashop 3.5.1 without problem but suddenly some clients contacted me because one or two products are added automatically after the validation. Even in the email (see attachment), you can see I've order just two products (47€ + 1,5€) but two others items has been added by the system and there is a difference between the subtotal and the total. Except upgrade sometimes Joomla, I don't touch anything. I tried also to copy the website to a development directory where I upgrade hika to v4 and also Joomla but the result is the same. I spent long hours to research the origin of the problem but I don't understand. Could you help me? Thanks in advance, William. Ps : sorry for my english ...")* Hi, Thanks for your reply. You have right even if nobody has delete order into the DB. I cleaned all fileds in the hikashop_order and hikashop_order_products and the problem is solved. Thanks again. Best regards, William. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM1LW9yZGVycy1tYW5hZ2VtZW50Lzg5NTk2NC1wcm9kdWN0LXMtYWRkZWQtYXV0b21hdGljYWxseS1hZnRlci12YWxpZGF0aW9uP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.122 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)