ALTER PROCEDURE [dbo].[eBayInventory_s] 
@ProductID NVARCHAR(50)
AS
DECLARE @Numeric BIT
DECLARE @CompanyID INT
DECLARE @ChannelID INT = 1 --for ebay

SELECT @ProductID = ISNULL(NULLIF(p.ShadowOf, ''), p.ID), 
	@CompanyID = p.CompanyID
FROM bvc_Product p
WHERE p.ID = @ProductID

SELECT @Numeric = ISNUMERIC(CartCode)
FROM CompanyWarehouseCartCode
WHERE CompanyID = @CompanyID
	AND Channel = @ChannelID

SELECT CASE 
		WHEN InventoryAvailableQty <= 0
			THEN 0
		WHEN @Numeric = 0
			AND InventoryAvailableQty > 0
			THEN InventoryAvailableQty
		WHEN @Numeric = 1
			AND InventoryAvailableQty > 0
			THEN
				--If there is 0.75 units after calculating percentage, then send 1. For example, available 3 and percentage set to 25%
				CASE 
					WHEN (p.InventoryAvailableQty * cwcc.CartCode) >= 0
						AND (p.InventoryAvailableQty * cwcc.CartCode) < 100
						THEN 1
					ELSE ((p.InventoryAvailableQty * cwcc.CartCode) / 100)
					END
		END AS Qty
FROM dbo.bvc_Product p
INNER JOIN dbo.CompanyWarehouseCartCode cwcc ON cwcc.CompanyID = p.CompanyID
WHERE p.ID = @ProductID
	AND cwcc.Channel = @ChannelID