Importing Orders

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Has anyone ever needed to import a group of orders from a third party csv file?  Is this something that would be possible to do from within PC admin?  Can the XML tools manager be made to allow for importing as well as exporting?

I have a need to import 50-100 orders or more at a time and assign them order numbers in a one step process.  

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
cpgmar Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-December-2005 Location: United States Status: Offline Points: 2	Post Options Post Reply Quote cpgmar Report Post Thanks(0) Quote Reply Topic: Importing Orders Posted: 10-October-2009 at 5:27pm
	Has anyone ever needed to import a group of orders from a third party csv file? Is this something that would be possible to do from within PC admin? Can the XML tools manager be made to allow for importing as well as exporting? I have a need to import 50-100 orders or more at a time and assign them order numbers in a one step process.
	Cindy The Tasteful Garden www.tastefulgarden.com

hotice007 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 26-November-2007 Status: Offline Points: 0	Post Options Post Reply Quote hotice007 Report Post Thanks(0) Quote Reply Posted: 10-October-2009 at 6:51pm
	I'm interested to know as well if anyone has any ideas...!

russnj Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 25-November-2009 Status: Offline Points: 0	Post Options Post Reply Quote russnj Report Post Thanks(0) Quote Reply Posted: 13-January-2010 at 3:35pm
	Any ideas if this is possible?

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 13-January-2010 at 4:22pm
	Other than the support offered QuickBooks and StoneEdge Order Manager, there are no standard features for importing orders into ProductCart.

RedLeafDev Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 12-January-2010 Location: Portsmouth, NH Status: Offline Points: 28	Post Options Post Reply Quote RedLeafDev Report Post Thanks(0) Quote Reply Posted: 10-February-2010 at 8:48pm
	We recently built multiple import / export processes for a client. In their case we exported orders, but we also wrote a shipping information import process which updates the order with package information and tracking numbers once it is shipped. It is not standard in ProductCart and would require a customization and certain server configuration (SQL Server 2005 with Integration Services installed) but it is possible to build what you describe. It sounds as though this would be a process that you would use more than once (it would not be cost effective if this was a one-time thing). The are other considerations/questions, for example, would the customer number already exist and also match up with the number in the order - or would the customer need to be created as well (and if so should a random password be assigned)? Please contact us at Red Leaf if you are interested in what I describe.
	Red Leaf Development Certified ProductCart Developers www.redleafdevelopment.com