The guy using the freetrade as his store wants to start over with the
invoices since there were quite a few used for orders tests and a few that
seem to have vanished.
Shawn
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Chuck
Gartland
Sent: June 6, 2001 4:58 PM
To: [EMAIL PROTECTED]
Subject: RE: [FreeTrade-dev] Clearing out database invoices
Shawn,
Perhaps you have a good reason to do this. I really do not find it likely
though. Assuming that you have a good reason you need to write a script.
The script should update each existing invoice with some sort of prefix.
The script should also make sure that if the invoice number is referenced
anywhere else (customer history or something like that) that the invoice
number is updated. Then you can start over with one. If you start over at
one with out getting rid of all traces of the old invoice numbers you will
wind up with duplicate invoice numbers and would deserve to be spanked. And
not by anyone from whom a spanking may be a good thing. You could update
all the invoice numbers and references to them manually but that would
introduce quite a bit of room for human error.
Why are you wanting to restart at one? Is this just an arbitrary decision
or will restarting at one some how improve performance or customer service?
Hope this helps,
Chuck
-------------------------------------------------
Chuck Gartland || [EMAIL PROTECTED]
Project 27 || www.project27.com
1836 Palm Avenue || 808 465-1381
Pearl City, HI 96782 || GMT -10:00 hours
-------------------------------------------------
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Shawn
> Honeychurch
> Sent: Wednesday, June 06, 2001 12:43 PM
> To: [EMAIL PROTECTED]
> Subject: [FreeTrade-dev] Clearing out database invoices
>
>
> Hello all;
>
> Does anyone know of a quick and effective way to reset the invoice numbers
> in the freetrade database? I just want to restart all the
> invoices at 1 and
> go from there without affecting the items or customer orders
> already in the
> database.
>
> Shawn
>
> _______________________________________________
> FreeTrade-dev mailing list
> [EMAIL PROTECTED]
> http://share.whichever.com/mailman/listinfo/freetrade-dev
>
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
_______________________________________________
FreeTrade-dev mailing list
[EMAIL PROTECTED]
http://share.whichever.com/mailman/listinfo/freetrade-dev
