Schema Information of Shiprocket V2
This subtopic provides a structured reference to assist you in working with Daton's Shiprocket v2 connector and the associated fields and tables.
Schema Information of Shiprocket V2
This subtopic provides a structured reference to assist you in working with Daton's Shiprocket v2 connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Shiprocket v2 connector:
- Orders
- Listings
- NDR
- Products
- Inventory_Details
Orders
Retrieves the list of all created and available orders in the Shiprocket account. The product and shipment details are displayed as sub-arrays within each order detail. For more information on the API, see Shiprocket - Orders.
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Field Name |
Data Type |
|---|---|
id |
NUMERIC |
channel_name |
STRING |
base_channel_code |
STRING |
channel_order_id |
STRING |
customer_name |
STRING |
customer_email |
STRING |
customer_phone |
STRING |
customer_address |
STRING |
customer_address_2 |
STRING |
customer_city |
STRING |
customer_state |
STRING |
customer_pincode |
STRING |
customer_country |
STRING |
customer_alternate_phone |
STRING |
pickup_location |
STRING |
order_type |
NUMERIC |
payment_status |
STRING |
total |
STRING |
tax |
STRING |
sla |
STRING |
shipping_method |
STRING |
expedited |
NUMERIC |
status |
STRING |
status_code |
NUMERIC |
master_status |
STRING |
payment_method |
STRING |
change_payment_mode |
BOOLEAN |
is_international |
NUMERIC |
purpose_of_shipment |
NUMERIC |
channel_created_at |
STRING |
created_at |
STRING |
updated_at |
STRING |
updated_on |
STRING |
pickup_boy_name |
STRING |
pickup_boy_contact_no |
STRING |
products |
RECORD |
shipments |
RECORD |
cod |
NUMERIC |
activities |
STRING |
allow_return |
NUMERIC |
is_incomplete |
NUMERIC |
pickup_exception_reason |
STRING |
rto_prediction |
STRING |
show_escalation_btn |
NUMERIC |
escalation_status |
STRING |
pii_removed |
NUMERIC |
allow_multiship |
BOOLEAN |
others |
RECORD |
Listings
Retrieves the list of all the product listings in your Shiprocket account, that is, all the products associated with a specific channel. For more information on the API, see Shiprocket - Listings.
Replication: Full Replication
Replication Key: NA
Fields
Field Name |
Data Type |
|---|---|
id |
NUMERIC |
title |
STRING |
image |
STRING |
price |
STRING |
quantity |
NUMERIC |
sku |
STRING |
channel_sku |
STRING |
channel_id |
NUMERIC |
channel_name |
STRING |
base_channel_code |
STRING |
channel_product_id |
STRING |
inventory |
NUMERIC |
synced_on |
STRING |
product |
RECORD |
category_name |
STRING |
hsn_code |
DATE |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
NDR
Retrieve information and manage shipments that are in Non-Delivery Report (NDR) status in your Shiprocket account. For more information on the API, see Shiprocket - NDR.
Replication: Full Replication
Replication Key: NA
Fields
Field Name |
Data Type |
|---|---|
id |
NUMERIC |
shipment_id |
NUMERIC |
channel_order_id |
STRING |
channel_name |
STRING |
customer_name |
STRING |
customer_email |
STRING |
customer_phone |
STRING |
customer_address |
STRING |
customer_address_2 |
STRING |
customer_city |
STRING |
customer_state |
STRING |
customer_pincode |
STRING |
payment_status |
STRING |
status |
STRING |
status_code |
NUMERIC |
payment_method |
STRING |
created_at |
STRING |
reason |
STRING |
attempts |
NUMERIC |
ndr_raised_at |
DATETIME |
courier |
STRING |
awb_code |
STRING |
channel_sku |
STRING |
master_sku |
STRING |
product_qty |
STRING |
escalation_status |
STRING |
product_name |
STRING |
product_price |
STRING |
shipment_channel_id |
NUMERIC |
history |
RECORD |
delivered_date |
STRING |
cancellation_reason |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Products
Retrieves a list of all the products in your Shiprocket account. For more information on the API, see Shiprocket - Products.
Replication: Full Replication
Replication Key: NA
Fields
Field Name |
Data Type |
|---|---|
id |
NUMERIC |
sku |
STRING |
hsn |
STRING |
name |
STRING |
description |
STRING |
category_code |
STRING |
category_name |
STRING |
category_tax_code |
STRING |
image |
STRING |
weight |
STRING |
size |
STRING |
cost_price |
STRING |
mrp |
STRING |
tax_code |
NUMERIC |
low_stock |
NUMERIC |
ean |
STRING |
upc |
STRING |
isbn |
STRING |
created_at |
STRING |
updated_at |
STRING |
quantity |
NUMERIC |
color |
STRING |
brand |
STRING |
dimensions |
STRING |
status |
STRING |
type |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
Inventory_Details
Check the inventory details of a product. This API has no required parameters, but further parameters can be defined to sort and filter the data. For more information on the API, see Shiprocket - Inventory_Details.
Replication: Full Replication
Replication Key: NA
Fields
Field Name |
Data Type |
|---|---|
id |
NUMERIC |
total_quantity |
NUMERIC |
available_quantity |
NUMERIC |
blocked_quantity |
NUMERIC |
category_name |
STRING |
updated_on |
STRING |
sku |
STRING |
is_combo |
NUMERIC |
name |
STRING |
type |
STRING |
color |
STRING |
brand |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
