...
Show 102550100 entries
Search:
Header name | Explanation | Format | Delimiter | Example | Adding a discount value | |
|---|---|---|---|---|---|---|
internal_conversion_ID | An identifying the transaction to which the basket position belongs. | Numeric | 4376671 | Make sure you copy this ID from an existing basket position. | ||
order_ID | The ID of the order to which the basket position belongs. | Numeric | ORD123456 | Make sure you copy this ID from an existing basket position. | ||
conversion_target_ID | TheID of the conversion target of the transaction to which the basket position belongs. | Numeric | TheID of the conversion target of the transaction to which the basket position belongs. | Use the ID of the default conversion target, unless the discount value is connected to a special campaign. | ||
conversion_target_name | The name of the transaction target related to the basket position. | Alphanumeric | Purchase | Use the name of the default conversion target, unless the discount value is connected to a special campaign. | ||
product_basket_index | The rank of the basket position within the basket. | Numeric | This index number is generated by the system, make sure the field is left empty. | |||
product_number | The name of the product as it was transmitted from the advertiser’s shopping system. | Alphanumeric | Socks, pullover, mobile phone | This field can be ignored. | ||
product_ID | The ID of the product coming from the advertiser’s shopping system. | Numeric | 6543 | This field can be ignored. | ||
product_currency_code | The ISO 4217 currency code in which the values of the transaction were defined. | ### | EUR | Make sure you use the currency code used for all the other basket positions. | ||
product_category_ID | The ID of the product category of the basket position. | Numeric | 386 | Use the ID of the default product category, unless the discount value is connected to a specific product. | ||
product_category_name | The name of the product category of the basket position. | Alphanumeric | default | Use the name of the default product category, unless the discount value is connected to a specific product. | ||
product_price | The of the product in the basket item. | Numeric: #.# | Period |
| In this field, the discount value should be added, using a minus sign. | |
product_quantity | The total number of products ordered for the basket position. | Numeric | 1 | Make sure this field is always set to 1, because it represents the factor by which the value in the previous field will be multiplied. | ||
product_total_price | The product price multiplied by the number of products ordered for the basket position. | Numeric | Period | 150.00 | The total price of the product is generated by the system, make sure the field is left empty. | |
product_commission_fix | The fix value used for the commission calculation. | Numeric: #.# | Period |
| If the commission model applied to this transaction is using a fixed commission, add a corresponding negative value in this field. | |
product_commission_percent | The percentage value used for the commission calculation. | Numeric: #.# | Period | 5.00 | If the commission model applied to this transaction is using a percentaged commission, make sure the same percentage is filled out in this field. | |
product_commission_total | The total amount of commission attributed to the basket position. | Numeric: #.# | Period | 22.50 | The total commission is generated by the system, make sure the field is left empty. | |
product_fee_fix | If the advertiser is billed by the platform owner, this field will contain the fix value used for the calculation of the fee. | Numeric: #.# | Period | .00 | If the fee model applied to this transaction is using a fixed fee, add a corresponding negative value in this field. | |
product_fee_percent | If the advertiser is billed by the platform owner, this field will contain percentage value used for the calculation of the fee. | Numeric: #.# | Period | 3.00 | If the fee model applied to this transaction is using a percentaged fee, make sure the same percentage is filled out in this field. | |
product_fee_total | If the advertiser is billed by the platform owner, this field will contain the fee the advertiser will have to pay for this transaction. | Numeric: #.# | Period | 3.00 | The total fee is generated by the system, make sure the field is left empty. | |
product_uniqid | An internal ID of the product in the basket position, related to the import. | Alphanumeric and printable special characters | 14x66c23-084f-3784-8084-c74f08536ce6 | Make sure you copy this ID from an existing basket position. | ||
product:_checksum | An internal validation code. | Alphanumeric and printable special characters | 097df04754f3524930b1f62e8296c845 | This field can be ignored. |
...
When you are done adding the basket positions with the relevant discount values, you can upload you file again using the export/import tool. For detailed instructions on uploading basket positions, please follow the instructions in this section of the article on bulk validation.
...