Need help populating database with products

Hi everyone,

I need to learn how to quickly populate my shopping cart database with products. Is there a tutorial suitable for CI or is any kind soul willing to guide me or point me in the right direction? I've been playing with the db products and category tables for some days now but no joy.

Thanks for any help.

@lulab,

Faker helps you build test data. Check it out: https://github.com/fzaninotto/Faker

@lulab,

Faker helps you build test data. Check it out: https://github.com/fzaninotto/Faker

Hi,

Thank you so much for your reply. I took a quick look at Faker but I'm still wondering if I can use it to upload data for real non-fake products? I need to feed db with product category, sub-category, name, title, description, corresponding image, quantity in stock etc etc. I wish I could do this with a CSV file, with the correct syntax of course and get Faker or similar script push it to the db?

@lulab,

Faker data is not real data and its not really designed to upload not fake data.

What format is the data in? There are definitely multiple ways to get it into the database.

Hi, 
I must be able to find a tutorial to help me export data from the db, csv format, then populate the file and upload back to db. Correct? 


Thanks! And have a nice day.

@lulab,

What database are you exporting from? And what database are you importing too?

Hi php_rocs,

Sorry I should have mentioned it's MySQL. Thanks.

[url=https://www.mysql.com/downloads/][/url]

Why do you think you need CI do to this? Chances are that you manage your MySQL database with PhpMyAdmin, which has export and import functions.

@Wouter60

You're right. I once used PhpMyAdmin to export but had errors during import. I'll reproduce the error and post. Thank you!

@lulab,

Also, pay attention to the MySQL version that you are migration from and the version that you are migrating to. Also, as mentioned above there are many tools that can help you migrate from one database to another.