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

In the attached example, in the computer sales tab, I'd like a cleaner version of cell K10 (highlighted in yellow). I'd like it to have an output of E10 (highlighted in green) - is there a way to update the formulas in K10, K5 - K7, or E51 - E58?
CompTIA Network+
LVL 13
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

I have a customer that is experiencing SQL database table record deletions that cannot be explained in that the programs used have no specific user action for deletion of the records.
To give a specific example the application provides for posting of sales invoices to a sales ledger account,
They reported yesterday that they posted an invoice in April and provided evidence of the audit trail confirming the posting but on viewing the sales account details yesterday this record no longer exists. I examined the table records directly via SQLSMS and the record in question does not exist

Is there a utility available that can identify when and by who a specific record was deleted from a table?
We have some subscriptions given to customers (e.g  Certificates, Email hosting, O365, AMCs)
What is the software used to manage these with email integration?  To notify the salesmen and customers about the upcoming expiry .
Exampe 1st email should go to customer before 60 days , then before 30 days , 15 etc.
I am using TeraWallet for woocommerce on my site. I want to customize this wallet in such a way that if a customer adds money here via their credit card then he can use upto 100% of his wallet balance on their purchase on my store but when he gets money via cashback or promo offer then he can use only 10% of that money in their next purchase. I think I have to make two categories here for this feature where in 1st category customer will have money loaded from their cards or refunds and in the 2nd category customer will have money earned from cashbacks and the 10% spending limit will apply on 2nd category. How to do that?
this is a follow-on to this question

Open in new window

I need to have a multiple layer sort.  I now have it sorting on Parent ID but then I need within the the Parent ID for it to be alphabetical.  For example, I have a $2 Off, Buy 4 and a Buy 9.  They need to be in that order but now they are Buy 9, Buy 4 and $2.  I know I can do menu order but that is another tedious task.

If someone can show me how in the code below to do a sort on Alphabetical within Parent ID that would be great.

[code]unction jk_add_custom_sku() {
$args = array(
'label' => __( 'Parent ID', 'woocommerce' ),
'placeholder' => __( 'Enter custom SKU here', 'woocommerce' ),
'id' => 'jk_sku',
'desc_tip' => true,
'description' => __( 'This SKU is for internal use only.', 'woocommerce' ),
woocommerce_wp_text_input( $args );
add_action( "woocommerce_product_options_sku", "jk_add_custom_sku" );

function jk_save_custom_sku( $post_id ) {
// grab the custom SKU from $_POST
$custom_sku = isset( $_POST[ 'jk_sku' ] ) ? sanitize_text_field( $_POST[ 'jk_sku' ] ) : '';

// grab the product
$product = wc_get_product( $post_id );

// save the custom SKU using WooCommerce built-in functions
$product->update_meta_data( 'jk_sku', $custom_sku );

add_action( "woocommerce_process_product_meta", "jk_save_custom_sku" );
//add_action( "save_post_product", "jk_save_custom_sku" );

####### Custom Sort Option

Open in new window

SonicWall SOHO security question...  I was speaking to a SonicWall rep on the phone and she stated, the basic SOHO firewall did not have any type of security unless, I purchased an intrusion security package.  While I know she is a sales agent for SonicWall, how safe is the SOHO SonicWall if I want to use it right out of the box without purchasing the Intrusion and gateway software package?
what is the best sales and marketing management tool/crm I can get out there.

I have field employees that need better management. THey are assigned based on a geographical region. Take for example a street, and I need to be able to measure all of the most important metrics to better understand our market.
A new startup mainly for tech b2b and want to simply focus on sale. Marketing etc...

Considering bitrix24 and or suitecrm on premise to work with asterisk

Kindly advise.
We are looking to develop landing  pages like:, however, have problems getting it to show on google. We have written that page almost 5years ago.

We understand, we might need to now: chooses relevant keywords and proper analysis. But don't know how to go about it. Kindly recommend training videos, or professional support to be able to do this. so that our team of content writers will be able to learn and adapt it as a necessary skill
I use a feature in Sage500 called Doc Transmittal, which allows my users to email a copy of a Sales Order to remote customers. The Doc Transmittal feature is configured using SMTP, via the IP address of the Exchange server. Basically when the Sage500 users enters a sales order for a customer, they are asked if they want to send a notification email to the customer, and the Sage500 users says OK. A email is sent to the customer and to the group email.

There are five people in the Sage500 group. They all have "Send AS" permission to the mailbox.  We can call the mailbox "SageMailbox".

A relay has been setup for SageMailbox.

Out of the five people that have access to SageMailbox, only three people can successfully use the Doc Transmittal successfully. The other two get the error attached.

Please help!!!
Expert Spotlight: Joe Anderson (DatabaseMX)
LVL 13
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

I have DAILY sales data for 3 products in this form: TABLE1
Product1|SaleAmount|UnitsSold|TimeStamp (there are multiple records for each day)
Product2|SaleAmount|UnitsSold|TimeStamp (there are multiple records for each day)
Product2|SaleAmount|UnitsSold|TimeStamp (there are multiple records for each day)

I have DAILY expense data for 3 products in this form: TABLE2
Product1|ExpenseAmount|ExpenseType|TimeStamp (there are multiple records for each day)
Product2|ExpenseAmount|ExpenseType|TimeStamp (there are multiple records for each day)
Product2|ExpenseAmount|ExpenseType|TimeStamp (there are multiple records for each day)

I need a few SQL statements:
1. I want to show the following columns on a MONTH BY MONTH basis for each product:
Thus, the rows will contain the name of each product; there will be ONE row for each product for each month.
The Month will show as Jan-2018, Feb-2018

2. I also want to show the following columns on a MONTH BY MONTH basis for each product:
Thus, the rows will contain the name of each product; there will be MULTIPLE ROWS for each product for each month, i.e. the number of rows for each month will …
Hi, I need help in coding sales ration in sql, plsql. I have a file attached with details
Database7.accdbHi Guys,

I am trying to create some meaningful CRM style reports and forms based on our accounts transaction file.
I need to create this kind of output:-

                          TOTAL SALES       FRESH          SAUSAGE            HAM             PIES          OFFAL           OTHER                  
customer          LYTD   YTD        LYTD  YTD      LYTD YTD    etc
                          TOTAL TOTAL   TOTAL TOTAL    etc

I think I am fast approaching my current query/crosstab/union etc  ability.
btw  LYTD is last year to date, I have achieved most things with a selection of select queries, crosstab queries, left/right and union queries and i think
I am making this more complicated than is necessary.

1. The reason i need left and right join query is because some customers have no data for LYTD or YTD so in order to get everything I need to do the whole left/right/union thing
but if i injected 0 where there is NULL can i dispense with the l/r/union.
2. I cant seem to work out how to get totals for all sales and categorys.

many thanks in advance.
Your humble servant
I had this question after viewing PayPal IPN, PHP, & MySQL.


I am selling CDs (and other stuff) mainly via eBay but also in other outlets (BigCommerce shop) and I want to do that following to automate this:
1. Collect payment notifications via Paypal IPN message using an IPN Listener Script and verify the payment - this bit has been tested as ok
2. Add CD/DVD sales information to a MySQL Database - I've created the database and attempted to add some lines to index.php to create entries
3. Transpose (parse) the resulting table information so that this can then be sent to Kunaki to ship the discs - I have found and partially updated a php file for this that does connect with Kunaki
4. As Kunaki is somewhat slow to send to anywhere but the USA, I wish to provide a link to a download for the software contained on the discs, immediately, so the buyer has instant access (currently, I've been doing this bit manually as I have access to the files on my home Synology NAS drive and have been sharing the links via email - I am eager to automate this somehow)
5. If I could also update the sale by providing a USPS tracking number that Kunaki provide, to the customer somehow, that would be great
6. Also, if I could update eBay or Paypal to state that the item has been sent, that would also be ideal.

So far, I have 3 files:

ipnlistener.php - to interface with the Paypal IPN
I need to subscribe to office365 to access email, office suite online/offline and onedrive for 3 users. I see 10 - 15 month per user, but seems the sales person keeps trying to sale me implementation, deployment and other services. can anybody help me? this is for business and may expend to 9 users in future.
Using Access 2016:  I have a Query which groups agents by sales. Not every one will have data that month. I would like to email each individual agent his sales for that month. My questions are:
1. what's the best way to set this up, IE should I use a query, or a report based upon the query. I would need to create an agents table with email and name.
2. what are the steps involved?
3. what would be the code, we currently use go daddy for our email. We do not have a server in-house.
4, what event of the report or query would I use to add the code?
5. can you share code that works for 2016 access?

is this even possible? If the agent has no sales for that month, it should not create the email or should not create a report, if the report is based on a query?
If you can help, I would be gratefully appreciative, or if you can point me to a "dummies" link where I can try to create something.

The last question I had, I got some awesome answers from PatHartman and John . I am in hopes that one of the experts can help me with this as well as those two helped me with my query question. I know this is a lot to ask, but if you know, please help.

Are cloud phones better than an on premise solution?
We currently have a Siemens 4K phone system used with a PRI.
We have about 230 voice over IP phones and about 15 digital line phones.
Most of the ip phones have a basic setup with add on module to configure additional lines.

The 15 digital lines are for our sales department, the have a ACD routing setup(similar to a hunt group). Each sales person has their prime line and 2 secondary lines. We have it configured so that that each sales person is able to answered each others lines. Each sales person has about 50 lines configured on two phones at their desk that they can answer when any line rings. We it setup this way because our president wants sales to try and answer all calls and not have them go to voicemail.

We recently started to look at cloud phones and providers like ring central, 101voice and others. Our main concern is QOS and if our setup in sales will be supported.

We are not sure if cloud phones will be more reliable and if we will have the same quality of service?

Thank You

Let me know if you need any clarification.
I want to attract sales people to sell my affiliate product, but I don't want to go beyond the limit of a few hours a week of managing the website.

So, I posted my offer on Freelancer and one person applied to the position, and then suddenly the job offer was taken down from Freelancer. (I am not sure why).

The job offer was a good offer, it said that sales person would earn 80% of the commissions. That's a good offer for someone to earn from the website. But the statistics
reveal that only that one person applied for the position.

If I have to spend many hours soliciting the job offer in order to get a sales person, then instead, I should close the website(s) because there is no time to deal with that.

Can anyone tell me where I can find such a sales person who will work in that scenario so as to expedite the sales of the website? (but without exceeding three hours a week
of management).
Has anyone managed to tap into 365 Client Management tenant details including subscription renewals with PowerBi. I dont want to give my sales team full delegated access to 365 to review subscriptions.
OWASP: Avoiding Hacker Tricks
LVL 13
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

Hi, I am using Access 2010. I want to learn advance and complex queries writing to manipulate data in tables, in VBA, which can perform on some events of form / report. I am familiar with query builder and basic queries.
Now I have an assignment to prepare a periodic summary for stock inventory, filtered by date and/or stock item. View, in datasheet on form / report, format as follows:
Filters applied: Date Range, Stock Group
Columns: StockItem, PackSize, PreviousQty, PreviousAvgRate, PreviousStockAmount, PurchaseQty During Date Rate, AvgRate of Buying During Date Rate, PurchaseAmount in Date Range, SalesQty During Date Range, AvgRate of Sales During Date Range, SalesAmount During Date Range, Qty of Balance Stock, AvgRate of Balance Stock, Amount of Balance Stock. AvgGain (AvgRateSale)-((PreviousStockAmount+PurchaseAmount in Date Range)/(PreviousQty+PurchaseQty)

Tables & Columns: (Interlinked columns only mentioned here)
tblStockItem: StockId, StockGroup, StockLabel, PreviousQty, PreviousBuyingAvgRate
tblStockPackSize: PackSizeId, StockId, PackSizeLabel
tblPurchase: PurchaseId, StockId, PackSizeId, Qty, Rate, Amount
tblSales: SalesId, StockId, PackSizeId, Qty, Rate, Amount

I am looking for expert guidance to write queries and how to set its recordset to any object to display data, in Access VBA. I will be thankful for your help.
Employee Tracking - GPS - I want app to web solution for tracking my sales employee and location with form to be filed when they reach that location.
Looking for a market research firm before launching a product? Any suggestions?
We use the Sales portion of Dynamics 365 CRM, specifically our current issue is with uploading quotes via the Custom Data Maps under Import Data. We have used this tool for over a year and randomly yesterday our most used custom data map was not showing up in the selection when importing a quote. The custom data map was still listed on the back end under Data Management/Data Maps, so I was able to export it, rename it, and import it. That got the team moving again yesterday, but we came in today and all of the custom data maps were missing from the end user import screen. We tried the export/rename/import trick and it worked for a few minutes but now the entire Custom Data Map section is missing as a selection while uploading through import data. I'll attach a screenshot of this. Has anyone run into this before, the custom data maps are listed under Data Management but the End Users do not see them, no changes have been made to the config.

I have below scenario and need help to address this issues. What would be your approach to solve this problem in bullet points or brief summary like  what is your assumptions,explain your analysis approach and chosen analytics techniques, expected output results, what recommendations do you suggest,do you see limitations

1. How would you assess the impact of weather on consumer spend last winter?

2. How would you determine if a specific block in your neighborhood is suitable for a new grocery store?

3. Bank XYZ has created a new credit card product, how would you determine the targeting strategy?

4. Bank XYZ  has observed declining credit card sales volumes in their core markets. How would diagnose the cause and what potential remediation’s may be put in place (if any)

5.  Credit Card company recently announced a new partnership with a key tech company. How would you quantify the per customer incremental value of this partnership?

I have a large database with many years of sales transaction records by customer, by stock code, by month by year.
I want to compare information form one year versus another year.
The Crosstab returns variable Column Headings which I want to change to Fixed Column Headings to work with the various queries, tables and reports I have compiled.
Row Heading: Customer
Row Heading: STOCK_CODE
Column Heading:TRN_YEAR:
Vaue: SalesValue






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.