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
Cloud Class® Course: C++ 11 Fundamentals
LVL 12
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Are the following business scams (I registered for a talk) or genuinely, there are people
who made it in the businesses?  I've heard of a neighbour's friend who made about
US$600k of sales via Amazon.

http://www.aceproacademy.com/5ssa-live-ecommerce-training-ag/?target=gem-5ssa3b-105&cam=gem-5ssa3b-105

And the bitcoin talk below as well:
http://www.aceproacademy.com/cps-live-training/?target=5ssa-thankyou&cam=5ssa-thankyou#!/index

What are the tell-tale signs if they are scams or anyone had been through them before & care to share?
1
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
Database7.accdbHi Guys,

I am trying to create some meaningful CRM style reports and forms based on our accounts transaction file.
I need to create this kind of output:-

                          TOTAL SALES       FRESH          SAUSAGE            HAM             PIES          OFFAL           OTHER                  
customer          LYTD   YTD        LYTD  YTD      LYTD YTD    etc
                          TOTAL TOTAL   TOTAL TOTAL    etc

I think I am fast approaching my current query/crosstab/union etc  ability.
btw  LYTD is last year to date, I have achieved most things with a selection of select queries, crosstab queries, left/right and union queries and i think
I am making this more complicated than is necessary.

1. The reason i need left and right join query is because some customers have no data for LYTD or YTD so in order to get everything I need to do the whole left/right/union thing
but if i injected 0 where there is NULL can i dispense with the l/r/union.
2. I cant seem to work out how to get totals for all sales and categorys.


many thanks in advance.
Your humble servant
Andy
0
I had this question after viewing PayPal IPN, PHP, & MySQL.

Hi,

I am selling CDs (and other stuff) mainly via eBay but also in other outlets (BigCommerce shop) and I want to do that following to automate this:
1. Collect payment notifications via Paypal IPN message using an IPN Listener Script and verify the payment - this bit has been tested as ok
2. Add CD/DVD sales information to a MySQL Database - I've created the database and attempted to add some lines to index.php to create entries
3. Transpose (parse) the resulting table information so that this can then be sent to Kunaki to ship the discs - I have found and partially updated a php file for this that does connect with Kunaki
4. As Kunaki is somewhat slow to send to anywhere but the USA, I wish to provide a link to a download for the software contained on the discs, immediately, so the buyer has instant access (currently, I've been doing this bit manually as I have access to the files on my home Synology NAS drive and have been sharing the links via email - I am eager to automate this somehow)
5. If I could also update the sale by providing a USPS tracking number that Kunaki provide, to the customer somehow, that would be great
6. Also, if I could update eBay or Paypal to state that the item has been sent, that would also be ideal.

So far, I have 3 files:

ipnlistener.php - to interface with the Paypal IPN
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
digitalmarketing

Every business relies on effective marketing to get the word out and sell products. It doesn’t matter what industry you’re in—if people don’t know your product or solution exists and why they should buy it, your company will not be successful. Unfortunately, many people working in tech today don’t have much knowledge of what strategies are used, and which tactics are most successful. 


If you don’t know that much about modern marketing, you’re definitely not alone! With that said, you should at least know the basics of effective tech marketing. Even if you’re not involved with marketing, knowing best practices will help you understand your consumers and help you serve them better.


Shifts in Marketing Strategies


Marketing today is much the same as it was a few decades ago, but the Internet has given us new mediums and the potential to reach an unimaginably large audience. Ads were once the biggest portion of any business’s marketing budget, but Americans have become more and more jaded about them over the years (with the possible exception of Superbowl commercials). 


With the more immersive environment of the Internet, ads have begun to lose their power and have become more annoying to the average buyer. 91% of people feel that ads are more intrusive today than they were two years ago, and 81% have navigated away from a webpage or closed it entirely because of pop-up ads. With these shifting attitudes, marketing tactics have changed as well. If your tech marketing could use some improvement, here are some best practices for modern marketing that can help any company succeed.


Understand Consumer Behavior


This is one of the most important principles of marketing. If you don’t know what your customer wants, you cannot market to them effectively. Fortunately, there are a lot of tools for gaining market intelligence, and the ability to collect data through big data platforms and Google Analytics gives marketers a lot to work with. There is also danger in relying solely on the numbers, however—it takes time and patience to build a brand, and it can’t be done by just plugging in the right numbers. You need to use your analytics as a supplement. Talk to your customers. Use surveys, focus groups, and interviews. Find out what they need and want from the source!


Create Better Content


One of the biggest shifts that has taken place in marketing over the last few years is the amount of content that is being created. Content can include blogs, videos, articles, quizzes, whitepapers, and more. Companies that create good content can gain goodwill with customers by providing value upfront and building customer trust and authority. The idea is that when they’re ready to buy, customers will think of the brand that gave them the best information, and choose that brand.


In order to effectively leverage content marketing, you don’t just have to produce content—you have to create good content. That may seem obvious, but there are a lot of tech companies out there just putting out blog posts for the sake of having a blog—the information isn’t necessarily valuable or even interesting. Tech companies that actually produce valuable content will stand out from the competition and catch the notice of consumers.


Create Emotional Responses


We like to think we’re rational creatures, but in general, emotions overshadow logic. Appealing to consumer’s emotions is what ultimately makes sales—emotional ad campaigns outperform rational campaigns by almost double. People want to make a personal connection to a brand in whatever way they can. That’s one of the reasons personalized marketing is becoming more and more popular as analytics empower marketers to hyper-segment their customers. 


One good way to create emotional responses in your audience is to tell a story. This helps you to connect more deeply with your customers and help them relate to your message. Think about it: would you rather make a recipe that just lists the steps and ingredients, or the one with a great family story behind it? It’s the same principle in tech marketing. Stories make everything better.


Marketing in Tech: Remember the Human Connection


People see everything your business posts and does online. Improve your brand awareness by implementing good online marketing strategies and connecting with customers. Getting noticed and building trust is a marathon. You need to continually add value, share your content, and look for new insights into your customers’ wants and needs. Numbers matter in tech marketing, but the human connection is absolutely crucial.


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
Cloud Class® Course: Microsoft Exchange Server
LVL 12
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

I need to subscribe to office365 to access email, office suite online/offline and onedrive for 3 users. I see 10 - 15 month per user, but seems the sales person keeps trying to sale me implementation, deployment and other services. can anybody help me? this is for business and may expend to 9 users in future.
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
Using Access 2016:  I have a Query which groups agents by sales. Not every one will have data that month. I would like to email each individual agent his sales for that month. My questions are:
1. what's the best way to set this up, IE should I use a query, or a report based upon the query. I would need to create an agents table with email and name.
2. what are the steps involved?
3. what would be the code, we currently use go daddy for our email. We do not have a server in-house.
4, what event of the report or query would I use to add the code?
5. can you share code that works for 2016 access?

is this even possible? If the agent has no sales for that month, it should not create the email or should not create a report, if the report is based on a query?
If you can help, I would be gratefully appreciative, or if you can point me to a "dummies" link where I can try to create something.

The last question I had, I got some awesome answers from PatHartman and John . I am in hopes that one of the experts can help me with this as well as those two helped me with my query question. I know this is a lot to ask, but if you know, please help.
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
Hello,

Are cloud phones better than an on premise solution?
We currently have a Siemens 4K phone system used with a PRI.
We have about 230 voice over IP phones and about 15 digital line phones.
Most of the ip phones have a basic setup with add on module to configure additional lines.

The 15 digital lines are for our sales department, the have a ACD routing setup(similar to a hunt group). Each sales person has their prime line and 2 secondary lines. We have it configured so that that each sales person is able to answered each others lines. Each sales person has about 50 lines configured on two phones at their desk that they can answer when any line rings. We it setup this way because our president wants sales to try and answer all calls and not have them go to voicemail.

We recently started to look at cloud phones and providers like ring central, 101voice and others. Our main concern is QOS and if our setup in sales will be supported.

We are not sure if cloud phones will be more reliable and if we will have the same quality of service?

Thank You


Let me know if you need any clarification.
0
3 LinkedIn Tools
The LinkedIn platform has been widely used by brands to communicate with the audience and improve their customer service. Similarly, the network has to do it right. Here are 3 tools that make LinkedIn so good.
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 want to attract sales people to sell my affiliate product, but I don't want to go beyond the limit of a few hours a week of managing the website.

So, I posted my offer on Freelancer and one person applied to the position, and then suddenly the job offer was taken down from Freelancer. (I am not sure why).

The job offer was a good offer, it said that sales person would earn 80% of the commissions. That's a good offer for someone to earn from the website. But the statistics
reveal that only that one person applied for the position.

If I have to spend many hours soliciting the job offer in order to get a sales person, then instead, I should close the website(s) because there is no time to deal with that.

Can anyone tell me where I can find such a sales person who will work in that scenario so as to expedite the sales of the website? (but without exceeding three hours a week
of management).
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
Get your problem seen by more experts
LVL 12
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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
Has anyone managed to tap into 365 Client Management tenant details including subscription renewals with PowerBi. I dont want to give my sales team full delegated access to 365 to review subscriptions.
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.