As I mentioned in the previous post I wanted to write a script to take the online CSV file from Sex Shop 365 and be able to import it directly into my osCommerce shops.
I’ve tested it and it works fine with my installation. You will have to modify it though as I’ve added an extra field (RRP) and modified the products_price based on this. If you’d like it, you can get the code from this page
PHP Code For Importing CSV Into osCommerce
Latest version for download as .txt file
The script should do the following:
- Extract top level categories and import into database if not already there
- Take sub categrories and import into database if not already there
- Exrtact all products and import main information into products table
- Add products name and description into products_description table
- Match products to categories
Someone might find this useful. As per usual – back everything up first! No warranty is implied or given. Do write to me if you much up your database – I enjoy a good laugh (harsh, but for your own good newbies)