# March

## <mark style="color:yellow;">Connector</mark> <mark style="color:yellow;">Enhancements</mark>

#### <mark style="color:green;">Amazon MWS Connector</mark>

1. Follow the Generic Guidelines while creating integrations. These will help with reducing delays while processing the data.\
   \&#xNAN;*The documentation for the Generic Guidelines for configuring the connector can be found* [*here*](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/amazon-mws#general-guidelines-for-configuring-amazon-mws-on-daton)*.*&#x20;

2. **Datatype Changes in Reports:**\
   Following is the list of corrections required in the existing integrations:\
   \
   \&#xNAN;***NOTE:***\
   *Edit the existing integrations to drop the tables first and then add them back. This is required to be done **only if these changes are required.***\
   \&#xNAN;*You can leave the existing integrations as is **if these changes are not required.***\
   \
   **Datatype Changes:**

   * **`ActiveListingsReport`** - `open_date`(string to datetime), `item_condition`(numeric to String), `Quantity_Lower_Bound_1,2,3,4,5`(String to Numeric)&#x20;
   * **`AllListingsReport`** - `open_date`(string to datetime), `item_condition`(numeric to String), `pending_quantity`(string to Integer), `maximum_retail_price`(string to Numeric)&#x20;
   * **`InactiveListingsReport`** - `open_date`(string to DateTime), `item_condition`(numeric to String)&#x20;
   * **`FBAStrandedInventoryReport`** - `date_stranded`(string to datetime), `date_classified_as_unsellable`(string to datetime)&#x20;
   * **`OpenListingsReport`** - `open_date`(string to datetime), `pending_quantity`(string to Integer)&#x20;
   * **`FlatFileOrdersByLastUpdateReport`** - `purchase_date`(string to DateTime)&#x20;
   * **`FlatFileAllOrdersReportByLastUpdateDate`** - `purchase_date`(string to DateTime)&#x20;
   * **`FBAPromotionsReport`** - `shipment_date`(string to DateTime)&#x20;
   * **`FBAInventoryAgeReport`** - `snapshot_date`(string to DateTime)&#x20;
   * **`FBAStorageFeesReport`** - `estimated_monthly_storage_fee`(string to Numeric)&#x20;

   \
   **Table Renames:**

   * `FBASmallAndLightReports` **to** `FBASmallAndLightInventoryReport`&#x20;
   * `RestockInventoryReport` **to** `FBARestockInventoryReport`&#x20;
   * `FlatFileOrdersByLastUpdateReport` **to** `FBAFlatFileOrdersByLastUpdateReport`&#x20;

   &#x20;

   **Column Renames:**

   **`FlatFileReturnsReportbyReturnDate`**&#x20;

   * `Order_Amount` **to** `Order_amount`&#x20;
   * `Refunded_Amazon` **to** `Refunded_amazon`
   * `Item_Name` **to** `Item_name`
   * `Return_reason` **to** `Returnreason`
   * `Merchant_RMA_ID`(**New field**)

3. The list of reports, their description, and their behavior can be found in the [source documentation](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/ecommerce/amazon-mws#amazon-reports).&#x20;

   <figure><img src="/files/NEdN1cG2Z1wvshfU4Nqh" alt=""><figcaption></figcaption></figure>

   <figure><img src="/files/ChHmNm69uZCrDXr0uf1s" alt=""><figcaption></figcaption></figure>

   * The list of reports that require reloading to get accurate historic data is as follows. *Incremental data will be accurate even without the reload after this release (18th March).*

     \
     List of tables that require reload -&#x20;

     1. `FBAPromotionsReport`
     2. `FBAMonthlyInventoryHistoryReport`
     3. `FBAInventoryEventDetailReport`
     4. `FBAInboundPerformanceReport`
     5. `FBAStorageFeesReport`
     6. `FBAReplacementsReport`
     7. `ReferralFeeDiscountsReport`
     8. `FBAReturnsReport` <br>
   * Support for historic data has been removed for snapshot reports.  Snapshot reports will process data from the date of integration. **No action is required from the users.**

4. **Real-Time Reports:**&#x20;
   * Jobs for all real-time reports will have a start time of 12:00 AM (Local time) and an end time as the current time.&#x20;
   * This will increase the number of duplicates but will ensure that the data is accurate.&#x20;
   * The data of the previous day would be fetched until 6 AM local time to address latency from Amazon. \
     **No action will be required from the users.**&#x20;
   * Reload will be required only if there are differences in data for the previous months.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/release-notes/release-notes/2021/march.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.