Sales

162

Solutions

366

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Share tech news, updates, or what's on your mind.

Sign up to Post

I signed up for costco membership in person at the costco store giving my united states state id.
I thought costco stored information by recording my state id number.

But when I used my costco membership number to sign up for costco.com online I was asked questions about my credit report.  
Where were you living in 1990?
a b c d choices.

In this example I am the consumer.
But I would like to be the merchant using customer state id.
Do you have examples of websites offering this service?
0
Upgrade your Question Security!
LVL 12
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Hi Expert,

I have a following requirement could anyone please suggest on this!

Assume a Sales table with columns for Sales_Amount, Customer_Name, and Region.
There are other columns and indeed other tables, but that’s not important.
 Give me the top 5 customers by total Sales_Amount, within each Region.
 The number of regions may vary over time, and your query needs to keep working as regions come and
 go (i.e., you don’t get to handle this with a CASE statement). You may assume there are more than
 5 customers with sales for each Region. So if I have 3 unique values of region in the table,
 I should get 15 rows, 5 for each region. But if there are 5 regions, I should get 25 rows.
 Write a Oracle-SQL script for this. No JOINs are needed, you’re only using one table.
You can use as many queries, and as many Temp Tables, as you need.


create table sales (customer_name varchar2(10), region varchar(20), amount number(10));

begin

insert into sales values ('ahmed2', 'Asia', 40000);
insert into sales values ('ahmed3', 'Asia', 60000);
insert into sales values ('ahmed4', 'Europe', 210000);
insert into sales values ('ahmed5', 'Europe', 30000);
insert into sales values ('ahmed6', 'Europe', 210000);
insert into sales values ('ahmed8', 'Europe', 5000);
insert into sales values ('ahmed9', 'Africa', 8000);
insert into sales values ('ahmed10', 'Africa', 86000);
insert into sales values ('ahmed11', 'Africa', 99000);
insert into sales values ('ahmed12', 

Open in new window

0
Designing a scientific calculator in Ms Access,I'm almost done with the calculator VBA in Ms Access. The current issues that I cannot sort out are below:

(1) I want the form size to open like the size of a pocket calculator, I want this form to be used as a calculator on all sales & purchases forms in ms access


Is there a code or something that can reduce the size of the form? in design format I'm able to that , but when I open the form it fills the whole screen, that what I do not want.

(2) the form must be called from the sales invoice form and appear like a calculator, I want the simple method of calling it like using a macro or VBA ( Do.cmd) , is it possible?

I have assembled a called for calculator , like the one we use in C#


Regards

Chris
0
hye, EE experts, i am thinking to get advertisement to my own web site that  has 6000 chinese visitor as  monthly in English site about taxi fares calculating , is there any idea or advice  for getting online advertisement affiliate commpany??
Another question related,  i have domain name  such as htttp:// www.fastfood.[city name]. How to and where to sell this domain name as godaddy recommended price 650 $ ??
0
We are trying to setup an API in Magento 1.9.3.8 when the current admin password is entered, the system comes back with Invalid current password. Does any one know what password is magento expecting? I am the admin of the system so should be able to use my password, but the role name is not admin, is Sales API.

Any one here have an idea of how to fix this? Cannot setup my taxjar account because of this issue.

Thanks,

FE
0
I want to get a list of sales orders that are 7 years old so I wrote the following query:

SELECT SalesOrderNumber, CAST (OrderDate AS date) AS 'Date of order'
FROM Sales.SalesOrderHeader
WHERE  DATEDIFF(YYYY, OrderDate, GETDATE()) = 7                            

I am concerned about the effect the  DATEDIFF expression in the WHERE clause will have on the execution plan that is decided upon by the optimizer because I know that one should not   have an expression on the lhs , so I changed it for this query and I gave me exactly the same execution plan:

DECLARE @compdate INT = 7
SELECT SalesOrderNumber, CAST (OrderDate AS date) AS 'Date of order'
FROM Sales.SalesOrderHeader
WHERE  @compdate = DATEDIFF(YYYY, OrderDate, GETDATE())  

Is there a better way of doing it ?
0
Hi、

I would like to use online "Map" service like Google Earth, Google Map, and etc. in order to display about 1000 customer locations on the map.
It is for the internal use, so I do not want to share the data on public, so that our sales staffs can use the tool for analyzing the route or location to set their sales strategies.

Could you share with me how to accomplish it and what are the actual steps?


Thank you,
AW
0
I have a query where I am trying to get one line for each sales agent for a particular month, with total sales for that agent for that month. I can't get the syntax. I have tried everthing I know of and it's probably very simple. the date field is called paid date. Can anyone help me?
I only have three columns in my query, 1. Agent, 2. Sum of Price and 3.  Paid date. The Agent is group by,  the Sum of Price field  is summed and the Paid Date  field is group by
0
So, I've done some AMAZING research and found...some VERY out-of-the-way places.  I'm thinking of building a Google map.

But, seems like then anyone could take the same data and recreate it.

Don't want to debate the merits of information be free.

Need suggestions about to monetize the work that I've done.  Sharing it puts it out there.  I can see that.  But...what can I consider to do with the page that holds the information?  Or, even the map itself? Should I even MAKE a map?  How can I use what I've got?  One suggestion I can see is...if my page is popular enough, put the map in there and let people who would copy it...go ahead.  A more popular page will always win the day.

Thanks!

OT
0
I have plotted sales revenue graphs on all the items under a certain brand.

From the graphs that I have plotted, can you help me identify any patterns or trends in the sales of each of the items under the brand? :)

Charts.xlsx
0
Cloud Class® Course: CompTIA Cloud+
LVL 12
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

I am trying to write a query in oracle for sales vs received per day of the same item.

Basically I have two identical tables with the exception of one column - one tables shows sales per day, the other shows received per day.

I need to write a report showing the sales AND received per day on the same line, even if one or the other is zero.

How do I write this particular query?
0
I have a table (tMain) of sales... one entry for each sale.  In this table is the model (FrameModel) and an office (Office, currently just testing for all offices in the table.)  I would like to run a query that will pull the max similar model sold and display their count and also find their percentage (based on the total number of FrameModels sold) .  I am using the following query to try to pull this and a date range based on a form for the user,  (Basically trying to find models that have sold over 1 to find out "top model" sellers.

Its returning results but  I know for sure that there are other fame models not even showing up that have many sales (over 10)

SELECT tMain.DOS, tMain.FrameModel, Count(tMain.FrameModel) AS CountOfFrameModel, tMain.FrameLine, tMain.Office
FROM tMain
GROUP BY tMain.DOS, tMain.FrameModel, tMain.FrameLine, tMain.Office
HAVING (((tMain.DOS) Between [Forms]![FReportSelect]![DateStart] And [Forms]![FReportSelect]![DateEnd]) AND ((Count(tMain.FrameModel))>1))
ORDER BY Count(tMain.FrameModel) DESC;

Thank you.
0
Hi,
I am building an integration for Microsoft Dynamics 365 especially for Sales product in it.
The plan is the following -
Any user within a company who is using Microsoft dynamics 365  can install my application. My application i have registered on Azure portal.
After doing OAuth for a particular user i intend to send him data for example the number of leads created in last month etc..
For this i will use the dynamics 365 Web APIs.
My question is will any organization be able to use it ?
Does any application registered through microsoft Azure portal allowed to do OAuth for any dynamics 365.
And will Microsoft dynamics 365 CRM allow to use the web APIS to access its data.

As i see that there are many versions of Microsoft Dynamics 365.
I have doubt regarding this.
I have also heard about developer service account.. Where does that fit into here.. If i have to build such an application.
Thanks
0
Hi there,

I am looking for a partner portal which enables my company to organize and streamline questions and requests from partners. Moreover, things like static technical sales and technical information, ticketingsystem, partner status (level & training), onboarding process are very welcome. My company is active in the contact center industry where it sells its contact center solution through partners.

Any advice will be appreciated!

Kind regards,

Joep Vreeswijk
0
Dear Experts

Our organisation has decided to implement ERP -   our management is convinced with SAP to be chosen however not yet finalized, our objective is to have one unified solution across the organisation at present we are using sales force.com for marketing and sales function,
1. would like to understand does SAP has capability for sales force automation and does it support the integrations like CTI, web, face book, mainly does it allow web API integrations
2, if not SAP please suggest other ERP product which can handle sales force automation and other process, we are in real estate vertical (we do not construct we only sell the flats).
3. what all the measures to be taken to implement ERP,  is CIO needed as the technology is one part, do we require Consultant who has implemented in our vertical and project manager who leads the implementation,
4. please help me with the list for the need of technology and IT head role in detail for this project similary consultants and Project Manager and what are various types of roles to be put in place to choose and start ERP implemtetion who can drive and implement successfully.
5. Please let me know the approach or methodology for implementing the  ERP what top management should do and what all the roles to be created to implement the ERP, thanks
0
How do i use macro to auto update my formulas and cell references? I have a pivot table containing sales data, with the columns stating months from January to March. But for every start of the month, i need to update the latest month (i.e. update to April when it's May) to show to a new column. I cant use getpivotdata because i need to track the cell reference, and the data will change for each month so i cant pre-count April's values. Beneath the pivot table, I have a normal table stating sales data total [i.e =sum(Jan-Mar)] which i have to manually update. Is there any way for macro to automate the normal table to update =sum(Jan-Mar) to Jan-Apr? Example like =sum(b1:d1) to =sum(b1:e1) and for subsequent months?
Book1.xlsx
0
Getting started with EventBrite

I am new to the web seminar business and need to rely on proven platforms for max guidance, so I cam spend my time prepping my seminar.

Has anyone used EventBrite for ticket sales?

Promotion?

Organizing event schedules and attendee lists?

 would be happy to hear from you and perhaps with some guidance about the steps I need to take.

Thanks
0
I have a client with an office365 account with a single e-mail address 'user@hisdomain.com'.  This user does outside sales work for other companies that have their own e-mail systems and domain names, and they have created e-mail addresses for my client in their domains 'user@theirdomain1.com and user@theirdomain2.com'.
My client uses office365 OWA, Outlook and Outlook for Mobile to access email
We currently have forwarded 'user@theirdomain1.com to user@hisdomain.com'.  When my client receives an e-mail from 'user@theirdomain1.com' they want to be able to reply to the e-mail and change the 'from' address to 'user@theirdomain1.com'
How can I set this up in office 365 so they are able to change the 'from' address to the proper Domain for the reply to keep e-mail continuity?
Thank you
0
Hi,

We are working with a marketing strategy  for assisting surveying certain areas.  The front end is a screen with a series of questions which will later be analyzed.  Our concern to EE  is how can we protect or make sure that visitors are not repeating the questionair.   Also, detect if same ip or if the visitors somehow hiding their ip.  We are trying to assure the visitors is one visit per actual visit to the pages, no repeats.

Please advice.
0
Cloud Class® Course: Microsoft Office 2010
LVL 12
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Need to launch a nationwide speaking tour but need a plan involving Social Media Marketing

I have a timely book whose message needs to be heard by the world, ASAP. And I hope to start a tour going from Boston to New York City, then on to Washington, the general routes of the carnage on 9/11/2001. I want book signings at various book sellers, some small free presentations at locations where I would get a warm audience and live presentations where I will sell tickets. It's the ticket sales which will be paying my travel costs, I think, rather than the books sales.

So, I look to my ability to schedule online presentations at no cost as the way to generate the traction I can use as I start to book physical speaking engagements.

For example, I am thinking about using online presentations like a Ted Talk, or even crowd funding to get it going.

You can see, my book topic is like none other, and has wide appeal, given it contains the secrets of secret societies, hidden in plain sight. And it proves there is much we do not know about America's history of massacres, on the occult date of 9/11 (September 11th in America and November 9th in Hitler's Germany)

https://www.amazon.com/Fortress-Harvard-ThinkTank-Royal-Revenge-ebook/dp/B077ZS8XJ7/ref=sr_1_2?ie=UTF8&qid=1513561863&sr=8-2&keywords=fortress+harvard

What is involved with making a Ted Talk?
What can you tel me about Crowd Funding?

I WILL use someone like GoFundMe. The 5% is NOT AN ISSUE for me.

I want quick…
0
Hi, I wonder if I could get a little advice with regards to the direction I should go with my website please. I'm an independant Windows software developer and I'm about to release a major upgrade of my one of my softwares "The DataSurgeon" (www.thedatasurgeon.net). Up till now, sales have been pretty thin, partly I suppose because marketing is not my strength, and also being a one-man show - I don't have a lot of time for it while trying to simultaneously do software development. Partly too, is that the software itself is sort of a multi-purpose package and I find it hard to explain it in a succinct, brief and "punchy" way (hence the reason why my current site is so wordy). It's a unique and specialized software for people who work with very large raw data files (ie. data warehouse, data archivists, IT back office people, contact list vendors/brokers, etc). It lets them (1) Easily do complex queries at a very low character-level (2) Modify/fix those found matches (3) Perform tallies and aggregates on the matches found. In effect, it does things easily that normally one would need to hire a programmer to accomplish - I guess that's my best angle here. I really don't know what to compare it to other than an easy to use "regex engine" or "grep software" without the learning curve. And again, it's much more than that.

Anyway, the existing format/layout of my website is clearly not hitting homeruns. I realize the current capture page is not the best and fanciest thing going, …
0
Hi Experts

Sorry people may be I mislead you. All what I want is how to include a productID range within Dsum

Dsum(“Closing”,”QryOpFinalstocks”,” [ProductID] = “ & Forms![<formname>]![<controlName>]& “ And [Warehouse ID] = “& Forms![<formname>]![<controlName>]& “ And [PPDate] <= “#& Forms![<formname>]![<controlName>]& “ #” )

I need that so that the selected code from the form query are picked correctly

How do we insert a product ID range in the above code??????????????

Regards

Chris
0
Hi all Experts!

I want your help on cost of sales, the second sub report attached to the invoice is supposed to calculate the cost of goods sold. At the moment staff are keying in the calculated average unit cost of the products manually which is prone to errors, and so to try and solve this problem I have created the code below, the idea here is that, the code will first sum all the total invoices values and then divided by the sum of all units for that product bought, the result is supposed to be an average cost per unit. But it is giving an error, any idea?

Private Sub Form_BeforeInsert(Cancel As Integer)
    Me.Cost = (Dsum(“TotalCost”,”tblInventory”,”ProductID = “ &Me.ProductID))/ (Dsum(“QuantityBought”,”tblInventory”,”ProductID = “ &Me.ProductID))
End Sub

Before select the product Id I have also notice an error, it disappears temporary after product ID selection. I understand there is a function in Ms Access called ISERROR(Value)that can suppress this error but I’m not sure how to use it.

Accomplishment

Here what I want to archive is that the moment a product ID is selected, the cost field on the form must be field and once the form was finished and saved then the cost should be inserted in the underlying table. Does this sound possible?

Regards

Chris
0
Need a ticket management system for a speaking tour

I need an easy to configure ticket sales service with some basic features:

- At first I will give tickets for free
- I want to switch to charging money per ticket, with the flip of a switch
- I'd like eventually offer the first X tickets for free, then charge a fee after that the free tickets have been taken

I need to support multiple speaking dates with multiple locations

I have no merchant credit card service and need a service which combines payment processing.

I need to accept many payment methods and not require a person to have a PayPal account in order to use a Visa card.

What are some choices?

I do have a WordPress site with a WooCommerce plug-in. But I suspect I would get up and running faster if a choose a full-service website for this.

Thanks
0
Hi Experts

I have four controls on a form as below:
1.      Total sales
2.      Cash Received
3.      Change
4.      Shortage
The shortage control will only filled in if the cash received is less than total sales , quite okay I have this VBA Code below , but I want the message part to be showing numbers or amount showing as shortage in the string as well.
If (Me.TotalSales > Me.CashReceived) Then
Beep
MsgBox “Please note that you received not enough cash for this transaction”
Cancel = True
Exit Sub
End If

Now suppose the shortage amount is $20, our business rule require that in the message the $20 should appear as well, example:
MsgBox “Please note that you have received not enough cash for this transaction, and so you have a shortage of $20, please check again”
0

Sales

162

Solutions

366

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.