Sales

92

Solutions

210

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

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
Get 15 Days FREE Full-Featured Trial
LVL 1
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

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.
1
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
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 11

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 20

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
Ready to get started with anonymous questions?
LVL 9
Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Have the attached report that simply shows sales by day.  I am wanting to add a Max line at the 150K to go across the page.  Does anyone know how to do this as the crystal graphs seems limited.
Shipping-Future-Orders.rpt
0
I am using Google Tag Manager for Wordpress: https://wordpress.org/plugins/duracelltomi-google-tag-manager/
I have followed all of the instructions.
I have an Analytics Account And a Tag Manager Account.
I have the Tags and the Trigger setup but I am still not getting Sales Data in Analytics.  Is there a tutorial out there or a know solution?  Does anyone have any recommendations on where to start to fix the issue?
0
Today’s effective marketing is about coming down to the customers’ level and engaging in a whole new way. A text message is one of the most effective and influential ways that you can engage your customers. Here are eight ways that you can utilize text messages to help your business.
1
Hello All,

I wrote small query where select query will fetch the status of one ORder . If the order status is not 1 it will update the status to another status. If not found it will handle the exception.
I am made one script.In the comment can you help in recitfiying the script asap. Need this script in this format only.



DECLARE
       
        v_REFERENCE_CODE varchar2(30);
        v_status_lkp varchar2(30);
        cursor ObsoleteSalesOrder is
               select a.REFERENCE_CODE,a.status_lkp from BASE_SALES_ORDER a,BASE_SALES_ORDER_LINE b where
                    a.SALES_ORDER_ID =b.SALES_ORDER_ID
                    and a.REFERENCE_CODE ='10132834';
       
BEGIN
open ObsoleteSalesOrder;
loop
fetch ObsoleteSalesOrder into v_REFERENCE_CODE,v_status_lkp;
exit when ObsoleteSalesOrder%notfound;
loop
if v_status_lkp !=1

--Do Below update
update base_sales_order set obsolete_flag = 1 where reference_code IN ('10132834');
update base_sales_order_line set obsolete_flag = 1 where sales_order_id
IN (select sales_order_id from base_sales_order where reference_code IN ('10132834'));
commit;
DBMS_OUTPUT.PUT_LINE('SalesOrder MArked it obsolete');

else if v_status = 1
DBMS_OUTPUT.PUT_LINE('SalesOrder is in obsolete');

else
DBMS_OUTPUT.PUT_LINE ('No sales ORder Found');

--Exception handling
end loop;
--Exception handling
else
end loop;
--Exception Handling
close ObsoleteSalesOrder;            
end;
/
0
Please provide me with a URL address of the Sprint PCS add a phone program.

I know several users who all currently have a single Sprint PCS cell phone and are interested in finding the details of how they can add a second phone to their Spring PCS account using the current Sprint PCS promotion that we have heard is going on until the end of June of 2017.
0
Dear Experts

We are using SugarCRM enterprise edition for sales force automation for marketing campaigns and sales work force now we have a requirement for business intelligence solution for SugarCRM enterprise edition.
1.  I have heard of CognosBI from IBM few years ago is this still the best BI to go for.
or any other BI tool please suggest

Thanks in advance.
0
Hello my name is Troy Bilbro I have put an application in for a customer service sales rep, a cashier position and a freight receiving associate. I received a phone call from the call center a few days ago but some how I got disconnected so I'm just wanting to know if it's possible to get another call from the call center to set me up with an interview because I am still interested in employment there. I'm currently living in Springfield IL but moving to santa fe new Mexico no Tuesday 6/20/2017 my cell phone number is 217-494-5357 thank you...
0
There are many other benefits to creating an inbound marketing strategy. Let’s take a look at five of the biggest and how they'll affect your business.
3
 

Expert Comment

by:keisha manley
Comment Utility
Hello, I am writing because I have a question about opening an  online
store. What are some steps to opening an online store and what do I need to
do to set up payment on my end and not the buyers?
0
 
LVL 16

Expert Comment

by:Kyle Santos
Comment Utility
@keisha
I recommend you ask a question and the experts can answer you.
https://www.experts-exchange.com/askQuestion.jsp
0
DNS-Protection-with-ConnectWise.png
It's always exciting around here! We're thrilled to expand our partnership with ConnectWise to offer customers better protection and performance. To get insight into why this matters, we sat down with George Anderson, Webroot’s product marketing director for business solutions, and Gavin Gamber, vice president of Channel Sales and Alliances at ConnectWise.
 
What is DNS Protection? Why is it important? Why do ConnectWise partners need this?  
 
Read more here.
4
Optimize your web performance
LVL 1
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

I am just thinking about this very cliched phrase that is so often used by corporate executives. And this dawned upon me when my friend asked me what is my USP when I decided to setup a store on an online marketplace.

I am thinking of this from 2 angles:
  1. From a business angle
  2. From a product angle

Example:
What really differentiate Supermarket A from Supermarket B,C, or D?

  • They will likely be selling the similar range of brands at likely the similar prices.
  • They will likely have the similar facilities like parking, children friendly facilities, etc
  • The level of service will likely be the same

So how can a business as such really differentiate themselves? And even if they do, how can prevent it from being duplicated.

And at the end, if they really came with something unique .. is it really a uniqueness that matter to the consumers?
0
I am looking for some kind of website where I can find sample proposals for different kind of IT projects? I know I can deliver the technology to my clients but I can't write a decent proposal which probably caused me to loose several bids. I right for example I am writing one for a VDI solution for a school. Does anyone know any resources?

Thank you!

Martin
0
We've recently written a couple of reporting programs in PHP and Javascript for our own bespoke software that reads data from a table to return tonnage, sales, costs and margin by customer.
The table has a cron job that rebuilds the table twice daily, currenly at around 2am and then again around 1pm.
We find that the first user to run a report following a table update, that the server call times out returning a HTTP time out error on screen.
Is there a reason, that anyone knows of as to why it only happens on the first server call?
If we close down the window and re-open to run the report again it works without issue and get a normal response time of a couple of seconds.
0
I had this question after viewing Sumif statment across and entire workbook.

Hi all,
I found this brilliant solution to how to SUMIF across worksheets, but I just can't figure out how to get it to work! I changed the "TabNames" to 'Mar17:END' and then it's giving me the error "We found a problem with this formula. Try clicking Insert Function...", which I don't have the knowledge to solve! Please help!

More info: I'm in direct sales. I have a summary sheet with all the products I sell, and I want to pull info from my monthly sales sheets to update my inventory. This was the best way I could come up with how to do this, but if there's a better way I'm definitely open to suggestions.
I had all my sales on a single sheet and everything worked great, but I'd really like to see how I do every month.

Any help is greatly appreciated!
TrackingMonthlyHelp.xlsx
0
Here is some sample data from a table named Sales  (sql server 2008r2)



salesassociateid    salesdatetime                                     Salesamount

                1234         2007-01-01 08:00:00.000                 55
                1234         2007-01-01 09:00:00.000                200
                1234         2007-01-01 14:00:00.000                500
                4545         2007-01-01 10:00:00.000                450
                4545         2007-01-01 13:00:00.000                210
                4545         2007-01-01 15:00:00.000                800

             

This table contains summary entries for each hours that sales were made.  No entry is written for hours that do not have sales

Sales hours are between 8am and 6pm

trying to write a query that will fill return a record for each potential sales hour with a zero amount for hours not in sales table
per sales associate per day  (for space reasons I just included one day)

Here is what I would like the query results to be

salesassociateid         hourofday    salesamount  salesdate
1234                             8                        55                  2007-01-01
1234                             9                        200                2007-01-01
1234                             10                       0                   2007-01-01  
1234                             11                       0                   2007-01-01
1234                 …
0
Hi Everyone

I was wodnering if anyone could kindly help please. I may go on a little bit but please bare with me. I am stuck on how to calculate this particular scenario.

A company charges its clients various different prices depending on the amount of sales per month as follows:

£0-300 sales / £30.00 fees per month  
£301-600 sales / £60.00 fees per month
£601-1000 sales / £90.00 fees per month
£1001-2000 sales / £180.00 fees per month
£2001-3000 sales / £250.00 fees per month
£3001-5000 sales / £300.00 fees per month
£5001-7000 sales / £400.00 fees per month
£7001-10,000 sales / £500.00 fees per month
The company has a one off cost £300 per client to set up its clients.

the company has 15 clients and they all get charged different fees per month as they do not have the same sales figures per month.

My question is what would be the best way to have a formula where I can see the breakeven point for the company. As the company would only ever have a one off cost of £300 per client but have various sales revenue figures, I am finding it hard to think of how to do this.

I would very much appreciate it if someone could guide me to a formula. Thank you in advance 🙂
0

Sales

92

Solutions

210

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.