e-commerce

how to build e-commerce shopping site software?

I've a plan to build a e-commerce shopping site software. Let anyone who wants a e-commerce site, he will sign up on my site e-commerce shopping site software, then a store will be created for him with subdomain, if my e-commerce site is e-commerce.com, he signed up with store name "sample", now he will have a store like sample.e-commerc...

Possible to select...for update, do e-commerce transaction, and then call a MySQL stored procedure in PHP?

Hello, I am currently building a PHP e-commerce website for my client. Its been going smoothly but I've hit a roadblock and was wondering if any MySQL/PHP experts can help me. Basically, the e-commerce site sells a product only once (meaning they only have one quantity in stock for each item), which means that once a customer checks out...

How long until MySQL transaction times out

How long can a MySQL transaction last until it times out? I'm asking because I'm planning to code an payment process for my e-commerce project somewhere along the lines of this (PHP/MySQL psuedo-code): START TRANSACTION; SELECT...WHERE id IN (1,2,3) AND available = 1 FOR UPDATE; //lock rows where "available" is true //Do payment proce...

Implenting Credit card processing within PHP MySql Site

Hi, I am developing an Ecommerce website and I would like to implement Credit/Debit card processing within the site. I would like to know if there are any good PHP scripts which fully implement this and the payment gateways that provide this service. Also the website will have a Money Back guarantee feature in the event of cancellin...

how to enable the Customer Information Manager (CIM) in authorize.net?

hi When i am storing the credit card information in customer information manager its showing "E00044Customer Information Manager is not enabled" error. How to solve this problem? ...

Google Analytics not working 100% with Magento

Hi, I need to solve a problem that the e-commerce report on analytics page, is showing 30% less sales than the Magento report. I was wondering where I put the analytics code with the sales transactions? In the success page after the payment? On our e-commerce, we use a third party billing app that makes the user navigate to another p...

Magento Multiple Authorize.net Gateways

I have a CAD and USD gateway accounts for processing credit card payments, both from a payment provider with support for the Authorize.net API. I've successfully configured one using Magento's built-in Authorize.net support... but how can I configure a second Authorize.net Gateway for use in my store? ...

Is there anything wrong with this mysql trigger?

I have a product, sales_order, and sales_order_product table. The nature of the products dictate frequent changes to price and weight. The customers often times save orders for a few days before submitting and paying for them. Because of this lag and the price/weight fluctuations, we allow them to freeze in the price/weight at the ...