Title: washem's Replies | WordPress.org

---

# washem

  [  ](https://wordpress.org/support/users/washem/)

 *   [Profile](https://wordpress.org/support/users/washem/)
 *   [Topics Started](https://wordpress.org/support/users/washem/topics/)
 *   [Replies Created](https://wordpress.org/support/users/washem/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/washem/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/washem/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/washem/engagements/)
 *   [Favorites](https://wordpress.org/support/users/washem/favorites/)

 Search replies:

## Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WPC Composite Products for WooCommerce] Incorrect price calculation](https://wordpress.org/support/topic/incorrect-price-calculation/)
 *  [washem](https://wordpress.org/support/users/washem/)
 * (@washem)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/incorrect-price-calculation/#post-15931003)
 * the compound pricing is wrong when using the click to pay button. Regular price
   
   Add to cart/checkoput seems ok compound price screenshots below
 * > [View post on imgur.com](https://imgur.com/a/UxXmWsx)
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WPC Composite Products for WooCommerce] Incorrect price calculation](https://wordpress.org/support/topic/incorrect-price-calculation/)
 *  [washem](https://wordpress.org/support/users/washem/)
 * (@washem)
 * [3 years, 8 months ago](https://wordpress.org/support/topic/incorrect-price-calculation/#post-15930643)
 * great plugin, spent ages setting it up.
 * works 100% with adding to cart but instant payment/single checkouts only charge
   the regular price and disregards all pricing?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Contact Form DB] Form to Database in one row](https://wordpress.org/support/topic/form-to-database-in-one-row/)
 *  [washem](https://wordpress.org/support/users/washem/)
 * (@washem)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/form-to-database-in-one-row/page/2/#post-8438514)
 * any tips on a query that simply generates a single result where an field =”x”?
 * SELECT `submit_time` AS ‘Submitted’,
    max(if(`field_name`=’text’, `field_value`,
   null )) AS ‘text’, max(if(`field_name`=’How much laundry do you have?’, `field_value`,
   null )) AS ‘How much laundry do you have?’, max(if(`field_name`=’basketsnumber’,`
   field_value`, null )) AS ‘basketsnumber’, max(if(`field_name`=’How much ironing
   do you have?’, `field_value`, null )) AS ‘How much ironing do you have?’, max(
   if(`field_name`=’shirtimage’, `field_value`, null )) AS ‘shirtimage’, max(if(`
   field_name`=’shirtsnumber’, `field_value`, null )) AS ‘shirtsnumber’, max(if(`
   field_name`=’Estimate’, `field_value`, null )) AS ‘Estimate’, max(if(`field_name`
   =’Email Address’, `field_value`, null )) AS ‘Email Address’, max(if(`field_name`
   =’GretText’, `field_value`, null )) AS ‘GretText’, max(if(`field_name`=’First
   Name’, `field_value`, null )) AS ‘First Name’, max(if(`field_name`=’Surname’,`
   field_value`, null )) AS ‘Surname’, max(if(`field_name`=’Mobile number’, `field_value`,
   null )) AS ‘Mobile number’, max(if(`field_name`=’Pickup date’, `field_value`,
   null )) AS ‘Pickup date’, max(if(`field_name`=’Pickup time’, `field_value`, null))
   AS ‘Pickup time’, max(if(`field_name`=’Delivery date’, `field_value`, null ))
   AS ‘Delivery date’, max(if(`field_name`=’Delivery time’, `field_value`, null ))
   AS ‘Delivery time’, max(if(`field_name`=’Fantastic, let\’s continue (1/3) >>’,`
   field_value`, null )) AS ‘Fantastic, let\’s continue (1/3) >>’, max(if(`field_name`
   =’OrderNumber’, `field_value`, null )) AS ‘OrderNumber’, max(if(`field_name`=’
   Select Your Level of Care’, `field_value`, null )) AS ‘Select Your Level of Care’,
   max(if(`field_name`=’Total Care’, `field_value`, null )) AS ‘Total Care’, max(
   if(`field_name`=’Pre Wash Garment Check’, `field_value`, null )) AS ‘Pre Wash
   Garment Check’, max(if(`field_name`=’Pre Wash Stain Removal’, `field_value`, 
   null )) AS ‘Pre Wash Stain Removal’, max(if(`field_name`=’Separate Whites & Colours’,`
   field_value`, null )) AS ‘Separate Whites & Colours’, max(if(`field_name`=’Whiter
   Whites Wash’, `field_value`, null )) AS ‘Whiter Whites Wash’, max(if(`field_name`
   =’Total’, `field_value`, null )) AS ‘Total’, max(if(`field_name`='<< Previous
   page’, `field_value`, null )) AS ‘<< Previous page’, max(if(`field_name`=’Next(
   2/3) >>’, `field_value`, null )) AS ‘Next (2/3) >>’, max(if(`field_name`=’Pickup
   Information’, `field_value`, null )) AS ‘Pickup Information’, max(if(`field_name`
   =’Pick Up Address’, `field_value`, null )) AS ‘Pick Up Address’, max(if(`field_name`
   =’I will be in attendance’, `field_value`, null )) AS ‘I will be in attendance’,
   max(if(`field_name`=’Driver Notes’, `field_value`, null )) AS ‘Driver Notes’,
   max(if(`field_name`=’Laundry Packaging’, `field_value`, null )) AS ‘Laundry Packaging’,
   max(if(`field_name`=’How is your laundry packaged for pick up?’, `field_value`,
   null )) AS ‘How is your laundry packaged for pick up?’, max(if(`field_name`=’
   total+packaging’, `field_value`, null )) AS ‘total+packaging’, max(if(`field_name`
   =’Terms TExt’, `field_value`, null )) AS ‘Terms TExt’, max(if(`field_name`=’I
   agree to the terms and conditions’, `field_value`, null )) AS ‘I agree to the
   terms and conditions’, max(if(`field_name`='<< Previous’, `field_value`, null))
   AS ‘<< Previous’, max(if(`field_name`=’Finalise >>’, `field_value`, null )) AS‘
   Finalise >>’, max(if(`field_name`=’stripe_id’, `field_value`, null )) AS ‘stripe_id’,
   max(if(`field_name`=’stripe_amount’, `field_value`, null )) AS ‘stripe_amount’,
   max(if(`field_name`=’stripe_created’, `field_value`, null )) AS ‘stripe_created’,
   max(if(`field_name`=’fillalldetailstxt’, `field_value`, null )) AS ‘fillalldetailstxt’,
   max(if(`field_name`=’Submitted Login’, `field_value`, null )) AS ‘Submitted Login’,
   max(if(`field_name`=’Submitted From’, `field_value`, null )) AS ‘Submitted From’,
   GROUP_CONCAT(if(`file` is null or length(`file`) = 0, null, `field_name`)) AS‘
   fields_with_file’ FROM `wp_cf7dbplugin_submits` WHERE `form_name` = ‘Washem Purchase
   v2.1’ GROUP BY `submit_time` ORDER BY `submit_time` DESC LIMIT 0,100
 * adding
 * and `field_value` = 100
 * or if I used ‘Orderznumber’=109
 * nothing happens?
 * returns nulls with ordernumber 100?
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[Contact Form DB] JSON export not Json compliant](https://wordpress.org/support/topic/json-export-not-json-compliant/)
 *  Thread Starter [washem](https://wordpress.org/support/users/washem/)
 * (@washem)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/json-export-not-json-compliant/#post-8436208)
 * It is a BOM issue I think as there is three bytes at the start of the JSON file
   making it non JSON
 * How to find the source?

Viewing 4 replies - 1 through 4 (of 4 total)