Rubi Picks

Picks by Rubi

$12.44 - $33.96

Item Object
(
    [ItemID] => 44961
    [ProductItemID] => 45239
    [OptionGroups] => Array
        (
            [114] => 7042
        )

    [UserPrice] => 
    [RetailPrice] => 32.90
    [ImageFolderName] => Rubi
    [ItemImage] => 82971.png
    [ItemCost] => 19.19
    [ManufacturerID] => 54
    [ManufacturerName] => Rubi
    [SKU] => 261062
    [MPN] => 82971
    [UPC] => 
    [GTIN] => 
    [CartDescription] => PICK 88,2 Oz. (2.500 gr.) 82971 
    [ItemNotes] => 
    [Length] => 10
    [Width] => 5
    [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 = 45239 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] => 6349
                            [ProductItemID] => 45239
                            [ItemID] => 44961
                            [ItemAvailable] => Available
                            [ManufacturerID] => 54
                            [SKU] => 261062
                            [MPN] => 82971
                            [UPC] => 
                            [GTIN] => 
                            [ItemCost] => 19.19
                            [Weight] => 1
                            [Length] => 10
                            [Height] => 1
                            [Width] => 5
                            [ItemNotes] => 
                            [ItemImage] => 82971.png
                            [CartDescription] => PICK 88,2 Oz. (2.500 gr.) 82971 
                            [HandlingTypeID] => 1
                            [SurchargeID] => 0
                            [CombineTypeID] => 2
                            [GroundOnly] => 
                            [FlatShipping] => 0
                            [InfoVerified] => 
                            [MinimumQuantity] => 1
                            [PackageQuantity] => 1
                            [ItemDateCreated] => 2012-07-25 16:28:54
                            [ManufacturerName] => Rubi
                            [ImageFolderName] => Rubi
                            [RetailPrice] => 32.90
                            [UserPrice] => 
                            [SelectedItemGroupings] => 114:7042
                        )

                )

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

    [AdminMode:protected] => 
)
ss			

Rubi Picks

  • Made of Special Tempered Steel
  • Highly Resistant at Breaking Point
  • Normalized Heat Treatment and Tempered Tip
  • Picks don't Include the Handle
  • Quantity: 1

Available Options

Name Reference
PICK 88,2 Oz. (2.500 gr.) 82971
PICK 105,8 Oz. (3.000 gr.) 82972
PICK HANDLE 82973

Customer Reviews and Ratings

No reviews yet! Be the first to review this product.

Review This Product

Product Shipping Information

You will be able to estimate shipping amount to your specific destination for your entire cart during the checkout process.

General shipping Information

You may also be interested in:

Copyright © 2012-2020 Pro Source Center
BBB Accredited: A+ Rating
Visa MasterCard Discover American Express