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.

To be able to transfer from SKU to SKU you will need to enable the client setting Enable Inventory Transfer from SKU to SKU under Settings > Client Settings > General Client Settings.
All Kit Types are prevented from transfers in both Sellercloud and Skustack. You can only transfer kit components. To transfer Independent Kits, you need to disassemble them first.

Transfer from SKU to SKU

You can transfer between SKUs individually or in bulk. If you use Serial Numbers in your workflow, the client setting Enable Serial Number Validation must be enabled to see this information. 

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 – not needed if you don’t use such.
  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 – not needed if you don’t use such. To track and validate the serial numbers of the SKUs you are transferring, the client setting Enable Serial Number Validation must be enabled.
  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.

Transferring SKUs To and From Bin-enabled Warehouses has to be done through Skustack.

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 clients 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
The average cost of the SKU you’re transferring From will remain the same. Only the average cost of the SKU you’re transferring To will be affected.

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.

To be able to transfer from SKU to SKU you will need to enable the client setting Enable Inventory Transfer from SKU to SKU under Settings > Client Settings.
All Kit Types are prevented from transfers in both Sellercloud and Skustack. You can only transfer kit components. To transfer Independent Kits, you need to disassemble them first. 

Transfer from SKU to SKU

You can transfer between SKUs individually or in bulk. If you use Serial Numbers in your workflow, the client setting Enable Serial Number Validation must be enabled to see this information. 

Individually

  1. Navigate to the Inventory tab and select Transfer Between SKUs from the top menu. 
  2. This tab shows the previous SKU to SKU transfers and provides search filters. Click on New Transfer.
  3. Enter the required information.
    1. From / To Warehouse – the Warehouse you will be deducting From and adding To.
    2. From / To SKU – the SKU you will be deducting From and adding To.
    3. Qty – the quantity to be transferred.
    4. Serial Numbers – not needed if you don’t use such.

In Bulk

  1. Navigate to Inventory > Transfer Between SKUs.
  2. Click on Download Sample to get the example file.
  3. Fill in the required data and upload the file. It is required to enter the SKUs, Quantity, and Sending and Receiving Warehouses.
    1. From / To Warehouse – the Warehouse you will be deducting From and adding To.
    2. From / To Product ID – the SKU you will be deducting From and adding To.
    3. Qty – the quantity to be transferred.
    4. Serial Numbers – not needed if you don’t use such.
  4. Go back to Sellercloud and click Choose file.
  5. Click on Upload File.
  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.

Transferring SKUs To and From Bin-enabled Warehouses has to be done through Skustack.

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.
  • If the clients 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

  • When enabled, Zero Cost SKUs will be taken into account for average cost adjustments.
    • If you transfer a $0 cost SKU and enable the setting after, the Average Costs will not be recalculated retroactively.
The average cost of the SKU you’re transferring From will remain the same. Only the average cost of the SKU you’re transferring To will be affected.

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for?
Contact Support