[Skip to main content](#vessel-content) # how to test purchase from begin to end ## - **[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")** - [![podjigateli's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2329-podjigateli "View podjigateli's Profile") Topic Author - [ Offline](/forum/user/2329-podjigateli) Less More - Posts: 10 - Thank you received: 0 - - 15 years 6 months ago [\#15187](#15187) by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile") *[how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15187 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* was created by *[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")* Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 6 months ago [\#15199](#15199) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15199 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Sure. There are several possibilities. You can can for example activate the bank transfer payment plugin and use it to complete the order. Otherwise, if you want to test an online payment method like paypal, you would have to configure it so that it runs on test mode. For paypal, you need to change the URL so that you use the sandbox. You also need a sandbox account in order to be able to test it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")** - [![podjigateli's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2329-podjigateli "View podjigateli's Profile") Topic Author - [ Offline](/forum/user/2329-podjigateli) Less More - Posts: 10 - Thank you received: 0 - - 15 years 6 months ago - 15 years 6 months ago [\#15260](#15260) by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile") Replied by *[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15260 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Thanks. What that means? This invoice has already been paid. For more information, please contact the merchant. At this time, we are unable to process your request. Please return to @yahoo.com and try another option. [ ![[img](http://www.hikashop.com/media/kunena/attachments/legacy/images/screen-20110428.jpg) ](http://www.hikashop.com/media/kunena/attachments/legacy/images/screen-20110428.jpg "[img") when I returned to my site there was a blank(nothing). - [ ![screen-20110428.jpg](/forum/attachment/1026) ](/forum/attachment/1026 "...n-20110428.jpg") [ ](/forum/attachment/1026?download=1 "...n-20110428.jpg") Last edit: 15 years 6 months ago by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 6 months ago [\#15263](#15263) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15263 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* It is possible for Paypal to report an order as already being paid if they have received an identical invoice number in the past. There are a couple ways to resolve this issue: In Your Paypal Account: Login to your Paypal account by going to [ www.paypal.com](http://www.paypal.com). Click "Profile" on the top menu bar. Under "Selling Preferences", click "Payment Receiving Preferences". Under "Block Accidental Payments", choose "No, allow multiple payments per invoice ID". On the HikaShop side: Open your phpmyadmin and select your database. There increase the auto_increment value of the hikashop_order table by running a query: [ www.cxliv.org/2005/01/06/updating\_auto-increment\_in\_mysql.php](http://www.cxliv.org/2005/01/06/updating_auto-increment_in_mysql.php) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")** - [![podjigateli's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2329-podjigateli "View podjigateli's Profile") Topic Author - [ Offline](/forum/user/2329-podjigateli) Less More - Posts: 10 - Thank you received: 0 - - 15 years 5 months ago [\#15350](#15350) by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile") Replied by *[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15350 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* So I did it all that you said. The transaction was completed but when I returned to store again there was nothing, no links to download file. I trying to sell file a image. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 5 months ago [\#15354](#15354) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15354 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* The links to the downloadable files are on the order details page. What you could do is set the orders listing page as return URL in the options of your paypal plugin... You can also edit the thank you message to tell the user that he needs to go to his order page to download the files. You can do that in the config under the tab languages. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")** - [![podjigateli's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2329-podjigateli "View podjigateli's Profile") Topic Author - [ Offline](/forum/user/2329-podjigateli) Less More - Posts: 10 - Thank you received: 0 - - 15 years 5 months ago [\#15374](#15374) by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile") Replied by *[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15374 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Thanks. So inconspicuous link. Had to do bigger, attractive. Need to add label "Download"->. One more question how to automatecly confirm purchase when buyer paid in paypal? I can set Pending status to "confirm" but is it not will be a hole for cheaters... Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 5 months ago [\#15377](#15377) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15377 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* You need to activate the option "allow payment notifications from paypal". Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")** - [![podjigateli's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2329-podjigateli "View podjigateli's Profile") Topic Author - [ Offline](/forum/user/2329-podjigateli) Less More - Posts: 10 - Thank you received: 0 - - 15 years 5 months ago - 15 years 5 months ago [\#15462](#15462) by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile") Replied by *[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15462 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* I have not found where is to activate this option. Only "Instant Payment Notification (IPN)" method on paypal site which need to setup. Is it this? Last edit: 15 years 5 months ago by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 5 months ago [\#15483](#15483) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15483 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* It's in the options of the paypal plugin in HikaShop. You can access the options of the plugin via the menu System->Payment methods and then click on its name to open its options. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")** - [![podjigateli's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2329-podjigateli "View podjigateli's Profile") Topic Author - [ Offline](/forum/user/2329-podjigateli) Less More - Posts: 10 - Thank you received: 0 - - 15 years 5 months ago [\#15494](#15494) by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile") Replied by *[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15494 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Thanks. It was activated. Still money "unclaimed" I need to login to my paypal account and "accept" payments. I did it, even after that on my site order status just "created". I need instant(automat.) accepting all payments without any delay so customer could immediately after payment download his file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 5 months ago [\#15495](#15495) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15495 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Then, you must have a problem on your server/website as that should work as you're describing. Which version of Joomla and HikaShop are you using ? Could you give the URL of your shop so that we can try a purchase ? Could you activate the debug mode of the paypal plugin, try again an order and look at the payment log file generated by HikaShop when a notification is received ? (the path of that file can be found in the tab files of the config). If you don't have that log file after that, it's either because HikaShop doesn't have the permission to write in that file so please make sure that it exists and that its permissions are 777; or because paypal couldn't trigger hikashop. In the second case, it could be because of a security component/application on you server. Once the log file is generated, you should open it to see what it contains. There should be valuable information as to why the notification couldn't be accepted, if that's the case. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")** - [![podjigateli's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2329-podjigateli "View podjigateli's Profile") Topic Author - [ Offline](/forum/user/2329-podjigateli) Less More - Posts: 10 - Thank you received: 0 - - 15 years 5 months ago [\#15537](#15537) by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile") Replied by *[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15537 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Joomla 1.6.1 HikaShop 1.4.9 No it's a localhost. No I don't have log file Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 5 months ago [\#15544](#15544) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15544 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* It's normal then. PayPal cannot technically notify a website which is in local since it's not accessible from the outside world. You need to have it online if you want PayPal to notify it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile")** - [![ClickWebDesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-05-2.jpg)](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile") - [ Offline](/forum/user/1441-clickwebdesign) Less More - Posts: 50 - Thank you received: 0 - - [](http://www.clickwebdesign.com.au) - 15 years 5 months ago [\#15705](#15705) by [ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile") Replied by *[ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15705 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Hi, I keep getting the "This invoice has already been paid. For more information, please contact the merchant." I'm testing using the paypal sandbox. I have tried the suggestions repeated below: In Your Paypal Account: Login to your Paypal account by going to [ www.paypal.com](http://www.paypal.com). Click "Profile" on the top menu bar. Under "Selling Preferences", click "Payment Receiving Preferences". Under "Block Accidental Payments", choose "No, allow multiple payments per invoice ID". On the HikaShop side: Open your phpmyadmin and select your database. There increase the auto_increment value of the hikashop_order table by running a query: [ www.cxliv.org/2005/01/06/updating\_auto-increment\_in\_mysql.php](http://www.cxliv.org/2005/01/06/updating_auto-increment_in_mysql.php) Any further thoughts or info I can provide to help? Thanks Chris Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile")** - [![ClickWebDesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-05-2.jpg)](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile") - [ Offline](/forum/user/1441-clickwebdesign) Less More - Posts: 50 - Thank you received: 0 - - [](http://www.clickwebdesign.com.au) - 15 years 5 months ago [\#15710](#15710) by [ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile") Replied by *[ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15710 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* **ClickWebDesign wrote:** > Hi, > I keep getting the "This invoice has already been paid. For more information, please contact the merchant." I'm testing using the paypal sandbox. I have tried the suggestions repeated below: > > In Your Paypal Account: > > Login to your Paypal account by going to [ www.paypal.com](http://www.paypal.com). > Click "Profile" on the top menu bar. > Under "Selling Preferences", click "Payment Receiving Preferences". > Under "Block Accidental Payments", choose "No, allow multiple payments per invoice ID". > > On the HikaShop side: > > Open your phpmyadmin and select your database. > There increase the auto\_increment value of the hikashop\_order table by running a query: [ www.cxliv.org/2005/01/06/updating\_auto-increment\_in\_mysql.php](http://www.cxliv.org/2005/01/06/updating_auto-increment_in_mysql.php) > > Any further thoughts or info I can provide to help? > > Thanks > Chris I should add the site is not local, live at a test domain Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 5 months ago [\#15731](#15731) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15731 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* What is the query you run on your phpmyadmin? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile")** - [![ClickWebDesign's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar_2012-12-05-2.jpg)](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile") - [ Offline](/forum/user/1441-clickwebdesign) Less More - Posts: 50 - Thank you received: 0 - - [](http://www.clickwebdesign.com.au) - 15 years 5 months ago [\#15734](#15734) by [ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile") Replied by *[ClickWebDesign](/forum/user/1441-clickwebdesign "View ClickWebDesign's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15734 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* ALTER TABLE jos_hikashop_order AUTO_INCREMENT = 2023 Thanks:) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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 - - 15 years 5 months ago [\#15750](#15750) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15750 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Maybe the auto_increment is not high enough ? Also, that will only work for NEW orders, not for existing ones. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")** - [![podjigateli's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/2329-podjigateli "View podjigateli's Profile") Topic Author - [ Offline](/forum/user/2329-podjigateli) Less More - Posts: 10 - Thank you received: 0 - - 15 years 5 months ago [\#15923](#15923) by [podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile") Replied by *[podjigateli](/forum/user/2329-podjigateli "View podjigateli's Profile")* on topic *[Re: how to test purchase from begin to end](/forum/4-how-to/15187-how-to-test-purchase-from-begin-to-end#15923 "Hello. I want to test my shop without spending real money. Virtue mart has this option. Does HikaShop has that option?")* Hello. Its me again. So I uploaded my localhost on host. Still order status "created" and no logs on "media/com_hikashop/upload/safe/logs/report_246948242.log". Permission 777. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzE1MTg3LWhvdy10by10ZXN0LXB1cmNoYXNlLWZyb20tYmVnaW4tdG8tZW5kP3RtcGw9bWFya2Rvd24=) 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.164 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)