Overview
A bulk upload of corrected orders allows you to provide changes to orders that you previously sent to the itemized commissioning system, which may include returned items or order cancellations, quantity increase or decrease of ordered items, or pricing changes for ordered items.
Note:
- ORDER_ID and ITEM_ID cannot be changed. If there is an error with ORDER_ID and ITEM_ID, please contact your Account Manager. You can set all quantities to 0 (zero) and submit a new order with a new unique ORDER_ID if you need to change these values (see Itemized Tracking - Bulk Upload: New Orders).
Corrections may not be applied to orders after the locking period has passed.
Locking periods vary by affiliate program. Please consult your account strategist for further information.
Bulk Upload: Itemized Tracking Corrected Orders Fields Explained
| Field | Description | Data/Type Length | Example | Required |
| PID | Unique ID assigned by Pepperjam to each program. NOTE: If you are unsure what this value is, please contact customer support. |
Integer | 893 | YES |
| OID | (Order ID) A unique ID, supplied by the advertiser, identifying transaction. Allowed Characters: Alpha-Numerics (A-Za-z0-9), dashes(-), underscores(_) |
Character (50) | FT-13543422 | YES |
| ITEMID | A unique ID, supplied by the advertiser, identifying the item. Otherwise known as the product ID, or SKU. Allowed Characters: Alpha-Numerics (A-Za-z0-9), dashes(-), underscores(_), periods(.), colons(:) |
Character (50) | SKU-13543422 | YES |
| AMOUNT | "SALE" based transactions, this value is the new sale amount for the single item. "LEAD" based transactions, this value is the flat dollar amount of a single lead and becomes the new amount paid to the publisher after it is multiplied by the quantity. NOTE: Do not include dollar signs ($) or commas (,) in this field. |
Decimal | 12.20 | YES |
| QUANTITY | The number of items; must be an integer. | Integer | 2 | YES |
| REASON | Please use one of the following codes for the reason you are correcting the transaction: 1 - Invalid credit card number 2 - Customer returned the order 3 - Duplicate order 4 - Invalid shipping/billing address 6 - Customer returned part of the order 7 - Merchandise was damaged 10 - Non-Payment 11 - TOS Violation 8 - Other |
Integer | 8 |
YES |
Rules
The upload file must be in CSV (comma separated value) format.
- The first line of the file must be the header, with the required fields above. The fields are case sensitive and the order of the fields does not matter.
- Multiple quantities of the same item in the same order should be represented with a single line
- No Personally Identifiable Information (PII) may be passed to Pepperjam. PII includes but is not limited to information which can be used to distinguish or trace an individual's identity, such as their name, social security number, email address, phone number, or physical address.