eCart5 - "Add To Cart" button setup

Hi.
After finishing my database,now I am trying to add the "Add To Cart button" for each product in my webpage.
I inserted 4 buttons in my webpage and then when I click on the buttons these problems happen:

Problem no 1:
I do not see 4 of my 6 column from database. I see only ProductName and ProductSKU.

This is the structure of my database:
ProductID, ProductSKU, ProductName, ProductCategoryID, ProductPrice, ProductThumb.

Problem no 2:
When I click on all 4 "Add to Cart" buttons (e.g. simulation for buying 4 different product), I see only the same ProductName/ProductSKU.

See attachment.
Thank you in advance and appreciate your assistance as you did so far.

1) not all of the cart columns will be added to the cart display by default.

When you add the cart display manager, the second step will allow you to specify which cart columns are added to the display. If you want to show them all, you will need to add them when creating the cart display using the Display Manager.

2) It sounds like all items are using the same ID.

Can you send a copy of your page so I can see how you have configured the add to cart buttons.

This post has been deleted.

In the binding column used to configure each button you have a window with preset columns starting with ID. You have to add a value for each of those you want to appear in the cart. To use price as an example, you highlight price and then in the value window below enter the price for the item. You don't need to add the $ sign. Do this with each item. Do not change to Quantity configuration however. It needs to remain 0 and updatable. Try this with one button and see what happens. Good luck

Hi Dave,
Thanks for your reply. I think your explanation is for static "Add to Cart" button if I understood well. I do dynamic add to cart, it means the informations are supposed to be retrieved from my database.
You can see the snap shot of Bindding display I have.
Thanks again.

It looks like you are properly binding the columns in your add to cart. However, if you are always adding the same item the values in the add to cart must be all working with the same record. Each of the add to cart buttons should either be filtering the recordset for that specific item, or you should have recordsets for each of the items on the page.

Hi Eric,
I have 6 columns in my database and recordset and I need to show all of them in Shopping Cart page, so I do not need to filter any column if I understood well your point.
Please see the 2 attachments (database jpg and shopping cart.php)in my previous post and here 2 more snapshot from my recordset and DW Server Behaviors setup. It may help you to see my setup and help me to find a solution.
Thanks.

The problem is that your add to cart server behaviors are all referencing your unfiltered recordset. For example all of the add to carts on the page have the name set like this:

$ATC_itemName = "".$row_rsClassyJewelers['ProductName']  ."";// column binding

Since the recordset is not filtered you will only ever get the first item in the recordset added to the cart regardless of what button you press.

To resolve this problem with your current page setup you will either need to add another rs that is filtered by the product id, or you can add individually filtered recordsets for each item.

If you have a repeat region for all of the add to cart buttons and have the values bound in there forms then you do not need to use an add to cart from recordset, you can just use a static value add to cart.

  ...., you can just use a static value add to cart.  

Since I have more than 400 items in my website and I was told here by Technical Support that it's better to make a dynamic add to cart and making a database. I spent almost more than a month for setup and it's not still done.
I recreated a new Recordset and filtered by ProductID.
It does not work and besides when I click on each "Add to Cart" button it does not redirect any more to the "shopping cart" page.
Please see the snap shot to make sure if I did it correctly.

Thank you for the updated info on this. I will need to check into this a little more to test out some things. In the mean time you should be able to get it to work by adjusting the filter that you have on this recordset. Instead of a URL parameter you should be referencing a form value. The value should be eCart1_1_ID_Add.

I think that this will get things working for you, post back if not to let us know. I will look into this to see if there is a problem with the internal code for the add to cart from rs.