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.

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.

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 ?

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?

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

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.

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

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

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 🙂