Gzavnili (USA -> Georgia forwarder) database.
Good day, I have dumped the database of Gzavnili, including:
1. Staging DB (has both test details and some real customer details)
2. Production DB.
Both are dumped recently, so all the customer information is still up-to-date.
PRICES:
$3500 - Stage + Prod DB
$1000 - Source Code of Gzavnili's Client API, Dashboard, Main API, Office API (LATEST)
Contact me: Session 052f9d76ad9b3db444bd870ebab67723ba6f90b684cd41de778be6f90c8c8d363e
$1000 - Source Code of Gzavnili's Client API, Dashboard, Main API, Office API (LATEST)
Contact me: Session 052f9d76ad9b3db444bd870ebab67723ba6f90b684cd41de778be6f90c8c8d363e
SAMPLES:
[customers.json]
[font=Consolas, 'Courier New', monospace]{
"id": "d8dabc92-74c0-4da2-8ef0-0a020887d87d",
"first_name": "Gocha",
"last_name": "Gochashvili",
"room_number": "Z96703",
"first_name_ka": "გოჩა",
"last_name_ka": "გოჩაშვილი",
"email": "gocha.gochashvili.1@btu.edu.ge",
"phone": "595302690",
"company_info": "",
"company_id": "",
"verified": true,
"isNotResident": false,
"status": "ACTIVE",
"user_id": "39d4e9d8-b931-4ad9-8ff9-580065d49f70",
"repackaging": true,
"insurance": true,
"marketing_permissions": true,
"registered": "gocha.gochashvili.1@btu.edu.ge",
"promotion": null,
"promotionChinaLand": null,
"promotionChinaAir": null,
"id_number": "59004005604",
"customerType": "PERSONAL",
"payCustomsInsteadOfMe": false,
"createdAt": "2026-08-25T19:58:52.051Z",
"updatedAt": "2026-08-25T19:59:25.038Z",
"orders": [],
"customerAddresses": [
{
"id": "37ef964b-1b12-4c0c-abf1-e85022bfed0b",
"address": "38 Ilia Chavchavadze St, T'bilisi, Georgia",
"tag": "home",
"title": "სახლი",
"city": "T'bilisi",
"additionalInstructions": "",
"lang": "44.90373109947968",
"lat": "41.710102340713",
"isDefault": true,
"status": "INACTIVE",
"customer_id": "d8dabc92-74c0-4da2-8ef0-0a020887d87d",
"created_at": "2026-08-25T20:04:51.846Z",
"modified_at": "2026-08-25T20:04:51.846Z"
}
]
},[/font]orders.json
[font=Consolas, 'Courier New', monospace]{
"id": "6055a295-bf45-4694-8e7d-95bca4cf6137",
"name": "Order 29",
"tracking_number": "TBA333969487737",
"tracking_number_2": null,
"room_number": "Z56204",
"weight_before": null,
"width_before": null,
"height_before": null,
"len_before": null,
"volume_before": null,
"weight": "0.60",
"width": null,
"height": null,
"len": null,
"volume": null,
"content": null,
"additional_identifier": null,
"price": null,
"price_gz": null,
"status": "RECEIVED IN US WAREHOUSE",
"timeSlot": null,
"order_date": null,
"additional_details_id": null,
"customer_id": "e1e19e33-1820-4f7c-aeb1-6e0729ca2222",
"branch_id": "1ad52c30-2978-4fe0-9db4-ecbba1e04365",
"box_id": null,
"signify_id": null,
"shelf_id": null,
"quickshipper_id": null,
"pallet_id": "c732f4f6-87b5-42ff-b9c2-645d147d4e96",
"address_id": null,
"custom_fee_id": null,
"wrapping": true,
"payed": null,
"inventarization": null,
"changedBy": null,
"declaration_status": "DECLERED",
"tracking_status": null,
"custom_status": "0",
"delivery_status": null,
"pay_status": null,
"vatPaymentAuto": null,
"vat_amount": null,
"declaration_id_for_vat": null,
"vat_payment_status": null,
"DeclarationPaymentAuto": null,
"NeedsCustom": null,
"vat": null,
"nusxa": null,
"do_not_ring_bell": null,
"leave_by_door": null,
"createdAt": "2026-08-25T20:22:09.838Z",
"updatedAt": "2026-08-25T20:27:50.159Z",
"customer": {
"id": "e1e19e33-1820-4f7c-aeb1-6e0729ca2222",
"first_name": "Davit",
"last_name": "Kurdadze",
"room_number": "Z56204",
"first_name_ka": "დავით",
"last_name_ka": "ქურდაძე",
"email": "Davitkurdadze@gmail.com",
"phone": "557948848",
"company_info": "",
"company_id": "",
"verified": true,
"isNotResident": false,
"status": "ACTIVE",
"user_id": "1e58a717-4a20-42c2-a85c-bb24a131ba35",
"repackaging": true,
"insurance": true,
"marketing_permissions": false,
"registered": "Davitkurdadze@gmail.com",
"promotion": null,
"promotionChinaLand": null,
"promotionChinaAir": null,
"id_number": "35001121425",
"customerType": "PERSONAL",
"payCustomsInsteadOfMe": false,
"createdAt": "2024-05-31T22:00:26.090Z",
"updatedAt": "2024-05-31T22:00:50.778Z"
},
"box": null,
"pallet": {
"id": "c732f4f6-87b5-42ff-b9c2-645d147d4e96",
"name": null,
"tracking": "PALLET 8.21.2026",
"status": "SHIPPED",
"airwaybill_id": "842a9f49-356f-4ec1-8e1c-5ce4ae67989a",
"created_at": "2026-08-19T20:39:27.355Z",
"modified_at": "2026-08-21T19:35:00.604Z"
},
"shelf": null,
"images": [],
"orderHistory": [
{
"id": "08ca1638-ea69-4305-b800-6abccde1532d",
"adminId": "780e42a7-cd45-471e-a57c-92616ffe7501",
"action": "Created",
"method": "Patch",
"comment": null,
"body": {
"box_id": "79483fb7-532a-4839-a242-baac86842699",
"status": "RECEIVED IN US WAREHOUSE",
"weight": "0.6",
"wrapping": true,
"branch_id": "1ad52c30-2978-4fe0-9db4-ecbba1e04365",
"room_number": "Z56204",
"tracking_number": "TBA333969487737"
},
"createdAt": "2026-08-25T20:22:10.173Z",
"order_id": "6055a295-bf45-4694-8e7d-95bca4cf6137",
"admin": {
"id": "780e42a7-cd45-471e-a57c-92616ffe7501",
"first_name": "Toma",
"last_name": "Mchedlishvili",
"email": "tmchedlishvili@gzavnili.com",
"location": "USA",
"role": "Admin",
"isAdmin": null,
"password": "$2a$10$UmHV87VnvBi1nPkr1QBpGu3.uJVS8.dC5Fgri.ljpim49mS7aX6Ha"
}
},
{
"id": "e06f7484-cfd8-491b-be9b-356e643f420c",
"adminId": null,
"action": "Order Updated by Customer",
"method": "PUT",
"comment": "",
"body": {
"declaration_status": "DECLERED"
},
"createdAt": "2026-08-25T20:27:50.163Z",
"order_id": "6055a295-bf45-4694-8e7d-95bca4cf6137",
"admin": null
},
{
"id": "aa3cbe50-03ab-4859-8821-d4fd758136dc",
"adminId": "780e42a7-cd45-471e-a57c-92616ffe7501",
"action": "Added In Pallet",
"method": "Patch",
"comment": null,
"body": {
"pallet_tracking": "PALLET 8.21.2026"
},
"createdAt": "2026-08-25T20:22:15.832Z",
"order_id": "6055a295-bf45-4694-8e7d-95bca4cf6137",
"admin": {
"id": "780e42a7-cd45-471e-a57c-92616ffe7501",
"first_name": "Toma",
"last_name": "Mchedlishvili",
"email": "tmchedlishvili@gzavnili.com",
"location": "USA",
"role": "Admin",
"isAdmin": null,
"password": "$2a$10$UmHV87VnvBi1nPkr1QBpGu3.uJVS8.dC5Fgri.ljpim49mS7aX6Ha"
}
}
],
"declaration": [
{
"id": "3796c6fb-f51e-4004-b2f6-23da12e13ece",
"website": "amazon.com",
"category": "სხვა მზა ნაწარმი",
"price": "14.99",
"order_id": "6055a295-bf45-4694-8e7d-95bca4cf6137",
"status": "Declared",
"currency": "USD"
}
],
"declarationFiles": [],
"payments": [],
"branch": {
"id": "1ad52c30-2978-4fe0-9db4-ecbba1e04365",
"name": "USA",
"address": "USA",
"postalCode": "0102",
"city": "New York",
"state": "New York",
"phone": "555-222-222",
"status": "OPEN",
"country": {
"id": "14dc5644-9c9f-4532-88de-adfbdf4463e8",
"name": "Test Country",
"currency": [
"USD"
],
"price": "8.9",
"status": "ACTIVE"
}
},
"signify": null,
"customer_address": null,
"quickshipper": null,
"orderDetail": null
},[/font]
SRC code:
Office api:
Office api:
├───admin
│ ├───dto
│ └───enums
├───adresses
│ ├───dto
│ └───enums
├───airway-bill
│ ├───dto
│ └───enums
├───boxes
│ ├───dto
│ └───enums
├───branches
│ ├───dto
│ └───enums
├───common
│ ├───config
│ ├───decorators
│ ├───enums
│ ├───guards
│ ├───logging
│ ├───shared
│ └───utilities
├───content_management
│ ├───dto
│ └───entities
├───content_management_images
│ ├───dto
│ └───entities
├───countries
│ ├───dto
│ └───enums
├───customer-address
│ └───enums
├───customers
│ ├───decorators
│ ├───dto
│ └───enums
├───custom_fee
│ ├───dto
│ └───entities
├───declaration
│ ├───dto
│ └───enums
├───declaration_files
│ ├───dto
│ └───enums
├───district
│ ├───dto
│ └───entities
├───exchange-rate
│ ├───dto
│ └───entities
├───health
├───images
│ └───dto
├───migrations
├───notifications
│ ├───dto
│ └───entities
├───order-details
│ ├───dto
│ └───entities
├───order-history
│ └───dto
├───orders
│ ├───dto
│ └───enums
├───pallets
│ ├───dto
│ └───enum
├───payments
│ ├───dto
│ └───enums
├───prices
│ └───dto
├───quickshipper
│ ├───dto
│ ├───entities
│ └───enums
├───room_numbers
│ └───dto
├───rs
│ ├───dto
│ └───entities
├───s3
├───shelf
│ ├───dto
│ └───enum
├───shops
│ ├───dto
│ └───entities
├───signify
│ └───dto
├───time-slots
│ ├───dto
│ └───entities
└───user-logs
└───dto