Importing my existing product database into os commerce
Posted 15 May 2012 - 16:31
1. Can I import my database into OS Commerce?
2. What field structure must I use?
3. What file types can be imported?
Posted 15 May 2012 - 16:34
You will most likely have to cut and paste some things into specific columns but it will make the process easier for you.
Posted 15 May 2012 - 20:48
After this, I moved to using a paid for product called osCommerce Manager, which resolved many of these limitations and generally worked well.
But then, I started having issues when trying to import thousands of products in one go, where the import would fail. Unfortunately after several attempts to get a satisfactory* and conclusive response from MagneticOne who make the product, I then resigned myself to the fate of having to perform product imports using the database software that osCommerce runs on, MySQL.
For importing of products however, this is how i do it.
1.> start of with a product list as comma, tab, or semi-colon seperated plain text file
- this IMPORTS a text file to a specification you specifiy with command line options, into a database table.
(this is a command built into mysql that you can run from command prompt on windows based machines, or from terminal on linux based machines.)
- this allows you to perform SQL queries and database operations from a command prompt
(this is another command, also built into mysql that you can run from command prompt or from terminal, or from SSH)
With the data, the above software, some patience, some paper and a pen and a little time, it is possible to import most data this way and it can be substantially faster than using php based products.
If you are able to export your current products to .CSV file or files, this will make things easier, and if you know the names of your columns of fields, then this can make life even easier.
* I still use MagneticOne osCommerce Manager for maintaining, moving, and editing products, and although it has some issues in those respects, it is a promising product, but i was badly dissapointed with the level of support when I identified what I believed to be a bug in the product when importing large numbers of products at once. They state is caused by one or more spurious characters, which is often true, but in this case they were wrong....
Posted 15 May 2012 - 20:52
2.> there are two main product tables. in a default installation these tables are called.
My Advice, is to do a default install, then export those two tables to see the field structures to use. PHPMyadmin installed on the host server will enable you to view all the field structure data you require.
3.> in terms of file types, these don't get imported into the database, these get stored on the filesystem of the webserver which hosts the osCommerce environment. There may be some add-ons that change this behaviour, but generally all images, and digital content for sale as downloads are stored as files on the file system of the host server, in whatever format they are.
In terms of database cell specifications, there are a variety of differences, such as varchar, date, binary, integer, etc.
Edited by WallaceNetworks.co.uk, 15 May 2012 - 20:54.
Posted 16 May 2012 - 18:04
Any interesting post shared is just to inspire, take it or leave it, I don't care.
We all have different stores and businesses with different needs.
Luckily there isn't a one size fits all, or we wouldn't be here at all !
FYI Just upgraded from PHP 5.3 to PHP 5.5 and saw big performance improvement.
But be aware php 5.5 is more strict about things.
UTF8-without BOM, no extra spaces allowed at the beginning or end of your php file, or your redirects wont work.
No double declarations of functions allowed - used to slip through the cracks ...
Posted 24 April 2013 - 08:37
Columns separated with
Columns enclosed with
Columns escaped with
Lines terminated with
Replace NULL with
You can put
in the first box, and
in the fourth. The others can be emptied out. If these are new to you then ask Google about 'escape sequences'. In my own case the file is downloaded into
Kristaleeann may like to look at the Youtube demonstrations, which have names like 'MySQL Database CSV File Import'.