Discussions
Exporting packing slip information in csv format
We are setting up a fulfillment house to ship our orders. We (and they) don't want to be using Netsuite in their warehouse, so we need a way to send them shipping instructions in some machine-readable format (ie, tab / comma separated or xls file). This would be sent daily, and should contain the same basic information as the packing slip (ie, select all fulfillments with a status of "picked", and export ship-to address, shipping type (UPS Ground / Fedex 2-day etc), list of items and quantities).
Can anyone give me any hints of how to do this? The main difficulty for me is that there is both per-fulfillment data and per-item data in the same file (e.g ship-to information followed by a list of items to go to that address), and I'm not sure how to achieve this.