Session Storage

[Guest]

Hi everyone. I am in the middle of the installation and I have a question. This e-shop will contain 3000 products with pictures. So I need a fast way to import and export in cvs files the database.

 

1. Should I choose file or database storage?

2. Which is the best way to import and export my csv product files?

 

Thanks in advance!

[kgt]

1. Absolutely choose database if you're on a shared server. If you're on a dedicated server, saving sessions to the filesystem will take some load off of the database.

 

2. Easy Populate:

 

http://www.oscommerce.com/community/contributions,500

[Guest]

Thank you very much for the quick reply. I know the option of easy populate but i think it is too complicated. Isnt it easier to import the cvs through php my admin?

[kgt]

Products exist in several tables. In PHPMyAdmin, look at all the tables that start with products_*. At the very least, your products will span two tables: products and products_description.

[ozcsys]

You will also need the categories and the product to categories tables

[Guest]

Thanx, that will help.

Do I need also the manufacturers table or the category description?

[ozcsys]

Thanx, that will help.

Do I need also the manufacturers table or the category description?

 

Basically you will need anything that has product info in it. The easiest thing to do would be to manually add a product and then do a backup and then use the table setup in the sql file as a template for adding your other products

[Guest]

Basically you will need anything that has product info in it. The easiest thing to do would be to manually add a product and then do a backup and then use the table setup in the sql file as a template for adding your other products

Perfect! Thats the best i think!!!

Thank you very much for your help!!!