Quick Summary: The Generic CSV format is a standard way for Netstock to export purchase, transfer, and work orders for use in external host systems. It is compatible with a range of ERPs, including NetSuite (vanilla integration) and MYOB EXO (with additional utilities), and can be used to develop integrations for other systems.
Notes for Developing an Import Process
Netstock allows users to create purchase, transfer, or work orders based on recommended order quantities. When downloaded, each order is written as a CSV file to the integration server. These files are then used to generate actual orders inside the host system.
Options for Processing
Manual import: Users select and load individual files as needed.
Automated import: A scheduled process monitors the directory, imports new orders, and then moves or deletes them to prevent duplicate processing.
File Delivery Details
A scheduled task on the Windows server runs every minute to collect new order files from Netstock.
Files appear in one of the following directories:
C:\NETSTOCK\customername\from_netstock\(Netstock customers)C:\Sage_Inventory_Advisor\customername\from_netstock\(Sage Inventory Advisor customers)
The drive letter may vary, and customername represents the environment name.
Naming Conventions
po_###.csv= purchase orderstr_###.csv= transfer orderswo_###.csv= work orders
Other CSV reports may exist in the same directory, but no other files will begin with po_, tr_, or wo_.
Each file contains one order for a single supplier/location.
Recommended Practices for Automation
Move processed files into success and failure subfolders.
Include error handling to alert users if an import fails.
At minimum, use Supplier, Location, Item, and Quantity when creating the order in the host system.
Where possible, ignore the Cost field and allow the ERP to determine the appropriate cost.
For additional guidance, contact your local Netstock team.
Order File Format
Position | Field Name | Description |
1 | OrderID | A unique numeric identifier from Netstock. |
2 | Supplier | The supplier code (of the supplier itself) – or in the case of transfer orders, the supplying warehouse code. |
3 | Location | The receiving warehouse/location code. |
4 | Creation Date | Date the order was created in Netstock. |
5 | User | Name of the user that created the order. |
6 | The email address of the user that created the order. | |
7 | Item | The product code. |
8 | UOM | Description of the unit of measure that the quantity relates to. |
9 | Quantity | The order quantity in the above unit of measure. |
10 | Cost | The unit cost in the above unit of measure. |
11 | Due Date | Required date for delivery. |
12 | Comment | Optional comments. |
File Layout Example
OrderID,Supplier,Location,CreationDate,User,Email,Item,UOM,Quantity,Cost,DueDate,Comment 33,SUP1,LOC1,2019/02/09,Joe Bloggs,joe@company.com,ITM1,Each,3791,12.4,2019/03/11, 33,SUP1,LOC1,2019/02/09,Joe Bloggs,joe@company.com,ITM2,Each,428,14.7,2019/03/11,a comment 33,SUP1,LOC1,2019/02/09,Joe Bloggs,joe@company.com,ITM3,Each,1152,8.2,2019/03/11, 33,SUP1,LOC1,2019/02/09,Joe Bloggs,joe@company.com,ITM4,Each,669,19.6,2019/03/11,
Forget about these 👇 😞 😐 😃 Have your say here!