Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x

Sales

101

Solutions

233

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 am in process of adding new item status to existing one. What all key fields , transactions I need to check and consider before making any chnages.

Thanks
0
Free Tool: SSL Checker
LVL 10
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I purchased a Ricoh MP C307 printer directly rather than going through the Ricoh sales people. It's a brand new printer with new toner, but for some reason it won't print black, we have to change font color to blue in order to print it. I called the seller, he told me I haven't done the setup right and that there is nothing wrong with the printer, he advised me to hire a Ricoh tech to do the proper setup. I've setup 100s of printers in my life time, I am pretty sure there is no magic step that I missed during setup. Would appreciate any tips on how to fix this. Thanks!
0
In a sales report I want to enter a date range from two DB fields used in a formula and then list two columns of results that list the results from the date range entered, as well as a comparison column of data from exactly one year previous. I'd like them to be listed side by side. Would I use a Subreport for the comparison data? And if so, how would I take the entered date range and have the Subreport use data from the previous year? I want only one prompt for a date range and have the report handle pulling data from the previous year for the comparison.

For example:

LEAD SOURCE CURRENT DATE RANGE:                                               LEAD SOURCE ONE YEAR AGO:
Lead Source: (formula 1)       Sales TTL: (formula 2)                          Lead Source: (formula 1)       Sales TTL: (formula 2)

I hope this is clear enough to follow, and thanks for the help!
0
Hello- I have recently gotten involved with our new MS Dynamics 2016 rollout for our sales teams and I am just kind of feeling my way through the many screens, etc.  I have one issue that I have inherited that I could use a little help troubleshooting.  We have two regional presidents.  Sales managers and sales team members are ultimately roll-up to these two presidents.  The way it has been explained to me is that when the presidents go into dynamics they have access to an 'exectuve view' (dashboard?) and one of the combo boxes on that view is 'My Open Opportunites'.  When the president selects 'My Open Opportunites' he is supposed to see ALL of the open opportunities in his region, from all sales team members.   This is working correctly for President A, but when President B looks at this screen there are no results.   Can someone point me in the right direction on what permission to check for President B in comparision to the settings for President A so that I might see if this can be corrected?  I have much to learn in the weeks ahead about all this but if I could get this little issue corrected it would be a great start!  Thanks for any help! -
0
Hello,

What Excel method(s) are most useful or valid for analyzing the relative sales success of a number of products?

That is a much less-specific question than I would like to be asking but suppose you have a sales report with the following information:

        Products: 200 SKU's
        Date Range: 3 years
        Number of Sales: 11,000+

...and containing the following data (file attached):

 2017-09-05c_EE.png
I had in mind creating a chart with the [# of items sold] as the vertical axis vs [time elapsed since product introduced] as the horizontal axis. However, that would be quite cluttered with 200 products so I'm interested in other approaches.

Thanks
Sales-report_2017-09-05_EE.xlsm
0
Need a report button for bad sales call attempts.

Just had an interesting sales call.  Well, there wasn't any call per se.  The phone rang and the caller ID was for a website.  When I answered, all that was playing was music and no person on the other end.  Annoying, right?  I hung up, looked up the website and found out it was a cloud VoIP website.  As soon as I went to the website a chat window popped up welcoming me.  Ugh.

Not sure if clever sales attempt phone call or rude way of luring me to their website.  I'm feeling the latter and also feeling taken advantage of.  I want to report this deceitful attempt at a sales call, but don't know if that's a thing?  If I mention the name then I also feel I'm spreading the word for them for free.  

>: (
2
 
LVL 7

Expert Comment

by:Brian Matis
Fortunately, I bet the people dealing with things like this complaint system might actually be the ones likely to care ;-)

For example: in the past I had great success with the FCC's Do Not Call list (Which I honestly wasn't expecting to work, but it absolutely did! I had needed to get a landline, and as soon as I did, it got a ton of daily telemarketing calls. Soon after adding the number to the DNC list, the calls dropped to nothing. The system worked!)
1
 
LVL 17

Author Comment

by:Kyle Santos
Nice.  In retrospect, I am just being bitter about it haha.  Just like we at EE do need data, I'm sure FCC needs the data as well to look upon and see 'do we deal with this now?  Is it a large or small problem?' :)  Who knows maybe they've already been reported or maybe I'm the first!
1
Adding curb appeal to your small business can attract your audience’s attention and convince them to come in to shop around. However, if you go overboard, you may cause your small business to look tacky or even annoying—pushing your ideal customer further away.
0
Hi,

I am trying to figure out how to sort SKUs in the sales order and in the shopping cart in Magento (ver. 1.9.0.1). Ideally we would like ascending SKU order. Any ideas on how to accomplish this?

Thanks in advance!
0
I would like to know if it is possible to restore sales in files and start over. I entered the wrong date for sales and I just would like to put them back and bring the correct date over.
0
Dear all;

I would like to find out whether it is possible to join two related queries to come up with summary data before create a report , example:

Query 1
Has the following fields

ProductID  SalesDate  SalesMixValue

Query 2

ProductID SalesDate SalesMixvalue

The idea here is to find the cumulative movement in terms of SalesMixValue , the thing is that each customer is given a discount on daily basis $200.00 any unused discounts is carried forward on a daily basis for future use , hence the need to determine the sales value on cumulative basis by product ID and Sales Date:

The mechanism here is that Query 2 must be always behind by one day lets say instead of pulling the current data as on 24/08/2017 it should just pull as on 23/08/2017

Query 1 must always pull the current data that is as on 24/08/2017

Now what is required here is to subtract Query 2 (salesMixvalue)  from Query1 (salesMixvalue) so that the accurate sales value netted with discount is reported as daily sales value.

Kindly see how you can help, I have heard of net query but frankly I do not understand it .


Regards

Chris
0
Better audio for more successful meetings
LVL 2
Better audio for more successful meetings

Challenge: S&ME was tired of poor audio quality of Skype for Business calls in mid-sized meeting and training rooms. They were looking for a reliable and cost efficient solution to replace the existing conferencing system.

5
 
LVL 3

Expert Comment

by:Anthony Pangilinan
Is it possible to have a place where people with different age range will hang together?

It sounds funny, and I think Kyle can also attest to it, but Pokemon Go achieves this. I've done raids that have included elementary aged kids and retirees. I've seen a lot of stories about children playing with their parents and grandparents and rejuvenating their relationships. The key to achieving this balance could be giving the users something on which to focus besides their own social lives. A 16 year old's social interests most likely won't align with a 30 year old's interests, but creating a common goal that interests people of any age can bring their worlds together.
4
 
LVL 17

Expert Comment

by:Kyle Santos
Well said.  That is one good example for sure.
0
I have the following query. The way it is written currently I have a column for each Customer. I was wondering if perhaps there is an easier way to write this. Basically so that I have two columns Customer and Net open Sales for 2017?

SELECT DISTINCT
        ( SELECT    SUM(price * total_qty)
          FROM      [KLL Open Orders - Header & Detail]
          WHERE     ( ( CUSTOMER IN ( 'AMA0010', 'AMA9010', 'AMA9011' )) )
                    AND ( (division = 'KLL') )
                    AND ( (end_date > = DATEADD(DD, -30, GETDATE())) )
                    AND ( ( ORD_STATUS = 'O' ) )
        ) AS Amazon2017 ,
        ( SELECT    SUM(price * total_qty)
          FROM      [KLL Open Orders - Header & Detail]
          WHERE     ( ( CUSTOMER IN ( 'BJS0010', 'BJS9010' )) )
                    AND ( (division = 'KLL') )
                    AND ( (end_date > = DATEADD(DD, -30, GETDATE())) )
                    AND ( ( ORD_STATUS = 'O' ) )
        ) AS BJ2017 ,
        ( SELECT    SUM(price * total_qty)
          FROM      [KLL Open Orders - Header & Detail]
          WHERE     ( ( CUSTOMER IN ( 'MOD0010', 'MOD9010' )) )
                    AND ( (division = 'KLL') )
                    AND ( (end_date > = DATEADD(DD, -30, GETDATE())) )
                    AND ( ( ORD_STATUS = 'O' ) )
        ) AS Burlington2017 ,
        ( SELECT    SUM(price * total_qty)
          FROM      [KLL Open Orders - Header & Detail]
          WHERE     ( ( CUSTOMER IN ( 'COS0010', 'COS0015', 

Open in new window

0
I want to do this for a customer.

I know I can access their Google Account from my computer (I have the email & password), I don;t remember how to do that (or even access my own Google Account, I know I have one)

How do I do that?

Thanks
0
Looking for a system which can reward sales people in a fair and transparent way such that easy for them to trace their own performance online and for us to reward, incentives, training, manage
0
I have one Facebook account and would like to talk with someone via chat who knows about how to properly configure Facebook, so that it can be used for professional, personal, as well as to sell products.

I currently have this page https://www.facebook.com/ted.penner.7 that is supposed to be my professional Facebook presence and people, even "friends" complain that they can't see anything at all.

1. I would like to be able to have a professional view as the default available at that URL to all the public.

2. I would also like to promote a video designed to sell a product from my website to a Facebook audience that cannot see any of my personal contacts such as so-called "friends" or "acquaintances".

Assistance is greatly appreciated.
0
Hi

In my WP blog, I'd like to give my users the opportunity to sell their associated art (their music)
Now that CD's don't exist, what are the opportunities here? mp3's, iPod?
How is music sold?
Do most people have the ability to acquire this music, in practicality?

Thanks
0
Webroot Certification Program
We're excited to announce the launch of our Webroot Certification Program.

The Webroot Certification Program covers key feature differentiators, deployment best practices, cybersecurity management, and basic troubleshooting techniques for SecureAnywhere® Business Endpoint Protection. The program enables the sales and technical teams at managed service providers (MSPs), value-added resellers (VARs), and other distributor partners to better sell and support the solution, as well as streamline and enhance their IT services business.

Get certified by signing up here.
2
I am about to launch a WordPress/WooCommerce site but worry about around the clock support for my site since my developer's in India, Monday thru Friday.

That's about 25% of the week! That being said, I would expect the bulk of sales to be on Eastern Standard Time, 8AM to Midnight, which means his coverage percentage is higher that 25%.

Are there are support models you can think of which would be me paying some small retainer for a WP developer to be on call and getting notified if there is a hiccup or site outage? Then, if there is real work that's needed, I'd pay on an hourly basis?

Curious...

Do I need to be worried at all about the site have problems which could cause it to be unavailable to process further orders?

I am not worried there may be a one in a hundred error rate which I can resolve when the email comes in, but instead, having a site outage causing orders to stop.
0
Hi,
I have a line chart that I use to show sales information.  I use it all year, but would like to highlight (via background shading) each quarter of the year.  I have had no luck so far.  Any suggestions?
Dan
0
[Video] Create a Disruption-Free Workspace
LVL 2
[Video] Create a Disruption-Free Workspace

Open offices have their challenges. And Sometimes, it's even hard to work at work. It's time to reclaim your office and create a disruption-free workspace. With the MB 660, you can:

-Increase Concentration
-Improve well-being
-Boost Productivity

I have a youtube video with a pitch for a subscription service.

I plan to get some assistance in promoting the service and want to find a way to tie the link being passed around by each individual salesperson, back to that individual so that I know what commission to pay them if those viewers become customers.

Assistance in figuring out how to do this is greatly appreciated.
0
I've got three columns: Individual, Amount, and Date. Each individual has multiple sales for each date, and I want to find the simplest way in which to see how much they sold on their best day, and potentially, what day that was. I can make a new sheet, with one column full of every date from January 1 to December 31, the second column containing the individual's name, and then a SUMIF to pull the totals for each day, then use MAX on that column to find the number, but I'm guessing there's a better way.
Best-Day-Experiments.xlsx
0
Hello!

Here's the issue: I've got three columns of data: Individual, Amount Sold, Date Sold.

People have multiple sales for each given date.

I want to find each person's best night, i.e. all the sales for each given date combined for that date, and then I'd like to see the max for each individual, so I can show them their best night.

I can do this by creating a new sheet with three columns, one containing every date from 1/1/17 to 12/31/17, the next containing the name of a single person, and the third containing a SUMIF formula, so that I have the sum of each person's sales for each day, and then take the MAX from that column. I am sure, however, that there is a better way. A PivotTable seems to only give me the largest single sale from each individual, instead of the night with the largest sale.

What's the simpler solution here?
0
 
LVL 12

Expert Comment

by:Andrew Leniart
Hi Cory, welcome to Experts Exchange.

What you have done is made a post here. To get expert help, you need to "Ask a Question" so that more experts are able to see you need help. Click the Big blue button near the top of your screen.

Ask-a-Question.png

The following link explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330
1
 
LVL 22

Expert Comment

by:Roy Cox
Hi Cory, you need to look at a PivotTable with dates grouped by day
0
How do i compute sales tax in monthly turnovers for the year in quickbooks.
0
The Sales reps absolutely love these and won't gve them up - I need to keep them on the road. 2GB RAM isn't upgradeable, best strategy for using virtual RAM ?
0
I have this view with the year to date sales values for each stock item sold: -
SELECT        Year, [Stock Code], SUM(SalesValue) AS TotVal
FROM            dbo.tbl_My_Table
GROUP BY Year, [Stock Code]
HAVING        (Year = YEAR(GETDATE()))

I want to create a SQL job to populate a table overnight e.g. tbl_Inventory_Category

I need to add StockCode and Category to the table, StockCode comes from the view. 'Category' is calculated thus:

•      A=  Products that make up 65% year to date sales.
•      B= Next 20%
•      C= Next 10%
•      D= Next 5%

Does anyone know how to achieve this?
0

Sales

101

Solutions

233

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.