Here you will learn how-to upload your CoOp Agreements inside Seelk Studio. This will enable you to track your Net Pure Product Margin (Net PPM) in Seelk Studio's Pricing and Dashboards Apps.

Introduction

Tracking NetPPM is key to ensure your products remain profitable from an Amazon perspective and avoid them being CRaP (Can't Realize a Profit), meaning delisted from your Amazon Catalog.

Note that we do not retrieve Net PPM Reports from Brand Analytics in Amazon Vendor Central due to Amazon limitations. In order to enable you to have insights on your current Amazon profitability, we built a Seelk Studio NetPPM metric based on verified calculations. Results won’t be exactly the same as in Vendor Central as Amazon’s calculation remains a mystery; but will remain close and representative of current reality.

Here’s the calculation, also available in the Metric Lexicon:

((Average Sales Price - Net COGS) / Average Sales Price ))

with:

  • Net COGS = COGS*(1-CoOp)

  • COGS is an average weighted over Accepted Sell-In Closed in Units, coming from the Purchase Orders reports.

  • Average Sales Price is an average weighted over Shipped Units, coming from Sales Diagnostic reports (Shipped COGS Sourcing view).

Add your CoOp for NetPPM Tracking - 1st time.

Note: before uploading your CoOp per marketplace, make sure you add in your Catalog the ASINs you want to track your NetPPM on. Once it’s done, you can proceed with the below:

  1. Go in your Account Settings.

  2. Click on Products via the Settings’ navigation bar.

  3. Access the Pricing & Profitability tab.

  4. Click on Import on top right - you will be prompted to download and upload your Pricing & Profitability file.

5. Click on Download template (with current Price Reference). An Excel spreadsheet entitled accountname_Price Reference_date is directly saved in your computer ‘Downloads’ file.

Screen Shot 2021-10-14 at 16.13.54.png

6. Click on the Excel file you just downloaded. You access a blank spreadsheet. Here’s the column items that need to be filled with the required format :

  • rrp, promo_price and cost_price: to be uploaded for Pricing Analysis. Not mandatory for NetPPM tracking.

  • coop: expressed in value —example: for 12%, write down 0.12. Mandatory for NetPPM tracking.

Note: Amazon CoOp are most of the time agreed at a country-level. As such, to save time and avoid adding manually the CoOp per ASIN, you can leverage on Excel’s Filter feature to filter on a specific marketplace. As such, you can apply in a click your CoOp for the whole column; and repeat the process for each marketplace.

Example:

Screen Shot 2021-10-14 at 17.11.43.png

7. Once you’re done, save your file and drag&drop it into the area provided or select it from your computer, then click ‘Confirm’.

Screen Shot 2021-10-14 at 16.23.12.png

8. Your NetPPM is instantly computed for present and past periods, and directly available inside Seelk Studio Dashboards and Pricing Apps.

Modify your CoOp / Add additional ones on the existing file.

1-5. Go in your Account Settings > Click on Products > Pricing & Profitability tab > Import > Download template (with current Price Reference) —You will download an Excel spreadsheet that contains all your current CoOp.

6. a. To add coOp on new ASINs, either you can:

  • Insert your new ASINs in the table and upload your updated file containing existing and new CoOp.

  • Delete all the cells except column titles, and only add new ASINs and their CoOp. Deleting cells of existing CoOp won’t remove them from Seelk Studio. (Recommended)

6. b. To update current CoOp, either you can:

  • Search the ASINs you want to change CoOp on and directly modify it in the concerned column. Uploading the updated file will overwrite existing content.

  • Delete all the cells except column titles, and only add the concerned ASINs and their updated CoOp. Deleting cells of existing CoOp won’t remove them from Seelk Studio, and uploading the updated file will overwrite existing content on concerned ASINs. (Recommended)

7. Drag and drop your updated file into the area provided or select it from your computer, then click ‘Confirm’.

8. Your NetPPM is instantly modified/computed for present and past periods, and directly available inside Seelk Studio's Dashboards and Pricing Apps.

Did this answer your question?