Business or Fresh Reports Are Missing From the Destination

Issue

The BUSINESS or FRESH report tables are included in the connection schema in the Fivetran dashboard, but they are not syncing to the destination.

Environment

Connector: Amazon Selling Partner

Resolution

To resolve this issue:

1. Contact Amazon Vendor Central support or your Amazon account representative. Ask them to confirm that the vendor account is enrolled in the corresponding Amazon Business or Amazon Fresh program for the affected marketplace and has access to its reports.

2. If the account isn’t enrolled or doesn’t have report access, work with Amazon to obtain the required enrollment and access.

3. After Amazon confirms access, re-authorize the connection in Fivetran:

   i. Go to your Amazon Selling Partner connection page.

   ii. Select the Settings tab.

   iii. Click Edit connection.

   iv. Click Re-Authorize Connection.

Cause

This issue occurs when your Amazon Vendor account is not enrolled in the selling program required by the report. For example:

• BUSINESS reports require enrollment in the Amazon Business program for the applicable marketplace.
• FRESH reports require enrollment in the Amazon Fresh program for the applicable marketplace.

If your account only supports RETAIL, Amazon rejects report requests that use sellingProgram=BUSINESS or sellingProgram=FRESH.