how to remove all old transaction from HQ Database?

Posted by Ramy0101 on February 16, 2008, 6:12 am

Please log in for more thread options

I deleted the trasaction from a store (store administrator -> database-

> delete transaction)

and now i want to delete it from the HQ. How can i do that ?

I tried to create "style:401 request data upload" worksheet and
setting the effictive date to an old date.
as i read and quote from the manual:
"Before uploading data, any transactions in the Headquarters database
that were previously uploaded for the same time period are deleted.
This ensures that the Headquarters database will not receive duplicate
records even if the same data upload worksheet upload is executed more
than once."

but it didn't have any effect.
what best way to remove this data?

Ramy

Posted by jocelynp on February 21, 2008, 10:28 am

Please log in for more thread options

Ramy -

If you really want to delete your trxs from HQ and not preserve the data
(not really recommended, possibly why there are no post backs yet):

You can execute the same selective delete queries you used on SO in HQ -
just make sure you run selects for the trxs you are going to remove - maybe
backup this info by exporting and filing away - then Backup your db - and
execute your delete statements.

Good luck.
--
Jocelyn

"Ramy0101" wrote:

> I deleted the trasaction from a store (store administrator -> database-

> > delete transaction)

> and now i want to delete it from the HQ. How can i do that ?

> I tried to create "style:401 request data upload" worksheet and

> setting the effictive date to an old date.

> as i read and quote from the manual:

> "Before uploading data, any transactions in the Headquarters database

> that were previously uploaded for the same time period are deleted.

> This ensures that the Headquarters database will not receive duplicate

> records even if the same data upload worksheet upload is executed more

> than once."

> but it didn't have any effect.

> what best way to remove this data?

> Ramy