Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
turbobricks (Guest)
turbobricks (Guest)
I want to adjust the order numbers (manipulate it) to match my quickbooks system - Instead of Order No. 27, I want it to be something like 3027, and then be sequential after that.
 
Anyway to do this?
 
SajMalik
SajMalik
You can change this in the database manually - but not inside Viart.
 
Using phpMyAdmin you can access the mySQL database and edit the table - vaOrders.
 
Change the number of the last order - if you do not yet have any order create an order and number it 3026. The first real customer becomes 3027 and you can then delete your first 'dummy' order.
 
I hope this helps you.
 
Chris
 
turbobricks (Guest)
turbobricks (Guest)
Thanks Chris - I will try to do this. Since Viart is hosting my shop, I am going to have to ask them to do this as I dont have access to the mySQL database... (at least I dont think I do)
 
ViArtSupport (Guest)
ViArtSupport (Guest)
Hello,
 
1.To update your last order which has the number 44, for example, you are to
run the following query( admin>system> DB management>Run SQL Query):
 
UPDATE va_orders SET order_id=6050 WHERE order_id=44.
 
Then your last order will have the 6050 number and the new orders will start
from 6051 number.
 
You will not need to edit any tables in your database in this case.
 
With regards,
ViArt Support Team