Populate tables

[Sleepless]

Hi Tim,

Would it be possible for you to tell me if it's even possible to add my products to the table any other way besides one item at a time? I have almost 800 items, I know for some that's not much, but it is very time consuming trying to add them one at a time. I use sql table to store my info for the store, but I'm not sure if it will work to populate the tables for this. Can you check if you have access to the site?
I saw there were scripts to get the info from existing tables, but I wasn't sure how to do it or if they were even usable.

Please let me know.

Thanks,
Kelly

[Mutley]

I have thousands of items... what i did was put them all in an excel spreadsheet (lined up the columns with the mysql columns in review_items), converted in excel to a .csv file and uploaded through mysql directly into the review_items table. Quick and easy :)

[imported_Tim Mousel]

Mutley is right, that's how I've done it in the past.

Thanks for the contribution.

Tim

[Sleepless]

Thank you Mutley and Tim.

I am not sure I would know how to do that, but I will give it a try. The problem is, my items are stored in a few tables. One table has the product name and one has the URL and one has the category etc. Will this cause a problem? They are linked to a category that is called by number and in another it shows the name the number corresponds to.
I'm guessing you rename each field before uploading?
I'm sorry to sound dense, but I'm a little confused.
I will play with it though and try to figure it out.

Thanks again,
Kelly

[Sleepless]

Okay. I was able to fill out all the info in the tables doing as suggested by Mutley. But one thing, which I find very important, is the product url. There is no field in my tables showing the url. The products all have the exact same url with the exception of the product id at the end.
http://www.sleeplessnightsonline.com/catalog/index.php?main_page=product_info&products_id=
So, there is no url in the tables. Any ideas how I can make this work? The product_id needed for the review script would be the number at the end of the url.
Any idea how or if there is a way to make this work?

Thanks,
Kelly

[imported_Tim Mousel]

Hard code the url into the webpage and have the item_id inserted into the url.

If that doesn't make sense, let me know.

Thanks,

Tim