This article explains the configuration settings available in a Bigcommerce 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 6 tabs:
- DETAILS - Channel Integration and configuration settings
- VAT - Tradebox's VAT settings
- ORDERS - a list of orders downloaded from this channel
- SALES - Graph comparing last 3 Calendar year's sales
- STATUSES - Table mapping marketplace statuses to Tradebox statuses
- SAGE 50/XERO - settings for accounts integration
Note: There is a save button at the bottom of each tab. Clicking this saves and closes down the channel details and takes you back to the channel list. If you are amending multiple tabs at once, you can navigate between the tabs without saving. It's only necessary to click the save button once you've made all your amendments in every screen.
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. More in-depth details can be found in the BigCommerce API Credentials article.
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: If ticked, Tradebox will create new products in the Product Module where a SKU in a downloaded order does NOT already exist. The product record created will only contain the minimum information required, such as SKU and description, and will not contain information such as price, location, dimensions etc. This is not applicable if you're using Accounts Software or None as your stock control method.
Don't Update Tradebox stock levels: If ticked, Tradebox will not amend stock levels in its own database based on orders received through this channel. This is not applicable if you're using Accounts Software or None as your stock control method.
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.
Days to Download: How many days' worth of sales you want Tradebox to download for this particular channel. Tradebox will never download any duplicate sales, but it can cover old ground to see if any orders that didn't meet your criteria on first check are now valid for download, and also update order statuses if applicable.
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 may be unavailable if you choose to download orders at a status prior to them being paid for or despatched.
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
Discount Amount is Net should be ticked if the discounts provided by your Bigcommerce site are a net value rather than gross.
- Don't Upload Zero Quantities: Tradebox will not upload a stock level of zero to any item on Bigcommerce.
- Upload Negative Quantities as Zero: If a stock level is negative, Tradebox will convert the stock level to zero instead.
- Upload Quantities for Bundles: Bundle products in Tradebox are by default excluded from uploads. Ticking this box will include them.
- For Sage BOM use Quantity to Make Up: If you're using Sage stock control and have BOM (bill of materials) products, Tradebox can calculate the number of BOM end products that can be made up from the component products, and upload that to Bigcommerce.
For more information, see our in-depth article on uploads here.
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 Configuration > Tax Rates where the user can apply the percentage rate 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.
For more detailed information, see our in-depth article here.
The orders section of the channel will display all orders that have been downloaded for that particular channel. It displays the following information:
Type: Displays either Sales Order or Sales Credit Note.
Date: The order date. By default, this is the date the order was placed.
No: The Tradebox order number, which is automatically assigned on download.
Channel No: The order number from the channel, in this case, the Amazon order number.
Customer: The customer's name.
Value: The total value of the order.
Status: The order status within Tradebox.
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 page of the channel details shows a breakdown of the sales value for this channel by month over the past three years, with the option to view as a bar graph or line chart.
The top section of the Statuses tab displays a list of marketplace order statuses and the corresponding Tradebox order statuses they are mapped to. This controls at which status your orders will download to Tradebox. The bottom section of the grid controls which statuses are set to post to your accounts package (if integrated). To edit a marketplace status, select edit or double click on it and a pop up box will appear that allows you to choose what Tradebox status to map it to, and whether you want that status to download. To edit a Tradebox status, select edit or double click on it and a pop up box will appear that will allow you to choose whether or not you want orders with that status to post to your accounts. You can add or delete marketplace statuses using the 'Statuses - Add New' and 'Delete' functions in the Action menu in the bottom right.
You can find more detailed information about this here.
If you have opted to link Tradebox to an accounts package, you will see either Sage 50 or Xero displayed as an additional tab within the channel. This holds the connection details for your accounts package, and, once connected a new range of tabs will open up. The Sage 50 connection page is shown below:
For full instructions on setting up the accounts link, please see our guides for either: