If you have either a Magento v1, or a CSV channel in Tradebox then you may occasionally see an adjustment line appear on one of your orders. This occurs when Tradebox has found a discrepancy between the total that it has calculated based on the item lines and carriage values it's been given, and the order total as provided by Magento or in your CSV file. This can occur for a couple of different reasons, depending on the channel type.
On every Magento order, Tradebox receives the order total as well as footer details such as carriage, and item line details about the product sold. Normally the total of item lines and footer will tally up with the order total passed by Magento. However, there may be instances where this doesn't happen due to:
- Incorrect settings within your Tradebox
- A rounding discrepancy
- A value applied to the order that is included in the total but is not passed by Magento's API within the item lines or the footer.
For each order, Tradebox will calculate the total of all the available elements and check if there's a difference to the order total provided by Magento.
Where the order total is greater than the sum of the elements passed by the API, Tradebox will assign the difference to an adjustment line.
Where the order total is less than the sum of the elements passed by the API, Tradebox will assign the difference as a discount line.
In either case, this results in an total of items that matches the real order total, with no amount unaccounted for. Where you're using stock control with Tradebox, this show as an additional product line for the SKU TBMAGENTOADJUST. The first time this appears, the order will go into query and you'll need to map it just as you would any other product.
If you see the adjustment on every order
If you see the adjustment on every order through a given channel then it's likely that you've got an incorrect setting within that channel. For example, where users have net prices on Magento but haven't checked the relevant setting, we see:
On this Magento order, we can see that the VAT amount of £42.90 has been split out into its own adjustment line. This is because the default settings in Tradebox assume the prices from Magento will be passed down as gross; if this is not the case, Tradebox will assume that the net value of the order is in fact the gross value, and will add the VAT as an adjustment. Generally speaking, this would impact every order unless the order itself has no VAT element.
To resolve this, go to Channels within Tradebox and double click on the Magento channel. On the Details page, tick the Product Prices are Net setting, and then save. To correct the orders, you will need to delete them and allow Tradebox to download them again.
A CSV integration will only give you an adjustment line where the Order Total field is mapped, and where the value in that field does not match what Tradebox has calculated based on the individual order lines.
Where the order total is greater than the sum of the elements passed in the file, Tradebox will assign the difference to an adjustment line.
Where the order total is less than the sum of the elements passed in the file, Tradebox will assign the difference as a discount line.
This will ensure that the order is created with the same order total as provided by your website. Where you're using stock control, this will show as a product with a SKU of ADJUST. The first time this appears, the order will go into query and you'll need to map it just as you would any other product.