[Urgent] Reset orders datas before opening ?

Before you ask about IDnR Addon see the VirtueMart - Invoice, Delivery Note and Receipt Addon
Mister Paul
Phoca Newbie
Phoca Newbie
Posts: 3
Joined: 17 Aug 2010, 22:19

[Urgent] Reset orders datas before opening ?

Post by Mister Paul »

Hi,

sorry for the [Urgent] but it is...
I hope your indulgence.
:)

It's time to go online for our shop... :twisted:
So I'd like to clean all the database infos gathered during development tests.
I have already deleted dummies products but now I need to clean orders.

1°On backend I changed the order statuts to 'Pending'. And then deleted them. OK
2° With phpMyAdmin I see that `jos_vm_orders` is empty now.
But I should reinitialize increment by this SQL command :
ALTER TABLE `jos_vm_orders` AUTO_INCREMENT =1
3°But 3 tables created by Phoca are still with old datas :
`#__{vm}_bills`
`#__{vm}_deliveries`
`#__{vm}_delivery_item`

Should I delete all the datas from these 3 tables and then reinitialize increment ?

Is it safe ?
No other tables to clean ?

Thanks for your help.
Paul
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: [Urgent] Reset orders datas before opening ?

Post by Jan »

Hi, sorry, I think this is more VM question, you can delete all data from IDNR addon tables (see in guide which they are), if you want to clean all your VM data, then I think, you need to clean the order table but maybe some others too - but this is then question on VM forum :-( :idea:

Jan
If you find Phoca extensions useful, please support the project
Post Reply