Import orders

Author

Message

Topic Search

Topic Options

cheflink

Newbie

Joined: 08-January-2007
Location: Australia
Status: Offline
Points: 0

Post Options

Post Reply

Quote cheflink

Report Post

Thanks(0)

Quote

Topic: Import orders
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

fidjiti

Senior Member

Joined: 30-November-2006
Location: United States
Status: Offline
Points: 0

Post Options

Post Reply

Quote fidjiti

Report Post

Thanks(0)

Quote

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. :)

netprofits View Drop Down

Certified ProductCart Developers

Joined: 05-January-2006
Location: United States
Status: Offline
Points: 22

Post Options

Post Reply

Quote netprofits

Report Post

Thanks(0)

Quote

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

Our Site

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
cheflink Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 08-January-2007 Location: Australia Status: Offline Points: 0	Post Options Post Reply Quote cheflink Report Post Thanks(0) Quote Reply Topic: Import orders 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

fidjiti Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 30-November-2006 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote fidjiti Report Post Thanks(0) Quote Reply 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. :)

netprofits Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 05-January-2006 Location: United States Status: Offline Points: 22	Post Options Post Reply Quote netprofits Report Post Thanks(0) Quote Reply 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 Our Site