This article explains the configuration settings available in a Magento Channel in Tradebox.
To access the channel configuration settings go to the Channels Module and either double click on the channel from the list or select the channel and choose the Edit button. The Channel is split into 7 tabs:
- Import File
Name is simply the label given to the channel to identify it. This appears in reports within Tradebox and against orders. To change this simply overwrite the existing entry and select the Save button.
Currency displays the currency of the channel. This field cannot be changed once it has been established. A Tradebox channel can only import sales that have a matching currency.
API Connection Details
This section displays the API credentials used during setup. The web URL is succeeded by /api/v2_soap/ which is automatically added by Tradebox. More in-depth details can be found in the Magento API Setup article.
This section displays a grid containing all of the Magento Customer Groups and allows the user to apply a filter on orders to download based upon which customer group they belong to. This feature is often used where the user wishes to apply different rules to orders belonging to different customer groups, for example trade orders and retail orders. The Download column indicates the customer groups that have been chosen for download.
The On Hold column allows all orders from a specified customer group to be automatically placed on hold in Tradebox. This means that the order cannot be marked as dispatched or posted to an accounts package until its status has been changed manually in the Order Module.
To refresh the Customer Group list click on the download arrow at the top right of the grid.
Place all downloaded orders on hold automatically changes the status of every imported order to On Hold. This means that the order cannot be marked as dispatched or posted to an accounts package until its status has been changed manually in the Order Module.
Create Tradebox Product Records allows the user to automatically create a product record in Tradebox when it encounters a SKU in an order that doesn't already exist in the Tradebox product list. This option only appears where the global Inventory Option (Configuration > Preferences) has been set to Tradebox. If the Inventory Option is set to Sage this option will be greyed out and any missing products will be automatically created. Where Tradebox creates products automatically it uses the online SKU and description only. It cannot create entries for quantities, pricing, location, dimensions etc, so it is advised to use this feature with caution. There are a number of routes to import products into Tradebox that enable this missing information to be entered.
Ignore transactions prior to allows the user to establish a watershed date in the channel where the software will ignore any orders with an order date prior to the date entered.
Invoice Date allows the user to choose the date to use on the invoice produced by Tradebox. The options are:
- Order Date - The date the order was placed
- Payment Date - The date the order was paid for
- Despatched Date - The date the order was despatched
By default, this option is set to Order Date. Payment Date and Despatched Date can only be used if they are provided by your site and the order is downloaded at a stage when they are populated.
Discount Type allows the user to configure the type of discounts applied on downloaded orders which inform how the order is calculated in Tradebox. The user can choose:
- None - No discounts to be applied
- Order Discount - This applies a discount off the entire order
- Item Line - This applies a discount off the Item, rather than the order. If chosen, Tradebox needs to know whether to apply the discount off the total number of units on the line, or, whether to apply the discount of each unit.
- Line = discount the line price after the unit price has been multiplied by the quantity
- Unit = discount the unit price before the unit price has been multiplied by the quantity
Order Number Prefix allows the user to apply a download filter based upon the number with which the Magento order number begins. By default, this is set to zero which means the filter has not been applied. If a prefix number is chosen, Tradebox will only download orders that begin with that number.
Get Price From shows the Magento Product Type the order's prices are being taken from. The option available are:
- Configurable Product (Default)
- Simple Product
- Add Both Prices
- Bundle Product
Get SKU and Description From shows the Magento Product Type the SKU and product description are taken from. The option available are:
- Simple Product (Default)
- Configurable Product
The default settings for Get Price From and Get SKU and Description From are set as Configurable Product and Simple Product by default. Based upon testing, these settings are applicable for the majority of users. It is recommended that these settings are tested and checked before accounts integration is added.
Product Prices are Net is commonly used where the Magento site is configured for prices excluding VAT which is popular amongst B2B sellers. By default, this is turned off.
Get Customer VAT Number can be turned on where the buyer is a business and the user wishes to collect their VAT number. This is taken from the Tax/VAT number field on the Account Information section of the Magento customer record. Turning on this feature does have an impact on the speed performance of the software as it requires additional API calls to Magento which slows the process down.
Bundled Products on Orders
Classically, a 'bundle' product is a collection of goods made up of other products, like a cricket set made up of bats, balls and stumps. This section allows the user to decide where to get the prices from and what should be displayed on the order.
Use Bundled Item Prices is ticked where the user wishes Tradebox to take the prices from the individual items in the bundled product, rather than the total bundle price.
Show Bundle Product allows the user to decide whether to display the Bundle Product description on the order or simply display the component parts of the bundle on the order.
Downloads and Uploads
Download Orders indicates whether the channel has been activated to download orders. By default, when a channel is setup, both download and upload options are turned off. To enable a channel to download orders, select the channel in the Channel module grid and choose the Activate button. The channel in the grid view will display a green tick under the Active and Download columns. The upload column will remain turned off, indicated by a red cross in the grid.
Upload Stock Levels displays whether the channel has been configured to allow Tradebox to pass stock levels back to the sales channel platform. This option can only be turned on from within the channel settings. When selected a confirmation box will ask the user to confirm whether stock levels should be uploaded.
Upload Negative Quantities as Zero enables negative stock level quantities to be substituted for a stock quantity of zero and is used where platforms don't allow negative stock.
The VAT Tab allows the user to choose which rate of VAT to apply against Sales, Carriage and Other income streams from the UK, EU and Rest of World (ROW). These rates are fed from the general configuration settings found in Maintenance > Tax Rates where the user can apply the percentage against each VAT rate.
All EU Sales are B2B allows the user to apply a blanket setting against all sales from within the EU so they are treated as B2B and VAT is not applied to sales.
Use Product Tax for Carriage configures Tradebox to calculate VAT on carriage income based upon the tax status of the products in the order. If all products in the order are VAT exempt then VAT on carriage will be calculated as VAT exempt using the appropriate tax code. If ANY of the products in an order are liable for VAT then carriage income will be calculated with VAT.
The Orders Tab provides a list of all orders processed through the channel and displays:
- Order Date
- Tradebox internal number
- Marketplace or Channel Number
- Customer Name
- Order Total
- Order Currency
- Order Status
Double clicking on any order in the grid opens the order in full. The grid can be sorted by any column and is sorted by order date by default.
The Sales Tab displays gross turnover figures for the last 3 years in both a table and a graph, juxtaposing the last 3 years fixed calendar sales. The graph has Column Chart icon and a Line Chart icon allowing the user to toggle between a column chart and line chart.
The Status Tab displays a list of marketplace order statuses and the corresponding Tradebox order statuses they are mapped to. The grid also displays whether each status has been selected to be downloaded and/or whether it is allowed to be posted to an accounts package (if integrated). To edit, double click on the status in the grid, which will generate the following pop out box:
Select a Tradebox Status to match the Marketplace status to. Tick the Download box to allow orders with this marketplace status to be downloaded. Tick Post to Accounts to allow orders of this status to be passed to your accounts package (if integrated).
The Accounts Tab provides connection details to the chosen Accounts package through this screen and is established per channel allowing different channels to be configured independently. Tradebox One currently only supports Sage 50. Integration for Xero, Sage One and Quickbooks will be released in later versions and configured through this screen.
Company allows the user to choose the Sage Company data they wish to integrate with from a drop down list.
Data Folder displays the path to the chosen Sage Data folder
Tradebox One requires 2 Logon Names for integration with Sage 50; TBUSER and TBSERVICE. These fields are prepopulated with the required login names that need to be set up in Sage. Passwords need to be provided if the TBUSER and TBSERVICE users in Sage have been given a password.
The Sage Accounts Guide provides step by step instructions on configuring the Accounts Integration in Tradebox One. The '
The 'Configuring Sage for use with Tradebox One' article also provides an in-depth overview of the actions required in setting up Sage.