We have some coding to open our database (MS SQL) and extract the information. We need to add a few fields to this but most are there in the attached.
The code attached sends and email to our customers with order info. We now need to get this information into the text file that our courier wants so that it will print a shipping label.
There is a little bit of logic needed and I attach a spreadsheet that shows the info I think we need in a database with a very simple interface to add or delete the info.
The info from the database will then test against the new database info and then create the shipping file based on logic in the feed and the database.
This should be fairly straightforward for a skilled coder.
The format of teh text file must match the example so that the courier can import direct. There is info attached in this.
We will need to work out the final details as we go.