SKU to SKU Transfer

Overview

SKU to SKU Transfer is a seamless method for transferring physical inventory from one product to another. It is typically used when a product is being rebranded, or refurbished, or when inventory needs to be consolidated from one SKU to another. One common use case for this transfer is when returned items are in good condition and suitable for resale but require a separate SKU to be classified as “Used.” In this scenario, the returned items need to be transferred to the “Used” SKU. This ensures that the returned items are correctly classified and inventory is accounted for.

Transfer from SKU to SKU

You can transfer inventory quantities from a SKU in any warehouse or bin (including bins that are not marked as Sellable) to any other SKU in any warehouse/bin.

You can transfer individually or in bulk.

Individually

1. Navigate to Inventory > Tools > Manage SKU to SKU Transfers.
2. This tab shows the previous SKU to SKU Transfers and provides search filters.
3. Click on the Plus icon.
4. Enter the required information.
   1. From Warehouse –  The Warehouse you will be deducting From. Once you choose the Warehouse you will be deducting From, the rest of the information will appear.
   2. Qty – The quantity to be transferred.
   3. Serial Numbers – Only applicable if the Serial Numbers workflow is enabled for your account.
5. Click Add.

In Bulk

1. Navigate to Inventory > Tools > Manage SKU to SKU Transfers.
2. Click on Download Template from the Action Menu to get the example file.
3. Fill in the required data and upload the file. It is required to enter the SKUs, the quantity, and Sending and Receiving Warehouses.
   1. From / To Product ID – The SKU you will be deducting From and adding To.
   2. Qty – The quantity to be transferred.
   3. From / To Warehouse – The Warehouse you will be deducting From and adding To.
   4. Serial Numbers – Only applicable if the Serial Numbers workflow is enabled for your account.
4. Go back to Sellercloud and click Upload file from the Action Menu.
5. Upload the file with the information.
6. The new Transfer will show in the grid after it is processed.

SKU to SKU transfers are recorded in the Inventory Movement of the products, and you can always check it for reference.

Average Cost Calculation

SKU to SKU transfers will affect Average Cost. Most sellers use the Weighted Average Cost calculation. The Average Cost calculation uses the Physical Inventory Count. For additional information, refer to the Product Average Cost.

There are a few client settings to keep in mind:

Do not copy average cost for SKU to SKU transfer

• If the client setting is enabled, there will be no Average Cost Adjustment recorded following a transfer.
• If the client setting is disabled, the following logic will be used:
  • For example, there are 10 units at $2.00 per piece ($20.00 in total) and 20 units at $3.00 per piece ($60.00 in total). Then, the total cost of $80.00 is divided by all units received, which is 30. $80.00 / 30 = Weighted Average Cost of $2.67.

Allow Zero Cost SKU to SKU Transfer to affect Average Cost

• This setting needs to be enabled when you are transferring From a SKU with a $0 cost.
  • If you transfer a $0 cost SKU and enable the setting after, the Average Costs will not be recalculated retroactively