Link to live app: https://stock-em.vercel.app/
Link to API Repo: https://github.com/juliawithers/stock-em-api
Stock'Em! is an app specifically for tracking inventory coming into and out of a business. Add SKUs, Customers, and Suppliers. Edit your customer and supplier information as necessary. Submit Customer and Supplier PO's. Inventory will automatically be updated from these PO's. View all past orders, whether for a customer or a supplier.
Things to do with this app:
- View Current Inventory
- View Current Customers
- View Current Suppliers
- View Current Order History - this shows both customer and supplier orders
- Add and Edit Customers
- Add and Edit Suppliers
- Add SKUs
- Enter Customer Orders
- Enter Supplier Orders
Landing Page
Inventory
Suppliers
Customers
Order History
Add & Edit Customers
Add & Edit Suppliers
Add SKUs
Customer Order
Supplier Order
React, HTML, Javascript, CSS, NodeJs, PostgreSQL
Please see the endpoints and schemas below:
Github for API: https://github.com/juliawithers/stock-em-api
`https://stock-em-api.herokuapp.com/api/stock-em`
/inventory
/suppliers
/customers
/past_orders
/skus
GET: request query:
`https://stock-em-api.herokuapp.com/api/stock-em/inventory/?user_id=${user_id}`
returns:
[{
"id": 1,
"sku": 1234,
"quantity": 25,
"inv_description": "capacitor",
"inv_location": "M01",
"date_entered": "2020-5-5"
},...]
POST:
body:
{
"sku": 1234,
"quantity": 25,
"inv_description": "capacitor",
"inv_location": "M01",
"date_entered": "2020-5-5"
}
returns:
{
"id": "newid",
"sku": 1234,
"quantity": 25,
"inv_description": "capacitor",
"inv_location": "M01",
"date_entered": "2020-5-5"
}
DELETE:
body:
{
"id": the inventory id
}
returns:
{
"id": deleted id
}
GET:
query params:
`https://stock-em-api.herokuapp.com/api/stock-em/suppliers/?user_id=${user_id}`
returns:
[
{
"id": 1,
"company": "Company 1",
"contact": "John Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"sup_address": "1234 Main St., Nowhere USA"
},...
]
POST:
body:
{
"company": "Company 1",
"contact": "John Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"sup_address": "1234 Main St., Nowhere USA"
}
returns:
{
"id": new id,
"company": "Company 1",
"contact": "John Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"sup_address": "1234 Main St., Nowhere USA"
}
PATCH:
body:
{
"id": id,
"company": "UPDATED COMPANY",
"contact": "John Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"sup_address": "1234 Main St., Nowhere USA"
}
returns:
{
"id": id,
"company": "UPDATED COMPANY",
"contact": "John Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"sup_address": "1234 Main St., Nowhere USA"
}
GET:
query params:
`https://stock-em-api.herokuapp.com/api/stock-em/customers/?user_id=${user_id}`
returns:
[
{
"id": 1,
"company": "Company 1",
"contact": "Jane Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"bill_address": "1234 Main St., Nowhere USA",
"ship_address": "1234 Main St., Nowhere USA"
},...
]
POST :
body:
{
"company": "Company 1",
"contact": "Jane Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"bill_address": "1234 Main St., Nowhere USA",
"ship_address": "1234 Main St., Nowhere USA"
}
returns:
{
"id": new id,
"company": "Company 1",
"contact": "Jane Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"bill_address": "1234 Main St., Nowhere USA",
"ship_address": "1234 Main St., Nowhere USA"
}
PATCH:
body:
{
"id": 1,
"company": "UPDATED CUSTOMER COMPANY",
"contact": "Jane Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"bill_address": "1234 Main St., Nowhere USA",
"ship_address": "1234 Main St., Nowhere USA"
}
returns:
{
"id": 1,
"company": "UPDATED CUSTOMER COMPANY",
"contact": "Jane Doe",
"phone": "111-111-1112",
"email": "[email protected]",
"bill_address": "1234 Main St., Nowhere USA",
"ship_address": "1234 Main St., Nowhere USA"
}
GET:
query params:
`https://stock-em-api.herokuapp.com/api/stock-em/past-orders/?user_id=${user_id}`
returns:
[
{
"id": 1,
"company":"Some Company",
"sku": 1234,
"quantity": 100,
"inv_description": "capacitor",
"cust_order": "PO123",
"sup_order": "",
"date_entered": "2020-1-1"
},...
]
POST:
body:
{
"company":"Some Company",
"sku": 1234,
"quantity": 100,
"inv_description": "capacitor",
"cust_order": "PO123",
"sup_order": "",
"date_entered": "2020-1-1"
}
returns:
{
"id": new id,
"company":"Some Company",
"sku": 1234,
"quantity": 100,
"inv_description": "capacitor",
"cust_order": "PO123",
"sup_order": "",
"date_entered": "2020-1-1"
}
GET:
query params:
`https://stock-em-api.herokuapp.com/api/stock-em/skus/?user_id=${user_id}`
returns:
[
{
"id": 1,
"sku": 1234,
"inv_description": "capacitor",
"date_entered": "2020-5-5"
},...
]
POST:
body:
{
"sku": 1234,
"inv_description": "capacitor",
"date_entered": "2020-5-5"
}
returns:
{
"id": new id,
"sku": 1234,
"inv_description": "capacitor",
"date_entered": "2020-5-5"
},