- This topic has 1 reply, 2 voices, and was last updated 15 years, 2 months ago by
.
-
Posts
-
I would like to know if it is possible to add products directly into the mysql database, rather than going through the product addition page for each of the 1500 products i need to add.
if anyone has experience with this, your knowledge would be greatly appreciated.
Yes, it is possible to upload product details directly into mysql database but eStore doesn’t have any build in function for this yet.
There are a few different ways to do this… you could write a PHP script that opens your data file (excel file), break it up into an array of lines that each represent a row of data, split each line up by the delimiter character (such as a comma ‘,’, tab ‘t’, semicolon ‘;’, space ‘ ‘, etc.), and then perform invididual MySQL INSERT queries (one INSERT for each line) to insert all your data from the file into the appropriate table fields.
- You must be logged in to reply to this topic.