Results 1 to 1 of 1
  1. #1
    Join Date
    Sep 2010
    Posts
    2
    Plugin Contributions
    0

    Default Imported from OS3 to Zen

    I was able to import the database from os3 to Zhen using a script I found on the internet. Everything looks good all customers and orders are in the zen database. Only one problem the cart does not see the orders. The orders are in the database. If I logon the cart and search the order ID it pull up . If I search by name it gives me this error.

    LEGEND: Billing and Shipping does not match
    1054 Unknown column 'o.orders_id' in 'on clause'
    in:
    [select count(distinct o.orders_id) as total from (orders o, orders_status s left join orders_products op on (op.orders_id = o.orders_id) ) left join orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '4' and ot.class = 'ot_total') and (op.products_model like '%sr%' or op.products_name like 'sr%')]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

    Anybody have any ideas ???
    Thanks in advance.
    Ed
    Last edited by edmaxwelldaytona; 8 Sep 2010 at 04:04 PM.

 

 

Similar Threads

  1. Imported products missing from admin, but present for orders and front-end display
    By AustinThemes in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 20 Feb 2011, 09:48 AM
  2. GST on imported goods
    By Ms_X in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 9
    Last Post: 8 Dec 2010, 01:28 PM
  3. No text attributes imported from osc
    By CharInLasVegas in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 8 Feb 2009, 04:21 AM
  4. Generating Products & Attributes from Imported Data File
    By pockets in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 25 Nov 2008, 06:31 PM
  5. I imported products from CSV but can't see them in my admin
    By aronchi in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 8 Jan 2008, 01:21 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