ShopSite Forums

Yesterday I was busy power editing price changes and product descriptions to
about 15 products-
When it came time to save I got an error message telling me that there was
a problem with some product ID's - well I was already in the process so I
had to continue to save-
When I checked to see what happened, most of my 15 products were deleted. I
went to the "sale" page where they were to appear, and there was empty space
where they should have been, and only a few products remained scattered
about. Viewing the source code for the page revealed that there were
"deleted records".

The html's for each product still existed in the servers directory, but
shopsite dumped them all from the store.
I spent the rest of the afternoon trying to put them all back(not done yet)!

My host was not able to shed any light on this.

Now I am extrememly hesitant to use power edit again. Anybody have any
ideas? I'm still using SS 5.0.1
-lauren

<http://www.heartsmith.com>

Lauren,
We've never had a problem with Power Edit but before we do anything like
this, we simply backup products/pages (Utilities > Database > Manage). You
can then easily restore if you find a problem.
Richard
www.shoplite.com

Yes... we LIVE by PowerEdit.

In over two years we haven't had one problem with PowerEdit deleting,
changing or altering products or pages other than what we wanted it to do.
Of course, we occassionally told it to do the wrong thing and screwed up the
database ourselves but nothing that wasn't our fault.

I would definately back up your databases once a month if not more often.
You'll find that it gives you a good peace of mind when something like this
happens (or if, heaven forbit, your server were to crash)...

Brandon Eley
2BigFeet.com
brandon@2bigfeet.com
www.2bigfeet.com

"shoplite.com" <rruda@shoplite.com> wrote in message
news:a8fu5d$ck4$1@support.shopsite.com...

Lauren,
We've never had a problem with Power Edit but before we do anything like
this, we simply backup products/pages (Utilities > Database > Manage). You
can then easily restore if you find a problem.
Richard
www.shoplite.com

Speaking of backups, my local computer tech says it's not "if" your system will ever need a backup, it's "when" you will need a backup. It could have been a sales pitch for more hardware but now I have peace of mind. He installed a tape drive which backups my StoneEdge Product Manager .mdb and Order Manager .mdb database every night automatically.

Jimmy Hilburger
www.switchhits.com


"Brandon" <brandon@2bigfeet.com> wrote in message news:a8hp75$pp2$1@support.shopsite.com...
Yes... we LIVE by PowerEdit.

In over two years we haven't had one problem with PowerEdit deleting,
changing or altering products or pages other than what we wanted it to do.
Of course, we occassionally told it to do the wrong thing and screwed up the
database ourselves but nothing that wasn't our fault.

I would definately back up your databases once a month if not more often.
You'll find that it gives you a good peace of mind when something like this
happens (or if, heaven forbit, your server were to crash)...

Brandon Eley
2BigFeet.com
brandon@2bigfeet.com
www.2bigfeet.com

"shoplite.com" <rruda@shoplite.com> wrote in message
news:a8fu5d$ck4$1@support.shopsite.com...

Lauren,
We've never had a problem with Power Edit but before we do anything like
this, we simply backup products/pages (Utilities > Database > Manage). You
can then easily restore if you find a problem.
Richard
www.shoplite.com

Always a good idea. I have a CDRW and a Zip drive. I just keep a backup of my databases and important info on the zip and every month or so backup my entire My Documents folder to CD's
"Switch Hits" <jimmy@switchhits.com> wrote in message news:a8hqe5$q2s$1@support.shopsite.com...
Speaking of backups, my local computer tech says it's not "if" your system will ever need a backup, it's "when" you will need a backup. It could have been a sales pitch for more hardware but now I have peace of mind. He installed a tape drive which backups my StoneEdge Product Manager .mdb and Order Manager .mdb database every night automatically.

Jimmy Hilburger
www.switchhits.com


"Brandon" <brandon@2bigfeet.com> wrote in message news:a8hp75$pp2$1@support.shopsite.com...
Yes... we LIVE by PowerEdit.

In over two years we haven't had one problem with PowerEdit deleting,
changing or altering products or pages other than what we wanted it to do.
Of course, we occassionally told it to do the wrong thing and screwed up the
database ourselves but nothing that wasn't our fault.

I would definately back up your databases once a month if not more often.
You'll find that it gives you a good peace of mind when something like this
happens (or if, heaven forbit, your server were to crash)...

Brandon Eley
2BigFeet.com
brandon@2bigfeet.com
www.2bigfeet.com

"shoplite.com" <rruda@shoplite.com> wrote in message
news:a8fu5d$ck4$1@support.shopsite.com...

Lauren,
We've never had a problem with Power Edit but before we do anything like
this, we simply backup products/pages (Utilities > Database > Manage). You
can then easily restore if you find a problem.
Richard
www.shoplite.com

Thanks Guys,
Based on all your experiences, I guess it must have been a fluke or
something I did. I did seriously have the backup regrets moments after I
realized what had happened. And you can be sure I will do a thorough backup
before any large PowerEdit operations again.
Thanks for all your replies.
-lauren
<lauren@heartsmith.com>

It's quick and easy to backup the online database online. It's a good
habit to get into before making any sweeping changes, or just once a
week. Since it's a matter of a few clicks, there's no downside to doing
it daily, or whenever you contemplate changes.

On the other hand, backing up the entire site to your local hard-drive
and then backing it up is a pretty painful operation (at least it is for
us: after compression our site creates a 230+ MB file). Nonetheless I do
that at least once a month. We have had our ShopSite file get corrupted
online, and my local backup was so out of date it was quicker to
reassign the pooched articles than to bring the old database up to date
(but still not very quick).

I've had floppys, SyQuests, Zips, Jaz cartridges, CDs and hard-drives
all fail on me. Some studies show that the realistic life expectancy for
a CD-R to remain error-free could be as short as 6 months - not exactly
the archival product it's advertised as. I recommend backing up to
multiple media if you can. An external FireWire drive has the potential
to outlast a CD-R and these days they're cheap. We backup to a 20GB
pocket-sized FireWire drive and take it offsite. We also backup to CD-Rs
and try to mirror data onsite. We've still lost data.

In article <a8hp75$pp2$1@support.shopsite.com>,
"Brandon" <brandon@2bigfeet.com> wrote:

Yes... we LIVE by PowerEdit.

In over two years we haven't had one problem with PowerEdit deleting,
changing or altering products or pages other than what we wanted it to do.
Of course, we occassionally told it to do the wrong thing and screwed up the
database ourselves but nothing that wasn't our fault.

I would definately back up your databases once a month if not more often.
You'll find that it gives you a good peace of mind when something like this
happens (or if, heaven forbit, your server were to crash)...

Brandon Eley
2BigFeet.com
brandon@2bigfeet.com
www.2bigfeet.com

"shoplite.com" <rruda@shoplite.com> wrote in message
news:a8fu5d$ck4$1@support.shopsite.com...
Lauren,
We've never had a problem with Power Edit but before we do anything like
this, we simply backup products/pages (Utilities > Database > Manage). You
can then easily restore if you find a problem.
Richard
www.shoplite.com

--
Fred Holliss, webmaster, Fitter International Inc.
"Balance and Fitness for Life"
Toll Free: 1-800-FITTER-1 | Int'l: +1-403-243-6830
http://www.fitter1.com | mailto:webmaster@fitter1.com