How to set up my text file full of products (not products but we'll call them that) to import into reviewpost?
My text file is outlined like so with thousands of entries:
Name of Business
Address Of Business
Phone Number Of Business
How to import this without doing it all one by one in the front of RP?
I've already created fields for the last two in admin for all categories.
I tried to look at the products field in phpmyadmin.
I copied the format and added them into my text file in the right order and then tried to get them into the database. Alls I get is errors. Just a big fat mess!
Therefore, after wasting hours and not getting anythang done right...I am asking here.
I see there are comments about importing as a csv file. I've searched the net and see that csv files are items separated by commas. Okay, so if I put a comma after each item how do I make the database take that information?
Ugh! I'm just so lost on everythang here. I keep searching these forums and google all day for answers and I can't find anythang at all that works for me. This is my second question I've been working on all day with no result.
Can someone please explain how to turn a text file into csv and import into the database product area or turn it into an sql file that I can import.