Page 1 of 2 12 LastLast
Results 1 to 10 of 13
  1. #1
    Join Date
    Oct 2007
    Posts
    5
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Importing Users, order, and products from OsCommerce

    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
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Oct 2007
    Posts
    5
    Plugin Contributions
    0

    Default Re: Importing Users, order, and products from OsCommerce

    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

  4. #4
    Join Date
    Jun 2003
    Posts
    33,715
    Plugin Contributions
    0

    Default Re: Importing Users, order, and products from OsCommerce

    ... use the same principals from the FAQ to import the rest of your information.
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  5. #5
    Join Date
    Oct 2007
    Posts
    5
    Plugin Contributions
    0

    Default Re: Importing Users, order, and products from OsCommerce

    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

  6. #6
    Join Date
    Oct 2007
    Posts
    5
    Plugin Contributions
    0

    Default Re: Importing Users, order, and products from OsCommerce


  7. #7
    Join Date
    Oct 2007
    Posts
    5
    Plugin Contributions
    0

    Default Re: Importing Users, order, and products from OsCommerce

    Quote Originally Posted by christiansees View Post
    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
    Code:
    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

  8. #8
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: Importing Users, order, and products from OsCommerce

    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
    Zen-Venom Get Bitten

  9. #9
    Join Date
    Nov 2007
    Location
    oregon
    Posts
    70
    Plugin Contributions
    0

    Default Re: Importing Users, order, and products from OsCommerce

    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.

  10. #10
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: Importing Users, order, and products from OsCommerce


 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Problems with importing from osCommerce, with language
    By blondu' in forum General Questions
    Replies: 0
    Last Post: 22 Oct 2011, 08:05 PM
  2. Question about importing from OScommerce
    By port27374 in forum Installing on a Linux/Unix Server
    Replies: 0
    Last Post: 15 Nov 2009, 02:28 AM
  3. Migrating Oscommerce users to Zencart Users
    By voodoo1967 in forum General Questions
    Replies: 1
    Last Post: 2 Jul 2009, 12:59 PM
  4. Importing OSCommerce DB into Zen Cart
    By Webskipper in forum Installing on a Mac Server
    Replies: 1
    Last Post: 29 Nov 2007, 06:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR