Questions tagged [sales-quote]
Denotes questions related to the sales quote on Magento (creation, management, modification, relations)
74
questions
0
votes
0
answers
19
views
d1m0000008oqveay--stage.sandbox.my.salesforce.com refused to connect in lightning when previewing Quote PDF
Hello
If someone can help, please instruct me the approach to solve this issue, thanks.
Refused to connect when I click on previewing quote in lightning..
d1m0000008oqveay--stage.sandbox.my....
0
votes
3
answers
148
views
Authentic way to access quote for admin and frontend area
I am working on shipping module where i need to fetch quote subtotal in both area frontend as well as admin order create.
I am using Magento\Checkout\Model\Session to get the quote subtotal but when i ...
- 460
0
votes
1
answer
38
views
I am new in magento! :: I have task to add a custom field('is_vip') in order columns. please help me?
Programatically, add a custom field('is_vip') in order. If a customer order value over $150 , the field value will be 1 and in order grid it will show yes.
0
votes
0
answers
104
views
Magento 2 Save Custom Address attributes in quote address
I have created 2 custom address attributes house name and landmark. From the backend, I can save the values of the attributes and it is shown in the address section. Also I have created fields in the ...
- 2,713
0
votes
0
answers
136
views
How Quote Works in Magento 2 and Data is inserted into Quote and Quote Item Table?
I want to know how Quote system works and how data is inserted into quote tables and how api retrieves data.Everything about quote by pure coding point of view i know that quote is cart object later ...
0
votes
0
answers
117
views
Magento 2 Create order even if product Qty is Zero
I want to create an order programmatically where a product qty is zero. I am unable to do so at I get a message as
{"0":"The requested qty is not available","1":"#1
...
- 1,153
0
votes
1
answer
494
views
How to set custom_field value from product page to quote after a product added to cart in magento 2?
I have a custom_field on the product details page( Like a hidden field ). Which is not a product attribute.
I can get this field value using checkout_cart_product_add_after event using an observer ...
- 2,671
1
vote
0
answers
29
views
Magento 1 Issue- Shopping cart rule does not apply on Reorder from backend
I am using Magento EE ver. 1.14.2.4
I have observed that shopping cart price rule does not apply on reorder from backend admin side.
It considers the original product amount instead of applying ...
- 2,630
1
vote
2
answers
2k
views
Magento 2 error "No such entity with cartid =xxxx"
I'm frequently getting this" No such entity with cartId =xxxxx " When I try to edit order by set order status to another status or assign order to customer. I've taken a look at the database ...
- 51
0
votes
1
answer
250
views
How do i get the value from addressInformation Magento 2
How do I get the example value which is the date.
$billingAddress = $order->getBillingAddress();
$shippingAddress = $order->getShippingAddress();
these two don't have it
But it saves in ...
- 669
0
votes
1
answer
221
views
How does sales_quote and sales_quote_adress table relate?
In the sales_flat_quote table, there is a store_id column. In my perspective the customer order in the front-end (website) and in the back-end, Magento creates each quote for different stores, if my ...
3
votes
0
answers
219
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 ...
- 31
0
votes
1
answer
340
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 ...
- 923
2
votes
0
answers
660
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 ...
- 147
1
vote
0
answers
25
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
0
answers
61
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
user76990
1
vote
1
answer
124
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();
...
8
votes
3
answers
651
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 = $...
- 2,950
0
votes
1
answer
185
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 ...
- 3,100
1
vote
1
answer
462
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 ...
- 1,331
2
votes
0
answers
559
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->...
- 600
1
vote
0
answers
33
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
1
answer
1k
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 ...
- 1,049
2
votes
0
answers
1k
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 ...
- 538
1
vote
0
answers
98
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 ...
- 11
6
votes
5
answers
16k
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 ...
- 2,950
0
votes
0
answers
174
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() == '...
- 375
1
vote
1
answer
655
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,753
1
vote
1
answer
1k
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.
...
- 147
16
votes
3
answers
2k
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 ...
- 634
1
vote
2
answers
3k
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....
- 21
1
vote
0
answers
141
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 ...
- 2,314
1
vote
0
answers
280
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 ...
- 11
0
votes
2
answers
806
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 ...
- 6,246
1
vote
2
answers
3k
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:...
- 191
0
votes
1
answer
985
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->...
- 213
0
votes
1
answer
639
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' => $...
- 43
1
vote
1
answer
2k
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,004
2
votes
1
answer
2k
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,040
1
vote
1
answer
2k
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.
- 552
1
vote
1
answer
5k
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 ...
- 1,247
3
votes
2
answers
3k
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 ...
- 1,965
0
votes
2
answers
341
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,118
1
vote
5
answers
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 ...
- 43
0
votes
3
answers
6k
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)->...
- 43
0
votes
1
answer
1k
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 ...
- 43
0
votes
1
answer
608
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 ...
- 43
1
vote
2
answers
796
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.
$...
- 43
0
votes
2
answers
7k
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('...
- 43
2
votes
2
answers
595
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 ...
- 2,713