Add to cart duplicates

I have a product page that has about 6 dog food types, some are for example chicken large and small bites. When I have my select lists for the add to cart or if I use static add to cart set for the different bags they do not go into the cart as different items.

For example, if I add a 6lbs large bites for 13.99 and a 6.6lbs small bite for 13.99 they only appear as one item in the cart instead of two different items. I have tried on two different pages and also using two different tables.

I am supposed to go live with this site on Monday and really need some help. Thanks in advance.

You can see the cart at bnbfood.php which I have changed to static items while troubleshooting.

Tim

Are you sure that they have different SKUs?

Yes if you add them individually they are fine with the correct name and description as well as price. If you had two dogs and needed one small bag of the large bites and one of the small bites of the chicken it as two of what ever you added to the cart first. When you go back to the record set and click test of both the different record sets they come back with the correct name , description etc.

I have built a different record set for each bag of food so they are all separate. They all have a product table and product category table. Inside the product table it is linked to the product category table via the product_cat_id table. The Product category has the product name in it so when you reference the cat_id in the product table its a different product.

I thought for sure if I did it with static ATC buttons it would not have the same issue as the dynamic.

Tim

Not sure I follow. So in the table you have something like this?:

SKU #: 12345LARGE
Name: Large Bytes Dry Dog Food Turkey Chicken Formula

SKU #: 12345SMALL
Name: Small Bytes Dry Dog Food Turkey Chicken Formula

Don't know why you need separate tables or record sets. Even though they have the same ingredients, they are completely different items, so they should have different SKUs.

Not sure I know what you mean by SKU?

What I'm trying to do is have a drop down list for each bag of food, with the three weights and prices. Each type of food has different prices for the different weights. The examples for ecart have not shown me how to do this however Jason from tech support was able to help get the drop down working correctly with me.

My big problem right now is that once I have all the drop downs and ATC buttons in places they are working correctly individually but like I stated, if you get one small bag of the large bite chicken and one small bag of the small bites chicken you only have one line stating say small bites chicken with a quantity of two. When it should be two lines in the cart with one line for a small bag of chicken lagre bites and one line for small bag chicken small bites. Even though these are the same price its two different items.

Tim

SKU stands for stock-keeping unit
Stock-keeping_unit

The key concept here is to make sure that each form of the same product has a unique identifier. This can be the universal SKU number (all SKUs are unique globally) or the older form of part number (internal use).

If you sold bulk, you would have one item number and one unit of measure, so you could tell the warehouse to send 14 pounds of item 12345.

If the items are in predetermined containers you would tell the warehouse to send 14 bags of item 12345 for one pound bags, or 28 bags of item 4567 for half pound bags of the same product.

You want the unique item number to contain all information needed to describe color, weight, size, type, etc.

Not sure what you worked out with Jason, but if the selection points to a unique item number, there shouldn't be any way that the selection would be grouped in with a different item.

So what you are saying if I understand it correctly, I have a product_id in my table for chicken large bites I need to make it unique in the DB and the one in the small bites unique in the DB? So that when they are added do the cart they are not grouped into one right?

Thanks,
Tim

You got it. It's very common for people to look at the ingredient as the product instead of looking at the package.

My only question with that is, the product ID in my table is the primary so would that not be unique?

It would depend on what column you are using in your cart display. You need to use a unique column through the entire process. There has to be some reason that the cart thinks they are the same item.