Hello im a total newbie when it comes to installing and php csv and all the other letters of the blooming alphabet. What im trying to do is upload a product csv file to my V 1.4.9.4 opencart store and ive been searching all day on the forums looking for anything that i understand but im still boggled can anybody explain to me the way you would tell a kid how to eat icecream as i am proper thick and really need help with where to put what and so forth id like to say thankyou and sorry for the hassle in advance many thanks Newbie Roy.
Csv import pro module in my signature!
Documentation: OpenCart User Guide
Mods: Total Import PRO | CSV Import PRO | Ecom Tracking | Any Feed | Autosuggest | OpenCart CDN
Thankyou for your reply but unfortunatly i have no money as of yet so was hoping for a technical solution rather than a cost solution although from what i have heard about your product once im on my feet again i will certainly be buying it many thanks Roy
round about way would be do a DB dump, look at how mysql inputs your data and then export to a code friendly editor convert to an excel file, add your new products/changes, export to a text file, reload to mysql.
It can be done and with some trial and error not that difficult.
It can be done and with some trial and error not that difficult.
930sc ... because it is fun!
sorry me no speak the lingo lol when i said i was totally new i meant i can just about switch my pc on what do you mean by DB dump and mysql..... Sorry for being a pain to you all RoySapporoGuy wrote:round about way would be do a DB dump, look at how mysql inputs your data and then export to a code friendly editor convert to an excel file, add your new products/changes, export to a text file, reload to mysql.
It can be done and with some trial and error not that difficult.
OH ... OK ...
MySQL is the database where all the information is stored.
A DUMP is where you move the information from a database to a CSV or such file. You would use phpmyadmin or another software on your server to do this or from the a backup in opencart's admin area.
How many products do you have?
IF under a hundred you just might be better off inputting them by hand into the cart.
SO, go to your hosting panel (probably cpanel) find the phpmyadmin link, find the database that installed into, hit the dump button (either save to screen or to a file).
Take that file into excel, be careful about which information goes into what column.
You will also need to increment the number for each product (this is the id number not the number of products)
Save as CVS file.
Go back to phpmyadmin on your server and upload the new products ...
And pray that you did screw something up.
It took me about 3-4 times before I stopped screwing up my DB ... total about 3-4 days of tinkering with this to figure this all out too ...
Either way, you either learn something ... either you gained a new skill or realized that a few bucks was worth it
MySQL is the database where all the information is stored.
A DUMP is where you move the information from a database to a CSV or such file. You would use phpmyadmin or another software on your server to do this or from the a backup in opencart's admin area.
How many products do you have?
IF under a hundred you just might be better off inputting them by hand into the cart.
SO, go to your hosting panel (probably cpanel) find the phpmyadmin link, find the database that installed into, hit the dump button (either save to screen or to a file).
Take that file into excel, be careful about which information goes into what column.
You will also need to increment the number for each product (this is the id number not the number of products)
Save as CVS file.
Go back to phpmyadmin on your server and upload the new products ...
And pray that you did screw something up.
It took me about 3-4 times before I stopped screwing up my DB ... total about 3-4 days of tinkering with this to figure this all out too ...
Either way, you either learn something ... either you gained a new skill or realized that a few bucks was worth it
930sc ... because it is fun!
Who is online
Users browsing this forum: No registered users and 2 guests
