Hi,

I run a product importing company and need help designing our database.

I’ve built a rough airtables database but I know it can be so much better. I’m looking for somebody to:

1. Briefly understand our business and the workflow



2. Look at the current airtable database



3. Make suggestions to a redesign and/or features we aren’t using



4. Execute on the redesign to the extent it takes any special skill

Here’s a rough idea of the business:


-We’ll have 50-100 orders (POs)


-About 12 factories


-Each shipment has lots of documentation that can be uploaded (PO, Bill of Lading, Packing List, Invoice, Shipping invoice)


-Each shipment has a lot of information that can be extracted (value, type of goods, duty code, cost of shipping, ports etc. )


-We’ve been using it to track the status of each shipment (ordered, ready to ship, booked, on the water, delivered, etc). There might be some integration available with shipping data using the ship number or HBL, but that might be an overkill. Manual updating is probably fine.

After we get this set up I’ll look to have my employees, shipping company and maybe even factories keep this updated going forward.

Scott