Amazon Fine Upload Process
- Amazon will send a summary email with a spreadsheet of all weekly fines to compliance@advantus.com. One email per vendor number.
2. Navigate to the ComplianceFineImportTemplate-FINAL.xlsx spreadsheet. ComplianceFineImportTemplate_Update (1).xlsx and create a copy with today’s date. Ex. ComplianceFineImportTemplate-08.28.23.
3. Complete the following Mandatory fields on the template:
- Debit memo # – This is the Issue ID on the Amazon Chargeback Excel spreadsheet.
- Amount of Debit Memo
- Purchase Order #
- Vendor Code- Leave this column blank. The system will load the correct customer number based on the PO on the import. Note: If you value the customer number in this import column, the system may load incorrect data.
- Reason for Debit
- Date of Debit Notification
- Status – drop down box
- Fine Responsibility – drop-down box that mirrors the same drop-down box in NS.
- Violation Type – drop-down box that mirrors the same drop-down box in NS.
- Amount Approved/Amount Disputed
- Approved Date
- Cost of Business – if the fine is due to Cost of Business then use the drop-down box to select Yes.
4. Guide to most common fines:
| Reason for Fine | Fine Responsibility | Violation Type | Fine Status |
| PO On-Time Accuracy | Supply Chain | Fill Rate | Approved |
| Carton Content Accuracy | IT | ASN | Approved |
| No Carton/Pkg Content label | Shipping | Labeling – Missing | Approved |
| Ship in Own Container | Cost of Business | Package | Approved |
| Prep – Bagging | Cost of Business | Package | Approved |
| Prep – External Bubble Wrapping | Cost of Business | Package | Approved |
| Prep – Barcode Labeling | Cost of Business | Package | Approved |
| Oversized Carton | Cost of Business | Package | Approved |
| Prep – Set Creation | Cost of Business | Package | Approved |
| ASN Accuracy | EDI | ASN | Researching |
5. Save the file as both an .xlsx and a .csv file in the following folder: Amazon Completed Uploads. The .csv file will be used to import.
6. The completed template will be uploaded into NetSuite using Scripted Import.
- Any records that are not successfully imported can be edited on the fine record or resubmitted using the process above.