Download OpenAPI specification:Download
API documentation for the Wherefour ERP/traceability platform. More information at: wherefour.com.
Returns a list of inventory categories, ordered by name.
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | number |
name | string |
[- {
- "id": 1,
- "name": "Ingredients"
}, - {
- "id": 5,
- "name": "Labor"
}, - {
- "id": 2,
- "name": "Packaging"
}, - {
- "id": 8,
- "name": "Parts"
}, - {
- "id": 3,
- "name": "Products"
}
]
Returns a paginated list of all inventory items.
updated_at | string Oldest date/time for the records to return |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | number |
name | string non-empty |
category_name | string non-empty |
on_hand | number |
unit_of_use | string non-empty |
unit_of_purchase | string non-empty |
unit_of_order | string non-empty |
unit_of_invoice | string non-empty |
unit_of_pick_and_ship | string non-empty |
unit_of_weight | string non-empty |
unit_of_dimension | string non-empty |
purchase_conversion | number |
property | string non-empty |
sku | string non-empty |
pull_strategy | string non-empty |
reorder_point | number |
lead_time | number |
retired | boolean |
waste_percentage | number |
quantity_not_tracked | boolean |
Array of objects >= 0 items unique | |
weight | number |
height | number |
width | number |
length | number |
created_at | string non-empty |
updated_at | string non-empty |
Array of objects >= 0 items unique |
{- "id": 56,
- "name": "New inventory item",
- "category_name": "Ingredients",
- "on_hand": 0,
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "unit_of_order": "each",
- "unit_of_invoice": "each",
- "unit_of_pick_and_ship": "each",
- "unit_of_weight": "pound",
- "unit_of_dimension": "inch",
- "purchase_conversion": 1,
- "property": "finished_good",
- "sku": "1234",
- "upc": "5678",
- "pull_strategy": "FIFO",
- "reorder_point": 0,
- "lead_time": 0,
- "retired": false,
- "waste_percentage": 0,
- "quantity_not_tracked": false,
- "standard_cost": "0.0",
- "conversions": [ ],
- "weight": 100,
- "height": 10,
- "width": 10,
- "length": 20,
- "internal_photo_is_public": true,
- "internal_description": "This is an internal description",
- "internal_description_is_public": true,
- "public_name": "New inventory item",
- "public_description": "This is an internal description",
- "show_hold_amounts": true,
- "internal_name_is_public": true,
- "receive_default_delivery_method_id": 1,
- "receive_default_location_id": 1,
- "receive_default_accept_rows": 1,
- "receive_default_to_total_cost": true,
- "receive_default_stock_status": "active",
- "receive_require_barcode": false,
- "receive_require_serial_number": false,
- "receive_require_location": false,
- "receive_require_expiration_date": false,
- "receive_prefill_expiration_date": false,
- "receive_expiration_date_days": 30,
- "receive_allow_unit_of_receiving_change": true,
- "receive_keep_quantity": true,
- "receive_keep_unit_of_receiving": true,
- "receive_keep_cost": true,
- "receive_keep_vendor_item_number": true,
- "receive_keep_location": true,
- "receive_keep_expiration_date": true,
- "receive_keep_stock_description": true,
- "receive_allow_custom_field_entry": true,
- "created_at": "2024-06-15T02:54:11.546Z",
- "updated_at": "2024-06-15T02:54:11.546Z",
- "custom_field_values": [
- {
- "id": 1,
- "custom_field_id": 1,
- "inventory_id": 1,
- "active_stock_id": 1,
- "value": "1",
- "value_type": "number",
- "created_at": "2021-08-23T14:25:37.200Z",
- "updated_at": "2021-08-23T14:25:37.200Z",
- "custom_field": {
- "id": 1,
- "name": "Test",
- "value_type": "number",
- "created_at": "2021-08-23T14:25:21.663Z",
- "updated_at": "2021-08-23T14:25:21.663Z"
}
}
]
}
Creates a new inventory item with the provided parameters.
name | string |
category_id | number |
unit_of_use | string |
unit_of_purchase | string |
unit_of_order | string |
unit_of_invoice | string |
unit_of_pick_and_ship | string |
unit_of_weight | string |
unit_of_dimension | string |
purchase_conversion | number |
property | string Enum: "raw_material" "overhead" "work_in_progress" "finished_good" |
sku | string |
upc | string |
pull_strategy | string Enum: "FIFO" "Hand Pick" "FEFO" "LIFO" |
reorder_point | number |
rate | number |
lead_time | number |
retired | boolean |
waste_percentage | number |
quantity_not_tracked | boolean |
standard_cost | number |
weight | number |
height | number |
width | number |
length | number |
id | number |
name | string non-empty |
category_name | string non-empty |
on_hand | number |
unit_of_use | string non-empty |
unit_of_purchase | string non-empty |
unit_of_order | string non-empty |
unit_of_invoice | string non-empty |
unit_of_pick_and_ship | string non-empty |
unit_of_weight | string non-empty |
unit_of_dimension | string non-empty |
purchase_conversion | number |
property | string non-empty |
sku | string non-empty |
pull_strategy | string non-empty |
reorder_point | number |
lead_time | number |
retired | boolean |
waste_percentage | number |
quantity_not_tracked | boolean |
Array of objects >= 0 items unique | |
weight | number |
height | number |
width | number |
length | number |
created_at | string non-empty |
updated_at | string non-empty |
Array of objects >= 0 items unique |
{- "name": "Whole milk",
- "category_id": 1,
- "unit_of_use": "gallon",
- "unit_of_purchase": "gallon",
- "unit_of_order": "gallon",
- "unit_of_invoice": "gallon",
- "unit_of_pick_and_ship": "gallon",
- "unit_of_weight": null,
- "unit_of_dimension": null,
- "purchase_conversion": 1,
- "property": "raw_material",
- "sku": null,
- "pull_strategy": "FIFO",
- "reorder_point": 50,
- "lead_time": 1,
- "retired": false,
- "waste_percentage": 0,
- "quantity_not_tracked": false,
- "standard_cost": "0.0",
- "weight": null,
- "height": null,
- "width": null,
- "length": null
}
{- "id": 0,
- "name": "string",
- "category_name": "string",
- "on_hand": 0,
- "unit_of_use": "string",
- "unit_of_purchase": "string",
- "unit_of_order": "string",
- "unit_of_invoice": "string",
- "unit_of_pick_and_ship": "string",
- "unit_of_weight": "string",
- "unit_of_dimension": "string",
- "purchase_conversion": 0,
- "property": "string",
- "sku": "string",
- "pull_strategy": "string",
- "reorder_point": 0,
- "lead_time": 0,
- "retired": true,
- "waste_percentage": 0,
- "quantity_not_tracked": true,
- "conversions": [
- {
- "to_count": 0,
- "from_count": 0,
- "catch_weight": true,
- "maximum_weight": 0,
- "minimum_weight": 0,
- "unit_of_measurement": "string"
}
], - "weight": 0,
- "height": 0,
- "width": 0,
- "length": 0,
- "created_at": "string",
- "updated_at": "string",
- "custom_field_values": [
- {
- "id": 0,
- "custom_field_id": 0,
- "inventory_id": 0,
- "active_stock_id": 0,
- "value": "string",
- "value_type": "string",
- "created_at": "string",
- "updated_at": "string",
- "custom_field": {
- "id": 0,
- "name": "string",
- "value_type": "string",
- "created_at": "string",
- "updated_at": "string"
}
}
]
}
Adds a new stock lot to the specified inventory item.
inventory_id required | integer inventory item record ID |
delivery_method_id required | number |
location_id | number |
vendor_id | number |
vendor_reference | string |
count required | number |
lot_code required | string required if automatic sequencing is not enabled or generate_lot_code is false |
barcode | string |
serial_number | string |
expiration_date | string must be in the preferred date format of the API user |
received_date required | string must be in the preferred date time format of the API user |
generate_lot_code | boolean |
generate_barcode | boolean |
generate_serial_number | string |
cost required | number |
cost_entered_is_total_code | boolean if cost_entered_is_total_code is false, the cost will be treated as a per unit cost |
stock_description | string |
vendor_item_number | string |
status | string Enum: "active" "inactive" "on_hold" "quarantined" |
id | number |
user_id | number |
inventory_id | number |
location_id | number |
lot_code | string |
status | string |
barcode | string |
details | string |
note | string |
count | number |
cost | number |
vendor_id | number |
expiration_date | string |
created_at | string |
updated_at | string |
base_count | number |
rate | number |
purchase_id | number |
global_identifier | string |
organization_id | number |
expiration_notified_at | string |
weight | number |
height | number |
width | number |
length | number |
serial_number | string |
generate_barcode | boolean |
generate_lot_code | boolean |
generate_serial_number | boolean |
Array of objects >= 0 items unique |
{- "delivery_method_id": 1,
- "location_id": 1,
- "vendor_id": 1,
- "lot_code": "1234",
- "stock_description": "New stock",
- "count": 100,
- "cost": 100,
- "cost_entered_is_total_cost": true,
- "status": "active",
- "expiration_date": "11/05/25",
- "received_date": "11/05/2024 02:39 PM"
}
{- "id": 35,
- "user_id": 6,
- "inventory_id": 4,
- "location_id": 1,
- "lot_code": "1234",
- "status": "active",
- "barcode": null,
- "details": "New stock",
- "note": "",
- "count": "100.0",
- "cost": "100.0",
- "vendor_id": 1,
- "expiration_date": "2025-11-05",
- "created_at": "2024-11-05T17:42:31.000Z",
- "updated_at": "2024-11-05T17:42:31.000Z",
- "base_count": "100.0",
- "rate": null,
- "purchase_id": null,
- "global_identifier": "18c63c87-fcac-40d3-b334-22ef41c85cf5",
- "organization_id": 1,
- "expiration_notified_at": null,
- "weight": null,
- "height": null,
- "width": null,
- "length": null,
- "serial_number": null,
- "generate_barcode": false,
- "generate_lot_code": false,
- "generate_serial_number": false,
- "custom_field_values": [ ]
}
Gets the last stock lot change for the specified inventory item.
{- "id": 1,
- "user_id": 1,
- "user_first_name": "Tony",
- "user_last_name": "Fiorello",
- "reason": "purchase",
- "lot_code": "WM001",
- "old_lot_code": "WM001",
- "barcode": "WM-000001-18",
- "old_barcode": "WM-000001-18",
- "details": "Whole milk",
- "rate": null,
- "cost": "200.0",
- "count": "100.0",
- "change": "100.0",
- "absolute_change": "100.0",
- "note": "buy lot 1",
- "work_order": null,
- "expiration_date": "2020-05-31",
- "created_at": "2020-09-11T13:57:47.026Z",
- "updated_at": "2020-09-11T13:57:47.026Z",
- "stock": {
- "id": 1,
- "name": "Whole milk",
- "lot_code": "WM001",
- "status": "active",
- "barcode": "WM-000001-18",
- "details": "Whole milk",
- "note": "buy lot WM001",
- "count": "100.0",
- "cost": "200.0",
- "expiration_date": "2020-10-11",
- "created_at": "2020-09-11T13:57:47.058Z",
- "updated_at": "2020-09-11T13:57:47.058Z",
- "inventory": {
- "id": 1,
- "name": "Whole milk",
- "category_name": "Ingredients",
- "on_hand": "1410.0",
- "unit_of_use": "gallon",
- "unit_of_purchase": "gallon",
- "property": "raw_material",
- "sku": null,
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}, - "location": {
- "id": 1,
- "name": "North Warehouse"
}, - "vendor": {
- "id": 1,
- "first_name": "Joe",
- "last_name": "Sample",
- "display_name": "Pacific Foods Co.",
- "email": "jsample@pacificfoods.com",
- "phone": "415-555-6758",
- "mobile": null,
- "fax": null,
- "note": null,
- "kind": "distributor",
- "created_at": "2020-09-11T13:57:47.005Z",
- "updated_at": "2020-09-11T13:57:47.005Z",
- "custom_field_1": null,
- "custom_field_2": null,
- "custom_field_3": null,
- "custom_field_4": null,
- "business_license_number": null
}, - "purchase": null
}
}
Returns inventory items that match the given name or SKU. Multiple matches may be returned.
page | integer Results page to view |
Search can be performed based on EITHER the inventory item name, OR a single SKU or an array of SKUs. The inventory item name will take precedence over the SKU parameter. Multiple matches may be returned.
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | number |
name | string non-empty |
category_name | string non-empty |
on_hand | number |
unit_of_use | string non-empty |
unit_of_purchase | string non-empty |
unit_of_order | string non-empty |
unit_of_invoice | string non-empty |
unit_of_pick_and_ship | string non-empty |
unit_of_weight | string non-empty |
unit_of_dimension | string non-empty |
purchase_conversion | number |
property | string non-empty |
sku | string non-empty |
pull_strategy | string non-empty |
reorder_point | number |
lead_time | number |
retired | boolean |
waste_percentage | number |
quantity_not_tracked | boolean |
Array of objects >= 0 items unique | |
weight | number |
height | number |
width | number |
length | number |
created_at | string non-empty |
updated_at | string non-empty |
Array of objects >= 0 items unique |
{- "name": "Product Name Here"
}
{- "id": 3,
- "name": "Bulk chocolate",
- "category_name": "Ingredients",
- "on_hand": 0,
- "unit_of_use": "pound",
- "unit_of_purchase": "pound",
- "purchase_conversion": 1,
- "property": "work_in_progress",
- "sku": "123456",
- "pull_strategy": "Hand Pick",
- "reorder_point": 10,
- "lead_time": 0,
- "retired": false,
- "waste_percentage": 0,
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
Lists invoices for a customer
customer_id required | integer customer record ID |
id | integer |
invoice_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
invoice_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 2,
- "invoice_date": "2024-02-22",
- "status": "draft",
- "instructions": "",
- "subtotal": "300.0",
- "discount": "10.0",
- "tax": "",
- "shipping": "25.0",
- "total": "315.0",
- "invoice_number": "INV2",
- "created_at": "2024-02-22T18:29:42.330Z",
- "updated_at": "2024-02-22T18:29:42.330Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Distribution",
- "email": "buyer@embarcado.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "sales_channel_id": null,
- "created_at": "2024-02-22T18:29:42.249Z",
- "updated_at": "2024-02-22T18:29:42.249Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "404-X0001",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North",
- "delivery_method_id": 6,
- "default_special_instructions": "Deliver to back dock 12"
}, - "sales_channel": null,
- "invoice_items": [
- {
- "id": 3,
- "name": "Finished good B",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "20.0",
- "cost": "2.5",
- "sku": "SK0001",
- "created_at": "2024-02-22T18:29:42.323Z",
- "updated_at": "2024-02-22T18:29:42.323Z"
}, - {
- "id": 4,
- "name": "Case of finished good B",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "10.0",
- "cost": "25.0",
- "sku": "SK0002",
- "created_at": "2024-02-22T18:29:42.323Z",
- "updated_at": "2024-02-22T18:29:42.323Z"
}
]
}
Creates a new invoice for the customer.
customer_id required | integer customer record ID |
id | integer |
invoice_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
invoice_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "invoice_number": "INV100",
- "invoice_date": "2020-09-04",
- "payment_term_id": null,
- "status": "open",
- "salesperson_id": null,
- "payment_terms": null,
- "delivery_method_id": 1,
- "instructions": null,
- "subtotal": 100,
- "discount": 0,
- "tax": 0,
- "shipping": 0,
- "total": 0,
- "invoice_items_attributes": [
- {
- "inventory_id": 4,
- "count": 10,
- "unit_price": 100,
- "override_unit_price": 0
}, - {
- "inventory_id": 6,
- "count": 5,
- "unit_price": 0,
- "override_unit_price": 0
}
]
}
{- "id": 14,
- "invoice_date": "2020-09-04",
- "po_number": "12345",
- "status": "open",
- "order_id": 1,
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "invoice_number": "INV100",
- "created_at": "2020-09-12T18:25:54.054Z",
- "updated_at": "2020-09-12T18:25:54.054Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": "",
- "line4": "",
- "line5": "",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": "",
- "line5": "",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "salesperson": "",
- "payment_term": "",
- "invoice_items": [
- {
- "id": 28,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "10.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T18:25:54.062Z",
- "updated_at": "2020-09-12T18:25:54.062Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "1165.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "purchase_conversion": "1.0",
- "property": "finished_good",
- "sku": "SK0001",
- "pull_strategy": "FEFO",
- "reorder_point": "0.0",
- "lead_time": 0,
- "retired": false,
- "waste_percentage": "0.0",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 29,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "5.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T18:25:54.066Z",
- "updated_at": "2020-09-12T18:25:54.066Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "0.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "purchase_conversion": "1.0",
- "property": "finished_good",
- "sku": "SK0002",
- "pull_strategy": "FIFO",
- "reorder_point": "0.0",
- "lead_time": 0,
- "retired": false,
- "waste_percentage": "0.0",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Updates an existing invoice
invoice_id required | integer invoice record ID |
customer_id required | integer customer record ID |
id | integer |
invoice_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
invoice_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 6,
- "invoice_date": "2020-09-04",
- "status": "draft",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "invoice_number": "INV100",
- "created_at": "2020-09-12T16:13:45.549Z",
- "updated_at": "2020-09-12T16:13:45.549Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "payment_terms": "Net 30",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping"
}, - "invoice_items": [
- {
- "id": 10,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:13:45.568Z",
- "updated_at": "2020-09-12T16:13:45.568Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "75.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "property": "finished_good",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Returns a paginated list of all invoices.
updated_at | string Oldest date/time for the records returned |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | integer |
invoice_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
invoice_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 6,
- "invoice_date": "2020-09-04",
- "status": "open",
- "salesperson_id": null,
- "salesperson_name": "",
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "invoice_number": "INV100",
- "payment_term_id": null,
- "created_at": "2020-09-12T16:13:45.549Z",
- "updated_at": "2020-09-12T16:13:45.549Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": "",
- "line4": "",
- "line5": "",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": "",
- "line5": "",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "invoice_items": [
- {
- "id": 10,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:13:45.568Z",
- "updated_at": "2020-09-12T16:13:45.568Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "75.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "property": "finished_good",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 11,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T16:13:45.574Z",
- "updated_at": "2020-09-12T16:13:45.574Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "40.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "property": "finished_good",
- "sku": "SK0002",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Retrieves a invoice record by ID
invoice_id required | integer Example: 1 ID for the invoice record |
id | integer |
invoice_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
invoice_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 1,
- "invoice_date": "2020-09-04",
- "status": "complete",
- "salesperson_id": null,
- "salesperson_name": null,
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "invoice_number": "INV1",
- "payment_term_id": null,
- "created_at": "2020-09-11T13:57:46.842Z",
- "updated_at": "2020-09-12T16:22:26.851Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North"
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "salesperson": "",
- "payment_term": "",
- "invoice_items": [
- {
- "id": 1,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "20.0",
- "cost": "2.5",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:47.050Z",
- "updated_at": "2020-09-11T13:57:47.050Z"
}, - {
- "id": 2,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "10.0",
- "cost": "25.0",
- "sku": "SK0002",
- "created_at": "2020-09-11T13:57:47.050Z",
- "updated_at": "2020-09-11T13:57:47.050Z"
}, - {
- "id": 12,
- "name": "Bulk chocolate",
- "inventory_id": 3,
- "category_name": "Ingredients",
- "count": "0.0",
- "cost": "0.0",
- "sku": null,
- "created_at": "2020-09-12T16:22:26.858Z",
- "updated_at": "2020-09-12T16:22:26.858Z"
}, - {
- "id": 13,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:22:26.863Z",
- "updated_at": "2020-09-12T16:22:26.863Z"
}
]
}
Locates a invoice by the invoice_number
invoice_number | string non-empty Example: invoice_number={
"invoice_number": "INV1"
} The invoice number in Wherefour to locate. All invoices with matching results will be returned. |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | integer |
invoice_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
invoice_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "invoice_number": "INV1"
}
{- "id": 1,
- "invoice_date": "2020-09-04",
- "status": "invoiced",
- "salesperson_id": null,
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "300.0",
- "discount": "10.0",
- "tax": "0.00",
- "shipping": "25.0",
- "total": "315.0",
- "invoice_number": "INV1",
- "payment_term_id": 1,
- "created_at": "2020-07-16T19:49:19.481Z",
- "updated_at": "2020-07-16T19:49:19.481Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-07-16T19:49:19.394Z",
- "updated_at": "2020-07-16T19:49:19.394Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North"
}, - "invoice_items": [
- {
- "id": 1,
- "name": "Chocolate bar",
- "category_name": "Products",
- "count": "20.0",
- "cost": "2.5",
- "sku": "SK0001",
- "created_at": "2020-07-16T19:49:19.640Z",
- "updated_at": "2020-07-16T19:49:19.640Z"
}, - {
- "id": 2,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "count": "10.0",
- "cost": "25.0",
- "sku": "SK0002",
- "created_at": "2020-07-16T19:49:19.640Z",
- "updated_at": "2020-07-16T19:49:19.640Z"
}
]
}
Returns all the orders for the customer ID provided.
customer_id required | integer customer record ID |
updated_at | string Oldest date/time for the records to return |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Distribution",
- "email": "buyer@embarcado.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": null,
- "kind": "retailer",
- "sales_channel_id": null,
- "origin": "wherefour",
- "created_at": "2024-02-22T18:29:42.249Z",
- "updated_at": "2024-02-22T18:29:42.249Z",
- "custom_field_1": null,
- "custom_field_2": null,
- "custom_field_3": null,
- "custom_field_4": null,
- "business_license_number": "404-X0001",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": { },
- "delivery_method_id": 6,
- "default_special_instructions": "Deliver to back dock 12",
- "sales_channel": null,
- "billing_address": {
- "id": 1,
- "type": "BillingAddress",
- "descriptive_name": "Default Billing",
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": null,
- "line4": null,
- "line5": null,
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "USA",
- "created_at": "2024-02-22T18:29:42.099Z",
- "updated_at": "2024-02-22T18:29:42.099Z"
}, - "shipping_address": {
- "id": 2,
- "type": "ShippingAddress",
- "descriptive_name": "Default Shipping",
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": null,
- "line5": null,
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "USA",
- "created_at": "2024-02-22T18:29:42.099Z",
- "updated_at": "2024-02-22T18:29:42.099Z"
}, - "delivery_driver": null,
- "delivery_vehicle": null,
- "addresses": [
- {
- "id": 1,
- "type": "BillingAddress",
- "descriptive_name": "Default Billing",
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": null,
- "line4": null,
- "line5": null,
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "USA",
- "created_at": "2024-02-22T18:29:42.099Z",
- "updated_at": "2024-02-22T18:29:42.099Z"
}, - {
- "id": 2,
- "type": "ShippingAddress",
- "descriptive_name": "Default Shipping",
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": null,
- "line5": null,
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "USA",
- "created_at": "2024-02-22T18:29:42.099Z",
- "updated_at": "2024-02-22T18:29:42.099Z"
}
]
}
Creates a new order for the customer.
customer_id required | integer customer record ID |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "order_number": "SO100",
- "order_date": "2020-09-04",
- "deliver_date": "2020-09-04",
- "produce_date": "2020-09-04",
- "po_number": "12345",
- "payment_term_id": null,
- "status": "open",
- "origin": "wherefour",
- "salesperson_id": null,
- "payment_terms": null,
- "delivery_method_id": 1,
- "instructions": null,
- "subtotal": 100,
- "discount": 0,
- "tax": 0,
- "shipping": 0,
- "total": 0,
- "order_items_attributes": [
- {
- "inventory_id": 4,
- "count": 10,
- "unit_price": 100,
- "override_unit_price": 0
}, - {
- "inventory_id": 6,
- "count": 5,
- "unit_price": 0,
- "override_unit_price": 0
}
]
}
{- "id": 14,
- "order_date": "2020-09-04",
- "produce_date": "2020-09-04",
- "deliver_date": "2020-09-04",
- "po_number": "12345",
- "status": "open",
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "origin": "wherefour",
- "order_number": "SO100",
- "created_at": "2020-09-12T18:25:54.054Z",
- "updated_at": "2020-09-12T18:25:54.054Z",
- "invoiced_at": "2020-09-12T18:25:54.054Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": "",
- "line4": "",
- "line5": "",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": "",
- "line5": "",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "salesperson": "",
- "payment_term": "",
- "order_items": [
- {
- "id": 28,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "10.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T18:25:54.062Z",
- "updated_at": "2020-09-12T18:25:54.062Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "1165.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "purchase_conversion": "1.0",
- "property": "finished_good",
- "sku": "SK0001",
- "pull_strategy": "FEFO",
- "reorder_point": "0.0",
- "lead_time": 0,
- "retired": false,
- "waste_percentage": "0.0",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 29,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "5.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T18:25:54.066Z",
- "updated_at": "2020-09-12T18:25:54.066Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "0.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "purchase_conversion": "1.0",
- "property": "finished_good",
- "sku": "SK0002",
- "pull_strategy": "FIFO",
- "reorder_point": "0.0",
- "lead_time": 0,
- "retired": false,
- "waste_percentage": "0.0",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Updates an existing order
order_id required | integer order record ID |
customer_id required | integer customer record ID |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 6,
- "order_date": "2020-09-04",
- "produce_date": "2020-09-04",
- "deliver_date": "2020-09-04",
- "po_number": "12345",
- "status": "open",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "order_number": "SO100",
- "created_at": "2020-09-12T16:13:45.549Z",
- "updated_at": "2020-09-12T16:13:45.549Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "payment_terms": "Net 30",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping"
}, - "order_items": [
- {
- "id": 10,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:13:45.568Z",
- "updated_at": "2020-09-12T16:13:45.568Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "75.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "property": "finished_good",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 11,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T16:13:45.574Z",
- "updated_at": "2020-09-12T16:13:45.574Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "40.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "property": "finished_good",
- "sku": "SK0002",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Returns the most recent shipment information for the order ID provided.
customer_id required | integer Example: 1 customer record ID |
order_id required | integer order record ID |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 1,
- "order_id": 2,
- "user_name": "Tony Fiorello",
- "ship_date": "2020-09-12T16:48:00.000Z",
- "shipment_number": 1,
- "tracking_number": null,
- "note": null,
- "created_at": "2020-09-12T16:48:13.512Z",
- "updated_at": "2020-09-12T16:48:13.512Z",
- "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "order": {
- "id": 2,
- "order_date": "2020-09-10",
- "produce_date": "2020-09-11",
- "deliver_date": "2020-09-11",
- "po_number": "123456-55",
- "status": "invoiced",
- "salesperson_id": null,
- "salesperson_name": null,
- "delivery_method_id": 1,
- "instructions": "\nShipment #1: 09/12/20\n10.0 Each - Chocolate bar (lot code: SC-00000)\n40.0 Cases - Chocolate bar, finished case (lot code: SCC-0000)\n",
- "subtotal": "1400.0",
- "discount": "0.00",
- "tax": "0.00",
- "shipping": "0.00",
- "total": "1400.0",
- "order_number": "SO2",
- "payment_term_id": 1,
- "created_at": "2020-09-11T13:57:46.842Z",
- "updated_at": "2020-09-12T16:48:13.688Z",
- "invoiced_at": "2020-09-11T00:00:00.000Z"
}, - "shipment_items": [
- {
- "id": 1,
- "count": "10.0",
- "inventory_name": "Chocolate bar",
- "inventory_sku": "SK0001",
- "auto_ship": [
- {
- "adjustment_id": 25,
- "stock_id": 13,
- "lot_code": "SC-00000",
- "barcode": "CH-000001-18",
- "count": "10.0",
- "change": "-10.0",
- "reason": "shipment"
}
]
}, - {
- "id": 2,
- "count": "40.0",
- "inventory_name": "Chocolate bar, finished case",
- "inventory_sku": "SK0002",
- "auto_ship": [
- {
- "adjustment_id": 26,
- "stock_id": 14,
- "lot_code": "SCC-0000",
- "barcode": "CHCA-000001-18",
- "count": "40.0",
- "change": "-40.0",
- "reason": "shipment"
}
]
}
]
}
Returns the most recent shipment information for the order ID provided.
customer_id required | integer Example: 1 customer record ID |
order_id required | integer Example: 2 order record ID |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 1,
- "order_id": 2,
- "user_name": "Tony Fiorello",
- "ship_date": "2020-09-12T16:48:00.000Z",
- "shipment_number": 1,
- "tracking_number": null,
- "note": null,
- "created_at": "2020-09-12T16:48:13.512Z",
- "updated_at": "2020-09-12T16:48:13.512Z",
- "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "order": {
- "id": 2,
- "order_date": "2020-09-10",
- "produce_date": "2020-09-11",
- "deliver_date": "2020-09-11",
- "po_number": "123456-55",
- "status": "invoiced",
- "salesperson_id": "",
- "salesperson_name": "",
- "delivery_method_id": 1,
- "instructions": "\nShipment #1: 09/12/20\n10.0 Each - Chocolate bar (lot code: SC-00000)\n40.0 Cases - Chocolate bar, finished case (lot code: SCC-0000)\n",
- "subtotal": "1400.0",
- "discount": "",
- "tax": "",
- "shipping": "",
- "total": "1400.0",
- "order_number": "SO2",
- "payment_term_id": 1,
- "created_at": "2020-09-11T13:57:46.842Z",
- "updated_at": "2020-09-12T16:48:13.688Z",
- "invoiced_at": "2020-09-11T00:00:00.000Z"
}, - "shipment_items": [
- {
- "id": 1,
- "count": "10.0",
- "inventory_name": "Chocolate bar",
- "inventory_sku": "SK0001",
- "auto_ship": [
- {
- "adjustment_id": 25,
- "stock_id": 13,
- "lot_code": "SC-00000",
- "barcode": "CH-000001-18",
- "count": "10.0",
- "change": "-10.0",
- "reason": "shipment"
}
]
}, - {
- "id": 2,
- "count": "40.0",
- "inventory_name": "Chocolate bar, finished case",
- "inventory_sku": "SK0002",
- "auto_ship": [
- {
- "adjustment_id": 26,
- "stock_id": 14,
- "lot_code": "SCC-0000",
- "barcode": "CHCA-000001-18",
- "count": "40.0",
- "change": "-40.0",
- "reason": "shipment"
}
]
}
]
}
Performs a "pick and ship" for the specified order. Wherefour will auto-select available lot coded inventory, based on each inventory item's pull strategy, to fulfill the order. If the location is specified, only inventory at that location will be considered. If not enough inventory is available, a partial shipment will be created. Results of the shipment, with the selected stock lots, will be returned.
The optional ship_date param can be used to specify the timestamp of the shipment. Date/time should be in the format "2021-02-02 12:00 AM" and in the same time zone as the user's Wherefour settings.
customer_id required | integer customer record ID |
delivery_method required | string |
location_name | string Name of the Wherefour location to pull stock from. If not provided, auto ship will pull available stock lots from any location. Name lookup will use the closest found match for the name provided or "null" for no match. |
tracking_number | string Tracking number to record for the shipment. |
ship_date | string |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "tracking_number": "123456",
- "delivery_method": "UPS Ground",
- "location_name": "North Warehouse"
}
{- "id": 2,
- "order_id": 14,
- "user_name": "Tony Fiorello",
- "ship_date": "2020-09-12T18:26:00.000Z",
- "shipment_number": 1,
- "tracking_number": null,
- "note": null,
- "created_at": "2020-09-12T18:26:02.037Z",
- "updated_at": "2020-09-12T18:26:02.037Z",
- "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "order": {
- "id": 14,
- "order_date": "2020-09-04",
- "produce_date": "2020-09-04",
- "deliver_date": "2020-09-04",
- "po_number": "12345",
- "status": "open",
- "salesperson_id": null,
- "salesperson_name": null,
- "delivery_method_id": 1,
- "instructions": "\nShipment #1: 09/12/20\n10.0 Each - Chocolate bar (lot code: 1234)\n",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "order_number": "SO100",
- "payment_term_id": null,
- "created_at": "2020-09-12T18:25:54.054Z",
- "updated_at": "2020-09-12T18:26:02.139Z",
- "invoiced_at": null
}, - "shipment_items": [
- {
- "id": 3,
- "count": "10.0",
- "inventory_name": "Chocolate bar",
- "inventory_sku": "SK0001",
- "auto_ship": [
- {
- "adjustment_id": 43,
- "stock_id": 39,
- "lot_code": "1234",
- "barcode": null,
- "count": "10.0",
- "change": "-10.0",
- "reason": "shipment"
}
]
}
]
}
Returns a paginated list of all orders.
updated_at | string Oldest date/time for the records returned |
status | string Order status |
search_start_date | string Oldest order date, produce on date, deliver on date, or ship on date to return |
search_end_date | string Newest order date, produce on date, deliver on date, or ship on date to return |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 6,
- "order_date": "2020-09-04",
- "produce_date": "2020-09-04",
- "deliver_date": "2020-09-04",
- "po_number": "12345",
- "status": "open",
- "salesperson_id": null,
- "salesperson_name": "",
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "order_number": "SO100",
- "payment_term_id": null,
- "created_at": "2020-09-12T16:13:45.549Z",
- "updated_at": "2020-09-12T16:13:45.549Z",
- "invoiced_at": "2020-09-12T16:13:45.549Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": "",
- "line4": "",
- "line5": "",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": "",
- "line5": "",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "order_items": [
- {
- "id": 10,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:13:45.568Z",
- "updated_at": "2020-09-12T16:13:45.568Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "75.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "property": "finished_good",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 11,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T16:13:45.574Z",
- "updated_at": "2020-09-12T16:13:45.574Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "40.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "property": "finished_good",
- "sku": "SK0002",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Retrieves an order record by ID
order_id required | integer Example: 1 ID for the order record |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 1,
- "order_date": "3/1/20",
- "produce_date": "3/1/20",
- "deliver_date": "3/1/20",
- "po_number": "123456-11",
- "status": "complete",
- "salesperson_id": null,
- "salesperson_name": null,
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "order_number": "SO1",
- "payment_term_id": null,
- "created_at": "2020-09-11T13:57:46.842Z",
- "updated_at": "2020-09-12T16:22:26.851Z",
- "invoiced_at": "2020-09-11T00:00:00.000Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North"
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "salesperson": "",
- "payment_term": "",
- "order_items": [
- {
- "id": 1,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "20.0",
- "cost": "2.5",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:47.050Z",
- "updated_at": "2020-09-11T13:57:47.050Z"
}, - {
- "id": 2,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "10.0",
- "cost": "25.0",
- "sku": "SK0002",
- "created_at": "2020-09-11T13:57:47.050Z",
- "updated_at": "2020-09-11T13:57:47.050Z"
}, - {
- "id": 12,
- "name": "Bulk chocolate",
- "inventory_id": 3,
- "category_name": "Ingredients",
- "count": "0.0",
- "cost": "0.0",
- "sku": null,
- "created_at": "2020-09-12T16:22:26.858Z",
- "updated_at": "2020-09-12T16:22:26.858Z"
}, - {
- "id": 13,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:22:26.863Z",
- "updated_at": "2020-09-12T16:22:26.863Z"
}
]
}
Locates an order by the order_number
order_number | string non-empty Example: order_number={
"order_number": "SO1"
} The sales order number in Wherefour to locate. All orders with matching results will be returned. |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | integer |
order_date | string |
produce_date | string |
deliver_date | string |
po_number | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
order_number | string |
created_at | string |
updated_at | string |
invoiced_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "order_number": "SO1"
}
{- "id": 1,
- "order_date": "2020-07-14",
- "produce_date": "2020-07-16",
- "deliver_date": "2020-07-16",
- "status": "invoiced",
- "salesperson_id": null,
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "300.0",
- "discount": "10.0",
- "tax": "0.00",
- "shipping": "25.0",
- "total": "315.0",
- "order_number": "SO1",
- "payment_term_id": 1,
- "created_at": "2020-07-16T19:49:19.481Z",
- "updated_at": "2020-07-16T19:49:19.481Z",
- "invoiced_at": "2020-07-16T00:00:00.000Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-07-16T19:49:19.394Z",
- "updated_at": "2020-07-16T19:49:19.394Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North"
}, - "order_items": [
- {
- "id": 1,
- "name": "Chocolate bar",
- "category_name": "Products",
- "count": "20.0",
- "cost": "2.5",
- "sku": "SK0001",
- "created_at": "2020-07-16T19:49:19.640Z",
- "updated_at": "2020-07-16T19:49:19.640Z"
}, - {
- "id": 2,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "count": "10.0",
- "cost": "25.0",
- "sku": "SK0002",
- "created_at": "2020-07-16T19:49:19.640Z",
- "updated_at": "2020-07-16T19:49:19.640Z"
}
]
}
Lists the quotes for a the customer.
customer_id required | integer customer record ID |
id | integer |
quote_date | string |
expiration_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
quote_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 1,
- "quote_date": "2024-02-22",
- "expiration_date": "2024-03-23",
- "status": "draft",
- "instructions": null,
- "subtotal": "300.0",
- "discount": "10.0",
- "tax": "0.0",
- "shipping": "25.0",
- "total": "340.0",
- "quote_number": "QO1",
- "created_at": "2024-02-22T18:29:42.552Z",
- "updated_at": "2024-02-22T18:29:42.552Z",
- "billing_address": {
- "id": 1,
- "type": "BillingAddress",
- "descriptive_name": "Default Billing",
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": null,
- "line4": null,
- "line5": null,
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "USA",
- "created_at": "2024-02-22T18:29:42.099Z",
- "updated_at": "2024-02-22T18:29:42.099Z"
}, - "shipping_address": {
- "id": 2,
- "type": "ShippingAddress",
- "descriptive_name": "Default Shipping",
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": null,
- "line5": null,
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "USA",
- "created_at": "2024-02-22T18:29:42.099Z",
- "updated_at": "2024-02-22T18:29:42.099Z"
}, - "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Distribution",
- "email": "buyer@embarcado.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": null,
- "kind": "retailer",
- "sales_channel_id": null,
- "created_at": "2024-02-22T18:29:42.249Z",
- "updated_at": "2024-02-22T18:29:42.249Z",
- "custom_field_1": null,
- "custom_field_2": null,
- "custom_field_3": null,
- "custom_field_4": null,
- "business_license_number": "404-X0001",
- "payment_terms": "Net 30",
- "salesperson": null,
- "delivery_method": "Route: Embarcadero North",
- "delivery_method_id": 6,
- "default_special_instructions": "Deliver to back dock 12"
}, - "sales_channel": null,
- "quote_items": [
- {
- "id": 1,
- "name": "Finished good B",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "20.0",
- "cost": "2.5",
- "sku": "SK0001",
- "created_at": "2024-02-22T18:29:42.541Z",
- "updated_at": "2024-02-22T18:29:42.541Z"
}, - {
- "id": 2,
- "name": "Case of finished good B",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "10.0",
- "cost": "25.0",
- "sku": "SK0002",
- "created_at": "2024-02-22T18:29:42.541Z",
- "updated_at": "2024-02-22T18:29:42.541Z"
}
]
}
{- "id": 14,
- "quote_date": "2020-09-04",
- "expiration_date": "2020-09-04",
- "po_number": "12345",
- "status": "open",
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "quote_number": "QO100",
- "created_at": "2020-09-12T18:25:54.054Z",
- "updated_at": "2020-09-12T18:25:54.054Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": "",
- "line4": "",
- "line5": "",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": "",
- "line5": "",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "salesperson": "",
- "payment_term": "",
- "quote_items": [
- {
- "id": 28,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "10.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T18:25:54.062Z",
- "updated_at": "2020-09-12T18:25:54.062Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "1165.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "purchase_conversion": "1.0",
- "property": "finished_good",
- "sku": "SK0001",
- "pull_strategy": "FEFO",
- "reorder_point": "0.0",
- "lead_time": 0,
- "retired": false,
- "waste_percentage": "0.0",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 29,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "5.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T18:25:54.066Z",
- "updated_at": "2020-09-12T18:25:54.066Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "0.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "purchase_conversion": "1.0",
- "property": "finished_good",
- "sku": "SK0002",
- "pull_strategy": "FIFO",
- "reorder_point": "0.0",
- "lead_time": 0,
- "retired": false,
- "waste_percentage": "0.0",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Creates a new quote for the customer.
customer_id required | integer customer record ID |
id | integer |
quote_date | string |
expiration_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
quote_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "quote_number": "QO100",
- "quote_date": "2020-09-04",
- "expiration_date": "2020-09-04",
- "payment_term_id": null,
- "status": "open",
- "salesperson_id": null,
- "payment_terms": null,
- "delivery_method_id": 1,
- "instructions": null,
- "subtotal": 100,
- "discount": 0,
- "tax": 0,
- "shipping": 0,
- "total": 0,
- "quote_items_attributes": [
- {
- "inventory_id": 4,
- "count": 10,
- "unit_price": 100,
- "override_unit_price": 0
}, - {
- "inventory_id": 6,
- "count": 5,
- "unit_price": 0,
- "override_unit_price": 0
}
]
}
{- "id": 14,
- "quote_date": "2020-09-04",
- "expiration_date": "2020-09-04",
- "po_number": "12345",
- "status": "open",
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "quote_number": "QO100",
- "created_at": "2020-09-12T18:25:54.054Z",
- "updated_at": "2020-09-12T18:25:54.054Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": "",
- "line4": "",
- "line5": "",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": "",
- "line5": "",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "salesperson": "",
- "payment_term": "",
- "quote_items": [
- {
- "id": 28,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "10.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T18:25:54.062Z",
- "updated_at": "2020-09-12T18:25:54.062Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "1165.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "purchase_conversion": "1.0",
- "property": "finished_good",
- "sku": "SK0001",
- "pull_strategy": "FEFO",
- "reorder_point": "0.0",
- "lead_time": 0,
- "retired": false,
- "waste_percentage": "0.0",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 29,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "5.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T18:25:54.066Z",
- "updated_at": "2020-09-12T18:25:54.066Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "0.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "purchase_conversion": "1.0",
- "property": "finished_good",
- "sku": "SK0002",
- "pull_strategy": "FIFO",
- "reorder_point": "0.0",
- "lead_time": 0,
- "retired": false,
- "waste_percentage": "0.0",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Updates an existing quote
quote_id required | integer quote record ID |
customer_id required | integer customer record ID |
id | integer |
quote_date | string |
expiration_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
quote_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 6,
- "quote_date": "2020-09-04",
- "expiration_date": "2020-09-04",
- "status": "draft",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "quote_number": "QO100",
- "created_at": "2020-09-12T16:13:45.549Z",
- "updated_at": "2020-09-12T16:13:45.549Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "payment_terms": "Net 30",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping"
}, - "quote_items": [
- {
- "id": 10,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:13:45.568Z",
- "updated_at": "2020-09-12T16:13:45.568Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "75.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "property": "finished_good",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 11,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T16:13:45.574Z",
- "updated_at": "2020-09-12T16:13:45.574Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "40.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "property": "finished_good",
- "sku": "SK0002",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Retrieves a quote record by ID
quote_id required | integer Example: 1 ID for the quote record |
id | integer |
quote_date | string |
expiration_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
quote_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 1,
- "quote_date": "2020-09-04",
- "expiration_date": "2020-09-04",
- "status": "complete",
- "salesperson_id": null,
- "salesperson_name": null,
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "quote_number": "QO1",
- "payment_term_id": null,
- "created_at": "2020-09-11T13:57:46.842Z",
- "updated_at": "2020-09-12T16:22:26.851Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North"
}, - "delivery_method": {
- "id": 1,
- "name": "UPS Ground",
- "kind": "shipping",
- "instructions": ""
}, - "salesperson": "",
- "payment_term": "",
- "quote_items": [
- {
- "id": 1,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "20.0",
- "cost": "2.5",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:47.050Z",
- "updated_at": "2020-09-11T13:57:47.050Z"
}, - {
- "id": 2,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "10.0",
- "cost": "25.0",
- "sku": "SK0002",
- "created_at": "2020-09-11T13:57:47.050Z",
- "updated_at": "2020-09-11T13:57:47.050Z"
}, - {
- "id": 12,
- "name": "Bulk chocolate",
- "inventory_id": 3,
- "category_name": "Ingredients",
- "count": "0.0",
- "cost": "0.0",
- "sku": null,
- "created_at": "2020-09-12T16:22:26.858Z",
- "updated_at": "2020-09-12T16:22:26.858Z"
}, - {
- "id": 13,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:22:26.863Z",
- "updated_at": "2020-09-12T16:22:26.863Z"
}
]
}
Locates a quote by the quote_number
quote_number | string non-empty Example: quote_number={
"quote_number": "QO1"
} The quote number in Wherefour to locate. All quotes with matching results will be returned. |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | integer |
quote_date | string |
expiration_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
quote_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "quote_number": "QO1"
}
{- "id": 1,
- "quote_date": "2020-09-04",
- "expiration_date": "2020-09-04",
- "status": "invoiced",
- "salesperson_id": null,
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "300.0",
- "discount": "10.0",
- "tax": "0.00",
- "shipping": "25.0",
- "total": "315.0",
- "quote_number": "QO1",
- "payment_term_id": 1,
- "created_at": "2020-07-16T19:49:19.481Z",
- "updated_at": "2020-07-16T19:49:19.481Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-07-16T19:49:19.394Z",
- "updated_at": "2020-07-16T19:49:19.394Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North"
}, - "quote_items": [
- {
- "id": 1,
- "name": "Chocolate bar",
- "category_name": "Products",
- "count": "20.0",
- "cost": "2.5",
- "sku": "SK0001",
- "created_at": "2020-07-16T19:49:19.640Z",
- "updated_at": "2020-07-16T19:49:19.640Z"
}, - {
- "id": 2,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "count": "10.0",
- "cost": "25.0",
- "sku": "SK0002",
- "created_at": "2020-07-16T19:49:19.640Z",
- "updated_at": "2020-07-16T19:49:19.640Z"
}
]
}
Returns a paginated list of all quotes.
updated_at | string Oldest date/time for the records to return |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | integer |
quote_date | string |
expiration_date | string |
status | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
quote_number | string |
created_at | string |
updated_at | string |
object | |
object | |
salesperson | string |
payment_term | string |
{- "id": 6,
- "quote_date": "2020-09-04",
- "expiration_date": "2020-09-04",
- "status": "open",
- "salesperson_id": null,
- "salesperson_name": "",
- "delivery_method_id": 1,
- "instructions": "",
- "subtotal": "100.0",
- "discount": "0.0",
- "tax": "0.0",
- "shipping": "0.0",
- "total": "0.0",
- "quote_number": "QO100",
- "payment_term_id": null,
- "created_at": "2020-09-12T16:13:45.549Z",
- "updated_at": "2020-09-12T16:13:45.549Z",
- "customer": {
- "id": 1,
- "first_name": "",
- "last_name": "",
- "display_name": "Embarcadero Market & Deli",
- "email": "buyer@embarcaderodeli.com",
- "phone": "415-555-6687",
- "mobile": "",
- "fax": "",
- "note": "",
- "kind": "retailer",
- "created_at": "2020-09-11T13:57:46.742Z",
- "updated_at": "2020-09-11T13:57:46.742Z",
- "custom_field_1": "",
- "custom_field_2": "",
- "custom_field_3": "",
- "custom_field_4": "",
- "business_license_number": "",
- "payment_terms": "Net 30",
- "salesperson": "",
- "delivery_method": "Route: Embarcadero North",
- "billing_address": {
- "id": 1,
- "line1": "1142 Main Street",
- "line2": "Suite 100",
- "line3": "",
- "line4": "",
- "line5": "",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "94455",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "line4": "",
- "line5": "",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "country": "",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "quote_items": [
- {
- "id": 10,
- "name": "Chocolate bar",
- "inventory_id": 4,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0001",
- "created_at": "2020-09-12T16:13:45.568Z",
- "updated_at": "2020-09-12T16:13:45.568Z",
- "inventory": {
- "id": 4,
- "name": "Chocolate bar",
- "category_name": "Products",
- "on_hand": "75.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "property": "finished_good",
- "sku": "SK0001",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 11,
- "name": "Chocolate bar, finished case",
- "inventory_id": 6,
- "category_name": "Products",
- "count": "0.0",
- "cost": "0.0",
- "sku": "SK0002",
- "created_at": "2020-09-12T16:13:45.574Z",
- "updated_at": "2020-09-12T16:13:45.574Z",
- "inventory": {
- "id": 6,
- "name": "Chocolate bar, finished case",
- "category_name": "Products",
- "on_hand": "40.0",
- "unit_of_use": "case",
- "unit_of_purchase": "case",
- "property": "finished_good",
- "sku": "SK0002",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Returns a paginated list of all shipments.
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | number |
order_id | number |
customer_id | number |
user_name | string |
ship_date | string |
shipment_number | number |
tracking_number | string |
note | string |
created_at | string |
updated_at | string |
object | |
Array of objects |
{- "id": 1,
- "order_id": 2,
- "customer_id": 1,
- "user_name": "Tony Fiorello",
- "ship_date": "2020-09-12T16:48:00.000Z",
- "shipment_number": 1,
- "created_at": "2020-09-12T16:48:13.512Z",
- "updated_at": "2020-09-12T16:48:13.512Z",
- "shipment_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipment_items": [
- {
- "id": 1,
- "count": "10.0",
- "inventory_name": "Chocolate bar",
- "inventory_sku": "SK0001",
- "auto_ship": [
- {
- "adjustment_id": 25,
- "stock_id": 13,
- "lot_code": "SC-00000",
- "barcode": "CH-000001-18",
- "count": "10.0",
- "change": "-10.0",
- "reason": "shipment"
}
]
}, - {
- "id": 2,
- "count": "40.0",
- "inventory_name": "Chocolate bar, finished case",
- "inventory_sku": "SK0002",
- "auto_ship": [
- {
- "adjustment_id": 26,
- "stock_id": 14,
- "lot_code": "SCC-0000",
- "barcode": "CHCA-000001-18",
- "count": "40.0",
- "change": "-40.0",
- "reason": "shipment"
}
]
}
]
}
Returns a paginated list of shipments for the specified order number.
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | number |
order_id | number |
customer_id | number |
user_name | string |
ship_date | string |
shipment_number | number |
tracking_number | string |
note | string |
created_at | string |
updated_at | string |
object | |
Array of objects |
{- "order_number": "SO1"
}
{- "id": 1,
- "order_id": 2,
- "customer_id": 1,
- "user_name": "Tony Fiorello",
- "ship_date": "2020-09-12T16:48:00.000Z",
- "shipment_number": 1,
- "created_at": "2020-09-12T16:48:13.512Z",
- "updated_at": "2020-09-12T16:48:13.512Z",
- "shipment_address": {
- "id": 2,
- "line1": "415 S. Pine Street",
- "line2": "Suite 210",
- "line3": "Apt. G",
- "city": "Petaluma",
- "country_subdivision_code": "CA",
- "postal_code": "94954",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipment_items": [
- {
- "id": 1,
- "count": "10.0",
- "inventory_name": "Chocolate bar",
- "inventory_sku": "SK0001",
- "auto_ship": [
- {
- "adjustment_id": 25,
- "stock_id": 13,
- "lot_code": "SC-00000",
- "barcode": "CH-000001-18",
- "count": "10.0",
- "change": "-10.0",
- "reason": "shipment"
}
]
}, - {
- "id": 2,
- "count": "40.0",
- "inventory_name": "Chocolate bar, finished case",
- "inventory_sku": "SK0002",
- "auto_ship": [
- {
- "adjustment_id": 26,
- "stock_id": 14,
- "lot_code": "SCC-0000",
- "barcode": "CHCA-000001-18",
- "count": "40.0",
- "change": "-40.0",
- "reason": "shipment"
}
]
}
]
}
Returns a paginated list of purchase orders.
updated_at | string Oldest date/time for the records returned. |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | number |
purchase_date | string |
purchase_number | string |
status | string |
deliver_by_date | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
created_at | string |
updated_at | string |
object | |
object | |
object | |
object | |
object | |
Array of objects |
{- "id": 1,
- "purchase_date": "2020-09-11",
- "purchase_number": "PO1",
- "status": "draft",
- "subtotal": "424.4875",
- "total": "424.49",
- "created_at": "2020-09-11T13:57:46.783Z",
- "updated_at": "2020-09-11T13:57:46.783Z",
- "vendor": {
- "id": 1,
- "first_name": "Joe",
- "last_name": "Sample",
- "display_name": "Pacific Foods Co.",
- "email": "jsample@pacificfoods.com",
- "phone": "415-555-6758",
- "kind": "distributor",
- "created_at": "2020-09-11T13:57:47.005Z",
- "updated_at": "2020-09-11T13:57:47.005Z",
- "billing_address": {
- "id": 39,
- "line1": "144 S. Broadway",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "postal_code": "95440",
- "country": "USA",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}, - "shipping_address": {
- "id": 40,
- "line1": "144 S. Broadway",
- "city": "San Francisco",
- "country_subdivision_code": "CA",
- "country": "USA",
- "created_at": "2020-09-11T13:57:46.802Z",
- "updated_at": "2020-09-11T13:57:46.802Z"
}
}, - "delivery_method": {
- "id": 3,
- "name": "Pickup",
- "kind": "shipping"
}, - "payment_term": {
- "id": 3,
- "name": "Net 15",
- "net": 15
}, - "purchase_items": [
- {
- "id": 2,
- "name": "Whole milk",
- "category_name": "Ingredients",
- "count": "58.75",
- "cost": "2.97",
- "created_at": "2020-09-11T13:57:46.836Z",
- "updated_at": "2020-09-11T13:57:46.836Z",
- "inventory": {
- "id": 1,
- "name": "Whole milk",
- "category_name": "Ingredients",
- "on_hand": "1410.0",
- "unit_of_use": "gallon",
- "unit_of_purchase": "gallon",
- "property": "raw_material",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}, - {
- "id": 1,
- "name": "Case box",
- "category_name": "Packaging",
- "count": "1000.0",
- "cost": "0.25",
- "created_at": "2020-09-11T13:57:46.836Z",
- "updated_at": "2020-09-11T13:57:46.836Z",
- "inventory": {
- "id": 7,
- "name": "Case box",
- "category_name": "Packaging",
- "on_hand": "400.0",
- "unit_of_use": "each",
- "unit_of_purchase": "each",
- "property": "raw_material",
- "created_at": "2020-09-11T13:57:46.825Z",
- "updated_at": "2020-09-11T13:57:46.825Z"
}
}
]
}
Searches for a purchase order based on the purchase order number provided. Multiple matches may be returned.
purchase_number | string PO number to search for |
page | integer Results page to view |
Total | integer Total count of results |
Per-Page | integer Number of results per page |
Link | string URLs for the next or previous pages of the results |
id | number |
purchase_date | string |
purchase_number | string |
status | string |
deliver_by_date | string |
instructions | string |
subtotal | string |
discount | string |
tax | string |
shipping | string |
total | string |
created_at | string |
updated_at | string |