Connector name:
ShipHero

Table name:
product

Column to add:
vendors — containing the vendor_id and vendor_sku values from Product.vendors

API documentation link:
ShipHero GraphQL API documentation — Product.vendors / ProductVendor
https://developer.shiphero.com/schema/types/product-vendor.html

Additional details:
Product.vendors is a one-to-many relationship, so a product can have multiple vendors. We would like the complete Product.vendors relationship to be synced into the existing product table rather than creating a separate table.

The ProductVendor object contains:

• vendor_id

• vendor_sku

We have confirmed this field is populated in ShipHero using live API queries. For example, SKU JSJS16002-OS returns two separate vendor entries, so the implementation should preserve multiple vendor records per product and not reduce the relationship to a single vendor_id.

We already have a separate vendor table synced, so we only need the vendor relationship fields from Product.vendors.

This data is important because our current vendor information comes primarily from purchase_order_line_item, which only provides vendor coverage for products that have appeared on purchase orders. Product.vendors provides the direct vendor assignment at the product level, including products with no purchase order history.

Thank you

Best Regards
Vishal