Zero Out Inventory Items

[DynamikArray]

Try zeroing out Official Marvel Handbook Master Edition Marvel 411 Lot Comic Book Comics Set Run

[DynamikArray]

LAST THING I USED , returns an active listing if it exists, this should be good enough to use for the remaining steps?

DECLARE @ebayLots NVARCHAR(MAX);
                  DECLARE @url VARCHAR(255) = CONCAT('https://s3-eu-west-1.amazonaws.com/images.linnlive.com/', lower(CONVERT(VARCHAR(32),HASHBYTES('MD5', CONVERT(VARCHAR(32), DB_NAME())), 2)) , '/');
                  SET @ebayLots = 'EBAY-LOTS';

                  SELECT
                      si.pkStockItemID,
                      si.CreationDate,
                      CONCAT(@url,LOWER(CONVERT(VARCHAR(40), sir.pkImageId)),'.jpg') AS 'Image',
                      si.ItemTitle,
                      si.ItemNumber,
                      il.BinRackNumber as LocationCode,
                      sl.Quantity,
                      sl.InOrderBook,
                      ep.IssueNumber as TotalIssues,
                      lp.LastPrice as CurrentListingPrice,
                      CAST(lp.LastPrice as money) / CAST(ep.IssueNumber as int) as PerComicPrice,
                      rp.repackPending,
                      et.ListingStatus,
                      et.ChangedDate,
                      et.CreatedDate,
                      templates.*
                     
                  FROM
                      StockItem si
                      
                     
                      
                  LEFT OUTER JOIN ProductCategories pc ON si.CategoryId = pc.CategoryId
                  LEFT JOIN Stock_ImageReg sir on ((sir.fkStockItemId = si.pkStockItemID) AND (sir.IsMain = 1))
                  LEFT OUTER JOIN StockLevel sl on si.pkStockItemId = sl.fkStockItemId
                  LEFT OUTER JOIN StockLocation sLoc on sl.fkStockLocationid = sLoc.pkStockLocationId
                  LEFT OUTER JOIN ItemLocation il on il.fkStockItemId = si.pkStockItemID AND il.fkLocationId = sLoc.pkStockLocationId
                  LEFT OUTER JOIN eBay_Templates2 et on et.fkInventoryItemId = si.pkStockItemID
                  
             
                  LEFT OUTER JOIN (
                    SELECT 
                        el.startTime,
                        el.endTime,
                        el.Qty,
                        el.Active,
                        el.RelistPending,
                        el.LastUpdateDate,
                        el.ListingPrice,
                        el.fkStockItemId,
                        el.ItemNumber
                    FROM Automation_eBayListing el 
                    WHERE Active = 1
                    ORDER BY LastUpdateDate desc OFFSET 0 ROWS
                  ) templates on templates.fkStockItemId = si.pkStockItemID
                
                  
                  LEFT OUTER JOIN (
                    SELECT si.ItemNumber, siep.ProperyValue AS [LastPrice], siep.pkRowId as 'LastPriceId'
                    FROM [StockItem] si
                    LEFT OUTER JOIN [StockItem_ExtendedProperties] siep ON si.pkStockItemID = siep.fkStockItemID AND siep.ProperyName = 'LastPrice'
                  ) lp ON lp.ItemNumber = si.ItemNumber

                  LEFT OUTER JOIN (
                    SELECT si.ItemNumber, siep.ProperyValue AS [IssueNumber], siep.pkRowId as 'IssueNumberId'
                    FROM [StockItem] si
                    LEFT OUTER JOIN [StockItem_ExtendedProperties] siep ON si.pkStockItemID = siep.fkStockItemID AND siep.ProperyName = 'Issue Number'
                  ) ep ON ep.ItemNumber = si.ItemNumber
                  
                  LEFT OUTER JOIN (
                    SELECT si.ItemNumber, siep.ProperyValue AS [repackPending], siep.pkRowId as 'repackPendingId'
                    FROM [StockItem] si
                    LEFT OUTER JOIN [StockItem_ExtendedProperties] siep ON si.pkStockItemID = siep.fkStockItemID AND siep.ProperyName = 'repackPending'
                  ) rp ON rp.ItemNumber = si.ItemNumber

                    

                  WHERE
                      (
                        (pc.CategoryName = @ebayLots)
                        AND (si.blogicalDelete = 0 )
                        AND (lp.LastPrice <> '')
                        AND (rp.repackPending = 1)
                      )
                  ORDER BY PerComicPrice
                  ```

[DynamikArray]

Log of all Books i keep messing with it.

Official Marvel Handbook Master Edition Marvel 411 Lot Comic Book Comics Set Run
Fantasy Magic The Gathering Adventurers Pestilence Autumnlands Image Idw Boom!
Dc Vertigo Unwritten American Carnage Scalped 100 Bullets Dc Vertigo 420 Lot

Manga Blade Of The Immortal Gunsmith Cats Robotech Appleseed Dark Horse - i think we have this item in stock still

Misc Books Sci Fi How To Drama Comedy Various 149 Lot Comic Book Comics Set