We sell our products on amazon in addition to using EDI for major retail chains, and the volume is such that we need to make the process of entering the amazon orders by the batch, rather than keying them in one at a time.
amazon has a open source order delivery system that is called AMTU, and it delivers batches of orders in a tab-delimited text file.
Has anyone used this combination before to create sales orders?
We would also need to be able to output a tab-delimited text file that confirms orders to upload back to amazon.
Thanks,
Brian
I looked at this thread:
http://www.mibuso.com/forum/viewtopic.php?t=16024 and think that will help, but I'm not a developer, and don't know that I can do this on my own.
Comments
You could also paste a couple of lines of the text file in here and somebody could give you a dataport. But you won't be able to import the txt file.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
These are the fields in the header of the text file.
I would paste more, but that is private data containing real names, numbers, addresses, etc. If someone orders more than 1 product in an order (i.e. two different SKUs, it is separate lines.
If you create a new customer, what do you search for first name or buyer-email?
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
We use the singular customer Amazon, and each order is a different ship-to. We don't store the ship-to addresses in the customer card, address list. We treat each one like a drop-shipment.
We too receive amazon orders.
As stated in the link you made above.
We pre-format the data into just the fields we actually use..
All the HEADERS
then All the Lines.
We also use just 1 Customer # and the dataport imports the customers info into the Ship-To fields else you will have thousands & thousands of customers at the blink of an eye.
And use a Dataport to import all the orders. Then you can customized it as you need. Here's how we import internet orders
http://savatage99.googlepages.com/Datap ... erswAd.txt
http://www.BiloBeauty.com
http://www.autismspeaks.org
So, the code for the dataport is compiled as a codeunit? Then you create a dataport to hit the sales header?
The application Designers Guide that comes on the product CD has a whole chapter about dataports. If you don't have it I can send you the link to download it.
PS: That orig post you linked to has many good tips.
Play around with some test data in a test environment.
If you get stuck somewhere lets us know.
http://www.BiloBeauty.com
http://www.autismspeaks.org
Harry, your dataport won't import, I get errors on Line 37 in your comment:
and if I remove that, I get errors on line 92:
The error I get is: The AL code is not indented as much as the first line.
It will pay to review the text about dataports.
For example I have added custom fields to our sales header table that WE need to process our orders you may not need them..such as:
50011 Internet Order Boolean
50012 Internet Backorder Boolean
50013 Internet Gift Wrap Boolean
50014 Internet 3rd Party BO Boolean
50015 Internet Gift Message1 Text 84
50016 Internet Gift Message2 Text 83
50017 Internet Gift Message3 Text 83
50018 Internet Order Type Option
50019 Internet Phone No. Text 30
50025 E-Mail Text 80
*Note - Customer PO Number is field 100 (External Doc Number)
http://savatage99.googlepages.com/Datap ... erswAd.fob
*PS When you add New fields to the Sales Header or Sales Line - If you add the Same Fields to the Sales Invoice Header & Sales Invoice Line using the same Numbers (ie.50011) the data will transfer over and be saved in the sales invoice. If you don't the Data will be lost when you post.
I don't think with a reg license you can make changes to the Sales Invoice header table - you will have to then ask your nSC.
http://www.BiloBeauty.com
http://www.autismspeaks.org
http://savatage99.googlepages.com/Datap ... erswAd.txt
I added alot of //Comments to help you see how & where things were happening.
I've found it very useful to become as aware as I can about the system and how it works. 8)
http://www.BiloBeauty.com
http://www.autismspeaks.org