All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

Edit quote qty but price incorrect for mutiple products

I would like to update quote from a order. When I update qty of a item from quotes it make correct subtotal and tax. However, when I update great than 2 items then subtotal and tax get last data ...
1
vote
1answer
25 views

how can we access customer session in checkout

I have one special field called some_id in customer data and I want to save the some_id and quote_id in database. I am using sales_quote_save_afterevent to save both ids. But my customer session is ...
0
votes
1answer
30 views

What is quote_preview table used for in Magento 2

I was checking the quote tables in Database and stumbled upon quote_preview table, anyone have idea what it is used for ?
1
vote
2answers
224 views

Create Column in Quote Payment Table in magento2

i want to add new column in Quote payment table i tried script but not working <?php namespace Ibnab\Additional\Setup; use Magento\Framework\Setup\InstallSchemaInterface; use Magento\Framework\...
0
votes
1answer
243 views

Product price is not set when programmatically creating quote

I am creating a rest api for cart. $product = Mage::getModel('catalog/product')->load(1); $quote = Mage::getModel('sales/quote'); $quote->addProduct($product, $qty); $quote->...
2
votes
1answer
720 views

Integrity constraint error referring to quote_item table while adding product to cart

I am getting the following error while trying to add product to cart in Magento 2.2.3. [2018-05-02 09:52:43] report.CRITICAL: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or ...
0
votes
1answer
295 views

“We can't add this item to your shopping cart right now” on detail page (Magento2 EE 2.1.7) Update

How to resolve ??? I has changed in vendor\magento\zendframework1\library\Zend\Cache\Backend\File.php:99 Change 'cache_dir' => null to 'cache_dir' => 'var/cache'. And not resolve this. Plsssss ...
0
votes
0answers
600 views

Add value for custom quote item attribute using REST api

I want to add value for custom quote attribute using rest api. This attribute is not a product attribute. I have created a database column in quote_item table. Also created the plugin on class Magento\...
3
votes
2answers
321 views

Create new row in Database when we click on button

By Default Magento create new row in Database in table sales_flat_quote_item_option once we click on ADD TO CART We are giving an option of uploading custom image on Product image with help of ...
0
votes
1answer
48 views

Unable to nullify a custom field

There is a custom extension that manage the shipping address for a local shipping carriers. Besides some extra fields for local data there is a custom field called tipo_direccion (address type in ...
0
votes
1answer
4k views

What is use of sales_flat_quote table? Can it be truncated? [duplicate]

I want to know functionality of sales_flat_quote table. If I would truncate this table then will any issue occur or not?
4
votes
2answers
4k views

How to run a query to deactivate quotes as Magento code?

I need a Magento code query to set all quotes to Not active. How do I write this query as a Magento code? UPDATE `sales_flat_quote` SET `is_active`=0 WHERE `customer_email`='user@gmail.com'
1
vote
1answer
546 views

How to manually convert a series of quotes to invoices (orders)

For about 24 hours yesterday we were experiencing an issue where Magento could not create new invoices. It has since been resolved but I now have a series of orders (22) that are trapped in the ...
1
vote
1answer
182 views

sales_flat_quote_* vs enterprise_customer_sales_flat_customer_quote_*

I'm looking to remove old quotes from the database via a Magento shell script, and I see enterprise_customer_sales_flat_quote and enterprise_customer_sales_flat_quote_address whose purpose is unclear ...
6
votes
4answers
23k views

How can I get a quote id after an order is made?

Okay the question is how to get a quote id after an order is made.. and I know what people are going to say - why? Well I have some custom details being inserted into a custom table at checkout (via ...
0
votes
1answer
317 views

Copy array from product to quote item and order item

I am copying single valued attributes from product to quote item and converting to order item. But is it possible to do that with an array? If yes - what's the process and what type should the table ...
3
votes
1answer
5k views

Add a column to quote item table

I want to add a column to the sales_flat_quote_item (and ..._order_item) table through an install script, but when I go to the table sales_flat_quote_item (or ..._order_item) in my database - the ...
1
vote
0answers
1k views

Possible Bug - Hidden tax amount on quote and order item but no discount amount [closed]

I came accross a problem with one of our customers order on magento 1.7.0.2. There seems to be two problems. In backend there 5 items. 3 of the items has discount applied on them. 2 items do not ...
47
votes
7answers
17k views

Price re-index causes DB deadlocks during checkout

I'm experiencing an issue where I believe the Product Price re-indexing process is causing a deadlock exception in the checkout process. I caught this exception in the checkout process: Order ...