Amazon Vendor Central API Connector

Amazon Vendor API integrates vendor systems with Amazon, streamlining inventory, sales, and operational insights for efficient supply chain management

4.8 on G2

Weld · Data Sources

Amazon Vendor Central API

Amazon Vendor Central APIYour warehouseLive

vendor_purchase_order72 columnsSynced

purchase_order_status33 columnsSynced

vendor_inventory_consignment_retail_report28 columnsSynced

vendor_inventory_manufacturing_retail_report28 columnsSyncing

vendor_inventory_sourcing_retail_report28 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Amazon Vendor Central API

Amazon Vendor Central API

Data source

Authenticating...

Ready to connect

Overview

Amazon Vendor Central API in your warehouse.
Ready for your agents.

Amazon Vendor API integrates vendor systems with Amazon, streamlining inventory, sales, and operational insights for efficient supply chain management Weld's Amazon Vendor Central API connector is fully managed: it extracts data from Amazon Vendor Central API, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.

Agent context

Amazon Vendor Central API data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Amazon Vendor Central API is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 32
fields: 468

Loading diagram…

purchase_order_status

vendor_purchase_order

catalog_item_summary

browse_classification_display_name

browse_classification_classification_id

item_classification

catalog_item_classification

classification_id

catalog_item_dimension

item_height_unit

item_height_value

item_length_unit

item_length_value

item_weight_unit

item_weight_value

catalog_item_identifier

identifier_type

catalog_item_image

catalog_item_product_type

catalog_item_relationship

variation_theme

catalog_item_sales_rank_classification

classification_id

catalog_item_sales_rank_display_group_ranks

website_display_group

catalog_item_vendor_details

manufacturer_code

manufacturer_code_parent

product_category_display_name

product_category_value

product_subcategory_display_name

product_subcategory_value

replenishment_category

purchase_order_status

purchase_order_number

purchase_order_status

purchase_order_date

last_updated_date

selling_party_party_id

selling_party_address_name

selling_party_address_address_line_1

selling_party_address_address_line_2

purchase_order_status_item

purchase_order_number

item_sequence_number

buyer_product_identifier

vendor_product_identifier

net_cost_currency_code

net_cost_amount

net_cost_unit_of_measure

list_price_currency_code

purchase_order_status_item_ordered_quantity_detail

purchase_order_number

item_sequence_number

ordered_quantity_amount

ordered_quantity_unit_of_measure

ordered_quantity_unit_size

cancelled_quantity_amount

cancelled_quantity_unit_of_measure

cancelled_quantity_unit_size

purchase_order_status_item_acknowledgement_status_detail

purchase_order_number

item_sequence_number

acknowledgement_date

accepted_quantity_amount

accepted_quantity_unit_of_measure

accepted_quantity_unit_size

rejected_quantity_amount

rejected_quantity_unit_of_measure

rejected_quantity_unit_size

vendor_purchase_order

purchase_order_number

purchase_order_state

order_details_purchase_order_date

order_details_purchase_order_changed_date

order_details_purchase_order_state_changed_date

order_details_purchase_order_type

order_details_import_details_method_of_payment

order_details_import_details_international_commercial_terms

vendor_purchase_order_item

purchase_order_number

item_sequence_number

amazon_product_identifier

vendor_product_identifier

ordered_quantity_amount

ordered_quantity_unit_of_measure

ordered_quantity_unit_size

is_back_order_allowed

vendor_forecasting_report

forecast_generation_date

mean_forecast_units

p_70_forecast_units

p_80_forecast_units

p_90_forecast_units

vendor_inventory_consignment_retail_report

sourceable_product_out_of_stock_rate

procurable_product_out_of_stock_rate

open_purchase_order_units

receive_fill_rate

vendor_inventory_manufacturing_retail_report

sourceable_product_out_of_stock_rate

procurable_product_out_of_stock_rate

open_purchase_order_units

receive_fill_rate

vendor_inventory_sourcing_retail_report

sourceable_product_out_of_stock_rate

procurable_product_out_of_stock_rate

open_purchase_order_units

receive_fill_rate

vendor_net_pure_product_margin_report

net_pure_product_margin

vendor_real_time_inventory_report

highly_available_inventory

vendor_real_time_sales_report

ordered_revenue

vendor_real_time_traffic_report

vendor_sales_consignment_business_report

customer_returns

shipped_cogs_amount

shipped_cogs_currency_code

shipped_revenue_amount

shipped_revenue_currency_code

vendor_sales_consignment_retail_report

customer_returns

shipped_cogs_amount

shipped_cogs_currency_code

shipped_revenue_amount

shipped_revenue_currency_code

vendor_sales_manufacturing_business_report

customer_returns

shipped_cogs_amount

shipped_cogs_currency_code

shipped_revenue_amount

shipped_revenue_currency_code

vendor_sales_manufacturing_retail_report

customer_returns

shipped_cogs_amount

shipped_cogs_currency_code

shipped_revenue_amount

shipped_revenue_currency_code

vendor_sales_sourcing_business_report

customer_returns

shipped_cogs_amount

shipped_cogs_currency_code

shipped_revenue_amount

shipped_revenue_currency_code

vendor_sales_sourcing_retail_report

customer_returns

shipped_cogs_amount

shipped_cogs_currency_code

shipped_revenue_amount

shipped_revenue_currency_code

vendor_traffic_report

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows Amazon Vendor Central API.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Amazon Vendor Central API context, finds the tables it needs and queries your warehouse.

Agent contextAmazon Vendor Central API tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextAmazon Vendor Central APItables32fields468

>

How many vendor_purchase_order rows do we have in our Amazon Vendor Central API data?

Reading the Amazon Vendor Central API context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.amazon_vendor_central.vendor_purchase_order

+ 31 more Amazon Vendor Central API tables

●weld·get_reference_schema

⎿vendor_purchase_order · 72 columns

purchase_order_number, purchase_order_state

●weld·run_query

⎿select count(*) from {{raw.amazon_vendor_central.vendor_purchase_order}}

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Amazon Vendor Central API data in your warehouse

>Ask about your Amazon Vendor Central API dataMCP

Destinations

Load Amazon Vendor Central API into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Amazon Vendor Central API connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Amazon Vendor Central API ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "amazon-vendor-central",
    "destination_schema_name": "amazon-vendor-central_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Put your Amazon Vendor Central API data to work.

Connect Amazon Vendor Central API, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Amazon Vendor Central API

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors