[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More







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

Hello :-)

I have an excel spreadsheet where there is a product code and the sales amount of that product per day. I need to take the average sales per day range for a given product. How many sales for product 01 between 10/11 and 02/12 for example.

Some idea?

The spreadsheet:
Exploring ASP.NET Core: Fundamentals
LVL 12
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

(1) I'm required to deliver the access application system in a supermaket envirnoment, now the number of cashiers will be 20 (Users) accessing the same sales accounting or tables. My application is split into backend & front end of which per user will have their own front end linked to the backend on the server.My fear here is the locking system even if all my forms show the record locks property  - No Locks, any idea how go about this?

(2) I have also experienced some issues of power failure in some clients work place, now because of the same you find in the FE folder sometime their is an extra file generated after power failure any idea how to sort out this? Though my current advice to the clients is to invest in UPSs


Example.xlsxExample.xlsxI have a spreadsheet, attached, of my prior year monthly sales, and my current YTD monthly sales.

How do I write a formula (not an array or VBS please) to compare YTD totals through this month last year, compared to this month this year?

Thank you.
I need traffic to my website. I have started with Social Media, Submitting my sites to Search Engines.

Several years ago, I studied SEO but, I have found that things have changed so much as it pertains to traffic such as Meta Tag's submissions and PPC.

I am looking to building up my traffic up to my E-commerce Websites / Aliexpress Affiliate websites.

Can you help me to build my traffic to my websites and to build my SEO?  My sites are very new in the development stages. If possible I would like free or low costing options.

Thanks in advance Experts.
I have a website that I designed with the Aliplugin.  This is it: http://essmen.com/.  My website visits are about 400 visits per day with any advertising other than links on Facebook, Twitter, and Google Plus.  I have two problems. One is the traffic and the other is that fact that no one is buying any of the affiliate products.  I have close to 19000 products on the website and can add more. I was advised by the Alipartnership to add as much product to increase my chances of indexing quickly.  I am a complete newbie and want to stop spinning my wheels on these issues. Can I get a little help on getting possible free traffic or very cheap traffic? And, I want to know how I can possibly get some one to buy something on my website to start making affiliate income?  I have had the website up going on two months. I do not want to just jump ship now based on the advise of the Aliplugin people. i'm just sayin'
How to calculate Last 2 months average sales in sql server (excluding the current month)
I have been working as a consultant for a number of years,    I have a diverse and pretty extensive background, I basically do server\desktop\network\firewall\VPN\Exchange hosting\DR\Business continuity down to desktop preventive maintenance, builds etc.. Basically whatever is needed.

One of my larger clients has concerne if I were to die where that leave them.  From day one due to my background of managing IT, and staff for companies with multiple location and being a senior IT person prior to consulting. I always put in place what I could to minimize exposure.  I do the same with the current client base.  Admin passwords are on file, all prod servers always covered by contracts with an SLA of on site in 4 hours etc.

This is a difficult one to answer.  They are under the false impression they would be safer with a larger consulting company. They will never get this level of responsiveness/expertise/service/or price.   I would love to grow the business and bring on someone else, or possibly acquire another consulting business, do I try to find a commissioned sales rep?  Or even take over accounts of a small consulting business in the area where the owner was close to retiring, but for the life of me, I am not sure how to find consulting businesses that might be for sale, or someone in a similar situation that I can trust, and would not go after our clients etc.
Surely there are other consultants on this site that are in similar situations.    If you think about it, we…
Doing a pst migration in tandem with an email migration into O365. We are using native tools so far, but with the nature of pst imports into O365, the manual process of setting up batches has been a bear to deal with. All the users are storing psts on their personal network share, so not a centralized location. Many users have multiple psts of varying sizes.  They are willing to consider a 3rd party tool to help, but there are so many out there. I haven't used any yet. Can anyone suggest what tools they have used, what they liked and disliked? Trying to make an informed decision without all the sales hype. Thanks!
I'm planning to go for Amazon FBA business & was recommended to get
Helium 10 to do analysis of sales in Amazon.

Someone told me it's almost US$200/month subscription or is it
US$200 once off?

While waiting for promo (heard sometimes there's half price), anyone
can suggest a similar freewares (that once I key in an ASIN ie Amazon
Stock I...  Number), it will list competitive products with their $ sales
turnover, profit margins (for each product), sales in terms of qty
I have now hit a brick here full time,after creating a DSN Less file and code below this works well with the same network and as long
the computer/Servername remain the same:

Driver={SQL Server Native Client 11.0};Server=Sales\SQLEXPRESS;Database=MDCAccounting;Trusted_Connection=yes;

Now our client is using his own network which is different to the one we are using or where the DSN Less was compiled as result the connection has failed even after doing the following:
(1) Installing the same Express server on their server ( This server is now called FINANCE not SALES as above)
(2) Ms Access runtime & correct ODBC on their Four work stations were all properly installed
Is there something I'm not understanding here, could it be there is need for a table relinker code? If yes do we have a sample somewhere?
I strongly believe that the fact that I'm moving the data base from one network to a diffrent customer network and server has caused this

Kindly assist with a working code if possible.
OWASP Proactive Controls
LVL 12
OWASP Proactive Controls

Learn the most important control and control categories that every architect and developer should include in their projects.

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?
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.


And the bitcoin talk below as well:

What are the tell-tale signs if they are scams or anyone had been through them before & care to share?
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));


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

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#


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 $ ??
We are trying to setup an API in Magento 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.


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 ?

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,
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
Become a Certified Penetration Testing Engineer
LVL 12
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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.


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? :)

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?
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.
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.
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






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.