Re: the dreaded unitShipCost

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53787
interpreted = N
texte = Why don't you stop the cart sweep then you wouldn't have to go through this. On Tuesday, November 4, 2003, at 12:15 PM, Andrew Simpson wrote: > okay. this has me going completely nuts. > > In one of our stores, you can add stuff to the cart and it calculates > the > price, unitshipcost and tax based on the formulas database. > > the code that runs when you add something to your cart is as follows: > > [AddLineItem > cart=[newcart]&sku=[sku]&db=/db/products.db]quantity=1[/AddLineItem] > > now, each time a user adds something to his cart i record this in a > database > so that, if they ever return to the site and log in again, i can > ressurect > the contents of any un-purchased carts. The reason i store it in the > database is because the carts directories get cleared out every 1440 > minutes > or something... so they are not always available. the above code works > fine > and adds price, shipcost and tax perfectly each time. > > the problem i have is that when somebody returns to the site and the > code > runs to re-add the contents of their old cart to their new one, it > completely misses the unitshipcost. > > here is the code that re-adds the products: > > [search > db=/db/ > existing_detail.db&eqEXISTING_IDdatarq=[EXISTING_ID]&asLINE_IDsort=1& > LINE_IDtype=number] > [founditems] > [AddLineItem > cart=[newcart]&sku=[PROD_SKU]&db=/db/products.db]quantity=1[/ > AddLineItem] > [/founditems] > [/search] > > > now i don't understand why the unitshipcost is calculated correctly and > available in the first instance and not in the second. does anybody > have any > ideas???? > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  2. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  3. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  4. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  5. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  6. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  7. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  8. Re: the dreaded unitShipCost ( John Peacock 2003)
  9. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  10. Re: the dreaded unitShipCost ( Alain Russell 2003)
  11. Re: the dreaded unitShipCost ( Alain Russell 2003)
  12. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  13. Re: the dreaded unitShipCost ( John Peacock 2003)
  14. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  15. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  16. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  17. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  18. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  19. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  20. Re: the dreaded unitShipCost ( Tim Robinson 2003)
  21. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  22. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  23. the dreaded unitShipCost ( "Andrew Simpson" 2003)
Why don't you stop the cart sweep then you wouldn't have to go through this. On Tuesday, November 4, 2003, at 12:15 PM, Andrew Simpson wrote: > okay. this has me going completely nuts. > > In one of our stores, you can add stuff to the cart and it calculates > the > price, unitshipcost and tax based on the formulas database. > > the code that runs when you add something to your cart is as follows: > > [AddLineItem > cart=[newcart]&sku=[sku]&db=/db/products.db]quantity=1[/AddLineItem] > > now, each time a user adds something to his cart i record this in a > database > so that, if they ever return to the site and log in again, i can > ressurect > the contents of any un-purchased carts. The reason i store it in the > database is because the carts directories get cleared out every 1440 > minutes > or something... so they are not always available. the above code works > fine > and adds price, shipcost and tax perfectly each time. > > the problem i have is that when somebody returns to the site and the > code > runs to re-add the contents of their old cart to their new one, it > completely misses the unitshipcost. > > here is the code that re-adds the products: > > [search > db=/db/ > existing_detail.db&eqEXISTING_IDdatarq=[EXISTING_ID]&asLINE_IDsort=1& > LINE_IDtype=number] > [founditems] > [AddLineItem > cart=[newcart]&sku=[PROD_SKU]&db=/db/products.db]quantity=1[/ > AddLineItem] > [/founditems] > [/search] > > > now i don't understand why the unitshipcost is calculated correctly and > available in the first instance and not in the second. does anybody > have any > ideas???? > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Stuart Tremain

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:

Setting up WebCatalog with Retail Pro data (1996) OT Spell Check (2003) WebCatb15 Mac CGI -- [purchase] (1997) This list needs a digest: rant, rave... (1997) [Sum] function? (1997) RE: How much ram??? (1997) Almost a there but..bye bye NetCloak (1997) How to add commas to number displays (2004) Not really WebCat (1997) Country & Ship-to address & other fields ? (1997) Why isn't this working (1999) Multi-processor Mac info ... (1997) Smart caching problems with 2.1b3? (1997) why .HTML pages no processing? (2000) Math Problem - Format? (1997) all records returned. (1997) trouble updating records in database (1998) iis 4.0 (1997) [/application] error? (1997) [WebDNA] Re:BCC and/or Character limit [sendmail] (2010)