Products can be imported into Tradebox from:
This article deals with importing Product Records from Sage after the initial set up of Tradebox One has been completed. If you're using Tradebox for Sage integration and have products set up in Sage, importing from Sage is the correct method to ensure your products are set up correctly.
Note - the product import from Sage can take some time. Many of our users have large product lists; we've timed an import of 1,000 product records from local Sage data at between 2 and 20 minutes on two different PC's of different spec. This import can be completed at any time, but will need to be completed before Tradebox One can post any orders to Sage.
To start with you will need to ensure that Sage is installed on the PC you are using, Sage 3rd Party Integration has been enabled and that you have created the two additional Sage user logons for Tradebox.
From within the Products section, choose the Import button at the top of the screen. This will generate the following input screen:
From the Source drop down list choose 'Accounts'.
- If some or all of the products in Sage already exist in Tradebox you can choose whether to Update Existing Records. This will update the existing product records with any changes made to the product description or tax code on the Sage product record.
- If updating existing records you can also choose whether to Update Quantities and whether this should be read from the Quantity in Stock or from the Free Stock (total in stock minus total currently allocated to orders); both of these are taken directly from the Sage product record.
- If Create Bundles from BOMs is ticked, Tradebox will create the product records as bundles composed of the subcomponents from the Bill of Materials tab of the Sage product record. A product that is set as a bundle cannot be added to another bundle - if the import finds such a product a line is written to the error log and a message box appears at the end of the import process.
Once you've chosed your import options, click OK. You'll be prompted to log in to Sage; the TBUSER logon you've created works fine though any Sage logon that's currently not in use can be used.
When you're ready to start the import, click OK.
Note - this part of the process may take some time. It's fine to leave this import running unattended. Tradebox will pop a message box once the import is complete.
Once your products have imported, you may wish to import a Product Mapping File. This informs Tradebox of the relationship (mapping) between the Sage product, the Tradebox product and the Online product. You can also choose to action the product mapping ad hoc the first time Tradebox handles a sale of each product (and this will happen automatically if your online SKUs are identical to your Sage product codes), though products are only eligible for stock upload once they've been mapped.
If you're using Sage stock control, you don't need to do the full import every time you add a few new products on Sage, as the Tradebox Data Service will automatically import these as part of its cycle.
The automatic import of products from Sage by the Tradebox Data Service is controlled by the 'Check for New Products' tickbox on the Configuration -> Preferences tab. This is turned on by default, but can be switched off at any time. We would recommend having this turned off temporarily if you have created a large number of products in Sage within the previous two days, as this will slow the service down. Instead, you can import them using the method described above, which gives you greater control over the process and is more obvious to you when the process has completed.