Thank You for this.
Because of this little modification i was able to get 7137 items into the system a little easier. ;)
with a batch file re-namer and batch file re-sizer.
and then i ended up creating SQL Inserts for all my items, categories, category mapping, pictures, product pictures. and so on.
Thank You for all the help and thank you for this thread :D
Corey
pictures stored in databse vs filesystem
- 1
- 5
- 2/10/2010
- United States
Hello, I got all this working but I was wondering if either phoenixfire425 or someone else could help me with setting the image paths to a large number of items. phoenixfire425 could you share the SQL insert statements you used to set the image paths and catagory mappings and all that good stuff? If it no longer store the images in the database where or how does it store the path to the image? I'm using v1.4 and I have 14,000 products from a different shopping cart that Im trying to convert to nop and all of the image refrences from it are just the string path stored in the database. Thanks for any help.
MVP
- 1794
- 14506
- 10/7/2009
- United Kingdom
bhiers wrote:
if you already have the images in the database, you can't change otherwise the pics already stored in the database won't appear
(to be exact, you can change, but you will have a lot of work to do - you would have to delete all the existing images then re-upload them :)
Why isn't this an option yet in NOP, I have 5600+ products storing the images in the DB is a total pain.
if you already have the images in the database, you can't change otherwise the pics already stored in the database won't appear
(to be exact, you can change, but you will have a lot of work to do - you would have to delete all the existing images then re-upload them :)