Product Mapping holds the relationship between the:
- Online Marketplace SKU
- Tradebox product SKU
- Sage Product Code (where applicable)
This is an essential process (where products are being held) because Stock Keeping Units (SKUs) can often differ between platforms and systems. The Product Mapping table keeps track of how each SKU is connected so stock levels can be adjusted and passed correctly. Ideally, all SKU's would be identical across all platforms and systems. However, this is often not the case.
Product Mappings are held on an individual sales channel basis because the products you have set up could have different relationships for different platforms.
The Product Mapping Import Template article provides an overview of the import file as well as an example template CSV file.
A step by step guide on how to import the product mappings can be found in the Importing Product Mappings article.
Online SKU + Tradebox SKU
Tradebox's default behaviour is to automatically create a mapping where the online SKU and the Tradebox SKU are identical. If Tradebox downloads an online order with a SKU that is not in the Tradebox product list, the order will be placed into a status of QUERY and the user will be prompted to either create a new product in Tradebox or map the downloaded SKU to an existing (non matching) Tradebox product.
Tradebox SKU + Sage Product Code
If Sage integration is set up, Tradebox will automatically create a mapping where the Tradebox SKU is identical to a Sage Product Code. If the product code doesn't exist in Sage, or, if the SKU is not EXACTLY identical, Tradebox will generate a Product Mapping Error prompting the user to create the product in Sage or map the SKU to an existing (non matching) Sage product.
Often the user may wish to create these Product Mapping relationships in advance of downloading any orders. Full details of how to do this can be found in the "Importing Product Mappings" article.
Product Mapping Tables
The Product Mapping tables can be viewed in the Product section of the program by selecting the Mapping button from the top of the screen and then choosing a Sales Channel and Mapping Type from the drop down menus. The following views can be displayed:
- All Mappings
- Tradebox SKUs with NO mapped online marketplace SKU
- Marketplace SKUs with NO mapped Tradebox SKU
- Marketplace SKUs with NO mapped Sage Product
- Current orders with unmapped SKUs
Once the filters have been applied the following screen is displayed:
This table holds the relationship between the 3 potential SKUs. The following features are also enabled/available via Product Mapping.
Many to One Relationships
The Product Mapping Table enables many to one relationships, where the different online SKUs are mapped to the same Tradebox SKU or Sage Product Code:
- ABC1 = ABC123
- ABC2 = ABC123
- ABC3 = ABC123
The Multiplier column allows the user to establish a factor by which the stock level in the downloaded online marketplace product SKU can be multiplied. Where the stock levels are adjusted (Tradebox or Sage) is dependent upon the Inventory Choice made when setting up the software. In the above example marketplace SKU BOARD_002 has a multiplier of 5 which means the downloaded quantity for this SKU from this channel will be multiplied by a factor of 5.
However, the product unit price (as sold) will remain the same. If this feature is used, the quantity stated MUST be DIVISIBLE by the gross product unit price, to the penny, after the multiplication.
- Units 30 - Price £1.20 = unit price in Sage of 4 pence
- Units 30 - Price £1 = unit price in Sage of 3.33333333 pence
The Exclude column allows the user to exclude the stock levels of a specific SKU from being uploaded to the marketplace. By default, all SKUs are excluded from upload. The exclusions are set per channel so a product may need to be included multiple times.
PO (Purchase Order) (Sage Only)
The PO function is only applicable where Tradebox is integrated with Sage 50 Accounts Professional. The feature allows the user to configure Tradebox to create a Purchase Order in Sage 50 Professional when it processes an order with the specified SKU in it. In the Product Mapping Import Template CSV file this field is called "DirectToCustomer".
Typically, this feature is used in a drop ship environment, where the user doesn't hold the item in stock and wishes to send a PO to the supplier for dispatch directly to the buyer. For this to happen successfully, each Product Record in Sage needs to be allocated to a Supplier Record. When this feature is utilised, Tradebox will:
- Create an individual PO in Sage, for each unique product, in the name of the Product Supplier as held on the Sage Product Record.
- Create the PO at the cost price held on the Sage Product Record.
- Create the PO with the downloaded order's shipping address.
To enable this feature, the PO box must be ticked against each appropriate SKU in the product mapping for each channel.
In addition, the ‘Create Purchase Orders (Dropshippers)’ instruction needs to be ticked. This can be found within each Sales Channel under Accounts > Postings.