Welcome, Guest. Please Login.
05/15/25 at 15:08:33
News:
Home Help Search Login


Pages: 1
Send Topic Print
Import Sales Orders (Read 495 times)
BethanyW
Browser
*




Posts: 46
Import Sales Orders
02/25/13 at 08:18:07
 
What would be the best way to import sales orders?  We have a web-based ordering system which emails orders to our sales department, which then has to enter them into DBA manually.  We'd like to switch to something more automated.
 
I have come across EDI in my searching, but am not sure it is the best soluti9n since it appears you need to set up separate 'customer' files (in ED-F: Enter Customer EDI Info).  I also haven't found much documentation on it - there is the edimap file listed on the resources page (http://www.istechsupport.com/resources.php), but that doesn't really explain which fields are required or how they relate to the 'EDI customer' information.  I guess overall I'm unsure how exactly it would be set up and work.
 
So, suggestions on the best way to do this - EDI, or something else - and how to proceed?
Back to top
 
 

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11
WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Import Sales Orders
Reply #1 - 02/25/13 at 08:55:46
 
The ED-F Customer information is additional information regarding existing customers, not a different entry for an existing customer and if you are not using true EDI you don't need to enter any of it.  
 
Importing Web Storefront orders has the added challenge that the customer may be new as well so you have to manage that aspect of it.  Using the EDI interface has the advantage of importing to a temporary file and having an error report that can be run to make sure all the data is valid before converting to a true order.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
BethanyW
Browser
*




Posts: 46
Re: Import Sales Orders
Reply #2 - 02/25/13 at 10:06:05
 
Okay, so it sounds like EDI is the way to go.
 
We only allow current customers whose online accounts have been verified to order on our website, so new customers would not be an issue that way since we would have already had to set them up online before they could order.
 
There's still the question of which fields are necessary and which can be ignored.  For example, I can't figure out which of them, if any, will be filled in based on the item code or 'real' customer information.
Back to top
 
 

Bethany Waldmann
Vermont Hardwoods
Chester, VT

Evo-Erp 2013.1, 5 user
IST Update: 7/26/13 SP1
Pervasive 11
Win2003 SBSR2 / XP Pro SP3 / Win7 x64 SP1
Crystal Reports v11
WWW   IP Logged
Pages: 1
Send Topic Print