1. SC Purchase Orders


  1. BTX to FBA transfer suggestion
  2. FOR NOW: Create SC Order Using Product List and Qty
    • GOAL: Receive all inventory into BTX warehouses in SC
  3. Then receive PO into FBA TEMP


2. Create FBA Shipment


  1. SELECT CAST(pu.ID AS NVARCHAR(50)) + ' ' + pu.PurchaseTitle AS ShipmentName,
    ISNULL(ptfs.SellerSku,(SELECT TOP(1) seller_sku FROM dbo._GET_AFN_INVENTORY_DATA_ WHERE ProductID = pui.ProductID ORDER BY Quantity_Available DESC, bvcP.DateCreated DESC)) AS ProductID,
    --pui.ProductID,
    pui.QtyOrdered As Qty,
    bvcP.QtyPerCase
    FROM [BTX.SELLERCLOUD.COM].SC.dbo.PurchaseItem pui
    LEFT JOIN dbo.ProductsLookups pl ON pl.ProductsLookupID = pui.ProductID
    LEFT JOIN [BTX.SELLERCLOUD.COM].SC.dbo.Purchase pu ON pu.ID = pui.PurchaseID
    LEFT JOIN dbo.ProductToFNSkus ptfs ON ptfs.ProductID = pl.ProductID
    LEFT JOIN [BTX.SELLERCLOUD.COM].SC.dbo.bvc_Product bvcP ON bvcP.ID = pui.ProductID
    WHERE pui.PurchaseID IN (3671,3672)
    ORDER BY pu.PurchaseTitle
  2. Import to SC
  3. Edit shipment ship from address
  4. edit shipment ship from warehouse
  5. preview shipment
  6. set status to working for all packages


3. Box Contents


EXEC dbo.Z_Sp_SelectBoxContentNew_ByPackageAndPO @PackageID = 7353, -- int                                                 @PurchaseID = 4203 -- int


4. Create AMT PO

  1. EXEC dbo.SP_Create_AMTPOs_FromSC_FBAShipmentPackages @PONumber = 4205, -- int
                                                         @PackageID = 7352 -- int
  2. For multiple shipments use this per shipment = EXEC dbo.SP_Create_AMTPOs_FromSC_FBAShipmentPackages 3484, 6824 =
  3. Excel File: paste > change to text > paste again
  4. \\bentex-amt2\EcommerceIntegration\BentexOrder\InputRequest


5. Create Shipment for Tact


EXEC dbo.SP_Create_WarehouseShipment @Warehouse = N'TACT_CA', @ShipmentID = N'1855'


6. Box Contents For New Version Shipments


Z_Sp_SelectBoxContentNew_ByPackage '6944'

 

EXEC dbo.Z_Sp_SelectBoxContentNew_ByPackage @PackageID = 7364 -- int


7. Create AMT control from the SC PO


SP_Create_AMTPOs_FromSC_FBAShipmentPackages_WList
 
PO # + package IDs


8. Create Shipment From Transfer ID


EXEC dbo.SP_Create_WarehouseShipment_FromSCTransfer @Warehouse = N'TACT_CA',  @SCTransID = 4664


9. Create Item Receipt From Inbound


SP_Create_WarehouseInbound_FromAMTInbounds