Guest Posted October 19, 2005 Share Posted October 19, 2005 Has anyone updated their product information (i.e. pricing, etc.) in excel and imported it to oscommerce. I have over 600 products so doing the update one-by-one is tedious to say the least. Any help would be greatly appreciated. Link to comment Share on other sites More sharing options...
Guest Posted October 19, 2005 Share Posted October 19, 2005 or is there a way to update product info in a faster manner? Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2005 Share Posted October 20, 2005 So could anyone tell me if you can import from excel....It wouls be very helpfull. Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2005 Share Posted October 20, 2005 Yes. Do you know anything about MySQL or phpMyAdmin? Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2005 Share Posted October 20, 2005 No...nothing. Is that a program? Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2005 Share Posted October 20, 2005 Long story short, MySQL is the database. phpMyAdmin is a open source program used to connect to MySQL in a "user friendly" manner. You may want to check with your host to see if they already have phpMyAdmin installed for you. If not, you can get it @ http://www.phpmyadmin.net, the settings would be the same as the ones you configured your OSC database. Theoretically you should be able to: Import your Excel file as a .csv(comma delimited) into your database Use the new table to import info into all of the other neccessary tables in the database I have close to 7000 items in my store, so believe me, I know where you're coming from. Unfortunately, I have to add things like pictures and descriptions manually, but they could be added via the same process. **I've also heard a program called Easy Populate mentioned on this forum several times, but I've never used it. Give it a look here: Easy Populate Hope this helps! Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2005 Share Posted October 20, 2005 great! So where can I download this software and how difficult is it to sync it to oscommerce? Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2005 Share Posted October 20, 2005 You can download either from the links I provided above. I would start by trying to implement Easy Populate, it seems that if you have no real experience with MySQL that this would be the place to start. I can't speak from experience, but EP seems like it is installed in your admin so that you can use it from there. In terms of "sync"ing the info to OSCommerce, as long as you are changing the database and including the proper information for OSC to index all of your fields, the front-end will automatically recognize your updates. A word of caution, if you have no real experience with MySQL I would not start with phpMyAdmin. Try to install Easy Populate first. Link to comment Share on other sites More sharing options...
dlebowski Posted October 20, 2005 Share Posted October 20, 2005 I use the "excel" contribution. If you search the contributions for excel import, you should be able to find it very easily. It works great for me. Ryan Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2005 Share Posted October 20, 2005 I'm looking forward to using it, but I still can't find a link to download and install. Would I find it on download.com? Link to comment Share on other sites More sharing options...
dlebowski Posted October 20, 2005 Share Posted October 20, 2005 I'm looking forward to using it, but I still can't find a link to download and install. Would I find it on download.com? It is located here http://www.oscommerce.com/community/contri...ch,Excel+Import Ryan Link to comment Share on other sites More sharing options...
ozstar Posted November 1, 2005 Share Posted November 1, 2005 I am also now looking to import an Excel file when I setup my new shop. What about the fields/columns? Does the import actually import the tables of the Excel file? Any help appreciated to explain it. Oz Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.