How to find the customer with the highest order amount?
The outer-most query joins the CUSTOMER_T table with the inner results to get the customer Name and total order amount for all customers that match the MAXAMT value. You may also pull the outer query of CUSTOMER_T inside the inner table and add it to the joins.
How to limit free shipping to certain products?
To limit the coupon to certain products, choose the first option (“Order at least X units of product Y, get free shipping to specific shipping zones”). Click on this product (none selected) and select the product, then choose the applicable shipping zone (s).
How to find all orders with order amounts?
Contribute your code and comments through Disqus. Previous: Write a query to find the name and numbers of all salesmen who had more than one customer. Next: Write a queries to find all orders with order amounts which are on or above-average amounts for their customers.
How to find details of customers who ordered?
Please note that I have seen a similar query here, but think my query is different enough to merit a separate question. Now suppose I would like to find the names of all the customers who have ordered more than 10 different types of product, and the number of types of products they ordered.
What is the definition of minimum order quantity?
What Is Minimum Order Quantity The definition of minimum order quantity, or MOQ for short, is the minimum quantity of goods a customer needs to order to start purchasing from a business. If the customer is unable to meet the MOQ requirement, the supplier will not sell their products to that particular customer.
Where to find minimum and maximum purchase quantity?
1. Go to Products › View and click the name of the product you want to edit. 2. In the Purchasability section, enter a Minimum and/or Maximum Purchase Quantity. 3. Save your changes when you are finished. Using the Products v2 experience? The Minimum and Maximum Purchase Quantity fields can be found under the Other Details tab.
How to find out your average order size?
If your wholesale business is just starting out or if you do not keep track of your historical order data, finding out your average order size will be difficult. However, if you can access your company’s historical order data, one possible way to set your MOQ is to set it just above your average order quantity.