Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Amazon Selling Partner (Vendor Account option) - Catalog module is missing.

Answered
SUCHETA SARKAR User

Amazon Selling Partner (Vendor  Account option) - Catalog module is missing. 

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Sandeep Preetam Saila Fivetranner

    Hi Sucheta

    Could you try mapping the CATALOG table with the ITEM_VENDOR_DETAILS table using the asin key for the above purpose?

    I'd be happy to help with any other queries you might have.

    Regards
    Sandeep
    Technical Product Owner

  • SUCHETA SARKAR User

    Hi Sandeep,

    How do we get ITEM_VENDOR_DETAILS table? We don't see CATALOG table or ITEM_VENDOR_DETAILS  table in our environment. We see table vendor_retail_procurement_order_item but it doesn't have any catalog metadata like brand, category etc.

    Thanks.

     

  • SUCHETA SARKAR User
    • Edited

    Sandeep,

    To add more details to this discussion, our goal is to ingest the data from Amazon Vendor Central to GCP using Fivetran. If the catalog meta data like brand, category, product title etc. were part of the original reporting tables, then we don't need a separate catalog module. Alternatively, we receive the catalog module and do a look up using the ASIN key as you mentioned earlier.

    Please note that these are just three reports shown below, we would like to ingest all the data / reports from Amazon Vendor Central to GCP using Fivetran.

    1. Top Search Terms from Amazon Vendor Central

    Top search terms using Fivetran

    2. Market Basket Analysis from Amazon Vendor Central

    Market Basket Analysis using Fivetran

    3. Repeat Purchase Behavior from Amazon Vendor Central

    Repeat Purchase Behavior using Fivetran

    1.