Customizing ProductCart - Import orders

Print Page | Close Window

Import orders

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=629
Printed Date: 25-February-2025 at 1:47pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Import orders

Posted By: cheflink
Subject: Import orders
Date 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

Replies:

Posted By: fidjiti
Date 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.

-------------
Linda - I wish I knew ASP.
To view my ever evolving site click the "www" button below. :)

Posted By: netprofits
Date 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.

-------------
NetProfits Internet Consulting

Certified ProductCart Developer

http://www.nicwebdesign.com" rel="nofollow - Our Site