# Release Notes

## February 2022

* Added the `GetMatchingProduct` table.
* Fixed the errors in the `ListInventorySupply` table.
* Fixed the issue of not loading data with `FBAStorageFeesReport`.

## January 2022

* Feature request for `GetMatchingProduct` Report.
* Fix for `FeePreviewReport` incrementing lastrundate on job cancellations.&#x20;
* Fix for Timestamp Error.

## August 2021

Fixed the missing records in the `ListFinanaceEvents` table.

## May 2021

Data leak fixes in `FBAFlatFileOrdersByLastUpdateReport` and nulls in `FlatFileReturnsReportbyReturnDate`&#x20;

## March 2021

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/kkmQqz0lfZmjozfkoea3" alt=""><figcaption></figcaption></figure>

   <figure><img src="/files/caAwFSUQaR7494ryTefv" 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.**
* **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.

## January 2021

* Memory leak fixed.
* Configuration pages revamped.
* Added two new reports.
* Fixed the daily inventory reports.

## April 2020

* Support for Far East region marketplaces has been added.
* Additional reports have been introduced.
* Rate limits have been optimized.&#x20;

## January 2020

Support for new APIs has been added and existing APIs have been optimized.

## December 2019

Error notifications will be displayed in a user-readable message. \
\&#xNAN;*Note: The error messages are not comprehensive and new messages would be updated for these sources when they occur.*

## November 2019

For `FBADailyInventoryReport` the increment data has been fixed.&#x20;


---

# 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/daton/integrations/data-sources/ecommerce/amazon-mws/release-notes.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.
