[FX.php List] Shopping Carts - Keep in SessionVars or Add Records right away?

[Head Honcho]

Hi Joel,

I record them immediately, and run a script weekly to "delete" non  
purchased orders.

It also helps in the reporting to see what people have started  
ordering and then dropped out, so to speak.

As Webko said, this also allows for "pausing" an order and resuming it  
later.

HTH.

Regards

Michael Ward
--
Head Honcho
CustoMike Solutions
Member, FileMaker Business Alliance
Member, FileMaker Technical Network
FileMaker 7 Certified Developer
FileMaker 8 Certified Developer
FileMaker 9 Certified Developer
FileMaker 10 Certified Developer
10 Wandoo Crt
Wheelers Hill, 3150
ph 0414 562 501
headhoncho at customikesolutions.com




On 29/07/2009, at 9:24 AM, Joel Shapiro wrote:

> Thanks Leo
>
> That's what I'd been thinking.
>
> It's good to see what different people are doing...
>
> -Joel
>
>
> On Jul 28, 2009, at 4:18 PM, Leo R. Lundgren wrote:
>
>> Yeah there's really a question of what features you want.
>>
>> The basic approach is to keep the cart in the session as session  
>> variables. There's really no need to put it all in the database,  
>> use the session for what it's worth instead :)
>>
>> BUT, keeping the cart inside the DB will allow for certain things,  
>> such as the client can put some stuff in the cart, mail his  
>> collegue, and tell him "hey, look at the stuff I put in our cart",  
>> and the collegue can do so from a totally different computer. They  
>> can collaborate.
>>
>> If that latter example isn't needed, I'd store it in the session.
>>
>>
>> 29 jul 2009 kl. 01.14 skrev Tim 'Webko' Booth:
>>
>>>
>>> On 29/07/2009, at 9:11 AM, Joel Shapiro wrote:
>>>
>>>> Hi all
>>>>
>>>> Anybody have any thoughts on *when* in shopping cart  
>>>> functionality it's best to add items as records to the database?
>>>>
>>>> My initial thinking is that it would make more sense to just keep  
>>>> items in Session Variable arrays and only add anything to the  
>>>> database at the time of Checkout -- to keep the DB from bulking  
>>>> up with unpurchased items left in the cart.  But searching  
>>>> online, it seems that carts often add records to the database as  
>>>> soon as they go into the cart.  (Might that be different when  
>>>> using MySQL as opposed to FMP?)
>>>>
>>>> FWIW - Users on this site will average 1-4 items per order.
>>>
>>> I tend to add them immediately - allows me to also re-show  
>>> previous not actually purchased items on request further down the  
>>> track...
>>>
>>> Cheers
>>>
>>> Webko
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>> -|
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>