[SOLVED] Duplicate Order Numbers: PayPal Payment

-- 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;

Th Alter Table worked.
Thank you very much.

Orders going trough to PayPal now.

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.

Ok, thanks for your feedback .

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,

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.

Hi,

Thanks for having shared your solution.