Alter Products Database?

[Justin]

Greetings,

I need to add text for the "More Info" section for pretty much every product
in my store. I have this text stored in a mysql table (easily converted to
a tab-delimited file). I'd like to be able to upload the text for each
product in a single shot. I don't want to have to go through every product
and do it by hand (I've more than 600 products!). Is there a way to do
this?

I've figured I could download the entire database and convert it to a mysql
table and then add the text to the appropriate fields with a sql query. I
guess the process would follow by then saving this table as a text-delimited
file. Then deleting the existing database and uploading this new file. My
only concern in this regard, would be whether or not I'd have to rebuild all
of the pages listing the products. Would I have to rebuild these pages?

Obviously, I'm trying to save myself a lot of tedious work here. But that's
what computers are for so...

Thanks,

Justin

[Larry Bohen]

Do you have your product information on your desktop perhaps in an MS Access
db?

We maintain our 9600 audiobook products on an MS Access db on my desktop and
upload to our ShopSite Pro store changes almost daily. I've had, on
occasion, to add the same more information text to 100s of these records at
a time.

Depending where you want to place your additional / new more information
text in each record, you may be able to use Access' Find & Replace feature.
I.E. If you have a common character or string of characters in each of your
records AND they only appear in each record once, you could bring up Find &
Replace. The Find portion would be the current common character (or string)
and the Replace would be the common character (or string) plus the
additional / new more information text.

Do an individual Find & Replace before you use the Replace All button.

--
Larry Bohen
www.audiobooksonline.com
"Justin" <adwhammy@hotmail.com> wrote in message
news:d50ufk$r93$1@eval.shopsite.com...

Greetings,

I need to add text for the "More Info" section for pretty much every
product
in my store. I have this text stored in a mysql table (easily converted
to
a tab-delimited file). I'd like to be able to upload the text for each
product in a single shot. I don't want to have to go through every
product
and do it by hand (I've more than 600 products!). Is there a way to do
this?

I've figured I could download the entire database and convert it to a
mysql
table and then add the text to the appropriate fields with a sql query. I
guess the process would follow by then saving this table as a
text-delimited
file. Then deleting the existing database and uploading this new file.
My
only concern in this regard, would be whether or not I'd have to rebuild
all
of the pages listing the products. Would I have to rebuild these pages?

Obviously, I'm trying to save myself a lot of tedious work here. But
that's
what computers are for so...

Thanks,

Justin

[Katrina Morris]

Hi Justin,

It's super easy to change info in batches with Shopsite. All you need to do
is make a tab delimited file with a unique identifier for the product - SKU
or Name (although I think shopsite requires the name regardless, so make
sure the name is the same, or something you want it to be updated to) and
the field you want to change, in this case, 'More Information'. Then you
just use the data upload feature under Utilities->Database->Upload. You just
map the fields and then update and you're done. Super-duper easy.

One caveat to mention - if you have any commas, quotation marks or
apostrophe's in your text, and you're using excel to make the tab delimited
file, you will end up with a whole bunch of extra quotation marks in your
text. There is a work-around using find and replace in Word and then
re-saving the file. I found it in the shopsite knowledgebase. If you can't
find it, just re-post and I'll give it to you.

Katrina
www.rexart.com

"Justin" <adwhammy@hotmail.com> wrote in message
news:d50ufk$r93$1@eval.shopsite.com...

Greetings,

I need to add text for the "More Info" section for pretty much every
product
in my store. I have this text stored in a mysql table (easily converted
to
a tab-delimited file). I'd like to be able to upload the text for each
product in a single shot. I don't want to have to go through every
product
and do it by hand (I've more than 600 products!). Is there a way to do
this?

I've figured I could download the entire database and convert it to a
mysql
table and then add the text to the appropriate fields with a sql query. I
guess the process would follow by then saving this table as a
text-delimited
file. Then deleting the existing database and uploading this new file.
My
only concern in this regard, would be whether or not I'd have to rebuild
all
of the pages listing the products. Would I have to rebuild these pages?

Obviously, I'm trying to save myself a lot of tedious work here. But
that's
what computers are for so...

Thanks,

Justin