disappearing SKU (etc.) fields
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20627
interpreted = N
texte = Ideas please on what I'm might possibly be missing!?!Here's the situation: I have one SKU (out of approx. 250) that isn't appearing on the details page...so there's no price shown, link to purchase, etc. either.You can see for yourself...go to the store, click on the New link, and this particular product -- 1001 Ways to be Romantic (book) -- will be near the top of the search results:http://www.me2u.com/GiftStore/At the bottom, you'll note that the SKU info isn't appearing for this just-added product.More details:1) a store search does a look up against ITEMS db first; so, for example, the new search turns up the ITEM SBK059 (the 1001 Ways book) in the search results.2) to see price and other details for a particular item, a second db is searched to retrieve the SKU(s) related to the selected ITEM. In this case, it should find one SKU, SBK059A, along with the price and weight (etc.) for this item.3) that's how it *should* work...but isn't for this one SKU. So I'll describe steps taken so far...4) steps already taken: -- scrutinized the SKU db and uploaded it (and yes, flushed old...) -- scrutinized the ITEMS db and uploaded it -- rebuilt both db's (from FMPro) and uploaded them5) next steps?????-- I'm going to look at the HTML for the details page tomorrow, but that seems unlikely (again, seems to be the only SKU out of 250 affected!)-- I'd greatly appreciate ideas of other things to try (am running out of ideas and am really surprised that this problem still lingers after examining and re-examining the db's....)TIA,Dale
Associated Messages, from the most recent to the oldest:
Ideas please on what I'm might possibly be missing!?!Here's the situation: I have one SKU (out of approx. 250) that isn't appearing on the details page...so there's no price shown, link to purchase, etc. either.You can see for yourself...go to the store, click on the New link, and this particular product -- 1001 Ways to be Romantic (book) -- will be near the top of the search results:http://www.me2u.com/GiftStore/At the bottom, you'll note that the SKU info isn't appearing for this just-added product.More details:1) a store search does a look up against ITEMS db first; so, for example, the new search turns up the ITEM SBK059 (the 1001 Ways book) in the search results.2) to see price and other details for a particular item, a second db is searched to retrieve the SKU(s) related to the selected ITEM. In this case, it should find one SKU, SBK059A, along with the price and weight (etc.) for this item.3) that's how it *should* work...but isn't for this one SKU. So I'll describe steps taken so far...4) steps already taken: -- scrutinized the SKU db and uploaded it (and yes, flushed old...) -- scrutinized the ITEMS db and uploaded it -- rebuilt both db's (from FMPro) and uploaded them5) next steps?????-- I'm going to look at the HTML for the details page tomorrow, but that seems unlikely (again, seems to be the only SKU out of 250 affected!)-- I'd greatly appreciate ideas of other things to try (am running out of ideas and am really surprised that this problem still lingers after examining and re-examining the db's....)TIA,Dale
Dale Stokdyk
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[OT] HTML Table Cell Problem (2003)
Multiple Selections in Pull-Down Menu (2000)
WebCatalog/Mac 2.1b2 - PIXO (1997)
Location of Browser Info.txt file (1997)
Upgrading old WebCat Database Files (1997)
Logging purchases (1997)
WebStar CGI Version (2005)
Dummy Credit Card Number for debug? (1997)
Time Tracking (2003)
international time (1997)
Errant Email. (1998)
SQL Madness (2005)
Attention SM: Trigger Bug? (2000)
My solution... (1996)
PCS Customer submissions ? (1997)
SSL problems (2002)
multi-paragraph fields (1997)
Next X hits (1996)
Fwd: Problems with Webcatalog Plug-in (1997)
Migrating to NT -Reply (1997)