Rubi Mallet Black Rubber

Item Object
(
    [ItemID] => 44886
    [ProductItemID] => 45149
    [OptionGroups] => Array
        (
            [114] => 6987
        )

    [UserPrice] => 
    [RetailPrice] => 10.07
    [ImageFolderName] => Rubi
    [ItemImage] => 66920.png
    [ItemCost] => 5.87
    [ManufacturerID] => 54
    [ManufacturerName] => Rubi
    [SKU] => 260976
    [MPN] => 66920
    [UPC] => 
    [GTIN] => 
    [CartDescription] => BLACK RUBBER HAMMER L. 250 gr. 66920 
    [ItemNotes] => 
    [Length] => 12
    [Width] => 1
    [Height] => 1
    [Weight] => 1
    [HandlingTypeID] => 1
    [SurchargeID] => 0
    [CombineTypeID] => 2
    [InfoVerified] => 
    [ItemAvailable] => Available
    [MinimumQuantity] => 1
    [PackageQuantity] => 1
    [SurchargeName] => 
    [Surcharge] => 
    [SubsequentSurcharge] => 
    [SurchargeLimit] => 
    [IsMinimum] => 
    [CombineTypeName] => 
    [UpperLimit] => 
    [InBox] => 
    [MaxWeight] => 
    [HandlingName] => 
    [USHandlingMultiplier] => 
    [TerritoryHandlingMultiplier] => 
    [CanadaHandlingMultiplier] => 
    [IntlHandlingMultiplier] => 
    [USExpressMultiplier] => 
    [TerritoryExpressMultiplier] => 
    [CanadaExpressMultiplier] => 
    [IntlExpressMultiplier] => 
    [FMName] => 
    [FMOption] => 
    [FMPrice] => 
    [FMNotes] => 
    [FMManufacturerID] => 
    [FMAvailability] => 
    [Cost] => 
    [NumericSKU] => 
    [Fields:protected] => 
    [LastUpdated] => 
    [DB:protected] => Util_Query Object
        (
            [name:Util_Query:private] => ItemValues
            [statement:Util_Query:private] => 
			SELECT ProductID, productitems.ProductItemID, items.*, ManufacturerName, ImageFolderName, 
			retail.Price AS RetailPrice, IFNULL(userprice.Price, ( ItemCost / (1 - UserMargin/100) ) ) AS UserPrice,
			GROUP_CONCAT( 
				DISTINCT CONCAT( 
					REPLACE(FORMAT(optiongroups.GroupID,0),',',''),
					':',
					REPLACE(FORMAT(optiongroups.OptionID,0),',','') 
				) ORDER BY optiongroups.GroupID, optiongroups.Priority SEPARATOR ',') AS SelectedItemGroupings
			FROM productitems
			INNER JOIN items ON items.ItemID = productitems.ItemID
			INNER JOIN manufacturers ON manufacturers.ManufacturerID = items.ManufacturerID
			LEFT JOIN optionsets ON optionsets.ProductItemID = productitems.ProductItemID
			LEFT JOIN optiongroups ON optiongroups.OptionGroupID = optionsets.OptionGroupID
			LEFT JOIN groups ON optiongroups.GroupID = groups.GroupID
			LEFT JOIN options ON options.OptionID = optiongroups.OptionID
			LEFT JOIN pricelists retail ON retail.ProductItemID = productitems.ProductItemID AND retail.UserID = 1
			LEFT JOIN pricelists userprice ON userprice.ProductItemID = productitems.ProductItemID AND userprice.UserID = %s
			LEFT JOIN usermanufacturers um ON um.ManufacturerID = manufacturers.ManufacturerID AND um.UserID = %s
			WHERE productitems.ProductItemID = %s AND items.ItemAvailable != 'NOT DISPLAYED'
			GROUP BY productitems.ProductItemID
            [query:Util_Query:private] => 
			SELECT ProductID, productitems.ProductItemID, items.*, ManufacturerName, ImageFolderName, 
			retail.Price AS RetailPrice, IFNULL(userprice.Price, ( ItemCost / (1 - UserMargin/100) ) ) AS UserPrice,
			GROUP_CONCAT( 
				DISTINCT CONCAT( 
					REPLACE(FORMAT(optiongroups.GroupID,0),',',''),
					':',
					REPLACE(FORMAT(optiongroups.OptionID,0),',','') 
				) ORDER BY optiongroups.GroupID, optiongroups.Priority SEPARATOR ',') AS SelectedItemGroupings
			FROM productitems
			INNER JOIN items ON items.ItemID = productitems.ItemID
			INNER JOIN manufacturers ON manufacturers.ManufacturerID = items.ManufacturerID
			LEFT JOIN optionsets ON optionsets.ProductItemID = productitems.ProductItemID
			LEFT JOIN optiongroups ON optiongroups.OptionGroupID = optionsets.OptionGroupID
			LEFT JOIN groups ON optiongroups.GroupID = groups.GroupID
			LEFT JOIN options ON options.OptionID = optiongroups.OptionID
			LEFT JOIN pricelists retail ON retail.ProductItemID = productitems.ProductItemID AND retail.UserID = 1
			LEFT JOIN pricelists userprice ON userprice.ProductItemID = productitems.ProductItemID AND userprice.UserID = -1
			LEFT JOIN usermanufacturers um ON um.ManufacturerID = manufacturers.ManufacturerID AND um.UserID = -1
			WHERE productitems.ProductItemID = 45149 AND items.ItemAvailable != 'NOT DISPLAYED'
			GROUP BY productitems.ProductItemID
            [type:Util_Query:private] => SELECT
            [context:Util_Query:private] => 
            [result:Util_Query:private] => Array
                (
                    [0] => Array
                        (
                            [ProductID] => 6315
                            [ProductItemID] => 45149
                            [ItemID] => 44886
                            [ItemAvailable] => Available
                            [ManufacturerID] => 54
                            [SKU] => 260976
                            [MPN] => 66920
                            [UPC] => 
                            [GTIN] => 
                            [ItemCost] => 5.87
                            [Weight] => 1
                            [Length] => 12
                            [Height] => 1
                            [Width] => 1
                            [ItemNotes] => 
                            [ItemImage] => 66920.png
                            [CartDescription] => BLACK RUBBER HAMMER L. 250 gr. 66920 
                            [HandlingTypeID] => 1
                            [SurchargeID] => 0
                            [CombineTypeID] => 2
                            [GroundOnly] => 
                            [FlatShipping] => 0
                            [InfoVerified] => 
                            [MinimumQuantity] => 1
                            [PackageQuantity] => 1
                            [ItemDateCreated] => 2012-07-25 16:01:09
                            [ManufacturerName] => Rubi
                            [ImageFolderName] => Rubi
                            [RetailPrice] => 10.07
                            [UserPrice] => 
                            [SelectedItemGroupings] => 114:6987
                        )

                )

            [rownum:Util_Query:private] => 1
            [foundRows:Util_Query:private] => 
            [loopFunction:Util_Query:private] => 
            [affectedRows:Util_Query:private] => 
            [database] => saunder_Store
        )

    [AdminMode:protected] => 
)
ss			

				
			
					

			

				

					    			
    			

			    
								

									
									$10.07
								
				
									
					
							

			    	

    					

				Qty: