A bulk upload of new orders allows uploading of orders into the itemized commissioning system. Orders that are bulk uploaded should never have been uploaded via a pixel (they are mutually exclusive).
We recommend pixel over bulk upload whenever possible, but know that may not be appropriate for everyone. Feel free to implement the method that you feel is appropriate for your needs and conditions. The itemized commissioning system will process your rules in the exact same way.
No Personally Identifiable Information (PII) may be passed through the batch file. 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.
NOTE: For mobile device report filtering to work, the click ID must be captured and supplied.
Bulk Upload: New Transactions Orders 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 |
| AFFILIATEID | Unique ID assigned by Pepperjam to each publisher. The advertiser can assign this value to their destination URL by using "{subid}" as a place holder | Integer | 43545 | YES |
| OID | (Order ID) A unique ID, supplied by the advertiser, identifying transaction. Allowed Characters: Alpha-Numerics (A-Za-z0-9), dashes(-), underscores(_), periods(.), colons(:) |
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(_) |
Character (50) | SKU-13543422 | YES |
| AMOUNT | The sale amount for the single item. NOTE: Do not include dollar signs ($) or commas (,) in this field. |
Decimal | 12.20 | NO |
| QUANTITY | The number of items; must be an integer greater than zero (0). | Integer | 2 | YES |
| DATETIME | The date and time the transaction happened. NOTE: All times must be sent and will be reported in Eastern Time. Times are representative of Daylight Savings Time |
YYYY-MM-DD HH:MM:SS | 2000-01-01 23:59:59 | YES |
| CLICKID | Unique ID assigned by Pepperjam to each click record generated from a creative. This value is passed to the advertiser's website as the placeholder clid in the creative destination URL. This will need to be captured and stored so it can later be passed back in your bulk upload. Usage: The most recent click ID associated with the transaction's customer. Additional Info: See Itemized Tracking - Click ID Capture and Storage for more information. |
Integer | 7823432 | YES |
| GOOGLECLICKID | Case-sensitive unique ID assigned by Google Ads each time a search ad is shown. This value is passed to the advertiser's website upon click as the placeholder gclid. This can be captured and stored so it can later be passed back in your bulk upload, where we will associate them with Pepperjam Network's Click IDs. Usage: The most recent Google click ID associated with the transaction's customer. |
Character (100) | TeSter-123 | NO |
| PROMOCODE | A single or pipe-separated list of promotional codes tied to a personalized coupon. It is used to ensure credit is given to the owner of the personalized creative, rather than someone who may have used it without permission. If a list is provided, the first valid code will be used. If a valid code is not provided, the sale will be attributed as normal. This is an optional parameter and the feature requires additional setup by your account manager. | STRING | MYPROMOCODE | NO |
Notes
- 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.
- For lead transactions (transactions with flat payouts), the 'AMOUNT' field is not required. A zero may be used.
- 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.