New Open Source Shopping Cart
I recently released a beta of a new free and open source shopping cart that I have created. It is slim on features, but built to be very easy to customize. For example, you can use externally defined products (even from multiple sources) and it is very easy to add fields to any existing tables. Blog entry: http://www.bryantwebconsulting.com/blog/index.cfm/2011/2/8/New-Open-Source-ColdFusion-Shopping-Cart Docs: http://www.bryantwebconsulting.com/docs/cart/ RiaForge: http://startercart.riaforge.org/ It runs on my new Neptune framework, so that is required to use it. http://www.bryantwebconsulting.com/docs/neptune/ http://neptune.riaforge.org/ I look forward to any feedback. Thanks! Steve ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342282 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Am I looking for a shopping cart? Or just SQL design pattern?
I've inherited a site at a customer and the previous (several) people working on this code did them no favors. For example, it's an e-commerce site and the table that records sales keeps track of the user id and the amount paid but not what product was bought or the form of payment. There actually IS a record of what the user bought but it's stored in their user record which is overwritten with each purchase so any history is lost. In addition, the site has discount-codes (coupons) but those are stored with the user, not the transaction so history is lost there too. In addition, I've noticed that discount codes are re-usable and can be edited without saving history so if you change the discount amount for future sales, running a historical report for sales involving that discount code are now bogus. I've been asked to fix this. I wonder if there is a standard pattern for the schema here since it must have been done a million times by now. I have never used an off-the-shelf shopping cart package either - I have always assumed that those are more about maintaining sessions/carts and interacting with payment gateways but it occurs to me that maybe they include the schema design I'm thinking of that allows proper accounting audit trails, etc. Any advice? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341972 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Am I looking for a shopping cart? Or just SQL design pattern?
Dave, eCommerce sites can be a bear to tackle as the requirements seem to always grow. I have used SiteDirector from QuillDesign (http://quilldesign.com) for several sites and it is a great affordable application that can be fully customized. I would imagine for the time it would take to fix your application you could purchase SiteDirector which would handle all your issues plus give you more functionality. Hope that helps. I've inherited a site at a customer and the previous (several) people working on this code did them no favors. For example, it's an e-commerce site and the table that records sales keeps track of the user id and the amount paid but not what product was bought or the form of payment. There actually IS a record of what the user bought but it's stored in their user record which is overwritten with each purchase so any history is lost. In addition, the site has discount-codes (coupons) but those are stored with the user, not the transaction so history is lost there too. In addition, I've noticed that discount codes are re-usable and can be edited without saving history so if you change the discount amount for future sales, running a historical report for sales involving that discount code are now bogus. I've been asked to fix this. I wonder if there is a standard pattern for the schema here since it must have been done a million times by now. I have never used an off-the-shelf shopping cart package either - I have always assumed that those are more about maintaining sessions/carts and interacting with payment gateways but it occurs to me that maybe they include the schema design I'm thinking of that allows proper accounting audit trails, etc. Any advice? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Am I looking for a shopping cart? Or just SQL design pattern?
this is all about normalization, there's a relationship between the user, the order and what was bought in the order. You'll have a one to many relationship between users and orders(a user can have multiple orders but an order can't have multiple users) and a many to many relationship between products and orders (an order can have multiple products and products can be in multiple orders) On Tue, Feb 8, 2011 at 9:34 AM, Dave Burns cft...@burnsorama.com wrote: I've inherited a site at a customer and the previous (several) people working on this code did them no favors. For example, it's an e-commerce site and the table that records sales keeps track of the user id and the amount paid but not what product was bought or the form of payment. There actually IS a record of what the user bought but it's stored in their user record which is overwritten with each purchase so any history is lost. In addition, the site has discount-codes (coupons) but those are stored with the user, not the transaction so history is lost there too. In addition, I've noticed that discount codes are re-usable and can be edited without saving history so if you change the discount amount for future sales, running a historical report for sales involving that discount code are now bogus. I've been asked to fix this. I wonder if there is a standard pattern for the schema here since it must have been done a million times by now. I have never used an off-the-shelf shopping cart package either - I have always assumed that those are more about maintaining sessions/carts and interacting with payment gateways but it occurs to me that maybe they include the schema design I'm thinking of that allows proper accounting audit trails, etc. Any advice? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Am I looking for a shopping cart? Or just SQL design pattern?
Thanks, Scott. I'm pretty good at data modeling so I feel like, with enough time, I can solve this problem well. But that's when it occurs to me that this has been solved by many before me who have the benefit of hindsight. Maybe I could save my client some money by either recommending they buy something or I could at least take someone else's schema and start with that instead of from scratch. BTW, it's not just about normalization. It's also thinking ahead about the requirements for audit trails, historical reporting, knowing what data can be changed and what is never allowed to change once recorded, etc. db ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Recommended Shopping Cart
Hi - I have a client that will be selling products, likely from multiple suppliers. I've programmed a CF extranet that will spit out a coupon code based on the number of points people accrue in the system. I need to integrate the coupon code, and list products by supplier where shipping rate taxes are handled effectively. I don't want to work with a crappy system, and if possible, would prefer the cart be written in CF, but I suppose that's not required. Budget is open depending on what impresses me as I'll be the one deploying it and potentially teaching low-skilled computer people how to use some of the basics. On the low end, in terms of pricing, I've recently taken a brief look at CFShopKart, and from what I can tell thus far, it looks to be supported and may provide me with what I'm looking for since I can modify as I wish. Which shopping cart / ecommerce systems do you all use? If the cart is not developed with CF, (most seem to be Php), have you needed to communicate with the cart via any of your CF applications? Thank you, Dakota ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338809 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Recommended Shopping Cart
I like CFShopKart for the same reason you do... But I posted a question here and on their forums and have not got a response yet... I am sure it's something simple. Rick -Original Message- From: Dakota Burns [mailto:dakota.bu...@gmail.com] Sent: Wednesday, November 03, 2010 3:27 PM To: cf-talk Subject: Recommended Shopping Cart Hi - I have a client that will be selling products, likely from multiple suppliers. I've programmed a CF extranet that will spit out a coupon code based on the number of points people accrue in the system. I need to integrate the coupon code, and list products by supplier where shipping rate taxes are handled effectively. I don't want to work with a crappy system, and if possible, would prefer the cart be written in CF, but I suppose that's not required. Budget is open depending on what impresses me as I'll be the one deploying it and potentially teaching low-skilled computer people how to use some of the basics. On the low end, in terms of pricing, I've recently taken a brief look at CFShopKart, and from what I can tell thus far, it looks to be supported and may provide me with what I'm looking for since I can modify as I wish. Which shopping cart / ecommerce systems do you all use? If the cart is not developed with CF, (most seem to be Php), have you needed to communicate with the cart via any of your CF applications? Thank you, Dakota ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338810 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Recommended Shopping Cart
I spent a long time reviewing cf shopping carts and the best one I found was Site Director. http://www.quilldesign.com/ Russ -Original Message- From: Dakota Burns [mailto:dakota.bu...@gmail.com] Sent: 03 November 2010 20:27 To: cf-talk Subject: Recommended Shopping Cart Hi - I have a client that will be selling products, likely from multiple suppliers. I've programmed a CF extranet that will spit out a coupon code based on the number of points people accrue in the system. I need to integrate the coupon code, and list products by supplier where shipping rate taxes are handled effectively. I don't want to work with a crappy system, and if possible, would prefer the cart be written in CF, but I suppose that's not required. Budget is open depending on what impresses me as I'll be the one deploying it and potentially teaching low-skilled computer people how to use some of the basics. On the low end, in terms of pricing, I've recently taken a brief look at CFShopKart, and from what I can tell thus far, it looks to be supported and may provide me with what I'm looking for since I can modify as I wish. Which shopping cart / ecommerce systems do you all use? If the cart is not developed with CF, (most seem to be Php), have you needed to communicate with the cart via any of your CF applications? Thank you, Dakota ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Recommended Shopping Cart
Checked their demo and that looks like a good product -- thanks! On Wed, Nov 3, 2010 at 5:01 PM, Russ Michaels r...@michaels.me.uk wrote: I spent a long time reviewing cf shopping carts and the best one I found was Site Director. http://www.quilldesign.com/ Russ -Original Message- From: Dakota Burns [mailto:dakota.bu...@gmail.com] Sent: 03 November 2010 20:27 To: cf-talk Subject: Recommended Shopping Cart Hi - I have a client that will be selling products, likely from multiple suppliers. I've programmed a CF extranet that will spit out a coupon code based on the number of points people accrue in the system. I need to integrate the coupon code, and list products by supplier where shipping rate taxes are handled effectively. I don't want to work with a crappy system, and if possible, would prefer the cart be written in CF, but I suppose that's not required. Budget is open depending on what impresses me as I'll be the one deploying it and potentially teaching low-skilled computer people how to use some of the basics. On the low end, in terms of pricing, I've recently taken a brief look at CFShopKart, and from what I can tell thus far, it looks to be supported and may provide me with what I'm looking for since I can modify as I wish. Which shopping cart / ecommerce systems do you all use? If the cart is not developed with CF, (most seem to be Php), have you needed to communicate with the cart via any of your CF applications? Thank you, Dakota ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338815 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Shopping Cart for subscription based purchases
I'm looking for a shopping cart that I can use to take order that are subscription based on reoccurring purhases. I've looked at Google's offering which is EXPERIMENTAL and Authorize.net's service. Can anyone recommend a service that easy to manage? Both Google and Authorize.net require working with XML data and I'm not quite sure how to work with their integration. Any examples of how to work with that would be awesome! http://developer.authorize.net/api/arb/ http://code.google.com/apis/checkout/developer/Google_Checkout_Beta_Subscriptions.html ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331798 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Shopping Cart for subscription based purchases
I'm looking for a shopping cart that I can use to take order that are subscription based on reoccurring purhases. I've looked at Google's offering which is EXPERIMENTAL and Authorize.net's service. Can anyone recommend a service that easy to manage? Both Google and Authorize.net require working with XML data and I'm not quite sure how to work with their integration. Any examples of how to work with that would be awesome! If you are looking to mostly roll your own, here's a CFC for the AuthNet Recurring API: http://authorizenetrecurring.riaforge.org/ Another option is to use a processor like Shift4 that uses tokens. This way you can just save the token and use that for each recharge, and easily handle cancellations/changes to the subscription solely on your end. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331799 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Shopping Cart for subscription based purchases
On Tue, Mar 16, 2010 at 4:05 PM, Mary Jo Sminkey mary...@cfwebstore.comwrote: I'm looking for a shopping cart that I can use to take order that are subscription based on reoccurring purhases. I've looked at Google's offering which is EXPERIMENTAL and Authorize.net's service. Can anyone recommend a service that easy to manage? Both Google and Authorize.net require working with XML data and I'm not quite sure how to work with their integration. Any examples of how to work with that would be awesome! If you are looking to mostly roll your own, here's a CFC for the AuthNet Recurring API: http://authorizenetrecurring.riaforge.org/ Another option is to use a processor like Shift4 that uses tokens. This way you can just save the token and use that for each recharge, and easily handle cancellations/changes to the subscription solely on your end. ABS Subscriptions at Authorize.net suck! 1. Notifications on payments are not reliable. 2. Expired Cards are not updated - Nice little cheat her, you can update a credit card adding 2 years to the experation year and it works a fair amount without customer interaction. 3. I know there was a 3rd but I'll stop here I can't remember the exact reason why we switched to CIM processing but it's amazing... you just need to handle your own recurring cycles and re-charge attempts based on decline reasons. It's a bit more work going CIM route, but then again I know 100% what's valid in my system every day, what's in re-try mode for declines, what we canceled because of re-try attempts that continue to decline etc. Think that's similar to Shift4 they provide a Authorize.Net provides a CustomerID and PaymentID because you can have multiple cards associated with one profile. then you just select the CustomerId PaymentId and amount to charge each month. http://www.authorize.net/solutions/merchantsolutions/merchantservices/cim/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331800 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Document Shopping Cart and .zip archive download
A client of mine has an online document repository. They would like to give visitors the option of selecting documents as they peruse the site (essentially putting these documents in a shopping cart), and when the visitors are ready to download their selected documents they can do so in one fell swoop instead of downloading them one at a time. The documents are free so there is no actual cart or online store, but I think it needs to work similar to a shopping cart scenario. I'm using CFMX 7 with a SQL Server 2000 database on a shared Linux server, and the framework used is fusebox 4. Has anyone programmed anything like this before? Here are my assumptions on how the application should work and would appreciate any feedback. ASSUMPTIONS 1. I assume that selected documents would be held in a pending queue (d.b. table) 2. Upon checkout the visitor will be sent to a page that will display a link to download a .zip file that contains all selected files 3. Upon completing the download, the .zip file should be deleted. QUESTIONS: 1. How do I dynamically create a .zip folder and place all of the visitors selected files in it and delete the .zip file upon download completion? NOTES: I was previously send a link to: http://download.newsight.de/Zip.zip (a zip cfc), however that link is broken and can't test this option Thanks in advance for the help. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Document Shopping Cart
A client of mine has an online document repository. They would like to give visitors the option of selecting documents as they peruse the site (essentially putting these documents in a shopping cart), and when the visitors are ready to download their selected documents they can do so in one fell swoop instead of downloading them one at a time. The documents are free so there is no actual cart or online store, but I think it needs to work similar to a shopping cart scenario. I'm using CFMX 7 with a SQL Server 2000 database on a shared server running Linux, and the framework used is fusebox 4. Has anyone programmed anything like this before? Here are my assumptions on how the application should work and would appreciate any feedback. ASSUMPTIONS 1. I assume that selected documents would be held in a pending queue (d.b. table) 2. Upon checkout the visitor will be sent to a page that will display a link to download a .zip file that contains all selected files 3. Upon completing the download, the .zip file should be deleted. QUESTIONS: 1. How do I dynamically create a .zip folder and place all of the visitors selected files in it and delete the .zip file upon download completion? I was sent this link, but this URL is not available anymore. http://zipcfc. riaforge. org/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323694 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Document Shopping Cart
1 You take the files that you want to to zip up and added them to a zip file Using cfzip or one of the available zip libraries like zipcfc http://zipcfc.riaforge.org/ 2 place the zip file in a temp directory with a unique name 3 Force the download using cfheader and cfcontent and then you can delete the file after you are done with cfcontent using the attribute deletefile=true HTH G! On Thu, Jun 18, 2009 at 9:29 AM, Kevin Phillips kev...@newtarget.comwrote: A client of mine has an online document repository. They would like to give visitors the option of selecting documents as they peruse the site (essentially putting these documents in a shopping cart), and when the visitors are ready to download their selected documents they can do so in one fell swoop instead of downloading them one at a time. The documents are free so there is no actual cart or online store, but I think it needs to work similar to a shopping cart scenario. I'm using CFMX 7 with a SQL Server 2000 database on a shared server running Linux, and the framework used is fusebox 4. Has anyone programmed anything like this before? Here are my assumptions on how the application should work and would appreciate any feedback. ASSUMPTIONS 1. I assume that selected documents would be held in a pending queue (d.b. table) 2. Upon checkout the visitor will be sent to a page that will display a link to download a .zip file that contains all selected files 3. Upon completing the download, the .zip file should be deleted. QUESTIONS: 1. How do I dynamically create a .zip folder and place all of the visitors selected files in it and delete the .zip file upon download completion? I was sent this link, but this URL is not available anymore. http://zipcfc. riaforge. org/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323705 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Shopping Cart Delivery Charge
Hi I am building a shopping cart which calculates shipping charges, some products also have an additional surcharge. Which is where i am stuck, The additional surcharge is stored within the product table. What i thought was to loop through the products in the cart, query the products database to get the surcharge or surcharges, loop through the query results for the individual surcharges. If this is the correct way, how do i then add the surcharges up and account for when the loop finishes. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305363 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Delivery Charge
i think the best way would be to do this is directly through sql in one query. you can build a list with the ids of all the products the customer has selected, then in 1 query... select surcharge from products where productid in(cfqueryparam value=theListOfProductIds# list=yes cfsqltype=cf_sql_varchar) and surcharge i am not sure but there must be a function in sql that adds up all the values in a column - maybe someone else can suggest it - but this sql statement then saves all the time that a loop would take and would just return the results where those products you have entered have a surcharge, then it is just a matter of adding it up. but as i said there must be a sql function you can use within this same function to do that Hi I am building a shopping cart which calculates shipping charges, some products also have an additional surcharge. Which is where i am stuck, The additional surcharge is stored within the product table. What i thought was to loop through the products in the cart, query the products database to get the surcharge or surcharges, loop through the query results for the individual surcharges. If this is the correct way, how do i then add the surcharges up and account for when the loop finishes. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Delivery Charge
if there isnt a function in sql that can do that then there is a function on cflib to get a columntotal http://cflib.org/udf.cfm?ID=887 so you can run that one query then pass the resulting column into the columnTotal udf and thats it, you will have the total surcharge... i think the best way would be to do this is directly through sql in one query. you can build a list with the ids of all the products the customer has selected, then in 1 query... select surcharge from products where productid in(cfqueryparam value=theListOfProductIds# list=yes cfsqltype=cf_sql_varchar) and surcharge i am not sure but there must be a function in sql that adds up all the values in a column - maybe someone else can suggest it - but this sql statement then saves all the time that a loop would take and would just return the results where those products you have entered have a surcharge, then it is just a matter of adding it up. but as i said there must be a sql function you can use within this same function to do that Hi I am building a shopping cart which calculates shipping charges, some products also have an additional surcharge. Which is where i am stuck, The additional surcharge is stored within the product table. What i thought was to loop through the products in the cart, query the products database to get the surcharge or surcharges, loop through the query results for the individual surcharges. If this is the correct way, how do i then add the surcharges up and account for when the loop finishes. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Delivery Charge
sorry i must be half asleep, you can use the sum function. so the full function would be select sum(surcharge) from products where productid in(cfqueryparam value=theListOfProductIds# list=yes cfsqltype=cf_sql_varchar) and surcharge i think the best way would be to do this is directly through sql in one query. you can build a list with the ids of all the products the customer has selected, then in 1 query... select surcharge from products where productid in(cfqueryparam value=theListOfProductIds# list=yes cfsqltype=cf_sql_varchar) and surcharge i am not sure but there must be a function in sql that adds up all the values in a column - maybe someone else can suggest it - but this sql statement then saves all the time that a loop would take and would just return the results where those products you have entered have a surcharge, then it is just a matter of adding it up. but as i said there must be a sql function you can use within this same function to do that Hi I am building a shopping cart which calculates shipping charges, some products also have an additional surcharge. Which is where i am stuck, The additional surcharge is stored within the product table. What i thought was to loop through the products in the cart, query the products database to get the surcharge or surcharges, loop through the query results for the individual surcharges. If this is the correct way, how do i then add the surcharges up and account for when the loop finishes. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Delivery Charge
Do you already have a query with your shopping cart? If so, just use a query-of-query (with SUM()). You don't mention if the surcharge is by product or by each item, but you may need to also be sure to factor in the product quantity. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Delivery Charge
The surcharge is for each product, you can only buy one main product at at time (multiple purchases are treated as trade), you can also add multiple accessories (which have no delivery charge) Shopping cart items are stored in the session. I am exploring the sum route at the moment. Thank you all for your response. Do you already have a query with your shopping cart? If so, just use a query-of-query (with SUM()). You don't mention if the surcharge is by product or by each item, but you may need to also be sure to factor in the product quantity. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Delivery Charge
You can carry a variable through your cfloop/cfoutput query to hold the running total of the surcharges. You can also hit the database with a new call for the sum, as other have mentioned. You can also do: cfset allsurcharges = ArraySum(ListToArray(ValueList([querycolumnname]))) William Hi I am building a shopping cart which calculates shipping charges, some products also have an additional surcharge. Which is where i am stuck, The additional surcharge is stored within the product table. What i thought was to loop through the products in the cart, query the products database to get the surcharge or surcharges, loop through the query results for the individual surcharges. If this is the correct way, how do i then add the surcharges up and account for when the loop finishes. Jason ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305376 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping cart with focus on inventory management? Or just inventory management?
Hi. I'm looking for a ColdFusion shopping cart that also has a good feature set for managing inventory. Really looking for an inventory management system that also has a shopping cart. Or actually it might not even *have* to have a shopping cart, if you know of a good CF inventory management system, please post it. My product CFWebstore does have a pretty comprehensive set of inventory management features as well, so you might want to take a look at it. I have a fair number of customers that also use it in conjunction with Quickbooks (using a 3rd party product to handle imports). It kind of depends on exactly what features you need which approach works best. Mary Jo Sminkey Author of CFWebstore, ColdFusion Ecommerce http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304786 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping cart with focus on inventory management? Or just inventory management?
+1 for SiteDirector (http://www.quilldesign.com). -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304788 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Shopping cart with focus on inventory management? Or just inventory management?
Hi. I'm looking for a ColdFusion shopping cart that also has a good feature set for managing inventory. Really looking for an inventory management system that also has a shopping cart. Or actually it might not even *have* to have a shopping cart, if you know of a good CF inventory management system, please post it. Thanks, -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304747 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping cart with focus on inventory management? Or just inventory management?
I was happy with SiteDirector the one time I used it. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 Ryan Stille wrote: Hi. I'm looking for a ColdFusion shopping cart that also has a good feature set for managing inventory. Really looking for an inventory management system that also has a shopping cart. Or actually it might not even *have* to have a shopping cart, if you know of a good CF inventory management system, please post it. Thanks, -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
some issue while increment/decrement value of product in a shopping cart
Hi, I'm having a strange issue and I need some help resolving it I have design a complete CFM shopping cart with auto generate discount coupon and lots of other features however a small thing still generate a major issue using + / - sign the customer can increase or decrease the ordered quantity of a particular item it is working fine when only 1 item is on the shopping cart if several item are in it increasing or decreasing the value of 1 of them will effect the all product quantity in the cart where am I wrong cfelseif Isdefined ('FORM.plus_button.y') cfloop from=1 to=#ArrayLen(SESSION.cart)# index=i cfset SESSION.cart[i].quantite = #IncrementValue(#SESSION.cart[i].quantite#)# / /cfloop cflocation url=contenu_commande.cfm cfelseif Isdefined ('FORM.moins_button.y') cfloop from=1 to=#ArrayLen(SESSION.cart)# index=i cfset SESSION.cart[i].quantite = #decrementValue(#SESSION.cart[i].quantite#)# / cfif SESSION.cart[i].quantite LTE 1 cfset SESSION.cart[i].quantite = 1 / /cfif /cfloop cflocation url=contenu_commande.cfm Thank you for your help Marc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302712 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: some issue while increment/decrement value of product in a shopping cart
Well you are obviously looping over your entire cart and adjusting the quantity of each item when the buttons are clicked. The buttons are also very generically named which makes me believe that they aren't tied to individual items in anyway. -Original Message- From: marc collignon [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2008 10:54 AM To: CF-Talk Subject: some issue while increment/decrement value of product in a shopping cart Hi, I'm having a strange issue and I need some help resolving it I have design a complete CFM shopping cart with auto generate discount coupon and lots of other features however a small thing still generate a major issue using + / - sign the customer can increase or decrease the ordered quantity of a particular item it is working fine when only 1 item is on the shopping cart if several item are in it increasing or decreasing the value of 1 of them will effect the all product quantity in the cart where am I wrong cfelseif Isdefined ('FORM.plus_button.y') cfloop from=1 to=#ArrayLen(SESSION.cart)# index=i cfset SESSION.cart[i].quantite = #IncrementValue(#SESSION.cart[i].quantite#)# / /cfloop cflocation url=contenu_commande.cfm cfelseif Isdefined ('FORM.moins_button.y') cfloop from=1 to=#ArrayLen(SESSION.cart)# index=i cfset SESSION.cart[i].quantite = #decrementValue(#SESSION.cart[i].quantite#)# / cfif SESSION.cart[i].quantite LTE 1 cfset SESSION.cart[i].quantite = 1 / /cfif /cfloop cflocation url=contenu_commande.cfm Thank you for your help Marc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: some issue while increment/decrement value of product in a shopping cart
Hi Bob, Thank you for your prompt answer , In deed I do loop in to all the Session content, but how can I provent that before I did add that increase / decrease feature , customers add to manualy change the quantity field value to upgrade it and it was working and not affecting the all session content the code was cfelseif Isdefined ('FORM.update_button.y') cfloop from=1 to=#ArrayLen(SESSION.cart)# index=i cfset SESSION.cart[i].quantite = FORM[quantite_ i] / /cfloop cflocation url=contenu_commande.cfm the only thing I did is to duplicate the fucntion and add the increase / decrease build in function to it. thank you for your help Marc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302725 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: some issue while increment/decrement value of product in a shopping cart
You don't notice the one big difference between before and after? The old code updated a cart items quantity based on the corresponding form fields value. There are a few ways to do it... one way would be to give each cart item its OWN form. Use the +/- as the submit buttons. Hide the cart item id in a hidden field for each form so you know which item to adjust then just +1 or -1 based on which submit button was clicked. cfloop from=1 to=#ArrayLen(SESSION.cart)# index=i form action=#cgi.script_name#?#cgi.query_string# method=post input type=hidden name=cartItemID value=#i# / input type=submit name=increaseQTY value=+ / input type=submit name=dereaseQTY value=- / #SESSION.cart[i].ItemName# /form br / /cfloop cfif isdefined('form.increaseQTY') cfset val(SESSION.cart[FORM[cartItemID]].quantite) = val(SESSION.cart[FORM[cartItemID]].quantite) + 1 / cfelseif isdefined('form.decreaseQTY') cfset val(SESSION.cart[FORM[cartItemID]].quantite) = val(SESSION.cart[FORM[cartItemID]].quantite) - 1 / /cfif form.increaseQTY.y and form.decreaseQTY.y if you use images for the plus and minus -Original Message- From: marc collignon [mailto:[EMAIL PROTECTED] Sent: Friday, April 04, 2008 12:26 PM To: CF-Talk Subject: Re: some issue while increment/decrement value of product in a shopping cart Hi Bob, Thank you for your prompt answer , In deed I do loop in to all the Session content, but how can I provent that before I did add that increase / decrease feature , customers add to manualy change the quantity field value to upgrade it and it was working and not affecting the all session content the code was cfelseif Isdefined ('FORM.update_button.y') cfloop from=1 to=#ArrayLen(SESSION.cart)# index=i cfset SESSION.cart[i].quantite = FORM[quantite_ i] / /cfloop cflocation url=contenu_commande.cfm the only thing I did is to duplicate the fucntion and add the increase / decrease build in function to it. thank you for your help Marc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302749 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Recommendation?
The main issue people have with it these days (and typically the reason I get from people that switch to my product) is that it no longer is really a ColdFusion application, it merely uses ColdFusion as the front-end to the underlying Java code. Ok, I wondered about that after reading through their site. Now it makes sense. Yes, that would most likely be a problem for me. Thanks so much! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Recommendation?
Thank you all for your posts...most helpful! Someone also mentioned another cart to me today called AbleCommerce. I hadn't come across that one yet -- has anyone ever had experience with it? Thanks again! Tana ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Recommendation?
Someone also mentioned another cart to me today called AbleCommerce. I hadn't come across that one yet -- has anyone ever had experience with it? Well, I can only briefly comment as it's a competitor to my product and it's been awhile since I had any direct access to a copy. But it's been around for awhile, as it was the first real ecommerce platform for ColdFusion and has a large, active community still. The main issue people have with it these days (and typically the reason I get from people that switch to my product) is that it no longer is really a ColdFusion application, it merely uses ColdFusion as the front-end to the underlying Java code. So it's considerably harder to modify than most of the other products listed here (assuming you are a CF developer and not a Java developer). You'd certainly want to make sure that you won't need to add or change any core functions to determine how much of an issue this is...which is not a bad assessment to do in any case prior to purchase to know how well any particular product meets your needs. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296215 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Shopping Cart Recommendation?
Hi, We're looking to convert our current e-commerce site over to ColdFusion but are having a tough time locating a fairly robust shopping cart that will work with it. We're looking for something already existing that can track inventory, accept gift certificates/discounts, PayPal, (possibly with an extention to tie into Quickbooks) to name a few. I think the closest products to what we want would be similar to ZenCart or ProductCart. Does anyone have any ideas for me? Thank you! Tana ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Recommendation?
Dana, Don't you have a shopping cart app? Bruce On Jan 7, 2008 2:17 PM, Tana Adams [EMAIL PROTECTED] wrote: Hi, We're looking to convert our current e-commerce site over to ColdFusion but are having a tough time locating a fairly robust shopping cart that will work with it. We're looking for something already existing that can track inventory, accept gift certificates/discounts, PayPal, (possibly with an extention to tie into Quickbooks) to name a few. I think the closest products to what we want would be similar to ZenCart or ProductCart. Does anyone have any ideas for me? Thank you! Tana ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Recommendation?
Check out SiteDirector by QuillDesign (www.quilldesign.com). I've used it several times and found it to be a nice commerce system. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Recommendation?
Dana, Don't you have a shopping cart app? Bruce On Jan 7, 2008 2:17 PM, Tana Adams [EMAIL PROTECTED] wrote: Yes we do but it's WebDNA/WebCatalog and that's no longer being supported. Tana ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296077 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Recommendation?
Check out SiteDirector by QuillDesign (www.quilldesign.com). I've used it several times and found it to be a nice commerce system. Thank you, Brian. I'll check that further. I appreciate your suggestion. Tana ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296078 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Recommendation?
I second SiteDirector. I've used it quite a bit over the last 8 years or so Check out SiteDirector by QuillDesign (www.quilldesign.com). I've used it several times and found it to be a nice commerce system. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Recommendation?
We're looking for something already existing that can track inventory, accept gift certificates/discounts, PayPal, (possibly with an extention to tie into Quickbooks) to name a few. I think the closest products to what we want would be similar to ZenCart or ProductCart. Does anyone have any ideas for me? Be sure to check out CFWebstore as well (www.cfwebstore.com). It can handle these kinds of things (and much more!) and has very high ratings from users on the Adobe Exchange, Hotscripts, etc. Feel free to email me directly if you have specific questions you'd like addressed. We do have an active peer-to-peer user group where you can direct questions as well. --- Mary Jo Sminkey [EMAIL PROTECTED] http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296085 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Recommendation?
+6 for CFWebStore - that's how many installations we have going right now, with a few more coming down the pike soon. Pros: * It's fusebox based. * It's got solid documentation * It's completely skinnable and modifyable * It has everything you're talking about except one - Quickbooks For the QuickBooks integration, that requires a product called T-Hub by Atandra along with some custom coding on your part to build the interface. If you want to email me off-list I can talk more to that. Definitely worth the cost! Hatton On Jan 7, 2008 8:31 PM, Mary Jo Sminkey [EMAIL PROTECTED] wrote: We're looking for something already existing that can track inventory, accept gift certificates/discounts, PayPal, (possibly with an extention to tie into Quickbooks) to name a few. I think the closest products to what we want would be similar to ZenCart or ProductCart. Does anyone have any ideas for me? Be sure to check out CFWebstore as well (www.cfwebstore.com). It can handle these kinds of things (and much more!) and has very high ratings from users on the Adobe Exchange, Hotscripts, etc. Feel free to email me directly if you have specific questions you'd like addressed. We do have an active peer-to-peer user group where you can direct questions as well. --- Mary Jo Sminkey [EMAIL PROTECTED] http://www.cfwebstore.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Recommendation?
For the QuickBooks integration, that requires a product called T-Hub by Atandra along with some custom coding on your part to build the interface. If you want to email me off-list I can talk more to that. Hey Hatton, I'd be interested in hearing what you did with T-Hub. Obviously I do get asked about Quickbooks integration fairly frequently, but there's so many good 3rd party products out there that specialize in this, it just makes more sense to let them handle it using a order export from the store versus my trying to constantly stay updated with what Intuit does (hard enough keeping up with PayPal, UPS, FedEx, AuthNet and all the other payment gateways, etc.!) There's a couple others I usually recommend but always interested to hear about others people might be using. --- Mary Jo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Recommendation?
For the QuickBooks integration, that requires a product called T-Hub by Atandra along with some custom coding on your part to build the interface. If you want to email me off-list I can talk more to that. Hey Hatton, I'd be interested in hearing what you did with T-Hub. T-Hub acts as an SOAP/XML intermediary between the Quickbooks API and any web interface. In short, it handles 4 basic transaction types spanning 3 Levels: Level 1: Order Export - Sends a basic request asking for orders. The store has to return an XML structure that contains ALL information about the order including customer details (bill and ship to), payment details (method, discounts, gift certificates, extra charges), and all product details. This level of integration can be done with any store that will dump said information in a CSV file OR can be done via the XML method provided certification is attained (see note below). Level 2: Order Payment Status Update - Since T-Hub monitors Quickbooks, as soon as a payment is made on an invoice the system can be triggered to update the payment status on the website. This happens via a SOAP request where T-Hub sends a packet that includes the order number and other specifics. The web store has to acknowledge receipt of the data. It must be certified by Atandra. Order Shipment Status Update - Same as Payment, only with shipping information. Level 3: Product Inventory/Price Import - T-Hub collects the information about the products in the QB database and sends them via XML to the web store. The store must be able to dynamically add product, manufacturers, categories and update price and inventory. Certification is needed for this step. What is this certification? Atandra will certify that a store software package works with T-Hub for a fee. We have a client that needs only Level 3, but that fee is $750. We have passed that cost on to the client and are working on a client specific version of the integration code at this time. We have two other clients that are interested in the rest of the integration and are planning on building out complete integration to the T-Hub standards as soon as they commit to the quote. Certification provides a few different things. The main one being that they list packages that have been certified. It's quite the interesting business model. They built this tool to interface between QB and web... and if a web package wants to be okayed to interface with T-Hub you have to pay THEM money to test YOUR code. Hatton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 shopping cart tutorial
On Monday 17 Dec 2007, Ali Majdzadeh wrote: Hi everybody: I want to make a shopping cart with CF8 and MS ACCESS. No, you don't. Use a real database. -- Tom Chiverton Helping to assertively target front-end appliances on: http://thefalken.livejournal.com Halliwells wishes all of its clients and suppliers the Very Best for Christmas the New Year This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295013 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 shopping cart tutorial
On Monday 17 Dec 2007, Ali Majdzadeh wrote: Hi everybody: I want to make a shopping cart with CF8 and MS ACCESS. No, you don't. Use a real database. I'm coming into this on the tail end, so I didn't see the original message. I wouldn't recommend Access for anything that will be used in production, particularly now that SQL Sever Express (2005 lite) is available. Back when it wasn't available I designed my SQL Abstraction library to work with Access (along with MySQL, SQL Server Oracle). So if for some reason you had problems installing one of the other 3, if you were using the onTap framework (or something like it) that abstracts the database access and were pretty monogamous about not using ad-hoc queries, then you could use an MS Access database locally for minimal development and testing to create a proof of concept and all your code would then still work for the other databases. But I agree that you really wouldn't want to use an Access database beyond the larval stages. I personally prefer using SQL 2005 on my notebook. The new SQL Server Management Studio that replaced Enterprise Manager + Query Analyzer is imo in some ways a step back from the older tools in spite of some minor improvements to the interface. Still, at least for my purposes it seems easier to manage than MySQL. -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295075 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CF8 shopping cart tutorial
Hi everybody: I want to make a shopping cart with CF8 and MS ACCESS. Do you know a simple tutorial for that? I found a couple of tutorials in easycfm.com but it will be great if I have more things to learn from. I rather not to use CFCs while I know they are great but I prefer to write one from scratch. Thank you very much Benign ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294948 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF Shopping cart + Canadian taxes
Hi there, Just wondering if anyone here has any experience with a shopping cart app and canadian taxation. I'm gonna look at CFWebstore. Any others or any suggestions? Thanks! -- Yves Arsenault Love is the only force capable of transforming an enemy into a friend. --Martin Luther King, Jr. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288689 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Integrating blog / gallery / imagecfc / shopping cart
On 9/15/07, Steve Good [EMAIL PROTECTED] wrote: So I have decided to integrate Rick's BlogCFM, and ImageCFC with a gallery and shopping cart. But before I start this, does anyone have any recommendations for the shopping cart and gallery I should use? I'm looking for something open source of course, and something that should be moderately easy to integrate. Once I finish I'm hoping to be able to apply one CSS sheet, and have one database running the whole thing. Any suggestions or success stories? By Gallery do you mean like a photo gallery? BlogCFM actually does photo galleries. Not saying I'm recommending it, but if you're willing to customize, the functionality is already in there. rick -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Shopping Cart Theory
I'm building a small shopping cart for a client - seems quicker to go from scratch than try to wrestle something already built back into our specific needs. Although I've done a couple of these, I was just wondering... What would the rest of you consider the optimal way to store items before checking out? Session var with an array? A temporary holding database for the items with just a UUID Session Var to keep up with the owner? I'm leaning towards the array in a session var - but this is on a shared server and I've seen sessions time out unexpectedly before, which wouldn't be good (where'd all my stuff go???). Anybody else? ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288573 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Shopping Cart Theory
Personally, I have them become a user before check out and then have the items in a shopping cart table based on their user id. That way it saves their cart for later purchase if needed. Else they can remove the items. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 10:41 AM To: CF-Talk Subject: Shopping Cart Theory I'm building a small shopping cart for a client - seems quicker to go from scratch than try to wrestle something already built back into our specific needs. Although I've done a couple of these, I was just wondering... What would the rest of you consider the optimal way to store items before checking out? Session var with an array? A temporary holding database for the items with just a UUID Session Var to keep up with the owner? I'm leaning towards the array in a session var - but this is on a shared server and I've seen sessions time out unexpectedly before, which wouldn't be good (where'd all my stuff go???). Anybody else? ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288575 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Theory
I'm for storing them in a table. I suppose that if you wanted to allow guest shopping, you could assign a temporary user id (some UUID) and store it on their machine as a cookie, and then use that as a key in the cart table. That's just a thought off the top of my head, so there could be some issues that I've not thought about, but it seems like a solid idea. Chris On 9/17/07, ColdFusion [EMAIL PROTECTED] wrote: Personally, I have them become a user before check out and then have the items in a shopping cart table based on their user id. That way it saves their cart for later purchase if needed. Else they can remove the items. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 10:41 AM To: CF-Talk Subject: Shopping Cart Theory I'm building a small shopping cart for a client - seems quicker to go from scratch than try to wrestle something already built back into our specific needs. Although I've done a couple of these, I was just wondering... What would the rest of you consider the optimal way to store items before checking out? Session var with an array? A temporary holding database for the items with just a UUID Session Var to keep up with the owner? I'm leaning towards the array in a session var - but this is on a shared server and I've seen sessions time out unexpectedly before, which wouldn't be good (where'd all my stuff go???). Anybody else? ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288577 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping Cart Theory
I have done both. It really depends on what the client wants and the hosting environment. I did one where the items were held in a temporary database table with a UUID simply because the client wanted to make sure that the customer could come back to their items if they either changed their minds later on or if something happened like their computer shut down unexpectedly. I put a time/date stamp on the cart and would purge the cart after 5 days. We also set it up so that if a registered (i.e. logged in customer) was shopping and they did not finalize their purchase, it would kick an email to them saying that they still had items in their cart and that they were going to be deleted in x days, and gave them a link to go back to the site and decide if they wanted to buy the items. I personally favor the holding of the items myself for the reason you said below, if something happens, you don't want the customer to have to go back and put all their items back into the cart. That would be a fast way to get me away from your site. Bruce On 9/17/07, Les Mizzell wrote: I'm building a small shopping cart for a client - seems quicker to go from scratch than try to wrestle something already built back into our specific needs. Although I've done a couple of these, I was just wondering... What would the rest of you consider the optimal way to store items before checking out? Session var with an array? A temporary holding database for the items with just a UUID Session Var to keep up with the owner? I'm leaning towards the array in a session var - but this is on a shared server and I've seen sessions time out unexpectedly before, which wouldn't be good (where'd all my stuff go???). Anybody else? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288578 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Shopping Cart Theory
I use CF Webstore which stores shopping cart data in a database table. I think this is more customer-friendly since average mortals don't want to be troubled by session expiration. -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 9:41 AM To: CF-Talk Subject: Shopping Cart Theory I'm building a small shopping cart for a client - seems quicker to go from scratch than try to wrestle something already built back into our specific needs. Although I've done a couple of these, I was just wondering... What would the rest of you consider the optimal way to store items before checking out? Session var with an array? A temporary holding database for the items with just a UUID Session Var to keep up with the owner? I'm leaning towards the array in a session var - but this is on a shared server and I've seen sessions time out unexpectedly before, which wouldn't be good (where'd all my stuff go???). Anybody else? ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288582 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Integrating blog / gallery / imagecfc / shopping cart
By Gallery do you mean like a photo gallery? BlogCFM actually does photo galleries. Not saying I'm recommending it, but if you're willing to customize, the functionality is already in there. rick -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com Thanks Rick, I didn't realize there was a gallery function in BlogCFM. I'm more than willing to customize. I'm trying to put a standard package together so I can just apply some CSS changes and make life easy for myself when putting up new sites. ~steve ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288584 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping Cart Theory
What would the rest of you consider the optimal way to store items before checking out? One request that the client made was that you could have an account - but that it be possible to shot/checkout *without* and account as well. So, there's a sign in to retrieve your data before you checkout, or you can just checkout without signing in. This requires a temporary id with temporary storage until we know who the actual shopper is. If you have an account, then a cookie is set (when allowed) and the site knows who you are whenever you return anyway - if you selected the remember me option at some point... After some thought - a temporary table to hold items plus a session ID to keep up with the customer, *AND* set a cookie with the same data just to be sure. If one craps out, there other exist as a backup. Overkill? Probably not... ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288590 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Integrating blog / gallery / imagecfc / shopping cart
Ok, So I have decided to integrate Rick's BlogCFM, and ImageCFC with a gallery and shopping cart. But before I start this, does anyone have any recommendations for the shopping cart and gallery I should use? I'm looking for something open source of course, and something that should be moderately easy to integrate. Once I finish I'm hoping to be able to apply one CSS sheet, and have one database running the whole thing. Any suggestions or success stories? Thanks! ~Steve ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288526 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Moving from cookie to session for shopping cart
What I want to do it move away from storing shopping cart information in a cookie. We currently do this because we have multiple servers that handle the shopping cart. What I want to do it use only two servers in a cluster, one active and the other passive, and use session variables to control the shopping cart. I know you still need a cookie for the session variable. What I thought was I could insert the session ID in a table with the stock number, quantity, and price. After the order is completed, the session ID is deleted and all information about the order is purged from the table. Also, I would probably set to purge sessions that are inactive for 7 days. So.. may table would look like this: SessionID Stock Qty Price AddDate - - - -- - 1234567 123 1 9.9504/30/2007 Sound good? Also, would CF Enterprise be idea for this? Take advantage of the clustering... Thanks Jacob ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Basic CFM shopping cart tutorial/Dreaweaver extension
I have also just wrote a very small demo for some quite simple Wish List / Cart style CFC for someone else. Not sure if this is enough to inspire: http://www.bennadel.com/blog/637-Ask-Ben-Creating-A-Simple-Wish-List-Sho pping-Cart.htm Or : http://bennadel.com/index.cfm?dax=blog:637.view I think the beauty of my solution is that it can take custom properties so you can basically create a setup that can handle whatever your products are talking about. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Sunday, April 15, 2007 4:33 PM To: CF-Talk Subject: Re: Basic CFM shopping cart tutorial/Dreaweaver extension I need no money transaction in the shopping cart so many options based on credit cards and shipping and something like that won't be necessary. Just showing the products in categories, and adding them to wish list/ buy list after logging in and showing the added products in a box righ_top of tha page will be completely enough. For something fairly simple like that, you're going to want to write your own I think. Most commercial shoppping carts are going to have at least the same amount of features as Cartweaver, if not more, so probably not going to work for you. If you want some help getting started, there is a basic shopping cart in Ben Forta's WACK book, and there's also one here at webmonkey: http://www.webmonkey.com/99/49/index4a.html Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Basic CFM shopping cart tutorial/Dreaweaver extension
Nice work Ben, I spent some time working on a shopping cart system a while back but never got round to completing the project. It's interesting to see you using the query method, any particular reason for using that instead of a standard arrays and structures? Cheers, Rob -Original Message- From: Ben Nadel [mailto:[EMAIL PROTECTED] Sent: 16 April 2007 13:51 To: CF-Talk Subject: RE: Basic CFM shopping cart tutorial/Dreaweaver extension I have also just wrote a very small demo for some quite simple Wish List / Cart style CFC for someone else. Not sure if this is enough to inspire: http://www.bennadel.com/blog/637-Ask-Ben-Creating-A-Simple-Wish-List-Sho pping-Cart.htm Or : http://bennadel.com/index.cfm?dax=blog:637.view I think the beauty of my solution is that it can take custom properties so you can basically create a setup that can handle whatever your products are talking about. ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Mary Jo Sminkey [mailto:[EMAIL PROTECTED] Sent: Sunday, April 15, 2007 4:33 PM To: CF-Talk Subject: Re: Basic CFM shopping cart tutorial/Dreaweaver extension I need no money transaction in the shopping cart so many options based on credit cards and shipping and something like that won't be necessary. Just showing the products in categories, and adding them to wish list/ buy list after logging in and showing the added products in a box righ_top of tha page will be completely enough. For something fairly simple like that, you're going to want to write your own I think. Most commercial shoppping carts are going to have at least the same amount of features as Cartweaver, if not more, so probably not going to work for you. If you want some help getting started, there is a basic shopping cart in Ben Forta's WACK book, and there's also one here at webmonkey: http://www.webmonkey.com/99/49/index4a.html Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Basic CFM shopping cart tutorial/Dreaweaver extension
Rob, By using a query I can do several things quite easily: 1. Check to see if an item already exists in the cart by comparing ALL properties. 2. Sum sub-total columns. 3. Sum quantity columns. 4. Add custom properties to the items query (ex. size, color, sex, wood, finish, media, etc.). 5. Loop over the items using the CFLoop/Query tag (easier than an index loop). I am sure that arrays / structs can handle all of that as well... There is just something I love about the ColdFusion query object. And again, I am NOT a big eCommerce person, so I am not sure how well this would hold up in the real world. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Monday, April 16, 2007 9:00 AM To: CF-Talk Subject: RE: Basic CFM shopping cart tutorial/Dreaweaver extension Nice work Ben, I spent some time working on a shopping cart system a while back but never got round to completing the project. It's interesting to see you using the query method, any particular reason for using that instead of a standard arrays and structures? Cheers, Rob ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: collecting IP Address through database shopping cart
No offense taken Jon. I probably should explain to you that this cart was built by a guy who's friends with the owner of our company and since he provided it to us free and he's very busy with his own job, I've kind of been made the guy to take on customizing the cart, so I'm a newbie to Coldfusion. I've picked up very quickly and have made single page forms. When making these pages I found the code in a forum that someone posted for retrieving the IPaddress. So that explains the array code. We want to capture our customers IPaddress to protect us and our clients against any fraudulent charges. I'll check the order of the queries. Thanks for the reply. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: collecting IP Address through database shopping cart
On Apr 13, 2007, at 4:57 PM, tracy sanchez wrote: I currently do have some single page forms that I use this code to capture the IP Address: cfset ipaddress=#cgi.remote_addr# cfset IPArray = listToArray(IPAddress,.) cfset IPNumber= (IPArray[1] * (256)^3) + (IPArray[2] * (256)^2) + (IPArray[3] * 256) + IPArray[4] Tracy, I'm not sure why you would have separate forms to capture the IP address, since that is available in your CGI variables. Are you using CFHTTP to post to those forms in some way? That would explain the why the value you're getting is the servers IP. On your duplicate values, I would suggest checking your query. It looks like you've got quite a few fields on your INSERT statement. I would suggest looking at that query again and see if you have your list of query params out of order with your field list. Ditto for your SELECT queries where you are retrieving the results. Also, what are you trying to accomplish by converting the IP address into an IP number (with the array)? That's not a slam on you, just trying to get clarification. I assume you're just looking to store the only address as a simple value in your db for tracking purposes, correct? HTH, Jon No offense taken Jon. I probably should explain to you that this cart was built by a guy who's friends with the owner of our company and since he provided it to us free and he's very busy with his own job, I've kind of been made the guy to take on customizing the cart, so I'm a newbie to Coldfusion. I've picked up very quickly and have made single page forms. When making these pages I found the code in a forum that someone posted for retrieving the IPaddress. So that explains the array code. We want to capture our customers IPaddress to protect us and our clients against any fraudulent charges. I'll check the order of the queries. Thanks for the reply. ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Basic CFM shopping cart tutorial/Dreaweaver extension
Hi everybody: Do you know any CFM shopping tutorial or a Dreamweaver extension that helps me build a shopping cart? I saw cartweaver but it is too complicated and full of options and I think I won't have full control over everything on that while I need to learn/ customize the whole shopping cart for my needs. I need no money transaction in the shopping cart so many options based on credit cards and shipping and something like that won't be necessary. Just showing the products in categories, and adding them to wish list/ buy list after logging in and showing the added products in a box righ_top of tha page will be completely enough. Thanks for your help Ali ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Basic CFM shopping cart tutorial/Dreaweaver extension
I need no money transaction in the shopping cart so many options based on credit cards and shipping and something like that won't be necessary. Just showing the products in categories, and adding them to wish list/ buy list after logging in and showing the added products in a box righ_top of tha page will be completely enough. For something fairly simple like that, you're going to want to write your own I think. Most commercial shoppping carts are going to have at least the same amount of features as Cartweaver, if not more, so probably not going to work for you. If you want some help getting started, there is a basic shopping cart in Ben Forta's WACK book, and there's also one here at webmonkey: http://www.webmonkey.com/99/49/index4a.html Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275289 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
collecting IP Address through database shopping cart
Hello,I have a shopping cart and I want to capture our clients IP Addresses when they order.it'll need to be passed through a dtabase shopping cart. _ Your friends are close to you. Keep them that way. http://spaces.live.com/signup.aspx ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275179 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: collecting IP Address through database shopping cart
CGI.REMOTE_ADDR -Original Message- From: tracy sanchez [mailto:[EMAIL PROTECTED] Sent: Friday, April 13, 2007 4:11 PM To: CF-Talk Subject: collecting IP Address through database shopping cart Hello,I have a shopping cart and I want to capture our clients IP Addresses when they order.it'll need to be passed through a dtabase shopping cart. _ Your friends are close to you. Keep them that way. http://spaces.live.com/signup.aspx ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275180 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: collecting IP Address through database shopping cart
my bad, sorry I had 15 things going on when I posted that. let me be a bit more detailed this time. I currently do have some single page forms that I use this code to capture the IP Address: cfset ipaddress=#cgi.remote_addr# cfset IPArray = listToArray(IPAddress,.) cfset IPNumber= (IPArray[1] * (256)^3) + (IPArray[2] * (256)^2) + (IPArray[3] * 256) + IPArray[4] I placed that same code into my form on my cart and since my database won't accept cgi.remote_addr as a field name, I named the fied name in the database ipaddress. I then added this code on my processing form: INSERT INTO orders (ipaddress, IDname, CCFname, CCLname, CCcompany,CCStreet1,CCStreet2,CCcity,CCstate,CCzip,Phone,Fax,Email,CCNumber,CCtype,CCexp,CCVC,shipFname, shipLname, shipcompany,shipStreet1,shipStreet2,shipcity,shipstate,shipzip,specialinstructions, orderdate, cleared, salestax, Shippingmethod, ShippingCost) VALUES ( cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#cgi.remote_addr#, The problem I'm having is that on our end where we retrieve the order info, the ipaddres feild is showing our IP instead of the clients and for some reason is showing the clients IP in another field that is designated for the clients ID code. In fact, it shows their IP and then their code and then their IP twice after that. so, I'm not sure what I've done wrong. any thoughts and thanks for your quick response ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: collecting IP Address through database shopping cart
On Apr 13, 2007, at 4:57 PM, tracy sanchez wrote: I currently do have some single page forms that I use this code to capture the IP Address: cfset ipaddress=#cgi.remote_addr# cfset IPArray = listToArray(IPAddress,.) cfset IPNumber= (IPArray[1] * (256)^3) + (IPArray[2] * (256)^2) + (IPArray[3] * 256) + IPArray[4] Tracy, I'm not sure why you would have separate forms to capture the IP address, since that is available in your CGI variables. Are you using CFHTTP to post to those forms in some way? That would explain the why the value you're getting is the servers IP. On your duplicate values, I would suggest checking your query. It looks like you've got quite a few fields on your INSERT statement. I would suggest looking at that query again and see if you have your list of query params out of order with your field list. Ditto for your SELECT queries where you are retrieving the results. Also, what are you trying to accomplish by converting the IP address into an IP number (with the array)? That's not a slam on you, just trying to get clarification. I assume you're just looking to store the only address as a simple value in your db for tracking purposes, correct? HTH, Jon ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
ColdFusion Shopping Cart
Sorry if this has been asked 1000 times before, but can anyone recommend a ColdFusion shopping cart under $500? It will only need to hold around 100 products but most importantly it needs to work correctly within Australia (I have had a disastrous experience in the past with a cart that fell apart when trying to set up for Australia). Ideally I will be able to link it to an Australian payment gateway, and if not it should have a secure strategy for storing credit card details. Any suggestions much appreciated. Kevan Stannard ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268280 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ColdFusion Shopping Cart
Will Tomlinson wrote one and believe it or not... it seems to work rather well. You could yell for him... or hold up a bologna sandwich... he'll find you. :-) -Original Message- From: Kevan Stannard [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 31, 2007 7:02 PM To: CF-Talk Subject: ColdFusion Shopping Cart Sorry if this has been asked 1000 times before, but can anyone recommend a ColdFusion shopping cart under $500? It will only need to hold around 100 products but most importantly it needs to work correctly within Australia (I have had a disastrous experience in the past with a cart that fell apart when trying to set up for Australia). Ideally I will be able to link it to an Australian payment gateway, and if not it should have a secure strategy for storing credit card details. Any suggestions much appreciated. Kevan Stannard ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion Shopping Cart
Sorry if this has been asked 1000 times before, but can anyone recommend a ColdFusion shopping cart under $500? It will only need to hold around 100 products but most importantly it needs to work correctly within Australia (I have had a disastrous experience in the past with a cart that fell apart when trying to set up for Australia). Ideally I will be able to link it to an Australian payment gateway, and if not it should have a secure strategy for storing credit card details. Any suggestions much appreciated. CFWebstore certainly should work fine for you. I've got more Aussie customers than any others outside the US and Canada. The current version is pretty easy to set up outside the US, and I have some additional international improvements coming in my next major release (currently in beta). Feel free to jump on my email list and ask for opinions from my users in terms of what you need to do...it's possible one of them may have already done your gateway if it is specific for Australia. Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268285 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ColdFusion Shopping Cart
Try http://www.adminprotools.com/detail/index.cfm?nPID=18cid=2cdesc=E%2DCommerce%20Custom%20Tags ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Gift Certificate/Shopping cart question
I personally just use the code, since it's a 20-digit random code that's going to be pretty secure on its own. You don't want to use the email since many people purchase them to give as gifts and the person using the code may not know the email of the person that bought it originally. I'm using the receiver's email in the field. The purchaser makes the purchase, then the receiver receives their certificate via email. But this makes me think... should I offer a choice of electronic or paper certificates? giftCertificateManager.cfc would be able to generate both types depending on what the user selects during checkout. Or should it just be a simple printable gift certificate type of thing. Thanks Mary Jo! Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265429 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Gift Certificate/Shopping cart question
I'm using the receiver's email in the field. The purchaser makes the purchase, then the receiver receives their certificate via email. But this makes me think... should I offer a choice of electronic or paper certificates? giftCertificateManager.cfc would be able to generate both types depending on what the user selects during checkout. I would allow either, because they may not want to email it. They may not know the receipient's email or they may want to give it as a gift at a later time, use it in a raffle as a prize, etc. Leave it as flexible for the buyer as possible. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Gift Certificate/Shopping cart question
Seems like a good idea would be to create a GiftCertificate.cfc and subclass them for specifc types DigitalCertificate extends GiftCertificate PaperCertificate extends GiftCertificate I would even look more into the Strategy Design Pattern. I am no OO expert but I have been reading up on different patterns lately and this looks like it may fit. If Im wrong here someone please point that out! http://en.wikipedia.org/wiki/Strategy_pattern On 12/31/06, Mary Jo Sminkey [EMAIL PROTECTED] wrote: I'm using the receiver's email in the field. The purchaser makes the purchase, then the receiver receives their certificate via email. But this makes me think... should I offer a choice of electronic or paper certificates? giftCertificateManager.cfc would be able to generate both types depending on what the user selects during checkout. I would allow either, because they may not want to email it. They may not know the receipient's email or they may want to give it as a gift at a later time, use it in a raffle as a prize, etc. Leave it as flexible for the buyer as possible. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265434 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Gift Certificate/Shopping cart question
I need to add gift certificate functionality to my store app. What's the best way to do this? I'm guessing I need a tblGiftCertificates. It contains a certificatecode, amount, message, datepurch, receiveremail, etc. The user buys and actually pays for the certificate like it was any item in the store? Would I set it up as an item for sale like that? Then, what's the best process for the certificate receiver to redeem their cert.? Use their email and a generated certificate code as info they'd put in a form during the checkout process? Then keep a running total on how much they have left on the cert? Like, if they had $20.00 on it. Then purchased $50 worth of merchandise, I'd need to be able to calculate they owe $30 balance during checkout, etc... I can see little issues arising... Thanks for any suggestions you guys/gals have. Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265383 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Gift Certificate/Shopping cart question
The user buys and actually pays for the certificate like it was any item in the store? Would I set it up as an item for sale like that? Generally yes. You can create a function to generate them automatically if you want, but you'd have to ensure that it is only done if you're using some online gateway and can validate the payment before sending them the code. If the store is low-volume, manually generating codes usually works fine. Then, what's the best process for the certificate receiver to redeem their cert.? Use their email and a generated certificate code as info they'd put in a form during the checkout process? I personally just use the code, since it's a 20-digit random code that's going to be pretty secure on its own. You don't want to use the email since many people purchase them to give as gifts and the person using the code may not know the email of the person that bought it originally. Then keep a running total on how much they have left on the cert? Yup. So in your table, I'd suggest keeping both the original amount as well as the current balance. You should also add information to your orders table to show the certificate code used so you can track it back to the purchaser. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Gift Certificate/Shopping cart question
I don't know where you are, geographically, but don't forget that you may not pay sales tax on gift certs themselves, so it might NOT be like any item in the store. -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Saturday, December 30, 2006 8:47 AM To: CF-Talk Subject: Gift Certificate/Shopping cart question I need to add gift certificate functionality to my store app. What's the best way to do this? I'm guessing I need a tblGiftCertificates. It contains a certificatecode, amount, message, datepurch, receiveremail, etc. The user buys and actually pays for the certificate like it was any item in the store? Would I set it up as an item for sale like that? Then, what's the best process for the certificate receiver to redeem their cert.? Use their email and a generated certificate code as info they'd put in a form during the checkout process? Then keep a running total on how much they have left on the cert? Like, if they had $20.00 on it. Then purchased $50 worth of merchandise, I'd need to be able to calculate they owe $30 balance during checkout, etc... I can see little issues arising... Thanks for any suggestions you guys/gals have. Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265391 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Gift Certificate/Shopping cart question
I don't know where you are, geographically, but don't forget that you may not pay sales tax on gift certs themselves, so it might NOT be like any item in the store. True. My software has the ability to set any product as not taxed, so this is easily handled. It's a good idea to have that function, as there are many other instances where products are not taxed. --- Mary Jo ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265392 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Gift Certificate/Shopping cart question
Thanks for all the advice. I'll be workin on it... Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Shopping cart questions?
You don't even need to run a scheduled task to do this, just put it in the application.cfm. Storing the cart in a db table is the way to go, I use the CFID, too. -Original Message- From: Patrick McElhaney [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 02:39 To: CF-Talk Subject: Re: Shopping cart questions? On 11/27/06, Doug Brown [EMAIL PROTECTED] wrote: Well, that is what I was thinking. The other issue that I have as far as using the database storage is image uploads. I plan on allowing a user to upload as many as 10 images per ad, and was wondering how to handle the image upload if they end up not checking out. Should I just run a scheduled task every so often and delete the images off the server based on the info in the tempCart table? I would run a scheduled task to delete expired carts (in the tempCart table) and their associated images at the same time. Patrick -- Patrick McElhaney 704.560.9117 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Robust, easily configurable shopping cart?
I need to add online commerce capabilities to a site. I've been playing with the idea of building the online catalog/cart application myself but this client wants to get rolling ASAP. Are there any recommended CF-based shopping cart apps? The following are important to me: * Doesn't rely on any specific framework, i.e. FB or Mach-II * Licensing allows full access to source code so I can apply my wite's look and feel * Supports a number of payment gateways, including PayPal and Google Checkout So far, cartweaver http://www.cartweaver.com/ seems to be a strong candidate, but there are things about it that I would need to add or enhance (more flexible shipping options, ability to have 1 full-sized image for a product, etc.). Thanks Pete ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Robust, easily configurable shopping cart?
Cf_ezcart is quite popular - Russ -Original Message- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 02 December 2006 00:43 To: CF-Talk Subject: Robust, easily configurable shopping cart? I need to add online commerce capabilities to a site. I've been playing with the idea of building the online catalog/cart application myself but this client wants to get rolling ASAP. Are there any recommended CF-based shopping cart apps? The following are important to me: * Doesn't rely on any specific framework, i.e. FB or Mach-II * Licensing allows full access to source code so I can apply my wite's look and feel * Supports a number of payment gateways, including PayPal and Google Checkout So far, cartweaver http://www.cartweaver.com/ seems to be a strong candidate, but there are things about it that I would need to add or enhance (more flexible shipping options, ability to have 1 full-sized image for a product, etc.). Thanks Pete ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262557 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Robust, easily configurable shopping cart?
I would say that CF_EzCart would be a good one.. http://www.cf-ezcart.com/shopping-cart-features.cfm Real-time credit card processors supported: a.. Authorizenet b.. Network 1 Financial c.. Netbilling, Inc. d.. EFSnetSM Web Payment Services e.. BluePay by Online Data Corporation f.. MerchantPartners.com LLC g.. uSight h.. Bank of America i.. The Processing Network j.. LinkPoint k.. CyberCash l.. TPG by iPayment Technologies m.. PayFlow Link and PayFlow Pro by Versign Corp. n.. PayPal, including Integration with PayPal's Instant Payment Notification System. - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 01, 2006 5:43 PM Subject: Robust, easily configurable shopping cart? I need to add online commerce capabilities to a site. I've been playing with the idea of building the online catalog/cart application myself but this client wants to get rolling ASAP. Are there any recommended CF-based shopping cart apps? The following are important to me: * Doesn't rely on any specific framework, i.e. FB or Mach-II * Licensing allows full access to source code so I can apply my wite's look and feel * Supports a number of payment gateways, including PayPal and Google Checkout So far, cartweaver http://www.cartweaver.com/ seems to be a strong candidate, but there are things about it that I would need to add or enhance (more flexible shipping options, ability to have 1 full-sized image for a product, etc.). Thanks Pete ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262558 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Robust, easily configurable shopping cart?
While cf_ezcart looks good, I'm not wild about the licensing terms. I have multiple sites that use my core site code, and I'd like to be able to modify the core code to integrate with my site and roll it out to whatever clients need a cart. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262559 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Robust, easily configurable shopping cart?
Damn...Russ beat me to it :) Just like Clint Eastwood on a keyboard. Doug B. - Original Message - From: Doug Brown [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 01, 2006 6:31 PM Subject: Re: Robust, easily configurable shopping cart? I would say that CF_EzCart would be a good one.. http://www.cf-ezcart.com/shopping-cart-features.cfm Real-time credit card processors supported: a.. Authorizenet b.. Network 1 Financial c.. Netbilling, Inc. d.. EFSnetSM Web Payment Services e.. BluePay by Online Data Corporation f.. MerchantPartners.com LLC g.. uSight h.. Bank of America i.. The Processing Network j.. LinkPoint k.. CyberCash l.. TPG by iPayment Technologies m.. PayFlow Link and PayFlow Pro by Versign Corp. n.. PayPal, including Integration with PayPal's Instant Payment Notification System. - Original Message - From: Pete Ruckelshaus [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, December 01, 2006 5:43 PM Subject: Robust, easily configurable shopping cart? I need to add online commerce capabilities to a site. I've been playing with the idea of building the online catalog/cart application myself but this client wants to get rolling ASAP. Are there any recommended CF-based shopping cart apps? The following are important to me: * Doesn't rely on any specific framework, i.e. FB or Mach-II * Licensing allows full access to source code so I can apply my wite's look and feel * Supports a number of payment gateways, including PayPal and Google Checkout So far, cartweaver http://www.cartweaver.com/ seems to be a strong candidate, but there are things about it that I would need to add or enhance (more flexible shipping options, ability to have 1 full-sized image for a product, etc.). Thanks Pete ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262560 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Robust, easily configurable shopping cart?
While cf_ezcart looks good, I'm not wild about the licensing terms. I have multiple sites that use my core site code, and I'd like to be able to modify the core code to integrate with my site and roll it out to whatever clients need a cart. Well, in that case I might suggest http://www.cartweaver.com/other/affordable.cfm It has unlimited licencing. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262561 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Robust, easily configurable shopping cart?
Are there any recommended CF-based shopping cart apps? The following are important to me: * Doesn't rely on any specific framework, i.e. FB or Mach-II I'm curious as to why you have this requirement...and not just because CFWebstore uses FB. :-) Why would you *not* want something that you know follows some logical coding pattern versus some unknown spagetti code? Not that without a framework you can't have decent code, but I don't quite understand the prejudice against it, for an off-the-shelf product. I can understand not using a framework for your own code, if that's your preference. But with someone else's code, it gives you some idea of how things are put together. That's the entire reason I switched to FB in the first place. Although I doubt I'd ever move to something like Mach-II, since I do still want to keep it reasonably simple for those that don't do OO programming. As for wanting a single license to cover all the sites you set up, Cartweaver is the only product I know that does that, at least for CF. As you've seen though, the tradeoff is the fairly limited functionality. Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262566 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Shopping cart?
Was wondering if anyone has or knows of a resource on developing shopping carts that use a database for cart storage versus session scope. Just wondering what the best way to handle things would be. The way I imagine it, and I may be wrong, is to have the client create their ad and place it into a tempAds Table, then I would use the adid as the cart item key. Once the client decides to check out and I receive confirmation of payment, I would pull the information from the temporary table and insert it into the advertisements table. Does this sound about right, or am I way off base? any help is much appreciated. Doug B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping cart?
Doug, here's what I've always done. User visits site - CF creates a shopping cart key (createUUID()) and stores it in the session scope, as a cookie, or puts it into a very simple CARTS table. My cart_contents table looks like this (pardon the caps, I still use caps for SQL) CREATE TABLE CART_CONTENTS ( CART_KEY char(35) NOT NULL default '', PRODUCT_ID int(10) unsigned NOT NULL default '0', OPTION_ID int(10) unsigned NOT NULL default '0', QUANTITY int(10) unsigned NOT NULL default '0', ACCESS_TIME datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (CART_KEY,PRODUCT_ID,OPTION_ID) ) TYPE=MyISAM; This setup allows me to have multiple SIZES/COLORS of each product in the cart, and keep them separate. The access_time field allows me to delete old cart contents. When the user checks out, an ORDER is created in the ORDERS table, and the I *COPY* the cart_contents items into an ORDER_CONTENTS table with the same structure, except the order_contents table also contains the CURRENT price of the product. Never rely on your products table for historical price information. I had a customer that was constantly changing prices, and if I only did joins to the product table to get price, things would get ugly. You could optionally maintain a price_history table or something, but that overcomplicates it if you ask me. After checkout is complete, the cart_key stored in the session scope is deleted... if they do more shopping, an ew cart_key gets created. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262568 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Robust, easily configurable shopping cart?
Mary Jo Sminkey wrote: Why would you *not* want something that you know follows some logical coding pattern versus some unknown spagetti code? To a developer who might not know fusebox or mach-II might consider FB to be spaghetti code :) It's possible that the original author uses his own coding styles and rules, and integrating a fusebox or mach-ii based app might be too much trouble. Just because you don't use a common framework doesn't mean there isn't logic and design to your code. Rick ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262569 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Robust, easily configurable shopping cart?
Rick Root wrote: Mary Jo Sminkey wrote: Why would you *not* want something that you know follows some logical coding pattern versus some unknown spagetti code? To a developer who might not know fusebox or mach-II might consider FB to be spaghetti code :) Then this is their own problem and do not change the 'truth'. :) When there is not any well known method/framework used, I personally do not prefer this kind of code and I don't trust it. It's possible that the original author uses his own coding styles and rules, and integrating a fusebox or mach-ii based app might be too much trouble. I heard this a lot but I personally do not know any developer who has his/her own method and creates a good code. :) The developers that I have respect - all of them- are using one of the known frameworks. Just because you don't use a common framework doesn't mean there isn't logic and design to your code. For me it does! Rick OÄuz Demirkapı TeraTech Inc. | Senior Developer 405 East Gude Dr Suite 207, Rockville, MD 20850, USA Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185 Web: http://www.teratech.com | E-mail: oguz.demirkapi AT teratech.com Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~~~ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Robust, easily configurable shopping cart?
It's possible that the original author uses his own coding styles and rules, and integrating a fusebox or mach-ii based app might be too much trouble. Yes, but that's exactly my point. With an unknown code base, there's no way to know how easy or hard it would be to integrate into ANY coding style, framework or not. I certainly have plenty of users that use my product with non-FB sites, it doesn't force them to code everything they do that way. Just because you don't use a common framework doesn't mean there isn't logic and design to your code. As I did say. But there's no way to know that, or to know if that logic or design will match your own logic and design. Generally with an off-the-shelf product, you're going to drop it into a separate directory and call it from there (unless you use it to run the entire site which many people may do). You don't want to integrate it highly into existing code for a simple reason...it makes updates a real PITA. Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262571 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping cart?
I had a customer that was constantly changing prices, and if I only did joins to the product table to get price, things would get ugly. You could optionally maintain a price_history table or something, but that overcomplicates it if you ask me. Doug covered the basics real well here, I'll just add that another good reason for not joining the product table is so you can delete products no longer being used, while maintaining your order history. --- Mary Jo ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262572 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Shopping cart questions?
I have a classifieds site that I am needing to design a shopping cart for. What I am looking to do is let the user create their ad and then once they are done and hit continue, they are taken to a page where they can choose to check out, or they can create another ad. I am wondering what the best way to store this information would be. I may in the future use a clustered enviornment and therfore do not think keeping the cart contents in the session scope would be a great idea. What would be the best way? Database? All input is appreciated. Doug B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping cart questions?
You could serialize the cart (using WDDX or some other method) and put it in the client scope. I also think just using a database is a good option. Using a database would allow you to easily see your customers' carts, which might be useful from a support perspective. Also, it would allow a customer to put ads in his cart and log in later from another computer to pick up where he left off. Patrick On 11/27/06, Doug Brown [EMAIL PROTECTED] wrote: I have a classifieds site that I am needing to design a shopping cart for. What I am looking to do is let the user create their ad and then once they are done and hit continue, they are taken to a page where they can choose to check out, or they can create another ad. I am wondering what the best way to store this information would be. I may in the future use a clustered enviornment and therfore do not think keeping the cart contents in the session scope would be a great idea. What would be the best way? Database? All input is appreciated. Doug B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261800 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Shopping cart questions?
If u store the cart in the database, they can at least come back later and complete the order. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 00:52 To: CF-Talk Subject: Shopping cart questions? I have a classifieds site that I am needing to design a shopping cart for. What I am looking to do is let the user create their ad and then once they are done and hit continue, they are taken to a page where they can choose to check out, or they can create another ad. I am wondering what the best way to store this information would be. I may in the future use a clustered enviornment and therfore do not think keeping the cart contents in the session scope would be a great idea. What would be the best way? Database? All input is appreciated. Doug B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shopping cart questions?
Well, that is what I was thinking. The other issue that I have as far as using the database storage is image uploads. I plan on allowing a user to upload as many as 10 images per ad, and was wondering how to handle the image upload if they end up not checking out. Should I just run a scheduled task every so often and delete the images off the server based on the info in the tempCart table? Doug - Original Message - From: Snake [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, November 27, 2006 7:05 PM Subject: RE: Shopping cart questions? If u store the cart in the database, they can at least come back later and complete the order. -Original Message- From: Doug Brown [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 00:52 To: CF-Talk Subject: Shopping cart questions? I have a classifieds site that I am needing to design a shopping cart for. What I am looking to do is let the user create their ad and then once they are done and hit continue, they are taken to a page where they can choose to check out, or they can create another ad. I am wondering what the best way to store this information would be. I may in the future use a clustered enviornment and therfore do not think keeping the cart contents in the session scope would be a great idea. What would be the best way? Database? All input is appreciated. Doug B. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261804 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shopping cart questions?
On 11/27/06, Doug Brown [EMAIL PROTECTED] wrote: Well, that is what I was thinking. The other issue that I have as far as using the database storage is image uploads. I plan on allowing a user to upload as many as 10 images per ad, and was wondering how to handle the image upload if they end up not checking out. Should I just run a scheduled task every so often and delete the images off the server based on the info in the tempCart table? I would run a scheduled task to delete expired carts (in the tempCart table) and their associated images at the same time. Patrick -- Patrick McElhaney 704.560.9117 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CF Shopping Cart solution
http://www.fasttrackonline.co.uk/support/support-centre.cfm http://www.fasttrackonline.co.uk/online-shopping-cart.cfm Although live and in production for some months the product is still being expanded as fast as I can get to it. Bugs are being knocked out as fast as beta test customers can find them! I am waiting for Zip code databases and USA sales tax schemas so the product will soon work well in the USA as well as the UK, expected within 10 days or so. Constructive feedback welcomed, please. Jenny Jennifer Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date: 15/09/2006 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4