Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sales-quote]

Denotes questions related to the sales quote on Magento (creation, management, modification, relations)

2
votes
0answers
29 views

How to correctly add an extra charge to a Magento 2 order's total amount?

We're using a custom module to calculate an amount we need to include in the grand total of the order, i.e. the customer will be charged for the product PLUS this custom amount. The result is our ...
0
votes
1answer
22 views

When add second product, custom attributes not save data. Using event “ sales_quote_item_set_product ” in Magento 2

I used the sales_quote_item_set_product event to save data to the table when adding to cart product. It works but when I add the next product, it does not save the old data in the old field. My ...
0
votes
0answers
19 views

Magento 2 customer is saved as guest even if he logged-in in quote table

We have an issue that if a customer is logged-in and add product to cart, in quote table we have a column as customer_is_guest, it is saving as 1, even if the customer is logged-in, it is showing as ...
1
vote
0answers
13 views

Magento 1.9 moving products between websites

How to move a product/item who was added to cart/quote on websiteA to cart/quote which is on websiteB. I would like to solve this problem with controller, but I am not very successfull. Do you ...
0
votes
0answers
16 views

Error While saving quote programmatically

Notice: Array to string conversion in D:\Projects\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php on line 3074
1
vote
1answer
22 views

How can I get customer_taxvat on sales flat quote in - Magento 1

public function loadAttributeOptions() { $customerAttributes = Mage::getResourceSingleton('customer/customer')->loadAllAttributes()->getAttributesByCode(); $attributes = array(); ...
0
votes
0answers
24 views

How to get the custom quote field in quote Api?

I have added a custom attribute in my quote table and sales_order table. How can I get this custom attribute in my quote Api so that I get the custom attribute with quote_id in response. After ...
8
votes
3answers
124 views

Getting Value of product attribute on cart page even not assigned to that particular product Magento 2

I am getting the product attribute from quote. It seems there is wrong value comes. Please check my below code. $objectManager = \Magento\Framework\App\ObjectManager::getInstance(); $cart = $...
0
votes
1answer
42 views

Show value of all totals in controller action

I need to log the values of all totals from a controller action. If the controller action is called, then i need a list rendered which shows the totals: If you are not familiar with totals then look ...
0
votes
0answers
35 views

Unable to Update a quote item additional_options on cart edit item action

I would like to update the quote item additional option with my custom input value I am trying below event checkout_cart_update_item_complete public function customPriceUpdate(...
0
votes
0answers
59 views

Request for quote and checkout at same time

We have a requirement like a customer can quote an item and checkout on same time by click on the process to checkout button. we have 2 type of products on our website. one for quote item and normal ...
0
votes
1answer
128 views

Magento 1: Check if customer has quote

How can I filter customers by the fact if they have a quote in the sales_flat_quote table? I could foreach every customer to check if their email address is located in the sales_flat_quote table, but ...
2
votes
0answers
372 views

Create quote with product options programmatically

i created a product with customizable options like this: and i've successfully create a quote like this: $store = $this->storeManager->getStore(); $websiteId = $this->storeManager->...
1
vote
0answers
19 views

Magento 2 : Send email of unused quote information to store admin with separate module

If customer not generated any order while fill checkout form and not created any order for few hours like 6 hours , so store admin getting email and get details of that customer.
1
vote
1answer
520 views

Get Payment details in QuoteManagement.php

I have extended QuoteManagement.php file for split order. It's working fine, but I need payment details like credit card details to process the order. But I am not able to get payment details in file ...
2
votes
0answers
257 views

Why some order id are skipping from admin panel Sales > Order [duplicate]

Why this number jumps from 189 to 191 ? When i found this issue there were many missing order number. Even i got solution that some order with status : pending or hold cant be seen in the admin ...
1
vote
0answers
53 views

No customer_id in sales_flat_quote but forced login? [closed]

In our shop there are records in the table sales_flat_quote where the customer_id is NULL. If I understand correctly this is due to a customer not being logged in. The catch is that our shop has ...
3
votes
2answers
3k views

I want to set custom price programmatically to the product Magento 2

I want to set the custom price for the product programmatically.In my current code , the customer create programmatically and set the products to the newly created customer.But i want set all product ...
0
votes
0answers
141 views

How to add a custom serialize value in sales_flat_quote_item_option table

Here my code but it does't work $action = Mage::app()->getFrontController()->getAction(); //echo "<pre>";print_r($action);die; if ($action->getFullActionName() == '...
1
vote
1answer
344 views

Tracing missing order numbers in the database, possibly even before they are “reserved”

Hoping for someone to chime in who extensively knows the Magento database architecture inside out. Missing order numbers. Example, in Magento, order number increments like: 100002410 100002411 ...
1
vote
1answer
309 views

Which tables are affected in Magento 1.9 when I empty the cart?

I am working with a Magento 1.9. I had added some products (Simple products) to my cart as a logged in user and saved it for checkout it later. But I haven't placed it as an order. I empty that cart. ...
10
votes
0answers
256 views

Is there an event or plugin spot for when cart rule is no longer valid?

Is there an event or place I can plugin for when a shopping cart price rule is no longer valid (such as when it expires or if you change the quantity of other products where it no longer applies)? I ...
1
vote
1answer
1k views

How to save order comment programmatically in magento2?

1)I'm creating custom order comment text box in sales->order->create new order . 2) Created order_comment column in sales_ order grid/quote. 3) I need to save order comment text box value into db....
1
vote
0answers
38 views

How to change Submit Order button on Magento 2

How can I change the "Submit Order" button on new order view? I tried changing Magento_Sales::order/create/totals.phtml Text get changes, but the page does not refresh on adding or deleting a ...
1
vote
0answers
126 views

Magento 2: How do I join sales_order_grid table to sales_order_item table?

select * from sales_order_item t1 inner join quote_item t2 on t1.quote_item_id=t2.item_id inner join sales_order_grid t3 on t1.order_id=t3.entity_id I am trying to pull a report along with each ...
0
votes
1answer
392 views

Magento 1 OR 2 : Set custom product weight in quote

I have a dynamic product which is based on user size input. On the basis of user size input I am calculating product price and weight. I already set the product calculated price in custom price field ...
1
vote
2answers
2k views

Update “sales_flat_order_item” table when making an order

I have created a custom product attribute that needs to be inserted into sales_flat_order_item (there's a custom column already created) everytime an order is placed. Config.xml for the observer event:...
0
votes
1answer
384 views

Remove SalesRule from Quote Magento 1.x

I want to remove the SalesRule from Quote if rule Coupon type is Mage_SalesRule_Model_Rule::COUPON_TYPE_NO_COUPON I have this code: $event = $observer->getEvent(); $quote = $event->...
0
votes
1answer
456 views

Product price not being set for programmatically created quote item

I am using the following code to set the product to the quote object $product=Mage::getModel('catalog/product')->load($id); $quote->addProduct($product,new Varien_Object(array('qty' => $...
1
vote
1answer
1k views

Magento 2 saving custom attribute to sales_order_items

I have a custom attribute of a product, that I want to have it's value stored in sales_order_items. I have added an extra column in the table sales_order_items. But How can I store the value of that ...
2
votes
1answer
1k views

Get quote data(Shipping zip code) from observer magento 2

I created a observer and i need to fetch the zip code of current quote, Below code is for my event.xml <event name="sales_quote_collect_totals_before"> <observer name="...
1
vote
1answer
912 views

How to add new input field in cart page in magento2?

In Magento2, I want to add/show custom input field in checkout page and save it to my custom field from Sales_order and Quote table in database.
1
vote
1answer
1k views

How to save quote billing address in magento 2?

For our project we have customized theme in Magento2. This has billing and shipping address pages. We have to save the billing address details in quote address table. But we didn't come across any ...
2
votes
2answers
1k views

Magento2 Split Order Based on Vendor

I am trying to split the order based on vendor during checkout process. If there are two products in cart from different vendor, order needs to be split based on vendor. I have followed the answer ...
0
votes
2answers
194 views

Magento model not fetching data

I am using magento 1.9. I want to retrieve data from sales_flat_quote_address table in onepagecheckout, after saved the shipping method. I have used the following codes. But no result. Code 1: $...
1
vote
5answers
2k views

convert quote to order for guest users

Hi I am converting a quote to order programatically. 929 is a quote id of a guest user.When i am trying a actual customers quote id it is working fine.but for guest this is not working. giving error ...
0
votes
3answers
4k views

Remove item from Quote item - Magento1.9

Hi I was trying to remove an item from the sales quote item. $quoteItemCollection = Mage::getModel('sales/quote_item')->getCollection()->addFieldToFilter('quote_id', $quoteId)->...
0
votes
1answer
659 views

Magento 1.9 Not able to create quote item

I have the following function inside my model.This checks for the device id(custom column in sales quote) in database and if found and the qoute item has same product id then just updates the qty or ...
0
votes
1answer
416 views

Get all quote id from custom column data magento 1.9

I have the following code. Where I pass a device id which is stored as a custom column in sales_quote and get all the quote ids to that device id. By trying the below code I am able to get only first ...
1
vote
2answers
486 views

get cart items from custom column value

I have a custom column in my sales_flat_quote_item table named as device_id. I am working on to create a api where a device id is sent and the cart available items are displayed for guest users. $...
0
votes
2answers
5k views

get product id from quote id - Magento 1.9

Hi need toget the product id of in a quote item.i have the qoute id with me and tried the below code but product id does not seem to display from the quote. $quoteId=784; $quote = Mage::getModel('...
2
votes
2answers
423 views

How to add quote Item id as new field?

I have a new field varient_id in sales_flat_quote_item and sales_flat_order_item table. I want to save item_id as varient_id in sales_flat_quote_item and sales_flat_order_item table. ie,quote ...
0
votes
1answer
63 views

How to save customized field of sales_flat_quote_items table's in sales_flat_order_item table?

How to save customized field of sales_flat_quote_items table's in sales_flat_order_item table? <fieldsets> <sales_convert_quote_item> <recipients_name> <...
1
vote
1answer
626 views

Event for Sales Order Quote Item

Question is about Magento 1.8 While creating order in the admin panel -> Sales -> Orders -> Create New Order When I add products, I can change the price to "Custom Price" and Update Items as below; ...
1
vote
1answer
366 views

Create an order from an existing order

I have seen lot of posts, but didn't get proper answer to create new order from an existing orders at magento. Concept is create an order from an existing orders by copying all elements/object from ...
0
votes
1answer
133 views

Set Default Shipping Price in Cart When Customer Isn't Signed In

I am trying to set up Magento so that if a new customer that isn't signed in and they add a product to their cart, it has a pre-selected shipping method and shows the price for that shipping method, ...
0
votes
0answers
263 views

magento save checkout onepage custom step data without creating a new column in quote table

I have created a new custom step on checkout onepage and want to save the data of custom step. Is there any other option than creating a new column in quote tables and saving data there.
4
votes
2answers
3k views

When Quote id generated in magento?

When Quote id generated in magento? Is it generated: when customer got registered or when customer adds product to cart. I have gone through many article but there is no clearance on it.
0
votes
0answers
1k views

programmatically adding product to cart returns every time diffrent quote id in android application

Below code work perfect on IOS application but now work in android application. <?php error_reporting(0); include("../app/Mage.php"); umask(0); Mage::app(); $store_id=$_POST["store_id"]; $...
1
vote
1answer
213 views

Magento 1: when is the email added to the quote?

I noticed something interesting today. I was working on a module that deals with the sales_flat_quote table. I'm using this table to notify abandoned carts. However, one of the email in this table ...