Messages

Great

i will open a new post to comment my experience with the app.
I have to say its excellent and with great support.

Thanks

Hi llegrand, Basara

I install a new server, config a product in abantecart,  Track Stock:Yes, Stock Checkout: No, Default Stock Checkout: OFF.

I have the same error.

After you check out an order you go to the page "/abantecart/index.php?rt=checkout/confirm"
Title:  Checkout Confirmation. You stay here.

then you go in other internet explorer to the product page and put product out of stock or put the product disabled
Then you go to the Checkout confirmation page and clic "Confirm Order" and system go to "/index.php?rt=checkout/success" without valide products.

Its a bug confirmed, please try by yourself and you will find the same error.

This happen because i dont have payment as paypal or something like that, my payment is cash on delivery so maybe this is the why there is not validation. I test also credit sell and when you go to the credit payment and clic "continue_button" it valide products and get you back to the cart. But In the "Confirm order" button there is not validation when you clic the button.

OK
I will revert the code changes and i will try again.

Thank you for your help

Basara, another test is:
You have a customer in "Confirmation order" stage, and you go to products and set quantity to cero.
after that the customer click in "Confirm Order" and the Customer received orderid and quantity products go to -1.

What is another way to see this error. There is not working quantity validation on "Confirm Order"

Basara i follow what you send me and i am ok.
Exist an error in Abantecart and its the following:

The quantity validation is in checkout process not in "Confirm Order".

The test scenario we are trying is with 5 customer, all checkout ok because quantity is 1. All 5 customer want 1 quantity.
The checkout process is OK.

When they go to the page Payment -> Confirm "Checkout Confirmation", they click in "Confirm Order", all at the same time, all received an order id, because there is no more validation in "confirm.php"
The page is: index.php?rt=checkout/confirm

please tech me, what i have to copy from checkout  to confirm  to execute the validation quantity process again in the confirm process. I send you the image validation from checkout that i need to call in confirm process.

Tell me what files and what sentences in php.

I thank you very much your help.

Hi Basara thank you very much for your fast answer but you dont understand me, the process is to reduce quantity in "confirm order", not in "checkout" because a person can not confirm order and the product is not selled.

I check out without problem, its in the "confirm order" option, when you get your order id, if i have 5 people giving clic at the same time and i have only one product quantity, all received an order id and all think they bought the product but only one should, becuase in yard sell first in first out. Right now my quantity goes to -4 and i have track stock activated and Stock Checkout No.

Please tell me how can we confirm order but only the first person receive orderid and all 4 receive a "sorry message".

I thing maybe is  a paramenter In settings -> All settings. "config_stock_subtract" = off.

Thank you very much for your help. If you want a can share you the link of the site in a private message.

I began a yard sell with Abantecart, we test the app and its excellent but have a big mistake that its not possible to use for a yard sell.

In a yard sell we have 1, 2 or 3 item products.
When 2 person select a product into the cart and we have only 1 quantity in stock, both checkout and both confirm order at the same time, and both got an order ID but we have only one product and quantity go to "-1" what is incorrect.

¿Is there a simple way to correct this to make useful abatecart for a yard sell? ¿Its there a way when several persons clic at the sametime only the first one get the product and the others recieved a sorry there is no product?

In Catalog - Products: i have
Track Stock:Yes
Stock Checkout: No
Minimum quantity: 1
Maximum quantity: 1
Pre-Order Stock Status: Out of stock

In settings - General i have:
Display Stock Quantity = ON
No Stock Auto Disable = ON
Default Pre-Order Stock Status: Out of stock
Enable Tree Grid: OFF
Enable Storefront Embed: OFF
Embed Click Action: Same Page Modal Dialog

In Settings - Checkout:
Default Stock Checkout: OFF




I will thank you your help.

Hello

Please go to

storefront/view/default/stylesheet/style.css

edit and change in this place:

.thumbnail a.productcart {
   background: #00A1CB;
   color: #fff;
   float: right;
   padding: 5px;
   font-size: 13px;
   text-transform: uppercase;
    position:relative;
   

Code Select Expand

display:none;
}

and if you use call to order, then edit here:

.thumbnail a.call_to_order, .productpageprice a.call_to_order {
   background: #00A1CB;
   color: #fff;
   padding: 8px;
   font-size: 13px;
   text-transform: uppercase;
   border: none;
   box-shadow: none;
   text-shadow: none;
   float: right;
   margin: 5px 10px;
   

Code Select Expand

display:none;
}

BUt what does that means?
I would like to know to change it in the place you say.

Hi

in spanish Abantecart received a message:
habet nulla seu negative stirpe attigit, Numerabis main productum sive omnia bene. ut a praecessi of
autodisable occasum, uber

Where i can change this?

Oh excellent
I didnt know it exist Themes free outsite the abantecart store.

thank you

Hello everybody

I investigated how to do the quantity restriction and got it by this way:

I create a view in mysql workbech:

Code Select Expand


CREATE
    ALGORITHM = UNDEFINED
    DEFINER = `root`@`localhost`
    SQL SECURITY DEFINER
VIEW `bitnami_abantecart`.`products_customer` AS
    SELECT
        `ac_op`.`product_id` AS `product_id`,
        `ac_op`.`name` AS `product_name`,
        SUM(`ac_op`.`quantity`) AS `quantity_hist`,
        `ac_c`.`customer_id` AS `customer_id`
    FROM
        ((`bitnami_abantecart`.`ac_order_products` `ac_op`
        JOIN `bitnami_abantecart`.`ac_orders` `ac_o` ON (`ac_op`.`order_id` = `ac_o`.`order_id`))
        JOIN `bitnami_abantecart`.`ac_customers` `ac_c` ON (`ac_c`.`customer_id` = `ac_o`.`customer_id`))
    WHERE
        `ac_o`.`order_status_id` = 5
    GROUP BY `ac_op`.`product_id`, `ac_c`.`customer_id`, `ac_c`.`customer_id`


This view show product_id, product_name, customer_id and sum(quantity) group by product and customer, so i can ask for orders made in history by customer with status "5-Complete".

And modify this

Code Select Expand

htdocs\core\lib\cart.php from line 166

Code Select Expand

$product_result = $this->buildProductDetails($product_id, $quantity, $options);
            if (count($product_result)) {
                $product_data[$key] = $product_result;
                $product_data[$key]['key'] = $key;

// Query for max product per customer --- CG
$prod_query_customer = $this->db->query("SELECT * FROM products_customer WHERE customer_id =
'".(int)$this->customer->getId()."' and product_id = '".(int)$product_result['product_id']."' ");
$quantity_hist = $prod_query_customer->row['quantity_hist'];
$quantity_ask = $quantity_hist +  $product_result['quantity'];

if ( $quantity_hist >= $product_result['maximum']) {
$this->cust_data['error'] = "Ya compró " .$quantity_hist. " de " .$product_result['maximum']. " unidades permitidas de: " .$prod_query_customer->row['product_name']. ". El producto se ha retirado de su carro de compras. Por favor compre otros productos disponibles.";
$this->update($key, 0 );
}
elseif ($quantity_hist > 0 and ($quantity_ask > $product_result['maximum'])) {
$new_quantity = $product_result['maximum'] - $quantity_hist;
$this->cust_data['error'] = "Ya compró " .$quantity_hist. " de " .$product_result['maximum']. " unidades permitidas de: " .$prod_query_customer->row['product_name']. ". La cantidad solicitada se ha ajustado a " .$new_quantity. ". Por favor revise su pedido.";
$this->update($key, $new_quantity);
}

//else {

                //apply min and max for quantity once we have product details.
                // if ($quantity < $product_result['minimum']) {
                //    $this->language->load('checkout/cart', 'silent');
                //    $this->cust_data['error'] = $this->language->get('error_quantity_minimum');
                //    $this->update($key, $product_result['minimum']);
                //}
                //if ($product_result['maximum'] > 0) {
                //    $this->language->load('checkout/cart', 'silent');
                //    if ($quantity > $product_result['maximum']) {
                //        $this->cust_data['error'] = $this->language->get('error_quantity_maximum');
                //        $this->update($key, $product_result['maximum']);
                //    }
             //   }
            } else {
                $this->remove($key);
            }
        }

I had to comment the quantity validation made by order (Abantecart default) to apply my own validation per customer.

Hello

Please follow this:

1. Add the extention bank transfer in menu extensions/payment
2. Go to system -> location -> languages definitions
3. Write in translation fields "Bank Transfer"
4. Change every field transaltion that said "Bank Transfer" to cash.
Example: default_banktransfer_name you write cash in store or only CASH.
Bank Transfer Instruction you write Cash payment instruction

I hope this help you

I will answer to myself

The right instruction is:

Code Select Expand

(int)$this->customer->getId()

Hello llegrand, Hello to all  I got it.

I investigate how to do the quantity restriction and found this:

I create a view in mysql workbech:

Code Select Expand


CREATE
    ALGORITHM = UNDEFINED
    DEFINER = `root`@`localhost`
    SQL SECURITY DEFINER
VIEW `bitnami_abantecart`.`products_customer` AS
    SELECT
        `ac_op`.`product_id` AS `product_id`,
        `ac_op`.`name` AS `product_name`,
        SUM(`ac_op`.`quantity`) AS `quantity_hist`,
        `ac_c`.`customer_id` AS `customer_id`
    FROM
        ((`bitnami_abantecart`.`ac_order_products` `ac_op`
        JOIN `bitnami_abantecart`.`ac_orders` `ac_o` ON (`ac_op`.`order_id` = `ac_o`.`order_id`))
        JOIN `bitnami_abantecart`.`ac_customers` `ac_c` ON (`ac_c`.`customer_id` = `ac_o`.`customer_id`))
    WHERE
        `ac_o`.`order_status_id` = 5
    GROUP BY `ac_op`.`product_id`,`ac_c`.`customer_id`


This view show product_id, product_name, customer_id and sum(quantity) group by product and customer, so i can ask for orders made in history by customer with status "5-Complete".

And modify this

Code Select Expand

htdocs\core\lib\cart.php from line 166

Code Select Expand

$product_result = $this->buildProductDetails($product_id, $quantity, $options);
            if (count($product_result)) {
                $product_data[$key] = $product_result;
                $product_data[$key]['key'] = $key;

// Query for max product per customer --- CG
$prod_query_customer = $this->db->query("SELECT * FROM products_customer WHERE customer_id =
'".(int)$this->customer->getId()."' and product_id = '".(int)$product_result['product_id']."' ");
$quantity_hist = $prod_query_customer->row['quantity_hist'];
$quantity_ask = $quantity_hist +  $product_result['quantity'];

if ( $quantity_hist >= $product_result['maximum']) {
$this->cust_data['error'] = "Ya compró " .$quantity_hist. " de " .$product_result['maximum']. " unidades permitidas de: " .$prod_query_customer->row['product_name']. ". El producto se ha retirado de su carro de compras. Por favor compre otros productos disponibles.";
$this->update($key, 0 );
}
elseif ($quantity_hist > 0 and ($quantity_ask > $product_result['maximum'])) {
$new_quantity = $product_result['maximum'] - $quantity_hist;
$this->cust_data['error'] = "Ya compró " .$quantity_hist. " de " .$product_result['maximum']. " unidades permitidas de: " .$prod_query_customer->row['product_name']. ". La cantidad solicitada se ha ajustado a " .$new_quantity. ". Por favor revise su pedido.";
$this->update($key, $new_quantity);
}

//else {

                //apply min and max for quantity once we have product details.
                // if ($quantity < $product_result['minimum']) {
                //    $this->language->load('checkout/cart', 'silent');
                //    $this->cust_data['error'] = $this->language->get('error_quantity_minimum');
                //    $this->update($key, $product_result['minimum']);
                //}
                //if ($product_result['maximum'] > 0) {
                //    $this->language->load('checkout/cart', 'silent');
                //    if ($quantity > $product_result['maximum']) {
                //        $this->cust_data['error'] = $this->language->get('error_quantity_maximum');
                //        $this->update($key, $product_result['maximum']);
                //    }
             //   }
            } else {
                $this->remove($key);
            }
        }

I had to comment the quantity validation made by order to apply per customer. I would like to make this validation in the product page, but in the checkout process is excellent too.

I know my solution is not the best but it work and very well.