ProductCart Shopping Cart Software Forums : Import orders https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 12:11:15 +0000 Thu, 01 Feb 2007 08:04:37 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=629 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Import orders : The main issue with any relational...]]> https://forum.productcart.com/import-orders_topic629_post1825.html#1825 Author: netprofits
Subject: 629
Posted: 01-February-2007 at 8:04am

The main issue with any relational database is that there are multiple tables with related information. There are fields in the orders table that relate an order to other tables by record number. For example, an order is linked to a customer through the Customer ID. The product details, shipping details and payment details must follow very specific formats. Orders are linked to products using the Product ID. Shipping and Payment info is stored in separate tables linked by the OrderID, etc.

It is poosible to import this data directly into the database from another source but it would require a lot of massaging of data to provide all of the correct information to link everything together as required.

]]> Thu, 01 Feb 2007 08:04:37 +0000 https://forum.productcart.com/import-orders_topic629_post1825.html#1825 <![CDATA[Import orders : My programmer imported them directly...]]> https://forum.productcart.com/import-orders_topic629_post1824.html#1824 Author: fidjiti
Subject: 629
Posted: 31-January-2007 at 11:50pm

My programmer imported them directly into product cart's SQL database. I don't think there is any other way to do this. But the downside to doing this is the report information such as most ordered items and top sellers, etc..., doesn't work, because it has to go through the system to get that info. If anyone from early Impact knows how to fix that it would be greatly appreciated. Anyways...that's what I had to have done because I had over 2000 previous orders. Oh and don't forget to set the order number count to start on the number after the last order you imported. If you want to keep them in order. My programmer knows ASP & works in MS SQL. I've been told MS SQL is better & easier to program than Access.

Hope that helps.



]]> Wed, 31 Jan 2007 23:50:58 +0000 https://forum.productcart.com/import-orders_topic629_post1824.html#1824 <![CDATA[Import orders : Hi - Does anyone know if you can...]]> https://forum.productcart.com/import-orders_topic629_post1823.html#1823 Author: cheflink
Subject: 629
Posted: 31-January-2007 at 9:33pm

Hi - Does anyone know if you can import large qtys of offline orders into product cart without having to rekey

Thanks cameron

]]> Wed, 31 Jan 2007 21:33:04 +0000 https://forum.productcart.com/import-orders_topic629_post1823.html#1823