uploading product with FTP client

[jazlee]

Is there a way I can upload products using ftp program to catalog (I already created) and keeping the product name same as my file name? I want to upload 100 or more pictures per catalog and to do so one by one and renaming it the file name is just too much.

 

 

I am a photographer and using it to upload my pictures for clients to purchase. If there is a better way I would appreciate it

 

Thanks

 

jaz

[crash3903]

To keep it the same can't you name the picture the same as your model (file) name?

 

regards

 

mark

[jazlee]

To keep it the same can't you name the picture the same as your model (file) name?

 

regards

 

mark

<{POST_SNAPBACK}>

 

 

I do but I have to upload one picture at a time and when I do upload it I still have to name it in my admin page. But i want to know if there is a convient way of just uploading the pictures in jpg using my ftp client and have them posted as product with the name of the file.jpg

 

if anyone could help. I search and search and could not find, maybe it cannot be done.

 

thanks

 

jaz

[jazlee]

I do but I have to upload one picture at a time and when I do upload it I still have to name it in my admin page.  But i want to know if there is a convient way of just uploading the pictures in jpg using my ftp client and have them posted as product with the name of the file.jpg

 

if anyone could help.  I search and search and could not find, maybe it cannot be done.

 

thanks

 

jaz

<{POST_SNAPBACK}>

 

 

can anyone help?

[Jeremy at oddly enough]

Its a bit more complicated, but only in that you need a few more things to make a product for osc, not just the image file. You need descriptions, you may want options, you need to associate them to categories, etc. You can insert products in batches directly into the db by updating the products, products_description, and products_to _categories tables. If you haven't any categories yet, you'd need to update categories, and categories_info I believe. If you want options, such as sizes, or frames, or colour vs b/w, then you have more tables associated with that to update too. Once you have a good look at the db, and understand the data required, and how the tables relate to one another, you only need a very basic understanding of MYSQL syntax to put together batches of commands to put the products in very quickly.

 

Jeremy