PDA

View Full Version : CSV Product Upload



michael_s
02-08-2013, 05:00 AM
The idea behind this is to allow the products to be modifiable offline in another database or spreadsheet system like FileMaker or Excel and then imported to osCommerce. It can be frustrating at times trying to put a very large number of products into the admin system when pages don't load right away. In essence, this is designed to facilitate a very large number of products.

This CSV Import Utility takes a comma-delimited text file containing products information and synthesizes the fields to be placed in the osCommerce mySQL tables. This script is standalone from the administration modules, is contained in one file, and is run by viewing it in your web browser (don't forget to secure the folder where it resides!).

INSTALLATION:

Just copy the following files:
/admin/csv_import.php
/admin/csv_import/csv_import.ini
/admin/csv_import/data_parsing.php
/admin/includes/languages/*/csv_import.php

the /admin/csv_import/csv folder must have write permissions

if you want a menu item in administration->tools just add the following line to /admin/includes/boxes/tools.php

'Excel/Calc Import (http://www.oscmax.com/forums/' . tep_href_link('csv_import.php') . ')
' .




More... (http://addons.oscommerce.com/info/8695)