close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Need to add SKU to eCart

Thread began 8/09/2021 12:32 pm by Peterson Design Studio - jefferis | Last modified 8/12/2021 11:11 am by Ray Borduin | 136 views | 15 replies |

Peterson Design Studio - jefferis

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

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?

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

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.

Sign in to reply to this post

Ray BorduinWebAssist

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?

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

Peterson Design Studio - jefferis

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!

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...