Sales

84

Solutions

17

Articles & Videos

194

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

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
Free Tool: SSL Checker
LVL 8
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.

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
Dear Experts,

I have created a business to consumer website in Umbraco. I want to get started on marketing. I have linked the site with google analytics and considering how to use log4net and splunk to see what pages are being viewed but what tools/techniques can I utilise to really get it going and get the low down on all traffic. Essentially i want to see whether the google adwords are working as efficiently as possible. Any help greatly appreciated.
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
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
Transaction Monitoring Vs. Real User Monitoring
LVL 1
Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

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
Hi all,
i have the unenviable task of updating an onliine sales portal made at least 10 years ago, and which links into a customers SAP system.

there are no problems when i am updating prices, but if i need to add items to the page, there is code i obviously need to alter:
onClick="buyItem('5247 BURN AID GEL 50G PK10','6.10', document.itemsform.box10.value)">

The question is, what and where does the "document.itemsform.box10.value" refer to, and can i just add to the box value if i am adding more items? i.e. if box11.value didnt exist, could i add that code to a new item?

thanks in advance
0
Recognizing that digital transformations will never end can be scary, like everything in life is dynamic, it is just another challenge to be faced.

Reconhecer que as transformações digitais nunca acabarão pode ser assustador, porém como tudo na vida é dinâmico esse é mais um desafio para ser enfrentado.

http://telecoms.com/481985/digital-transformation-is-a-journey-just-dont-count-on-ever-finishing/
3
 
LVL 6

Expert Comment

by:Brian Matis
"Digital transformation itself is a thankless task. It is one which is constantly criticized and scrutinized, but there is unlikely to ever be a satisfactory answer to the question. Digital transformation is a journey, according to Whitelock. It is the constant pursuit of remaining relevant and avoiding obsolescence."

Ain't that the truth!
1
Hi
I need help to make financial reports.

I have a website that can show reports about sales and I need it to be printed when the user want it.

The condition is that:
1. Every page must have page number.
2. Printer can tell wheter to change to another paper or not, like a customer reports if the customers is change, so it will be printed to another page even to the current page for the current customer is just half the page.
3. There have to be header for every page and date too under the header, and the footer is just a straight line, like a border bottom.
4. It just can be printed if the user have the permission to do so.
5. It just can be exported if the user have the permission to do so, the export can be csv, excel, and pdf.
6. The tools control can be made by me and can be control by the permission the user have.

I already tried mpdf but I can't handle the download button and other tools because my reports is a dynamic one not the fixed that can be just called like a normal document.

What tools I can use to make the reports I need and with the condition I want?

Thank you...

This is the code:

<!DOCTYPE html>
<html lang="en">
<head>
    <style>
	.table td {
		border-top:none;	
	}
	.titlerpt {
		font-size: larger;	
		color: #800000;
	}
	.tbltitle {
		border-bottom: 1px black solid;
		font-size: medium;
		color: #000080;
	}
	.tblisi {
		font-size: small;
	}
	
	@media print and (orientation:portrait) {	
		.table td {
			border-top:none;	
		

Open in new window

0
6
Hello

Imagine this scenario -

A user walks into one of our support centres. The user has one of our mobile apps installed on their device. A beacon within the support centre is set to transmit an alert to a support tech when it detects the presence of our mobile app close to it. The beacon sends information on the user to the support tech who is able to identify them.

Possible?
0
Announcing the Most Valuable Experts of 2016
LVL 6
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

I am a C# developer and Mac user and like the idea of using Microsoft's Visual Studio 2017 for Mac to write a cross platform app for iPhone and Android.

I have played with Xamarin and understand it's actually a website I would be offering, which is in stark contrast to an Objective C native app.

My question involves the need to the App Store from Apple.

If I wrote a cross-plarform app, could I distribute it outside the Apple channel? An iPhone user can purchase anything they want from a website.

Wondering...

Thanks
0
The role of marketing has made dramatic shifts over the last decade. With the prevalence of AI and more sophisticated business intelligence, the role of Chief Marketing Technologist has emerged to manage it all. Here's why the position matters, and how their expertise impacts the world of tech:
http://blog.experts-exchange.com/martech/chief-marketing-technologist-what-this-role-means-for-tech/
6
Hello!

I am designing a template that sales people will use to log their activity. I want to make it so that, for example, cell D3 changes to "someone@example.com" when email is selected from the drop down list in E3 or "(XXX)-XXX-XXXX" when mobile phone is selected. This is easy to be done, however, when a sales person goes to log the data they will have to erase the formula to put in the info. Is there any way it can display the data I want but then act like an empty cell when a user goes to input data?
0
Hi
I have 2 different methods which are used to forecast future product returns, the problem is that the answers from each method are drastically different - ie; one method is nearly double the forecast qty of the other (4966 vs 2689), and I'm looking for some advice on which is the most appropriate or "statistically correct" (if there is such a thing).

See attached file to better understand the methods used, and their results.

The data that is involved is Sales and Returns of a product across the product timeline.
The product timeline refers to the date from when the product was first sold, to the date when the warranty runs out on that first sale.
The warranty period for the product is eg; 36 months - so 36 months after the first sale is made, the warranty expires and the product is no longer in the Warranty Install Base (WIB).

The WIB is cumulative sales from the first sale of the product until the warranty runs out.

The first method uses the returns per month against the WIB (for that month) to provide the monthly return rate.

The second method uses the cumulative returns per month against the WIB (for that month) to provide the cumulative return rate.

The first method:
Assuming we are running the report in May, n order to project/predict the return rate for June, the report looks at the average return rate for the previous 12 months, and uses this average as the return rate for June.
Then, to predict the return rate for July, we use the  average of…
0
Setting up a new store. There will be about 1300 different inventory items.  I have a merchant Visa/MC processing account. Is there a way to process all the sales on an iPad? When I was at a farmer's market once, the shop owner did the whole thing on his iPad. Typed in the product code on the pad, swiped my card and I signed right on the screen. The receipt got emailed to me in lieu of printing. I really liked the simple solution. This is also the way the Apple salespeople do it at Apple stores. No need for a big cash register set up. Not even a computer or printer.

So..... what app is that? What was that guy using at the farmer's market?

FYI: My merchant services provider is PayPal (NOT to be confused with PayPal "request money" via email). It's a service that PayPal has that directly processes the Visa/MC WITHOUT the PayPal stuff that most people do (i.e. sign up for an account, yada yada).

Anyway, if the above could be done, great. and the following would be an extra bonus, if possible:

1) Scan barcodes with the iPad camera
2) keep track of inventory

-  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  

Anyway, I want to keep this simple. The farmer's market owner's solution is exactly what I'd like. If the scanner/inventory makes it all much more complicated, I can eliminate that.

Thanks for your help!!

Greg
0
6

Sales

84

Solutions

17

Articles & Videos

194

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.