Hi,
sorry for the [Urgent] but it is...
I hope your indulgence.
It's time to go online for our shop...
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
[Urgent] Reset orders datas before opening ?
-
- Phoca Newbie
- Posts: 3
- Joined: 17 Aug 2010, 22:19
- Jan
- Phoca Hero
- Posts: 48403
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: [Urgent] Reset orders datas before opening ?
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
Jan
Jan
If you find Phoca extensions useful, please support the project