This article explains the configuration settings available in a Woocommerce Channel in Tradebox One.
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
URL is the url of your Woocommerce webstore domain
Consumer Key is taken from your Woocommerce API credentials
Consumer Secret Key is taken from your Woocommerce API credentials
See the WooCommerce API Credentials article for instructions on how to create these credentials on WooCommerce.
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 instructs Tradebox to create new products in the Product Modulewhere a SKU in a downloaded order doesn't 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 Orders Dated Prior to: Allows the user to configure Tradebox to ignore any transactions prior to a given date preventing orders that fall before this date from being downloaded.
Ignore Orders Dated After: Allows the user to download orders up to a certain date and prevent any orders downloading after that date. This would usually be used where certain settings would apply up to a specific date, and different settings after that date, for example, the date you become VAT registered.
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
Item Line Prices are Discounted: Depending on your configuration on Woocommerce, discounts may be already applied to item lines before these values are passed down to Tradebox. Ticking this setting advises Tradebox that the discount has already been applied and prevents it from applying the discount a second time.
Update Product Records: This is for use if you are using Tradebox to update stock levels on your Woocommerce website. To update stock, Tradebox requires the Woocommerce product ID as well as the product SKU. When this option is selected, Tradebox will automatically collect the IDs from any new products you create on Woocommerce. Please note that this can increase the length of time your service cycle takes to run if you have a lot of products on Woocommerce.
- Don't Upload Zero Quantities: Tradebox will not upload a stock level of zero to any item on Woocommerce.
- 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 Woocommerce.
Please see our Uploading Stock Levels guide for more information.
The VAT section of the channel details shows a set of default tax codes for UK, EU, and Rest of World. The illustration above shows the default codes for a business on the standard VAT scheme. If you are using stock control in either Tradebox or an accounts package, UK and EU settings cannot be amended as Tradebox will automatically use the tax code on the product record.
All EU Sales are B2B: If all EU sales coming through this sales channel are business sales with a valid VAT number, this box should be ticked as it will instruct Tradebox to treat this sale as zero rated. If connecting to an accounts package, this will automatically use whichever tax code you have mapped to the EU B2B Sales tax rate in Configuration > Tax Rates in Tradebox.
Use Product Tax For Carriage: If you are selling goods with a mixture of tax codes, you may wish to select this option. With this setting turned on, if all of the products on an order are non-vatable, then no VAT will be applied to the carriage. If any product on the order is standard rated then the carriage will also be standard rated, even if the majority of the products are non-vatable.
Use Single Tax Code for ALL Entries: If ticked, all sales and carriage through the channel will use the code you choose from the dropdown that appears. This takes precedence over all other VAT settings except the per-customer tax code within the Contacts screen.
EU VAT Calculation Method
Where EU sales are not B2B, there are three additional options for how to treat sales that are shipped to the EU.
1. Zero Rated VAT EU Orders: For use if you wish all EU orders to be treated as zero rated, the same as your ROW sales.
2. Countries Table on Orders Not Exceeding €150: To be used where you are liable for VAT on EU orders up to a value of €150. This will instruct Tradebox to check the tax rates you have applied against each EU country in Configuration > Countries within Tradebox. This will be determined based on the country the order is being shipped to.
3. Countries Table Regardless of Value: This is used if you are liable for VAT on all EU orders, regardless of their value.
For more details on how Tradebox deals with VAT, see our 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 SO (Sales Order) or SC (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, 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, 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.
This is explained in more detail 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: