Importing Users, order, and products from OsCommerce

Hello,
I am trying to import all my users, orders, and products, from OsCommerce. I know that there is probably already a thread here regarding this but I can't seem to get any useful results from the search. I also searched the wiki and had worse results there. Any pointers would be appreciated. Links to threads etc.
Thanks

In the top bar far right is tutorials/FAQ's - a quick search nets this How do I import my OSC database into Zen Cart

Kobra
Thanks for your reply. I did look over this faq.
And it says "*This only copies over your categories and products..!" Which is less than I need. Surely as Zen cart is an "Upgrade" from OsCommerce there are people who have made the complete conversion?
Christian

... use the same principals from the FAQ to import the rest of your information.

I should have remembered from the OsCommerce forums that the search function is bunk and that you get much better results from google.
Here is the thread that I needed for all others future reference.
http://www.zen-cart.com/forum/showthread.php?t=20788

And this http://www.zen-cart.com/forum/showthread.php?t=15667

christiansees:

And this http://www.zen-cart.com/forum/showthread.php?t=15667

Isn't there anyone else out there working on this? I would post to the thread listed above but it seems I don't have permission. So here goes messing about with multiple threads.
When I try to run the script ```
Convert OSC to ZENCART CUSTOMER; CATEGORY; PRODUCTS and ORDERS

ALTER TABLE customers ADD customers_nick VARCHAR( 96 ) NOT NULL AFTER customers_email_address;
ALTER TABLE customers ADD customers_group_pricing INT( 11 ) DEFAULT '0' NOT NULL;
ALTER TABLE customers ADD customers_email_format VARCHAR( 4 ) DEFAULT 'TEXT' NOT NULL;
ALTER TABLE customers ADD customers_authorization int(1) NOT NULL default '0';
ALTER TABLE customers ADD customers_referral VARCHAR(32) NOT NULL default '';

ALTER TABLE orders ADD payment_module_code varchar(32) NOT NULL default ''AFTER payment_method;
ALTER TABLE orders ADD shipping_method varchar(128) NOT NULL default '' AFTER payment_module_code;
ALTER TABLE orders ADD shipping_module_code varchar(32) NOT NULL default '' AFTER shipping_method;
ALTER TABLE orders ADD coupon_code varchar(32) NOT NULL default '' AFTER shipping_module_code;
ALTER TABLE orders ADD cc_cvv blob AFTER cc_expires;
ALTER TABLE orders ADD order_total decimal(14,2) default NULL;
ALTER TABLE orders ADD order_tax decimal(14,2) default NULL;
ALTER TABLE orders ADD paypal_ipn_id INT( 11 ) DEFAULT '0' NOT NULL;
ALTER TABLE orders ADD ip_address varchar(15) NOT NULL default '';

ALTER TABLE orders_products CHANGE products_quantity products_quantity FLOAT DEFAULT '0' NOT NULL;
ALTER TABLE orders_products ADD onetime_charges decimal(15,4) NOT NULL default '0.0000';
ALTER TABLE orders_products ADD products_priced_by_attribute tinyint(1) NOT NULL default '0';
ALTER TABLE orders_products ADD product_is_free tinyint(1) NOT NULL default '0';
ALTER TABLE orders_products ADD products_discount_type tinyint(1) NOT NULL default '0';
ALTER TABLE orders_products ADD products_discount_type_from tinyint(1) NOT NULL default '0';

ALTER TABLE products ADD products_type INT( 11 ) DEFAULT '1' NOT NULL AFTER products_id;
ALTER TABLE products ADD products_virtual TINYINT( 1 ) DEFAULT '0' NOT NULL AFTER products_price;
ALTER TABLE products CHANGE products_weight products_weight FLOAT DEFAULT '0' NOT NULL;
ALTER TABLE products CHANGE products_ordered products_ordered FLOAT DEFAULT '0' NOT NULL;
ALTER TABLE products ADD products_quantity_order_min FLOAT DEFAULT '1' NOT NULL;
ALTER TABLE products ADD products_quantity_order_units FLOAT DEFAULT '1' NOT NULL;
ALTER TABLE products ADD products_priced_by_attribute tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD product_is_free tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD product_is_call tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_quantity_mixed tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD product_is_always_free_shipping tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_qty_box_status tinyint(1) NOT NULL default '1';
ALTER TABLE products ADD products_quantity_order_max FLOAT DEFAULT '0' NOT NULL;
ALTER TABLE products ADD products_sort_order int(11) NOT NULL default '0';
ALTER TABLE products ADD products_discount_type tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_discount_type_from tinyint(1) NOT NULL default '0';
ALTER TABLE products ADD products_price_sorter decimal(15,4) NOT NULL default '0.0000';
ALTER TABLE products ADD master_categories_id int(11) NOT NULL default '0';
ALTER TABLE products ADD products_mixed_discount_quantity tinyint(1) NOT NULL default '1';
ALTER TABLE products ADD metatags_title_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD metatags_products_name_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD metatags_model_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD metatags_price_status TINYINT( 1 ) DEFAULT '0' NOT NULL;
ALTER TABLE products ADD metatags_title_tagline_status TINYINT( 1 ) DEFAULT '0' NOT NULL;

ALTER TABLE categories ADD categories_status TINYINT( 1 ) DEFAULT '1' NOT NULL;
ALTER TABLE categories_description ADD categories_description TEXT NOT NULL;

ALTER TABLE banners_history ADD INDEX idx_banners_id_zen ( banners_id );
ALTER TABLE banners ADD INDEX idx_status_group_zen ( status, banners_group );

ALTER TABLE specials ADD INDEX idx_status_zen ( status );
ALTER TABLE specials ADD INDEX idx_products_id_zen ( products_id );
ALTER TABLE specials ADD INDEX idx_date_avail_zen ( specials_date_available );

ALTER TABLE featured ADD INDEX idx_status_zen ( status );
ALTER TABLE featured ADD INDEX idx_products_id_zen ( products_id );
ALTER TABLE featured ADD INDEX idx_date_avail_zen ( featured_date_available );

ALTER TABLE salemaker_sales ADD INDEX idx_sale_status_zen ( sale_status );

ALTER TABLE categories ADD INDEX idx_categories_parent_id_TEST ( parent_id );
ALTER TABLE categories ADD INDEX idx_parent_id_cat_id_zen ( parent_id, categories_id );
ALTER TABLE categories ADD INDEX idx_status_zen ( categories_status );

ALTER TABLE product_types_to_category ADD INDEX idx_category_id_zen ( category_id );
ALTER TABLE product_types_to_category ADD INDEX idx_product_type_id_zen ( product_type_id );
ALTER TABLE product_types ADD INDEX idx_type_master_type_zen ( type_master_type );

ALTER TABLE products ADD INDEX idx_products_status_zen ( products_status );

ALTER TABLE products_to_categories ADD INDEX idx_cat_prod_id_zen (categories_id, products_id);
ALTER TABLE products_attributes ADD INDEX idx_id_options_id_values_zen ( products_id, options_id, options_values_id );

ALTER TABLE products_discount_quantity ADD INDEX idx_id_qty_zen ( products_id, discount_qty );
ALTER TABLE products_options_values_to_products_options ADD INDEX idx_prod_opt_val_id_zen ( products_options_values_id );
ALTER TABLE products_options ADD INDEX idx_lang_id_zen ( language_id );

ALTER TABLE tax_rates ADD INDEX idx_tax_zone_id_zen ( tax_zone_id );
ALTER TABLE tax_rates ADD INDEX idx_tax_class_id_zen ( tax_class_id );

ALTER TABLE configuration ADD INDEX idx_key_value_zen ( configuration_key, configuration_value(10) );
ALTER TABLE configuration_group ADD INDEX idx_visible_zen ( visible );
ALTER TABLE configuration ADD INDEX idx_cfg_grp_id_zen ( configuration_group_id );
ALTER TABLE product_type_layout ADD INDEX idx_key_value_zen ( configuration_key, configuration_value(10) );

ALTER TABLE customers ADD INDEX idx_email_address_zen ( customers_email_address );
ALTER TABLE customers ADD INDEX idx_referral_zen ( customers_referral(10) );
ALTER TABLE customers ADD INDEX idx_grp_pricing_zen ( customers_group_pricing );
ALTER TABLE customers ADD INDEX idx_nick_zen ( customers_nick );
ALTER TABLE customers ADD INDEX idx_newsletter_zen ( customers_newsletter );
ALTER TABLE customers_basket ADD INDEX idx_customers_id_zen ( customers_id );
ALTER TABLE customers_basket_attributes ADD INDEX idx_cust_id_prod_id_zen ( customers_id, products_id(36) );

ALTER TABLE orders ADD INDEX idx_status_orders_cust_zen ( orders_status, orders_id, customers_id );
#ALTER TABLE orders ADD INDEX idx_customers_id_zen ( customers_id );
ALTER TABLE orders_status_history ADD INDEX idx_orders_id_status_id_zen ( orders_id, orders_status_id );
ALTER TABLE orders_products ADD INDEX idx_orders_id_zen ( orders_id );
ALTER TABLE orders_products ADD INDEX orders_id_prod_id_zen ( orders_id , products_id );
ALTER TABLE orders_products_attributes ADD INDEX idx_orders_id_prod_id_zen ( orders_id , orders_products_id );
ALTER TABLE orders_products_download ADD INDEX idx_orders_id_zen ( orders_id );
ALTER TABLE orders_products_download ADD INDEX idx_orders_products_id_zen ( orders_products_id );

ALTER TABLE layout_boxes ADD INDEX idx_name_template_zen ( layout_template, layout_box_name );

ALTER TABLE coupon_gv_queue ADD INDEX idx_release_flag_zen ( release_flag );
ALTER TABLE coupons ADD INDEX idx_active_type_zen ( coupon_active, coupon_type );
ALTER TABLE coupons_description DROP INDEX coupon_id;
ALTER TABLE coupons_description ADD PRIMARY KEY (coupon_id, language_id);
ALTER TABLE coupon_restrict ADD INDEX idx_coup_id_prod_id_zen (coupon_id, product_id);
ALTER TABLE coupon_redeem_track ADD INDEX idx_coupon_id_zen ( coupon_id );
ALTER TABLE coupon_gv_queue DROP INDEX uid;
ALTER TABLE coupon_gv_queue ADD INDEX idx_cust_id_order_id_zen ( customer_id , order_id );
ALTER TABLE coupon_email_track ADD INDEX idx_coupon_id_zen ( coupon_id );

ALTER TABLE reviews ADD INDEX idx_products_id_zen ( products_id );
ALTER TABLE reviews ADD INDEX idx_customers_id_zen ( customers_id );

ALTER TABLE admin ADD INDEX idx_admin_name_zen ( admin_name );

ALTER TABLE files_uploaded ADD INDEX idx_customers_id_zen ( customers_id );

ALTER TABLE email_archive DROP INDEX email_to;
ALTER TABLE email_archive ADD INDEX idx_email_to_address_zen ( email_to_address );
ALTER TABLE email_archive DROP INDEX module;
ALTER TABLE email_archive ADD INDEX idx_module_zen ( module );

ALTER TABLE media_to_products ADD INDEX idx_media_product_zen ( media_id, product_id );
ALTER TABLE media_clips ADD INDEX idx_media_id_zen ( media_id );
ALTER TABLE product_music_extra ADD INDEX idx_music_genre_id_zen ( music_genre_id );

ALTER TABLE paypal ADD INDEX idx_zen_order_id_zen ( zen_order_id );
ALTER TABLE paypal_payment_status_history ADD INDEX idx_paypal_ipn_id_zen ( paypal_ipn_id );
ALTER TABLE paypal_session ADD INDEX idx_session_id_zen ( session_id(36) );

First I found several end of line errors. Then I got this error ALTER TABLE specials ADD INDEX idx_date_avail_zen( specials_date_available ) ; no such item.
Suggestions, constructive help?
thanks

If you view the date on that thread it is 2005 and there have been b'out 6 updates since then so you must check the tables & names

hi christiansees

did you get everything all worked out ok? If so any pointers I am just thanking of converting over myself from osc I have mainly all downloadable products and services in my store.

http://www.portali.co.nz/zen-cart-articles/zen-cart-hints-and-tips---technical/how-do-i-import-my-oscommerce-database-into-zen-cart.html

misty:

http://www.portali.co.nz/zen-cart-articles/zen-cart-hints-and-tips---technical/how-do-i-import-my-oscommerce-database-into-zen-cart.html

... which is a copy of the FAQ on the Zen Cart tutorials area: https://www.zen-cart.com/tutorials/index.php?article=10

Thank You for pointing this out..bookmarked
:smile:

Okay...
I have an excel spreadsheet with customer (member) info.
I need to import that into ZenCart so that our 4000 members start with the "wholesale" price group as per dual pricing mod.

Username: (membernumber)
Password: (TBD)
Email: (email)
wholesale price group: (1)

I don't know what fields to create or how to go about importing the data. I have a csv file that I used for an import tool into the CMS we're using, but still need some more info.

Edit: I've already used easy populate to import our inventory for sale, all that remains is the memberbase.