首页 > 电子商务 > oscommerce到zencart迁移

oscommerce到zencart迁移

2008年11月26日

先安装zencart,假设所有oscommerce表的表名是以osc开头的

I had no products in the Zen Cart Database so I imported the id fields. If you installed the sample data or entered any products then this probably won’t work. If you wish to reset any tables and delete the items try using TRUNCATE in MySQL. This worked for version 2.2 of osCommerce and 1.3.7 of Zen Cart.

  1. Back up the old osCommerce Database and all the files on the Web Server. (I mean it)
  2. Log into phpMyadmin for the osCommerce Database and export any tables that begin with osc_categories* or osc_products*
  3. Log into phpMyAdmin on the destination MySQL Server and import all those tables.

INSERT INTO categories SELECT *, 1 FROM osc_categories;
INSERT INTO categories_description SELECT *, ” FROM osc_categories_description;
INSERT INTO products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix) SELECT * FROM osc_products_attributes;
INSERT INTO products_attributes_download SELECT * FROM osc_products_attributes_download;
INSERT INTO products_description SELECT * FROM osc_products_description;
INSERT INTO products_notifications SELECT * FROM osc_products_notifications;
INSERT INTO products_options (products_options_id, language_id, products_options_name) SELECT * FROM osc_products_options;
INSERT INTO products_options_values SELECT *, 0 FROM osc_products_options_values;
INSERT INTO products_options_values_to_products_options SELECT * FROM products_options_values_to_products_options;
INSERT INTO products_to_categories SELECT * FROM osc_products_to_categories;
INSERT INTO products (products_id, products_quantity, products_model, products_image, products_price, products_date_added, products_last_modified, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_ordered) SELECT * FROM osc_products;

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

电子商务

  1. 本文目前尚无任何评论.
  1. 本文目前尚无任何 trackbacks 和 pingbacks.

This blog is kept spam free by WP-SpamFree.