Can I import my excel spreadsheet via phpmyadmin for stock updating

[Paulw01]

Hi there,

Rather than use the slow import process on Prestashop to import excel spreadsheets, can I import the excel file via phpmyadmin somehow ? I assume this would be much faster ?


Is there a way I could set this up - and only use the fields / rows I require similar to the prestashop import facility ?

Also is there a way of viewing products and categories in phpmyadmin that would allow me to see exactly the description and related info of a product, and then for example, delete a set range of products or categories and re-upload specific products back again to replace the deleted ones etc ?

thanks all.

Paul

[CYTechnologies]

Hello Paulw01,

You would actually look to export your Excel file into a “CSV” file, at this point you could then open phpMyAdmin click “Import” and select the file to import.

This can be a bit trickey if you do not know what your doing though. Check this article out:
http://123techtalk.blogspot.com/2008/08/import-csv-to-sql-using-phpmyadmin.html

[Paulw01]

Hi there,

This looks like it could save a lot of time. Many thanks for your quick reply.
Will look now

Paul

[Paulw01]

This looks just like the thing i need !

Just one other question, can I just name columns that I want phpmyadmin to use from my csv? Will it then ignore column names I do not specify ? (similar to selecting the pull down tabs using presta import marking columns as ignore)

So reading from left to right on the csv, as long as columns required are in the corrrect order as per csv and entered correctly in the same order into phpmyadmin those columns or data will import correctly straight to the database.
?

Thanks again

Paul

[CYTechnologies]

I haven't done a loaddata in a while but if I'm not mistaken as long as the initial row (which would be the column names) are the same as in the db it should update those records and ignore the others.

However, I strongly suggest you backup your database before attempting this, it could mess up the db.

[Paulw01]

Ok, will look into it further - once finished updating stock today- the slow way.

thanks again.

Paul

[Star]

I have done this before and it REALLY mess up my DB. I made a back up using Prestashop back office backup tool. Then I found out the backup was not completed after I screw up my data. My suggestion is make a DB back up every half hour for 2 to 3 times, then compare with the size and make sure the backup is complete before you do anything.

Good luck to you.