[Skip to main content](#vessel-content) # \[SOLVED\] Duplicate Order Numbers: PayPal Payment ## - **[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")** - [![MSTACE's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-05.jpeg)](/forum/user/7448-mstace "View MSTACE's Profile") Topic Author - [ Offline](/forum/user/7448-mstace) Less More - Posts: 301 - Thank you received: 11 - - 12 years 8 months ago - 12 years 8 months ago [\#145602](#145602) by [MSTACE](/forum/user/7448-mstace "View MSTACE's Profile") *[\[SOLVED\] Duplicate Order Numbers: PayPal Payment](/forum/35-orders-management/866164-solved-duplicate-order-numbers-paypal-payment#145602 "-- url of the page with the problem -- : www.resumesthatwork.com.au/ -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.")* was created by *[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")* -- url of the page with the problem -- : [ www.resumesthatwork.com.au/](http://www.resumesthatwork.com.au/) -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: **This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.** Last edit: 12 years 8 months ago by [MSTACE](/forum/user/7448-mstace "View MSTACE's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg2NjE2NC1zb2x2ZWQtZHVwbGljYXRlLW9yZGVyLW51bWJlcnMtcGF5cGFsLXBheW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 8 months ago [\#145644](#145644) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Duplicate Order Numbers: PayPal Stopping Payment](/forum/35-orders-management/866164-solved-duplicate-order-numbers-paypal-payment#145644 "-- url of the page with the problem -- : www.resumesthatwork.com.au/ -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.")* Hi, A solution will probably be : - To clear your order listing history through your PayPal account - or to increase your order number by using this SQL request through your phpmyadmin for example : ALTER TABLE #_hikashop_order AUTO_INCREMENT=10000; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg2NjE2NC1zb2x2ZWQtZHVwbGljYXRlLW9yZGVyLW51bWJlcnMtcGF5cGFsLXBheW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")** - [![MSTACE's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-05.jpeg)](/forum/user/7448-mstace "View MSTACE's Profile") Topic Author - [ Offline](/forum/user/7448-mstace) Less More - Posts: 301 - Thank you received: 11 - - 12 years 8 months ago [\#145793](#145793) by [MSTACE](/forum/user/7448-mstace "View MSTACE's Profile") Replied by *[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")* on topic *[Duplicate Order Numbers: PayPal Stopping Payment](/forum/35-orders-management/866164-solved-duplicate-order-numbers-paypal-payment#145793 "-- url of the page with the problem -- : www.resumesthatwork.com.au/ -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.")* Th Alter Table worked. Thank you very much. Orders going trough to PayPal now. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg2NjE2NC1zb2x2ZWQtZHVwbGljYXRlLW9yZGVyLW51bWJlcnMtcGF5cGFsLXBheW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")** - [![MSTACE's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2013-07-05.jpeg)](/forum/user/7448-mstace "View MSTACE's Profile") Topic Author - [ Offline](/forum/user/7448-mstace) Less More - Posts: 301 - Thank you received: 11 - - 12 years 8 months ago - 12 years 8 months ago [\#145809](#145809) by [MSTACE](/forum/user/7448-mstace "View MSTACE's Profile") Replied by *[MSTACE](/forum/user/7448-mstace "View MSTACE's Profile")* on topic *[Duplicate Order Numbers: PayPal Payment](/forum/35-orders-management/866164-solved-duplicate-order-numbers-paypal-payment#145809 "-- url of the page with the problem -- : www.resumesthatwork.com.au/ -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.")* **UPDATE:** The first order after the Alter Tables worked fine. The rest of the orders since then are being rejected by PayPal as duplicates again. Re-did the SQL command. NOW the order numbers look totally different. Working now. Last edit: 12 years 8 months ago by [MSTACE](/forum/user/7448-mstace "View MSTACE's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg2NjE2NC1zb2x2ZWQtZHVwbGljYXRlLW9yZGVyLW51bWJlcnMtcGF5cGFsLXBheW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 8 months ago [\#145831](#145831) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[\[SOLVED\] Duplicate Order Numbers: PayPal Payment](/forum/35-orders-management/866164-solved-duplicate-order-numbers-paypal-payment#145831 "-- url of the page with the problem -- : www.resumesthatwork.com.au/ -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.")* Ok, thanks for your feedback ![:)](/media/kunena/emoticons/8.png ":)"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg2NjE2NC1zb2x2ZWQtZHVwbGljYXRlLW9yZGVyLW51bWJlcnMtcGF5cGFsLXBheW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mulmud](/forum/user/31805-mulmud "View mulmud's Profile")** - [![mulmud's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31805-mulmud "View mulmud's Profile") - [ Offline](/forum/user/31805-mulmud) Less More - Posts: 5 - Thank you received: 1 - - 12 years 6 months ago [\#151398](#151398) by [mulmud](/forum/user/31805-mulmud "View mulmud's Profile") Replied by *[mulmud](/forum/user/31805-mulmud "View mulmud's Profile")* on topic *[\[SOLVED\] Duplicate Order Numbers: PayPal Payment](/forum/35-orders-management/866164-solved-duplicate-order-numbers-paypal-payment#151398 "-- url of the page with the problem -- : www.resumesthatwork.com.au/ -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.")* Hello, Is there a work-around for this solution? I have no idea how to use PHP , although I do have FTP access to all files on my website server. And paypal does not allow for deleting order history. Thank You, Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg2NjE2NC1zb2x2ZWQtZHVwbGljYXRlLW9yZGVyLW51bWJlcnMtcGF5cGFsLXBheW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mulmud](/forum/user/31805-mulmud "View mulmud's Profile")** - [![mulmud's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31805-mulmud "View mulmud's Profile") - [ Offline](/forum/user/31805-mulmud) Less More - Posts: 5 - Thank you received: 1 - - 12 years 6 months ago [\#151443](#151443) by [mulmud](/forum/user/31805-mulmud "View mulmud's Profile") Replied by *[mulmud](/forum/user/31805-mulmud "View mulmud's Profile")* on topic *[\[SOLVED\] Duplicate Order Numbers: PayPal Payment](/forum/35-orders-management/866164-solved-duplicate-order-numbers-paypal-payment#151443 "-- url of the page with the problem -- : www.resumesthatwork.com.au/ -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.")* I solved the issue via FTP by going to the following file path: /httpdocs/administrator/components/com_hikashop Access the SQL file tables.sql Scroll down to #_hikashop_tables change the "int(10) value to a different increment value save the file and re-upload to the server. The following user(s) said Thank You: [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg2NjE2NC1zb2x2ZWQtZHVwbGljYXRlLW9yZGVyLW51bWJlcnMtcGF5cGFsLXBheW1lbnQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")** - [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile") - [ Offline](/forum/user/4105-xavier) Less More - Posts: 13201 - Thank you received: 2322 - - - - [](http://www.kidiweb.fr) - 12 years 6 months ago [\#151469](#151469) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile") Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[\[SOLVED\] Duplicate Order Numbers: PayPal Payment](/forum/35-orders-management/866164-solved-duplicate-order-numbers-paypal-payment#151469 "-- url of the page with the problem -- : www.resumesthatwork.com.au/ -- HikaShop version -- : 2.3.0 -- Joomla version -- : 3.2.2 -- PHP version -- : x.x.x -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : Error_message I recently updated my client's website to Joomla 3.2.2 from Joomla 2.5. Thus this was a new HikaShop install again since it was a different platform. Paypal is now stopping payment on all of the orders because the invoice numbers are the same as the old system. So it appears that the invoice was already paid. I did change the Order and Invoice number format to: 2014-{automatic_code} The order numbers now appear as: Order number : 2014-Q14 (The last order number in the J2.5 site was: F1W34) But this DOES NOT seem to fix the problem. Same error with PayPal: This invoice has already been paid. For more information, please contact the merchant. Your purchase couldn't be completed There's a problem with the merchant's PayPal account. Please try again later.")* Hi, Thanks for having shared your solution. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL29yZGVycy1tYW5hZ2VtZW50Lzg2NjE2NC1zb2x2ZWQtZHVwbGljYXRlLW9yZGVyLW51bWJlcnMtcGF5cGFsLXBheW1lbnQ/dG1wbD1tYXJrZG93bg==) 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.348 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)