...
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.
...
To adjust the order value via the conversion file, just follow the instructions related to conversion in the article on bulk validation. The relevant headers in the conversion file are the ‘conversion_order_value’, the ‘conversion_commission_rate’ and the ‘conversion_commission_type’. For further details, read the comprehensive description of the conversion file.