OsCommerce Data Importer
| This is a script i made to import OsCommerce data into zen cart. It imports customers, poducts, product description, categories, category descriptions, category structure, specials, and reviews. This script runs stand alone, meaning it it independent from zencart's fuctions and settings, so is ok to run when you are not quite setup. |
 Zen Cart® Versions |
v1.3.9 |
 Original Author |
Nezah Technologies |
| Last Updated by |
skipwater - 29 Dec 2011 |
 Downloads |
6,776 |
Version History
| OsCommerce Data Importer - Version: 2.3 | |||||||||||||
| Added customers_info_date_account_last_modified field and fixed a few typos. | |||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 2.2 | |||||||||||||
|
Update order_total and order_tax in orders table OSC has no order_total or order_tax so we populate it from orders_total table. Update master_categories_id in product table OSC has no master_categories_id so we populate it from products_to_categories table. |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 2.1 | |||||||||||||
|
OSC has no categories_status field in the category table so we set all categories active in Zen Cart. This fixes the error when Categories - Always Show on Main Page in the admin to work. |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: v2.0 | |||||||||||||
|
Works on all 1.3.x The following tables are transferred. PRODUCTS: (import_osc_products.php) Categories Categories Description Products Products Description Products to Categories Products Options Products Options Values Products Options Values to Products Options Products Attributes Products Attributes Download Products Notifications Manufacturers Manufacturers Info Reviews Reviews Description Languages Specials Tax Class Tax Rates ORDERS: (import_osc_orders.php) Orders Orders Products Orders Products Attributes Orders Products Download Orders Status Orders Status History Orders Total Currencies CUSTOMERS: (import_osc_customers.php) Customers Address Book Customers Info Zones Zones To GEO Zones |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: v1.9 | |||||||||||||
|
Rewritten to minimize memory usage, now uses 60% less memory. This should help to eliminate the Fatal error: Allowed memory size of xxxxxxxx bytes exhausted. Added Zen Cart requires products_options_values with a record ID=0, language=1, name=TEXT, and sort=0 so a text box option name to a product works. This record is not in the osc table so it is added. |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.8 | |||||||||||||
| added settable MYSQL Character Set code | |||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.7 | |||||||||||||
|
Added Tax Class and Tax Rate Tables Added Currencies Table Added Zone Tables |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.6 | |||||||||||||
|
Add error trap if records transfered zero then the import will be zero. This stops the warning message 'Warning: Variable passed to each() is not an array or object' |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.5 | |||||||||||||
|
This update added import_osc_configure.php file. This now holds the mysql server, data base name, user, password values so you no longer need to edit import_osc_customers.php, import_osc_products.php, import_osc_orders.php script files. Also added user interface input to set transfer values. import_osc_products.php Set Product Review (Drop down) -- Pending -- Approved Transfer Product Specials (Drop down) -- YES -- NO import_osc_customers.php Set Default Customer email Type (Radio Button) -- TEXT -- HTML Set Default Customer Authorization Type (Drop down) -- Approved -- Pending Approval - Must be Authorized to Browse -- Pending Approval - May Browse No Prices -- Pending Approval - May browse with prices but may not buy -- Banned - Not allowed to login or shop This update added the following tables: import_osc_products.php Products Attributes Download Products Notifications Languages Specials Once again thanks to Albert Savage, Centec2b and original authors of these scripts. |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.4 | |||||||||||||
|
This update added Products Reviews to import_osc_products.php Due to OSC Product Review missing the review status field I have added a user choice to transfer reviews as Pending or Approved. See import_osc_products.php for setting. Also created import_osc_meta_tags.php as its own script due to the likely hood that the meta tag field names will need to be changed. As of this update v1.4 OSC Data Importer handles: Products: Categories Categories Description Products Products Description Products to Categories Products Options Products Options Values Products Ooptions Values to Products Options Products Attributes Manufacturers Manufacturers Info Reviews Reviews Description Orders: Orders Orders Products Orders Products Attributes Orders Products Download Orders Status Orders Status History Orders Total Customers: Customers Address Book Customers Info Meta Tags: Categories Meta Tags Products Meta Tags Once again thanks to Albert Savage, Centec2b and original authors of these scripts. |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.3a | |||||||||||||
|
This is a small addition to Skipwater's recent contribution I have added the code to enable the import of metatags. Given the numerous variations and contributions that are available to handle metatags in OSC please check the code in this contribution and your own field names, to make sure the names are correct or change as necessary Backup both your databases, OsCommerce and ZenCart before you undertake and changes |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.3 | |||||||||||||
|
This script is just an update to albertsavage Version 1.2 1. Added Manufacturers tables into the product importer script. 2. Added screen display record counts. 3. Added some error trapping. Very simple to use scripts. |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.2 | |||||||||||||
|
This is a very adapted version of the prior versions because it has 3 major improvements: 1. It separates products, customers, and orders into 3 separate import scripts so that you can import products at the beginning of your conversion and then customers and orders through for testing and then final go-live. 2. It eliminates problems with parsing due to products, orders, or customers having an apostrophe in the fields anywhere. (this would cause previous versions to fail if your customer's name was O'Neill 3. It now improves upon source and destination databases allowing table prefixes (if you are transferring within a database or just have prefixes. All have been thoroughly tested on fresh and modified zen and osc MS 2.2 copies I had to undue some of the coding from the previous version due to failing loads of larger tables and assignment of product details. This has been tested on at least 3 different environments. GLTA |
|||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.1-with-attributes | |||||||||||||
| The Original contribute in zen cart named [OsCommerce Data Importer] is modified to include the product attributes. | |||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.1 | |||||||||||||
| This update version also imports address book. | |||||||||||||
|
Report A Problem | ||||||||||||
| OsCommerce Data Importer - Version: 1.0 | |||||||||||||
|
Report A Problem | ||||||||||||
Date Added
File Size
PHP 5.3 Safe?
