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)

0
votes
0answers
15 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
20 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
122 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
39 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
32 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
54 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
118 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
357 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
508 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
233 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
52 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
2k 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
136 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
335 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
286 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
244 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
118 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
387 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
365 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
445 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="...
0
votes
1answer
890 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
187 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
649 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
404 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
474 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
4k 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
413 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
621 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
362 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
130 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
261 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
211 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 ...
0
votes
2answers
684 views

Get cart contents from my custom module

In my magento, I have added a product to cart - so I see the following on the checkout page: I have a custom module with a TestController with a IndexAction where I want to retrieve the current ...
1
vote
1answer
5k views

How to change product name in quote item dynamically

Is it possible to add several the same product times to the cart with a different name? I did with different price, but I have not managed to do it with a different name. I used an observer "...
1
vote
2answers
1k views

Create Duplicate quote item instead of updating existing quote item for same product

Requirement-- I have created a custom Purchase Order module for my Magento Store, in which a same product may be supplied from many suppliers. You will be fully cleared from below example- (1) A ...
1
vote
1answer
992 views

Event to track quote changes in magento

I want an observer to track changes in Quote like when removing products, updating, adding product from frontend and backend as well. This observer should run after magento native code. There are ...