Description |
This method can be called to create new web sales orders in SupplyStream. The products within the order must have sufficient available stock for the order to be created if "PushToDC" is set to true. |
...
- The Sale Order is defined by the SalesOrderNumber (Identifier)
- If one Line Item in the sales order returns an error (for example, 'Error Submitting SalesOrder: TESTSO - Error. Product 5963405 has no free stock.'), then the entire sales order fails to upload.
- The address is not validated on upload.
- The sales order cannot be edited once uploaded
- In a CSV, if a sales order number is used, and then repeated later on in the file (separated by another sales order), these entities will be treated as separate sales orders.
- A single Sales Order (defined by the Sales Order number) does not accept multiple lines of the same ProductCode.
- Anything that comes through as a SalesOrderLineItem will need inventory and we will need to fully process as a pick.
- Once a Sales Order is at status Dispatched, the Sales Order is closed. No further dispatches will be sent for this sales order.
- If any of the billing address fields are provided, then the full address fields are required.
...
Entity Relationships
This diagram shows the high level relationship between the entities detailed in the Field Level Details section of this page.
Field level details
WebSalesOrder | ||||||||||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") | ||||||||
SalesOrderNumber | Sales Order Number. Must be unique. | nvarchar(50) | Must be unique. | Mandatory | Dispatch Note, Commercial Inv | 12/Dispatch/ SalesOrderNumber | ||||||||
SalesOrderReference | Open reference field | nvarchar(50) | Dispatch Note, Commercial Inv | 12/Dispatch/ SalesOrderReference | OnHold | Related to wholesale, retail environment; build and then send. Order is not sent for picking but available stock is assigned to the order. Release a Sales Order from hold from SEKO 360 or using the Load Release Sales Order from Hold service. | Boolean | TRUE, FALSE | DoNotPushToDC | If set to TRUE, the order is sent to SEKO360, but no stock is assigned to it and is not sent to be picked by the DC. A dispatch request must then be made from your SEKO360 account. | Boolean | TRUE, FALSE | ||
CourierName | Courier the goods should be dispatched on. CourierName accepted values supplied by SEKO. | Nvarchar(100) | Values provided by SEKO | If required by DC | ||||||||||
CourierService | Courier service the goods should be dispatched on. CourierService accepted values supplied by SEKO. | Nvarchar(100) | Values provided by SEKO | If required by DC | ||||||||||
NotificationMethod | Method in which the customer wishes to be notified by the carrier (if applicable): email = Email Notification | Nvarchar(50) | SMS,EMAIL | |||||||||||
Notes | Open notes field that appears on the standard outbound documentation | nvarchar(4000) | Dispatch Note, Commercial Inv | |||||||||||
SpecialInstructions | A note to the DC. (Not seen if wave picking is used) | nvarchar(4000) | Pick Note | |||||||||||
SalesOrderDate | The date as appears on the outbound documentation. If left blank, the date in which the sales order was created will be used. | Datetime | CSV: dd/MM/YYYY e.g. 12/09/2016 yyyyMMdd HHmmss | Dispatch Note, Commercial Inv | ||||||||||
OrderType | The type of order. For orders using a next day service, “Expedited” should be specified in this field. | nvarchar(100) | Web, Expedited | |||||||||||
SalesInvoiceNumber | Sales Invoice number | nvarchar(100) | 12/Dispatch/ SalesInvoiceNumber | |||||||||||
DocumentIdentifier | Placeholder. | nvarchar(100) | ||||||||||||
GiftMessage | The message to the person the gift is being sent to. Pick Note will specify "Yes" if a Gift Message is present. | nvarchar(500) | ||||||||||||
GiftMessageFrom | The person the gift is from. The new field can be populated as required, including personalised names i.e. “Mum”. If first name and last name is required, the entire name should be populated within this field. | nvarchar(100) | ||||||||||||
GiftMessageTo | The person who the gift is being sent to. The new field can be populated as required, including personalised names i.e. “Dad”. It also allows the user to specify the “To” when the gift message is for someone else who lives at the same address as the delivery recipient. If first name and last name is required, the entire name should be populated within this field. | nvarchar(100) | ||||||||||||
ShipmentTerms | DDU, DDP, etc. | nvarchar(100) | Conditional: When required for the carrier | Commercial Inv | ||||||||||
| CourierShopID | Code used during carrier allocation. | nvarchar(50) |
DeliveryDetails | ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") |
ContactCode | Placeholder | nvarchar(100) | ||||
Title | Title of the delivery contact i.e. Mrs, Mr, etc. If 'Title' included, DeliveryDetails→ FirstName or DeliveryDetails→ LastName required. | nvarchar(20) | ||||
FirstName | First name of the delivery contact | nvarchar(50) | Conditional: Required if DeliveryDetails→ LastName not included | Dispatch Note, Commercial Inv | 12/Dispatch/ ShipToAttention | |
LastName | Last name of the delivery contact | nvarchar(50) | Conditional: Required if DeliveryDetails→ FirstName not included | Dispatch Note, Commercial Inv | 12/Dispatch/ ShipToAttention | |
Line1 | Line 1 of the delivery contacts address. If you have a web order that is being delivered to a Company address, this should be the Company Name. | nvarchar(100) | Mandatory | Dispatch Note, Commercial Inv | 12/Dispatch/ DeliveryAddressLine1 | |
Line2 | Line 2 of the delivery contacts address | nvarchar(100) | Dispatch Note, Commercial Inv | 12/Dispatch/ DeliveryAddressLine2 | ||
Line3 | Line 3 of the delivery contacts address | nvarchar(100) | Dispatch Note, Commercial Inv | 12/Dispatch/ DeliveryAddressLine3 | ||
Line4 | Placeholder | nvarchar(100) | Dispatch Note, Commercial Inv | |||
City | City of the delivery contacts address | nvarchar(50) | Mandatory | Dispatch Note, Commercial Inv | 12/Dispatch/ DeliveryAddressCity | |
County | County of the delivery contacts address | nvarchar(50) | Mandatory | Dispatch Note, Commercial Inv | 12/Dispatch/ DeliveryAddressCounty | |
PostcodeZip | Postcode of the delivery contacts address. Postcode is not validated by the SEKO system | nvarchar(20) | Mandatory | Dispatch Note, Commercial Inv | 12/Dispatch/ DeliveryAddressPostCode | |
CountryCode | Country of the delivery contacts address (ISO-2). | nvarchar(2) | Mandatory | Dispatch Note, Commercial Inv | 12/Dispatch/ DeliveryAddressCountry | |
PhoneNumber | Phone number of the delivery contact | nvarchar(20) | Conditional: required by some carriers | Non wave Dispatch Note only, Commercial Inv | 12/Dispatch/ DeliveryPhoneNumber | |
EmailAddress | Email address of the delivery contact | nvarchar(150) | Mandatory | 12/Dispatch/ DeliveryEmailAddress |
...