Any way to go to assoicated product in pull down?

I have tried all the many options (Grouped products / associated products / attributes / attributes linked to products) and I still can't quite get the store to do what I want.  Before I build something let me know if I am missing it or if there is already a plug in for this.

Lets say I sell a screw, it is the same screw but has 3 different sizes.
Screw 1 - 2" Sku 1234 - $1
Screw 2 - 3" Sku 5678 - $1.50
Screw 3 - 4" Sku 9012 - $2

If the user goes to the screw 1 page I want them to be able to see the details and sku for screw one and add to the cart (which they can do) but I also want them to see a pull down with the other options that you can select a 3" or 4" of these screw.  If the user selects 3" I want it to take you to the 3" screw product page which now has the 3" sku and price ect.

I have set up all 3 skus and all display fine by themselves.  I tried setting up Product attributes for each and linking to a product but it adds the prices of the products I link to together and also does not take you to the new product if you select from a pull down.  If you Got to screw 1 select screw 2 and add to the cart it add screw 1 still.

Here is an example of roughly how I would like it to work.  If you go here

https://www.fastenal.com/products/details/37014

you will see a nut.  There is also an option to buy this same nut in a pack of 100.  If you click that it takes you to the product with a new page / sku / price ect.

Making them related products does not give me the nice drop down that I want where I can label it "Screw Length" and have a nice drop down that quickly shows the differences.

However when I do a Product Attribute I can do all that, but it won't take me to the product that is selected when I change the attribute I want.

Any help?

THanks

What you need to do on the screw product in admin is click into Product Attributes >> then click the Attribute Combinations tab..here is where you define your various sizes, stock levels, skus, and price differentials. This will cause a drop down to appear on the product page allowing the customer to choose which size they want and price adjusts accordingly...no need to send them to another page.

As a further example, if you sell a zinc version and stainless version of the screws, they too would need to be set up in attribute combinations so that the customer sees a drop down showing zinc and stainless options at each of the available sizes...with their price differentials shown adjacent.

So you might have the following attribute combinations defined for a single screw product:
1/4" stainless
1/2" stainless
1" stainless
1 1/4" stainless
1 1/2" stainless
2" stainless
3" stainless
1/4" zinc
1/2" zinc
1" zinc
1 1/4" zinc
1 1/2" zinc
2" zinc
3" zinc

..each with their own stock level, SKU, and price.

Oh ....and if you don't see the Attribute Combinations tab, it's because you currently have that product set to "Track Inventory"...you need to set it to "Track inventory by product attributes" instead...

Hope this helps!

It still puts the original part sku in the shopping cart.  I need all these products to have their own part number so people can get to the 2" screw directly.  I just want an easy option for them to select the other attributes and take them to that part (or at least check out with that item), but I am thinking it cannot do that which is strange since it does appear you can associate other parts to attributes.

bobarmstrong wrote:

When you are inputting your product attribute combinations, there is a space to input each attribute combination's SKU, MPN, GTIN, current stock level, minimum stock level and a few other things...just be sure to input each attribute combination's SKU, then, when it is added to cart, it's SKU will appear and not the product's master SKU.

Thanks for the reply.

I am using 3.4 and what you describe is exactly how I feel like it should work but sadly it does not.  
No matter what I do when I add the item to the cart and look at the cart they all have the same main part number SKU.  

I tried to reproduce in demo store but they do not show a SKU column on the checkout screen.  The description of the part shows the new attribute I selected but the sku stays the same and does not take out of the corrects parts inventory.

Really wish this worked or there was an easy way to switch between parts that are in the same product attribute group.

bobarmstrong wrote:

Are you absolutely certain that you've specified a unique value for the SKU of each of your attribute combinations?
On one of my client's sites we differentiate the attribute combinations from the master product SKU like this, for example:
972-W-7R    (product master SKU - color indicator - size and left/right indicator)

I have at least 5 different client's sites running 3.40 and all of them work correctly, so there must be a problem with your configuration.
Example:
Go here and add any size to your cart, then go check out and see how it knows the correct SKU..
http://www.myfootshop.com/hallux-trainer-insoles

Just to clarify:
After you go to >> Product Attributes tab and input your Attributes for a product, [size and/or material(zinc or stainless) and/or finish (chrome or brass or nickel)] (this is also where you upload more specific photos of the different attributes -optional)...
You probably prefer to define size attributes using a drop down type of control, and you might prefer check boxes for the finish and material attributes... your decision...

After adding each of the attribute types(size, color, finish, material, etc.) and values (customer choices) as I've described, you will click on the Attribute Combinations tab, and then add new combination..select one of the attributes you just created, then input it's unique SKU and other info..save..or you can click the generate all combinations button, then edit their SKU's, which is usually quite a bit quicker if you have many possible combinations for the product.

By doing it this way, not only does it make for a simpler customer experience, but it allows you complete control over pricing differentials. For example, when creating the attributes, you can specify that brass costs an additional $0.10 each and that the 3" size costs an additional $0.30 each, and when the customer chooses a 3" brass screw, the system will automatically calculate and display the additional $0.40 each.


Afterthought:

There is a setting in admin >> configuration >> settings >> catalog settings:
Enable dynamic price update:

Make sure it is checked so that when a customer chooses an option which has a price differential defined, the price on page is updated on the fly to reflect the price of that particular attribute combination.

Thanks again, Yep I am sure I have it set up correctly.  It enters it as two items in shopping cart when selecting different attributes, if I check database the xml attribute fields are all filled out correctly.  I see there is no sku field in shopping cart database so it has to be pulling that sku in real time.  Checked all the tables and all the IDs line up and the sku is there but it just doesn't pull it for proper display.  Very strange.

I think I am just going to have to build the drop down to go to the associated part page anyway as unlike your sample site all these screws need to have their own sku/product/page as I blast out the order in EDI after I get it in and am importing it from a supplier where these are all individual line items.  I just wanted a quicker way for them to jump from one size to another and hoped I could do it with these attributes and associated parts.

Oh well...I tried. I just can't imagine having thousands of pages of products when you only need a couple hundred. The only advantage I can see is that you'll have many more potential URL's for Google to index....but at the expense of the customers having to click through that many pages of results to find what they need...hope you plan to use Specification Attributes for filtering at least..

Good luck-

Steve