Skip to content
  • There are no suggestions because the search field is empty.

Amazon Europe - data collection

This content details how to extract the required data from the Amazon Europe portal and send for processing.

Steps on how to collect the data for Resideo International

  1. Log into Amazon Vendor Central using the Last Pass credentials from Active - Resideo - Amazon Vendor Central from Resideo - Europe.

    1. There will be a MFA authentication code sent.

    2. Check the email, enter the code, and click “Submit Code”

    3. This will bring you to an account selection screen, select the account DE – bk-electronic GmbH”. And click select account

    4. This will bring up another login screen for Amazon Vendor Central Europe where you will have to change the login email to the proper one from Last Pass.

    5. You will then have to enter another MFA code that will be emailed

    6. Enter the code in the box and again click “Submit Code”

  2. You will be brought to the URL vendorcentral.amazon.de/home/vc from where you will go to the top left and click on the Retail Analytics Button

  3. Navigate the top ribbon below, click on Sales.

  4. From here you will navigate down to the box labeled “Time Frame,” and select Weekly

  5. Confirm that the Week displayed is Last Week
  6. Make sure “Manufacturing” is selected under the “Distributor view”.

  7. Make sure the "Currency" dropdown says “EUR – Euro”

  8. Click “APPLY”.

  9. Navigate to the right of apply and select the CSV download.

    1. Do this even if you get "No data to display. Please adjust your filters"
  10. After that has been done and says “your report has been requested” go back to the “Distributor View,” select the drop down, click “Sourcing”, click “Apply” and select the CSV under downloads again
  11. Go to the top toolbar, and click “Inventory"
  12. From here you will navigate down to the box labeled “Time Frame,” and select Weekly

  13. Confirm that the Week displayed is Last Week
  14. Make sure “Manufacturing” is selected under the “Distributor view”.

  15. Make sure the "Currency" dropdown says “EUR – Euro”

  16. Click “APPLY”.

  17. Navigate to the right of apply and select the CSV download.

    1. Do this even if you get "No data to display. Please adjust your filters"
  18. After that has been done and says “your report has been requested” go back to the “Distributor View,” select the drop down, click “Sourcing”, click “Apply” and select the CSV under downloads again
  19. From here you’ll navigate to the top right of the screen and click Manage Downloads".
  20. It’ll bring up the 4 files, click "Download" when all 4 files are ready.
  21. Rename the files using the information below.
  22. Then go to the top of the screen and select a different account and repeat steps 3 through 21 until all accounts are done.
  23. Log out of the portal.
  24. Zip all 24 Manufacturing files together.
    1. Call the zip file: Resideo International Amazon Manufacturing YYYYMMDD
  25. Send the zip file to data@krunchbox.com
  26. Zip all 24 Sourcing files together.
    1. Call the zip file: Resideo International Amazon Sourcing YYYYMMDD
  27. Send the zip file to data@krunchbox.com

FILE NAMES for Manufacturing

  • Account 1: DE - bk-electronic GmbH

    • File 1: Manufacturing Sales = DE bk Sales_ASIN_Manufacturing_Retail_Germany_Weekly_DD-MM-YYYY_DD-MM-YYYY

    • File 2: Manufacturing Inventory = DE bk Inventory_ASIN_Manufacturing_Retail_Germany_Weekly_DD-MM-YYYY_DD-MM-YYYY

       

  • Account 2: DE - Pittway SARL

    • File 1: Manufacturing Sales = DE Pit Sales_ASIN_Manufacturing_Retail_Germany_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = DE Pit Inventory_ASIN_Manufacturing_Retail_Germany_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 3: ES - Securite Communications SAS

    • File 1: Manufacturing Sales = ES Sales_ASIN_Manufacturing_Retail_Spain_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = ES Inventory_ASIN_Manufacturing_Retail_Spain_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 4: FR - Pittway SARL

    • File 1: Manufacturing Sales = FR Pit Sales_ASIN_Manufacturing_Retail_France_Weekly_DD-MM-YYYY_DD-MM-YYYY

    • File 2: Manufacturing Inventory = FR Pit Inventory_ASIN_Manufacturing_Retail_France_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 5: FR - Securite Communications SAS

    • File 1: Manufacturing Sales = FR Sec Sales_ASIN_Manufacturing_Retail_France_Weekly_DD-MM-YYYY_DD-MM-YYYY

    • File 2: Manufacturing Inventory = FR Sec Inventory_ASIN_Manufacturing_Retail_France_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 6: GB - Pittway SARL

    • File 1: Manufacturing Sales = GB Sales_ASIN_Manufacturing_Retail_UnitedKingdom_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = GB Inventory_ASIN_Manufacturing_Retail_UnitedKingdom_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 7: IT - Pittway SARL

    • File 1: Manufacturing Sales = IT Pit Sales_ASIN_Manufacturing_Retail_Italy_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = IT Pit Inventory_ASIN_Manufacturing_Retail_Italy_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 8: IT - Securite Communications SAS (ex Honeywell srl)

    • File 1: Manufacturing Sales = IT Sec Sales_ASIN_Manufacturing_Retail_Italy_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = IT Sec Inventory_ASIN_Manufacturing_Retail_Italy_Weekly_DD-MM-YYYY_DD-MM-YYYY

  • Account 9: NL - Pittway SARL

    • File 1: Manufacturing Sales = NL Pit Sales_ASIN_Manufacturing_Retail_Netherlands_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = NL Pit Inventory_ASIN_Manufacturing_Retail_Netherlands_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 10: NL - Resideo NL

    • File 1: Manufacturing Sales = NL Res Sales_ASIN_Manufacturing_Retail_Netherlands_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = NL Res Inventory_ASIN_Manufacturing_Retail_Netherlands_Weekly_DD-MM-YYYY_DD-MM-YYYY

  • Account 11: PL - Pittway SARL

    • File 1: Manufacturing Sales = PL Pit Sales_ASIN_Manufacturing_Retail_Poland_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = PL Pit Inventory_ASIN_Manufacturing_Retail_Poland_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 12: PL - Resideo Honeywell Home

    • File 1: Manufacturing Sales = PL Res Sales_ASIN_Manufacturing_Retail_Poland_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = PL Res Inventory_ASIN_Manufacturing_Retail_Poland_Weekly_DD-MM-YYYY_DD-MM-YYYY 

FILE NAMES for Sourcing

  • Account 1: DE - bk-electronic GmbH

    • File 1: Manufacturing Sales = DE bk Sales_ASIN_Sourcing_Retail_Germany_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = DE bk Inventory_ASIN_Sourcing_Retail_Germany_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 2: DE - Pittway SARL

    • File 1: Manufacturing Sales = DE Pit Sales_ASIN_Sourcing_Retail_Germany_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = DE Pit Inventory_ASIN_Sourcing_Retail_Germany_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 3: ES - Securite Communications SAS

    • File 1: Manufacturing Sales = ES Sales_ASIN_Sourcing_Retail_Spain_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = ES Inventory_ASIN_Sourcing_Retail_Spain_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 4: FR - Pittway SARL

    • File 1: Manufacturing Sales = FR Pit Sales_ASIN_Sourcing_Retail_France_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = FR Pit Inventory_ASIN_Sourcing_Retail_France_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 5: FR - Securite Communications SAS

    • File 1: Manufacturing Sales = FR Sec Sales_ASIN_Sourcing_Retail_France_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = FR Sec Inventory_ASIN_Sourcing_Retail_France_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 6: GB - Pittway SARL

    • File 1: Manufacturing Sales = GB Sales_ASIN_Sourcing_Retail_UnitedKingdom_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = GB Inventory_ASIN_Sourcing_Retail_UnitedKingdom_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 7: IT - Pittway SARL

    • File 1: Manufacturing Sales = IT Pit Sales_ASIN_Sourcing_Retail_Italy_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = IT Pit Inventory_ASIN_Sourcing_Retail_Italy_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 8: IT - Securite Communications SAS (ex Honeywell srl)

    • File 1: Manufacturing Sales = IT Sec Sales_ASIN_Sourcing_Retail_Italy_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = IT Sec Inventory_ASIN_Sourcing_Retail_Italy_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 9: NL - Pittway SARL

    • File 1: Manufacturing Sales = NL Pit Sales_ASIN_Sourcing_Retail_Netherlands_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = NL Pit Inventory_ASIN_Sourcing_Retail_Netherlands_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 10: NL - Resideo NL

    • File 1: Manufacturing Sales = NL Res Sales_ASIN_Sourcing_Retail_Netherlands_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = NL Res Inventory_ASIN_Sourcing_Retail_Netherlands_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 11: PL - Pittway SARL

    • File 1: Manufacturing Sales = PL Pit Sales_ASIN_Sourcing_Retail_Poland_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = PL Pit Inventory_ASIN_Sourcing_Retail_Poland_Weekly_DD-MM-YYYY_DD-MM-YYYY 

  • Account 12: PL - Resideo Honeywell Home

    • File 1: Manufacturing Sales = PL Res Sales_ASIN_Sourcing_Retail_Poland_Weekly_DD-MM-YYYY_DD-MM-YYYY 

    • File 2: Manufacturing Inventory = PL Res Inventory_ASIN_Sourcing_Retail_Poland_Weekly_DD-MM-YYYY_DD-MM-YYYY

Visual Guide on how to collect the data for Resideo International

  1. Log into Amazon Vendor Central using the Last Pass credentials from Active - Resideo - Amazon Vendor Central from Resideo - Europe.

     

    1. There will be a MFA authentication code sent.

    2. Check the email, enter the code, and click “Submit Code”

    3. This will bring you to an account selection screen, select the account DE – bk-electronic GmbH”. And click select account

    4. This will bring up another login screen for Amazon Vendor Central Europe where you will have to change the login email to the proper one from Last Pass.

    5. You will then have to enter another MFA code that will be emailed

    6. Enter the code in the box and again click “Submit Code”

  2. You will be brought to the URL vendorcentral.amazon.de/home/vc from where you will go to the top left and click on the Retail Analytics Button

  3. Navigate the top ribbon below, click on Sales.

  4. From here you will navigate down to the box labeled “Time Frame,” and select Weekly

  5. Confirm that the Week displayed is Last Week
  6. Make sure “Manufacturing” is selected under the “Distributor view”.

  7. Make sure the "Currency" dropdown says “EUR – Euro”

  8. Click “APPLY”.

  9. Navigate to the right of apply and select the CSV download.

    1. Do this even if you get "No data to display. Please adjust your filters"
  10. After that has been done and says “your report has been requested” go back to the “Distributor View,” select the drop down, click “Sourcing”, click “Apply” and select the CSV under downloads again

  11. Go to the top toolbar, and click “Inventory"
  12. From here you will navigate down to the box labeled “Time Frame,” and select Weekly

  13. Confirm that the Week displayed is Last Week
  14. Make sure “Manufacturing” is selected under the “Distributor view”.

  15. Make sure the "Currency" dropdown says “EUR – Euro”

  16. Click “APPLY”.

  17. Navigate to the right of apply and select the CSV download.

    1. Do this even if you get "No data to display. Please adjust your filters"
  18. After that has been done and says “your report has been requested” go back to the “Distributor View,” select the drop down, click “Sourcing”, click “Apply” and select the CSV under downloads again
  19. From here you’ll navigate to the top right of the screen and click Manage Downloads".
  20. It’ll bring up the 4 files, click "Download" when all 4 files are ready.
  21. Rename the files using the information below.
  22. Then go to the top of the screen and select a different account and repeat steps 3 through 21 until all accounts are done.
  23. Log out of the portal.
  24. Zip all 24 Manufacturing files together.
    1. Call the zip file: Resideo International Amazon Manufacturing YYYYMMDD
  25. Send the zip file to data@krunchbox.com
  26. Zip all 24 Sourcing files together.
    1. Call the zip file: Resideo International Amazon Sourcing YYYYMMDD
  27. Send the zip file to data@krunchbox.com