Need to add SKU to eCart

Hi Ray, the site you helped me work on a while back is working, but the client needed to have the Product SKU show and not just the item number. I have successfully added the SKU to products results and products detail pages, but I can't seem to get it to display in the eCart. cart page. Not sure it would carry over to the checkout pages either since i haven't gotten that far... Any help appreciated. I tried adding <p id="eCart1_JSON_Display_Description_<?php echo $eCart1->DisplayInfo("WAUID"); ?>" class="eC_ItemDescription min_tablet"><?php echo $eCart1->DisplayInfo("Description"); ?><br />
<?php echo $eCart1->DisplayInfo("ProductSKU"); ?></p> to the cart page, and it throws no php errors, but it doesn't display the SKU

Hope I don't have to redo the entire cart :-0

TIA,

Jeff

You have to open the cart object and add the column:
ProductSKU

then you have to update your add to cart server behaviors on your products_details.php page and set the sku to come from your database.

I wish I used this program weekly, so I wouldn't forget how to use it :-)
I had already gone into cart object When I open the eCart Add to Cart bindings, even though I have the Query showing the ProductSKU, it is not showing as an option in the Database binding only in the $eCart Is that correct?

Query: SELECT ProductID, ProductSKU,ProductName, ProductImage, ProductName, ProductShortDesc, ProductLongDesc, WholesalePrice, ProductPrice, ProductShortDesc, ProductLongDesc
FROM products
WHERE products.ProductID = ParamProductID LIMIT 1 Is t


ALSO, IMPORTANT THE ADD TO CART BUTTON IS ALSO ON THE PRODUCT RESULTS PAGE, SO I NEED TO RUN THE CART 2 TIMES?

First you have to edit the cart object itself and add the column there. Webassist->eCart->eCart Object

I had already done that. Now instead of showing the productSKU field it is showing something like the Product ID., but it is conflated with other numbers not in the Product ID. The SKU is displayed as text.
this is the code in the dynamic text:
<?php echo $eCart1->DisplayInfo("ProductSKU"); ?>

This is what displays:
4" CORRUGATED COUPLING 20/CT

162853598174297145

the product id is 6803664 SKU is 01 C204

Not sure what is displayed.

Can you give me FTP access and a URL to test with? I'll take a look.

Are you sure you uploaded the new eCart object after editing it?

Yes I uploaded the WA cart files that had been modified.

You hadn't updated your Add to Cart server behaviors on the results or details pages. I've updated them to add the SKU for you and it seems to work now.

Geez, i thought I had. Do you need to update it on every page? Or is the add to cart update Global? I have it on the product results and detail page.
In any case, thanks!

Any page that has an Add to Cart button would need to be updated.