# 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="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FHe0EfEJmKF7aSS4yzhMd%2Frelease%20noteMWS.png?alt=media&#x26;token=9eb663d2-fe46-4e71-af71-d24cbaffa94e" alt=""><figcaption></figcaption></figure>

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2Fv427GgxOUdL3DqYepgGN%2Frelease%20noteMWS1.png?alt=media&#x26;token=2f939e52-ce37-4650-88a8-4e155cd54992" 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` \\

* 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;
