Sales

92

Solutions

209

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

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

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
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
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
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
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
hi,

i'm using sharepoint 2007, wss 3.0 and on our main page i have a rectangle box going from right to left with some sales figures inside

how do i go about removing this rectangle box


regards
si
0
A client of mine is interested in obtaining a list of all of the online payment systems besides PayPal.

Please provide me with a list of online payment systems besides PayPal.
0
I've tried to create a Form to Calculate Sales and Taxes, but I'm not able to get the form to work.  Super new to vba, off and on for a few years and its now become imperative for me to get this done.  This is the code i have so far.

Private Sub txtSalesTax_Change()

Me.txtSubtotal.Text = Val(Replace(txtSalesPrice.Text, "$", "")) * Val(Replace(txtSalesTax.Text, "%", "")) / 100

End Sub

Private Sub txtSubtotal_AfterUpdate()

Me.txtSubtotal.Value = Format(txtSubtotal.Text, "$0,00")

End Sub

Private Sub txtSalesTax_AfterUpdate()

Me.txtSalesTax.Text = Val(txtSalesTax.Value) / 100
Me.txtSalesTax.Text = Format(txtSalesTax, "Percent")

End Sub


Private Sub txtTotalSale_Values()
    Dim dbltxtTotalSale As Double

    On Error Resume Next

    dbltxtTotalSale = CDbl(txtSubtotal.Value)
    dbltxtTotalSale = dbltxtSubtotal + CDbl(PriceIncrease.Value) - CDbl(txtSubtotal.Value)
    dbltxtTotalSale = dbltxtTotalSale + CDbl(PriceIncrease.Value)

    txtTotalSale.Value = dbltxtTotalSale
   
    txtTotalSale = Format(txtTotalSale, "$0.00")

End Sub
0
IoT Devices - Fast, Cheap or Secure…Pick Two
IoT Devices - Fast, Cheap or Secure…Pick Two

The IoT market is growing at a rapid pace and manufacturers are under pressure to quickly provide new products. Can you be sure that your devices do what they're supposed to do, while still being secure?

Dear Experts

We are evaluating to provide crome note books to sales force team who are using SugarCRM enterprise , at present they are using SugarCRM mobile app but there is a requirement from them for the laptop/note book, also we have integrated SugarCRM with google.
 please suggest me does crome notebook does it have a portability or supports dongle/data card for the internet,  this is in additional to the wifi connectivity also is it possible to control the app level like to restrict users only use business applications like CRM and ERP.

please suggest
0
fatal error : Exception code= C0000005 @
error log
     file: Z:\\VFP9Rerr.log
                Called from - pos.loadline.line 0 ( )
                Called from - pis. grid1. colpart_part_no.keypress line 0 ( )
                Called from - rman line 0 (z:\rman.exe)



please how can we fix this
currently running a retail store pos software and that error occurs when trying to scan an item  for sales
0
On my site, I want to advertise books which are similar to my own. I heard I can be an affiliate w/ Amazon and earn a small cut.

What kinds are commissions are we talking about for a book that retails for $19.99?

I do have WooCommerce installed.

Thanks
0
1)      Using one-dimensional array. A company pays its 20 salespeople on a commission basis. The sales people receive PHP 2,000.00 per week plus 9 percent of their gross sales for that week. For example, a salesperson who grosses PHP 5,000.00 in sales a week receives PHP 2,000.00 plus 9 percent of PHP 5,000.00, or a total of PHP 2,450.00. Write a program(using an array of counters) that determines how many of the salespeople earned salaries in each of the following ranges (assume that each salesperson’s salary is truncated to an integer amount):
a.      2000-2999
b.      3000-3999
c.      4000-4999
d.      5000-5999
e.      6000-6999
f.      7000-7999
g.      8000-8999
h.      9000-9999
i.      10000 and above
0
I want to protect a cell from editing but allow the cell to be populated with a radio command button that populates the cell with the user id and timestamp.  a pop up message appears when the cell has been populated (in my case approving the form).  I can certainly lock the cell but then the radio button doesn't work,  what do I need to add on the front end of marco below?

Sub Product()

  UserName = Environ("username")
   
    Range("$i$5").Select
    ActiveCell.FormulaR1C1 = UserName
    Range("$j$5").Select
    ActiveCell.FormulaR1C1 = " " & Now

    x = UCase(Range("$i$5").Value)
    y = UCase(Range("$i$3").Value)
   
    If x = y Then

    MsgBox "ERROR - APROVER ID ERROR" & vbNewLine & vbNewLine & "Product Approver ID must be different then Sales Approver ID"
   

    Range("$j5").Select
    ActiveCell = vbNullString
    Range("$i$5").Select
    ActiveCell = vbNullString
   
    Exit Sub
   
    End If

       
    MsgBox "Approved"
End Sub
0
We are trying to build and excel spreadsheet for our sales people on their commission they earn and are have difficulties putting in the correct formulas.  Here is what we are trying to accomplish.  If a Sales Person make a sale to ABC company on 1/1/17 for a 36 month period for $1000.00 they are paid in percentages in the given form.  Month 1 -12 they are paid 10%, 13 - 24 @ 4%, 25 - 36 @ 1% and commission is ended at the the end of the 36th month.  Any advise would be helpful to get on the right track.

Thank you in advance.
0

Sales

92

Solutions

209

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.